ITL, DELAYED BLOCK CLEANOUT
Just curious... Could someone shed some light on INTERESTED TRANSACTIONS LIST and DELAYED BLOCK CLEANOUT?Thanks
RE: ITL, DELAYED BLOCK CLEANOUT
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: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. ___
RE: ITL, DELAYED BLOCK CLEANOUT
Vladimir, Have a look at http://www.geocities.com/kgkrish/transactions.html This will solve most of your questions. If not Pls let me know. Thanks Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vladimir Barac - posao Sent: Monday, October 29, 2001 6:25 AM 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
RE: ITL, DELAYED BLOCK CLEANOUT
Hi, The document is a draft copy. There are few (not much tech) errors. So take that with a pinch of salt Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of K Gopalakrishnan Sent: Monday, October 29, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: ITL, DELAYED BLOCK CLEANOUT Vladimir, Have a look at http://www.geocities.com/kgkrish/transactions.html This will solve most of your questions. If not Pls let me know. Thanks Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vladimir Barac - posao Sent: Monday, October 29, 2001 6:25 AM 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
RE: ITL, DELAYED BLOCK CLEANOUT
is this page still available or has been moved. I got an error trying to access the link Thx Deepak --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Hi, The document is a draft copy. There are few (not much tech) errors. So take that with a pinch of salt Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- Gopalakrishnan Sent: Monday, October 29, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Vladimir, Have a look at http://www.geocities.com/kgkrish/transactions.html This will solve most of your questions. If not Pls let me know. Thanks Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- Barac - posao Sent: Monday, October 29, 2001 6:25 AM To: Multiple recipients of list ORACLE-L Just curious... Could someone shed some light on INTERESTED TRANSACTIONS LIST and DELAYED BLOCK CLEANOUT? Thanks __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ITL, DELAYED BLOCK CLEANOUT
I have no problems in accessing that. Alternatively you can find that at http://www.revealnet.com/newsletter/newsletter_1100.htm Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- Thapliyal Sent: Monday, October 29, 2001 11:05 AM To: Multiple recipients of list ORACLE-L is this page still available or has been moved. I got an error trying to access the link Thx Deepak --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Hi, The document is a draft copy. There are few (not much tech) errors. So take that with a pinch of salt Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- Gopalakrishnan Sent: Monday, October 29, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Vladimir, Have a look at http://www.geocities.com/kgkrish/transactions.html This will solve most of your questions. If not Pls let me know. Thanks Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- Barac - posao Sent: Monday, October 29, 2001 6:25 AM To: Multiple recipients of list ORACLE-L Just curious... Could someone shed some light on INTERESTED TRANSACTIONS LIST and DELAYED BLOCK CLEANOUT? Thanks __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ITL, DELAYED BLOCK CLEANOUT
I have no problems in accessing that. Alternatively you can find that at http://www.revealnet.com/newsletter/newsletter_1100.htm Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- Thapliyal Sent: Monday, October 29, 2001 11:05 AM To: Multiple recipients of list ORACLE-L is this page still available or has been moved. I got an error trying to access the link Thx Deepak --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Hi, The document is a draft copy. There are few (not much tech) errors. So take that with a pinch of salt Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- Gopalakrishnan Sent: Monday, October 29, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Vladimir, Have a look at http://www.geocities.com/kgkrish/transactions.html This will solve most of your questions. If not Pls let me know. Thanks Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- Barac - posao Sent: Monday, October 29, 2001 6:25 AM To: Multiple recipients of list ORACLE-L Just curious... Could someone shed some light on INTERESTED TRANSACTIONS LIST and DELAYED BLOCK CLEANOUT? Thanks __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).