5.250 DBA_PRIVATE_TEMP_TABLES

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

Related View

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

Note:

This view is available starting with Oracle Database 18c.

See Also: