ANBOB™

在公司累脑子，出来奉献点儿体力，顺便也当散散心缓解一下，接了个苦差事，从9月20号开始出差浙江两周，最近也已经 […]

3 begin
4 hdl := dbms_datapump.attach(‘SYS_IMPORT_FULL_03′,’SYSTEM’);
5 DBMS_DATAPUMP.STOP_JOB(hdl,1,0);
6 end;

alter system set control_files=’+DATA/ANBOB/CONTROLFILE/current.260.793738081′,’+DATA/ANBOB/CONTROLFILE/current.261.793738087′,’+DATA/ANBOB/CONTROLFILE/current.276.793737555′ scope=spfile;

Control Seq=53995=0xd2eb, File size=594=0x252
File Number=0, Blksiz=16384, File Type=1 CONTROL
Logical block number 1 (header block)

数据文件如果有2g，先create一个大表占了1G,后来建了个几M小表，再把大表drop 掉加purge选项，向把数据文件resize到100M，往往会失败，在磁盘紧张的情况下，想知道数据文件最小值是多少？就要计算datafile HWM

其中有两个编号段比较特殊
1，错误编号-10000到-10999 不是真正的错误，是保留下来用于debug使用
2，错误编号-20000到-20999是自定义异常，错误信息最大2048B

HANG ANALYSIS:
==============
Open chains found:
Chain 1 : :
<0/1777/32406/0x5275fca0/13913/SQL*Net message from client>
— <0/1477/37455/0x5275e4e8/16043/enq: TX - row lock contention>

SQL> shutdown immediate
ORA-00600: internal error code, arguments: [3708], [910], [], [], [], [], [], []

Basically this error is raised because LGWR timmed out.

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []