RE: Delayed Block Cleanout is not happening

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 30 Aug 2000 21:06:57 +1000
Message-Id: <10604.115832@fatcity.com>

Hi Gopal,

The --U- flag with the lock count still 1 indicates that the transaction did a commit cleanout on this block. No further cleanout is to be expected until the row is modified by a subsequent transaction.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

@

@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: K Gopalakrishnan [mailto:kaygopal_at_yahoo.com] Sent: Wednesday, 30 August 2000 20:08
To: Oracledba_at_lazydba.com
Cc: oracle-l_at_fatcity.com
Subject: Delayed Block Cleanout is not happening

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/

---

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Wed Aug 30 2000 - 06:06:57 CDT