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], [], [], [], [], [], [], []