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