Temp Usage

Click [Realtime] > [Usage Monitoring] > [Temp Usage] in the global navigation bar to open the Temp Usage page.

The Temp Usage page displays session temporary usage information. The users can monitor sessions that are using excessive temporary tablespace due to inefficient execution plans or poorly written SQL statements.

The following is a description of the items provided on the Session Temp Usage page.

Item	Description
SID	Session SID
Serial#	Serial number of the session
User	Session username
Program	Session program name
Module	Session module name
Tablespace	Name of the Temp tablespace in use
Used/Total Size	Used Temp size status
Extents	Number of extents