Oracle教程 2023-02-24

Oracle 视图 DBA_PRIVATE_TEMP_TABLES 官方解释，作用，如何使用详细说明

Oracle视图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	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