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 |
---|---|---|---|
|
|
|
Session ID of the session that created the private temporary table |
|
|
|
Session serial number of the session that created the private temporary table |
|
|
|
Instance ID of the session that created the private temporary table |
|
|
|
Owner name of the private temporary table |
|
|
|
Private temporary table name |
|
|
|
Private temporary table's tablespace name |
|
|
|
Private temporary table's duration (for example, |
|
|
|
Number of rows in the private temporary table when analyzed |
|
|
|
Number of blocks used by private temporary table |
|
|
|
Average row length |
|
|
|
Timestamp of last analyze |
|
|
|
Transaction ID of the transaction duration private temporary table |
|
|
|
Save point number of the transaction duration private temporary table |
Note:
This view is available starting with Oracle Database 18c.
See Also:
-
Oracle Database Administrator’s Guide for an introduction to private temporary tables