When is a commited transaction removed form the ITL

Author: asktom.oracle.com | Published: 30th Apr 2008 | Visited: 103 times | Add Comment
Filed in: Oracle FAQ

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 Article

Sponsored Links

• Dim Out the Main Form of an Application When Modal Form is Displayed in Delphi TIPS :: Dialog windows you use to display critical information to the user are, in most cases, displayed modally. A modal form is one where the application can' ...

• Read committed--Why transaction can read uncommitted data Hello Tom Thanks for your time.. I have a question: I understand that by default Oracle uses read committed by statement level, normally other session can't see the modification execept the session that makes the modification itself. Read c ...

• About the transaction status in oracle 9i Hello Tom Thanks for your time.. I am using oracle 9i(9.2.0.1) databases. And some day I find there is a column (status) in the v$transaction and I understand if there is a transaction open and not committed, the status always shows active. If ...

• Form Print Control An extender control to make printing a form quick, easy and flex ...

• Building ASP.NET Web Pages Dynamically in the Code-Behind - Part 2: A Form Example This article shows a technique for building ASP.NET Web pages where the entire page contents are created dynamically in code-be ...

• Using A Single Transaction With Multiple Typed DataSets Provides a detailed explanation of how to implement a single transaction across multiple Typed Data ...

• Drag and Drop on a Windows Form How to insert an image on a form in runtime mode, dragging it to the right position and by using a database retrieve the position and shape when starting the application up a ...

• Windows Forms Validation w/ ErrorProvider Control Quickly (Validate Whole Form at Once) Windows Forms Validation w/ ErrorProvider Control Quickly (Validate Whole Form at O ...

• Restore Form Position and Size in C# Presents some logic and code to intelligently restore windows' sizes and positi ...

• Form Changed Control A component that allows you to monitor all the controls on the form and list any that have changed (for dirty check ...

Next: Performance Bottleneck