Provides the monitoring and maintenance of rollback segments, including current statements, transactions and execution plans.
Toolbar Operations -
Available Operations for General Tab Refresh: Refreshes all the tab results from the database Reconnect: Reconnects to the database server Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed Create Rollback Segment: Creates a new rollback segment Edit Rollback Segment: Edits selected rollback segment Drop Rollback Segment: Drops selected rollback segment Rollback Segment Properties: Shows properties of selected rollback segment Refresh Seconds: Enables the interval in which to refresh the tabs if you check the "Auto Refresh" box Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds" Size: Shows the different sizes in the selected unit of measurement
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