RE: ITL, DELAYED BLOCK CLEANOUT

From: SARKAR, Samir <Samir.SARKAR_at_nottingham.sema.slb.com>
Date: Mon, 29 Oct 2001 08:44:31 -0800
Message-ID: <F001.003B718E.20011029083522@fatcity.com>

<FONT
face=Arial>Vladmir,
 

Whenever we modify any data
or index blocks and commit it, Oracle will do a fast commit by marking the transaction
as committed in the rollback segment header. But Oralce does not actually clean up
the locks in the modified data or index blocks. The next transaction which
does a select on the those modified blocks will do the actual
cleanout of the block. This
is delayed block cleanout.
 

Sorry, I cant shed much
light on the Interested Transactions list though.
 

Samir Sarkar
Oracle DBA - Lennon
Team Schlumberger<FONT
face=Impact color=#800000>Sema
Email :
samir.sarkar_at_sema.co.uk <FONT face=Verdana color=#000080 size=1>         
samir.sarkar_at_nottingham.sema.slb.com <FONT face=Verdana color=#000080 size=1>Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418
Ext. 76217 Fax
: +44 (0) 115 - 957
6018           

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Vladimir Barac - posao   [mailto:vbarac_at_mobtel.co.yu]Sent: 29 October 2001   14:25To: Multiple recipients of list ORACLE-LSubject:   ITL, DELAYED BLOCK CLEANOUT
  Just curious... Could someone shed some   light on INTERESTED TRANSACTIONS LIST and DELAYED   BLOCK CLEANOUT?Thanks

---

This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema.
If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.

---

Received on Mon Oct 29 2001 - 10:44:31 CST