Oracle DBA Tools - Rollback Manager
Provides the monitoring and maintenance of rollback segments, including current statements, transactions and execution plans.
|
Toolbar Operations -
Refresh : Will refresh all tabs in the rollback manager from the database
Create Rollback Segment: Create a new rollback segment
Edit Rollback Segment: Edit selected rollback segment
Drop Rollback Segment: Drop selected rollback segment
Rollback Segment Properties: View properties of selected rollback segment
Refresh Seconds: The interval in which to refresh the tabs if "Auto Refresh" is enabled
Auto Refresh: Indicates whether to refresh the tab results automatically every X number
of seconds determined by the "Refresh Seconds"
|
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
|
 Oracle DBA Tools - Rollback Manager - General Tab |
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
|
 Oracle DBA Tools - Rollback Manager - Transaction Users Tab |
Current Statement Tab - The current SQL statement on the select transaction.
|
 Oracle DBA Tools - Rollback Manager - Current Statement Tab |
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
|
 Oracle DBA Tools - Rollback Manager - Open Cursors Tab |
