Oracle DBA Tools - Rollback Manager Provides the monitoring and maintenance of rollback segments, including current statements, transactions and execution plans. | |
Toolbar Operations - Available Operations for General Tab | |
General Tab - Provides a list of available rollback segments Segment: Name of the rollback segment Owner: Owner of the rollback segment Tablespace: Name of the tablespace containing the rollback segment Status: Rollback segment status Transactions: Number of active transactions Initial: Initial extent size Next: Secondary extent size PCT Increase: Percent increase for extent size Current: Size of the rollback segment Optimal: Optimal size of the rollback segment Used: Current size of active extents, averaged over time Extents: Number of extents in the rollback segment Current: Current extent Block: Current block Gets: Number of header gets Waits: Number of header waits Hit Rate: (Gets-Waits)*100/Gets USN: ID number of the rollback segment | |
Transaction Users Tab - Provides a list of active transactions on the selected rollback segment Rollback Seg: ID number of the rollback segment Session ID: Session identifier Serial #: Session serial number OS User: Operating System client user name Oracle User: Oracle username Start Time: Starting time of the operation Status: Status of the session | |
Current Statement Tab - The current SQL statement on the select transaction. | |
Open Cursors Tab - Provides a list of open cursors on the session ID of the selected transaction SQL: SQL Text for the open cursor Last Loaded: Time at which the query plan was loaded into the library cache |