使用10203事件跟蹤Oracle塊清除

2024-08-29 13:34:29

字體：大中小

供稿：網(wǎng)友

　Oracle的10203事件可以用來跟蹤數(shù)據(jù)庫的塊清除（cleanout）操作,從事件列表中，我們可以知道該時(shí)間的含義為：block cleanout 。該事件需要在系統(tǒng)級(jí)設(shè)置，重啟數(shù)據(jù)庫后生效：SQL> alter system set event="10203 trace name context forever" scope=spfile;System altered.SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.Total System Global Area 126948772 bytes
Fixed Size                   452004 bytes
Variable Size              92274688 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.SQL> show parameter eventNAME                                 TYPE        VALUE
------------------------------------ ----------- --------------------------------
event                                string      10203 trace name context forever在跟蹤文件中，我們可以發(fā)現(xiàn)類似如下的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.原文地址：http://www.eygle.com/archives/2006/04/event_10203_cleanout.Html

上一篇：Oracle熱備期間的過量Redo生成控制

下一篇：Oracle9i中利用自動(dòng)撤銷管理的優(yōu)點(diǎn)