DBA_PRIVATE_TEMP_TABLES

DBA_PRIVATE_TEMP_TABLES describes all of the private temporary tables in the database.

USER_PRIVATE_TEMP_TABLES describes the private temporary tables in the current session. This view does not display the INST_ID column.

Column Datatype NULL Description
SID NUMBER   Session ID of the session that created the private temporary table
SERIAL# NUMBER   Session serial number of the session that created the private temporary table
INST_ID NUMBER   Instance ID of the session that created the private temporary table
OWNER VARCHAR2(128)   Owner name of the private temporary table
TABLE_NAME VARCHAR2(128)   Private temporary table name
TABLESPACE_NAME VARCHAR2(128)   Private temporary table’s tablespace name
DURATION VARCHAR2(128)   Private temporary table’s duration (for example, SESSION or TRANSACTION)
NUM_ROWS NUMBER   Number of rows in the private temporary table when analyzed
BLOCKS NUMBER   Number of blocks used by private temporary table
AVG_ROW_LEN NUMBER   Average row length
LAST_ANALYZED DATE   Timestamp of last analyze
TXN_ID RAW(8)   Transaction ID of the transaction duration private temporary table
SAVE_POINT_NUM NUMBER   Save point number of the transaction duration private temporary table

See Also: