最近出差,至双节后

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

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