RE: ITL, DELAYED BLOCK CLEANOUT

[SARKAR, Samir]

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 SchlumbergerSema Email : [EMAIL PROTECTED]           [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018            -----Original Message----- From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]] Sent: 29 October 2001 14:25 To: Multiple recipients of list ORACLE-L Subject: 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. ___________________________________________________________________________