oracle 消除块竞争(hot blocks)
SELECT p1 “file#”, p2 “block#”, p3 “class#”
FROM v$session_wait
WHERE event = ‘read by other session’;
oracle high load案例及AWR分析过程
Begin Snap: 18125 20-Apr-12 11:01:00 337 1.0
End Snap: 18126 20-Apr-12 12:00:28 490 1.0
Elapsed: 59.46 (mins)
DB Time: 12,979.44 (mins)
ssh 端口转发 助TOAD，PL/SQL DEV窗口程序连接不能直接访问的数据库
SecureCRT ssh 端口转发功能
toad—>127.0.0.1:3000—ssh –>web server—ssh—>db server:1521
in version 10.2 oracle does not support quota on temporary tablespaces,ora-30041
如果在10gr1及以前的版本，在temp tablespace设quota是可以的，但真正的不应该在temp 上设限额，本身就是一个bug，在10gr2中被修复，所以10gr2及以后的版本不在允许
Initializing the Oracle ASMLib driver: [FAILED] on RHEL5.1 asmlib安装详情
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [FAILED]
log:modprobe: FATAL: Module oracleasm not found.
sql script: 找出stale statistics的对象
Using the code below one can find the tables/indexes that have stale statistics in a schema, when options=>’GATHER AUTO’ is used oracle gathers statistics analyzes the tables/indexes that have stale statistics.
exp EXP-00056 ora-00932 导出异常
[oracle@dev-db backup]$ exp icme3/icme3 file=icme3_20120409.dmp
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully
ORA-00600: internal error code, arguments: [qcsgpvc3] Bug:7172752
when compile package body,
ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []
