###从scott.t1118_1表里delete一条记录(因为数据库经历了重启所以无法接着上面的测试了,只能重新开始)
---session 1:delete一条记录,不提交
SYS@tstdb1-SQL> delete from scott.t1118_1 where username='ANONYMOUS';
1 row deleted.
---session 2:排除掉state=0(状态为free)的block
SYS@tstdb1-SQL> select obj,indx,addr,hladdr,flag,lru_flag,class,state,dbarfil,dbablk,ba,tch from x$bh where obj=41231 and state!=0;
OBJ INDX ADDR HLADDR FLAG LRU_FLAG CLASS STATE DBARFIL DBABLK BA TCH
---------- ---------- ---------------- ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- ----------
41231 8670 0000000110997C58 07000001B6AFD160 0 0 4 1 5 60682 070000015E0E2000 1
41231 16171 0000000110997C58 07000001BCC9B928 524288 0 1 1 5 60687 070000015F4AC000 1
41231 28310 0000000110997C58 07000001BCC9F230 524288 0 1 1 5 60684 070000015E2E8000 1
41231 47972 0000000110997C58 07000001BCCA5180 524288 0 1 1 5 60686 070000015F392000 1
41231 59894 0000000110997C58 07000001B6B0C908 33554433 0 1 1 5 60683 070000015E1D6000 2
41231 59895 0000000110997B10 07000001B6B0C908 524288 2 1 3 5 60683 070000015E1D8000 1
41231 79479 0000000110997C58 07000001BCCAE9D8 524288 0 1 1 5 60685 070000015F268000 1