Undo Usage
Click the [Analysis] > [Usage Analysis] > [Undo Usage] menu in the global navigation bar to open the Undo Usage screen.
Undo Usage
This screen displays the changes in Undo size by time unit for the specified period.
Total Undo Usage
The users can view detailed information about the total Undo usage of the selected items in Undo Usage.
Log Time
Collection time
Tablespace Name
Tablespace name
Used/Total Size
Used undo status
Session Undo Usage
The users can view detailed information about sessions that used Undo for the selected item during the specified time period.
SID
Session SID
Serial #
Serial number
User Name
Session user name
Program
Session program name
Max Used
Maximum Undo Size
Avg Used
Average Undo usage size
Max Segment Block
Maximum number of segment blocks
Avg Segment Block
Average segment block count
Undo Detail
When the users click Sid in Session Undo Usage, the users will be taken to the Undo Detail page.
On this page, the users can view the usage and change in undo usage in minutes and seconds.
Additionally, session information can be viewed at the bottom of the page.
Last updated