看到刘兄的一篇文章转载下
Reference:http://www.oracledatabase12g.com/archives/diff-hidden-parameter-between-10g-and-11g.html[……]
“hcheck.sql” script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g
Execution Environment:
Access Privileges:
Requires to be run connected as SYS schema
Usage:
$ sqlplus
SQL*Plus: Release 9.2.0.2.0 – Production on Mon Nov 11 12:00:06 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
C[……]
ASM Preferred mirror Read
ASM Preferred mirror Read
Introduction
The concept of the Preferred Read is not a new idea, but is now implemented in Oracle’s ASM volume
management in Oracle 11g.The concept is to read from the storage that can present the needed data at a lower
latency. Initially, this was designe[……]
11gR2 rac ora.asm error (ASM)
ASM – ora.asm error
11.2.0.3 RAC CRS 无法启动
[ohasd(25286)]CRS-2112:The OLR service started on node db-41.
2012-04-25 14:46:13.120
[ohasd(25286)]CRS-1301:Oracle High Availability Service started on node db-41.
2012-04-25 14:46:13.120
[ohasd(25286)]CRS-8017:location: /etc/oracle/lastg[……]
11G New feature: Failed Logon Delays
在pub上看到一个不错的帖子 oracle 11g password delay
对这个特性 做如下说明
Failed Logon Delays
A hacker may attempt a brute force hack to break into your Oracle Database. This is where they try constant logons to the database using some form of a word list. To try to make brute force hacking more difficult, Ora[……]
MySQL Plug-in for EM 12c
来自pythian mysql project
With this plug-in, a DBA can add a new MySQL target just as they can an Oracle database. Oracle Enterprise Manager Agent doesn’t have to be running on the same host as the monitored MySQL database. I.e., remote monitoring of the MySQL database using one or two agents is[……]
Scripts: report the index fragmentation status
/* ************************************************************* */
/* Index Fragmentation Status (idsfrag.sql): */
/* */
/* This script will report the index fragmentation status */
/* for a schema.[……]
11g 密码延迟登陆导致 library cache lock
Linux mysql 优化
linux mysql
一、修改内核参数
1.1、编辑/etc/sysctl.conf
vi /etc/sysctl.conf
net.ipv4.tcp_max_syn_backlog = 65536
net.core.netdev_max_backlog = 65536
net.core.somaxconn = 32768
net.core.wmem_default = 8388608
net.core.rmem_default = 8388608
net.core.rmem_max = 16777216
net.core.wmem_max = 16777[……]
