DBA_PRIVATE_TEMP_TABLES

Previous Next JavaScript must be enabled to correctly display this content

5.253 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

See Also:

"USER_PRIVATE_TEMP_TABLES"
"PRIVATE_TEMP_TABLE_PREFIX"
Oracle Database Administrator’s Guide for an introduction to private temporary tables