Re: Delayed Block Cleanout is not happening

Ok 'm always willing to learn, how did you do the data block dump?

joe

K Gopalakrishnan wrote:
>
> Hi All...
>
> I have created a table and inserted one row. Now I
> have dumped the datablock and here is the ITL Entry
>
> Itl Xid Uba Flag
> Lck Scn/Fsc
> 0x01 0x0002.012.00000012 0x00c00b8f.0037.01 ----
> 1 fsc 0x0000.00000000
>
> Now I have updated a row in that table..(but didn't
> commmit..) Here is that ITL entry
>
> Itl Xid Uba Flag
> Lck Scn/Fsc
> 0x01 0x0002.012.00000012 0x00c00b8f.0037.01 --U-
> 1 fsc 0x0000.00009131
>
> Here the flag is --U- As expected...And i did a
> commit.
> And the ITL falg has not changed..
>
> I forced a block cleanout by doing a full table scan
> of that table. But still the ITL flag is --U-
>
> My question is WHEN EXACTLY the block clean out is
> done and how do i trace that?
>
> The version is 8.0.3 and NT 4.0 (SP5) If that matters.
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
> --
> Author: K Gopalakrishnan
> INET: kaygopal_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Joe Testa  http://www.oracle-dba.com
Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs