快捷搜索:  as  test  1111  test aNd 8=8  test++aNd+8=8  as++aNd+8=8  as aNd 8=8

网赌新浦金可靠吗:使用10203事件跟踪Oracle块清除



Oracle的10203事故可以用来跟踪数据库的块清除(cleanout)操作,从事故列表中,我们可以知道该光阴的含义为:block cleanout 。

该事故必要在系统级设置,重启数据库后生效:

SQL> alter system set event="10203 trace name context forever" scope=spfile;

System altered.

SQL> shutdown immediate;

Database closed.

Database dis网赌新浦金可靠吗mounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area126948网赌新浦金可靠吗772 bytes

Fixed Size452004 bytes

Variable Size92274688 bytes

Database Buffers33554432 bytes

Redo Buffers667648 bytes

Database mounted.

Database opened.

SQL> show parameter event

NAMETYPEVALUE

------------------------------------ ----------- --------------------------------

eventstring10203 trace name context forever

在跟踪文件中,我们可以发明类似如下的block cleanout 信息:

Begin cleaning out block ...

Found网赌新浦金可靠吗 all committed transactions

Block c网赌新浦金可靠吗leanout record, scn:0xffff.ffffffff ver: 0x01 opt: 0x02, entries follow...

itli: 1flg: 2scn: 0x0819.0045cd54

Block cleanout under the cache...

Block cleanout record, scn:0x0819.0045cea1 ver: 0x01 opt: 0x02, entries follow...

itli: 1flg: 网赌新浦金可靠吗2scn: 0x0819.0045cd54

... clean out dump complete.

原文地址:http://www.eygle.com/archives/2006/04/event_10203_cleanout.html

免责声明:以上内容源自网络,版权归原作者所有,如有侵犯您的原创版权请告知,我们将尽快删除相关内容。

您可能还会对下面的文章感兴趣: