« Windows Live Messenger可以自由申请 | Blog首页 | 李白手书真迹-上阳台 »
使用10203事件跟踪Oracle块清除
链接:https://www.eygle.com/archives/2006/04/event_10203_cleanout.html
Oracle的10203事件可以用来跟踪数据库的块清除(cleanout)操作,从事件列表中,我们可以知道该时间的含义为:block cleanout 。
该事件需要在系统级设置,重启数据库后生效:
SQL> alter system set event="10203 trace name context forever" scope=spfile; System altered. SQL> shutdown immediate; Total System Global Area 126948772 bytes SQL> show parameter event NAME TYPE VALUE |
在跟踪文件中,我们可以发现类似如下的block cleanout 信息:
Begin cleaning out block ... Found all committed transactions Block cleanout record, scn: 0xffff.ffffffff ver: 0x01 opt: 0x02, entries follow... itli: 1 flg: 2 scn: 0x0819.0045cd54 Block cleanout under the cache... Block cleanout record, scn: 0x0819.0045cea1 ver: 0x01 opt: 0x02, entries follow... itli: 1 flg: 2 scn: 0x0819.0045cd54 ... clean out dump complete. |
历史上的今天...
>> 2015-04-20文章:
>> 2013-04-20文章:
>> 2011-04-20文章:
>> 2009-04-20文章:
>> 2007-04-20文章:
>> 2005-04-20文章:
By eygle on 2006-04-20 17:04 | Comments (0) | Internal | 748 |