Versions Compared

Old Version 3

changes.mady.by.user Nadine Hinojosa

Saved on

compared with

New Version Current

changes.mady.by.user Nadine Hinojosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Oracle DBA Tools - Rollback Manager

Provides the monitoring and maintenance of rollback segments, including current statements, transactions and execution plans.
Oracle DBA Tools - Rollback ManagerImage RemovedImage Added

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
Image AddedOracle DBA Tools - Rollback Manager - General TabImage Removed

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
Image AddedOracle DBA Tools - Rollback Manager - Transaction Users TabImage Removed

Oracle DBA Tools - Rollback Manager - Transaction Users Tab


 
Current Statement Tab - The current SQL statement on the select transaction.
Image AddedOracle DBA Tools - Rollback Manager - Current Statement TabImage Removed

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
Image AddedOracle DBA Tools - Rollback Manager - Open Cursors TabImage Removed

Oracle DBA Tools - Rollback Manager - Open Cursors Tab

...