Tech Tutorials Database
GeekArticles FAQ Oracle FAQ
 

When is a commited transaction removed form the ITL

 
Author: asktom.oracle.com
Category: Oracle FAQ
Comments (0)

Hi Tom, A transacion entry is created in the ITL in the data/index block header when a transaction modifies a block. How long does this entry stays in the ITL after the transaction is committed and do you get a snapshoot too old if a long runnig que...

Read More...




Sponsored Links




Read Next: how can I tell what sql caused my trigger to fire



 

 

Comments



Post Your Comment:

Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe