How to stop or kill datapump jobs?(停止数据泵job)
3 begin
4 hdl := dbms_datapump.attach(‘SYS_IMPORT_FULL_03′,’SYSTEM’);
5 DBMS_DATAPUMP.STOP_JOB(hdl,1,0);
6 end;
迁移controlfile 从文件系统到ASM
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;
计算controlfile size，dd 迁移raw device中的controlfile
Control Seq=53995=0xd2eb, File size=594=0x252
File Number=0, Blksiz=16384, File Type=1 CONTROL
Logical block number 1 (header block)
Script: 查看datafile 的HWM,估算resize 最小size
数据文件如果有2g，先create一个大表占了1G,后来建了个几M小表，再把大表drop 掉加purge选项，向把数据文件resize到100M，往往会失败，在磁盘紧张的情况下，想知道数据文件最小值是多少？就要计算datafile HWM
How to list all events?（oracle事件列表）
其中有两个编号段比较特殊
1，错误编号-10000到-10999 不是真正的错误，是保留下来用于debug使用
2，错误编号-20000到-20999是自定义异常，错误信息最大2048B
hanganalyze 分析 dbms_ijob.broken无效的问题
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>
ora-600 [3708] [910] internal error issue
SQL> shutdown immediate
ORA-00600: internal error code, arguments: [3708], [910], [], [], [], [], [], []
Basically this error is raised because LGWR timmed out.
ORA-00600 [keltnfy-ldmInit] internal error issue
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
