Oracle教程 2023-02-25

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

Oracle视图V$FIXED_TABLE是一个内部视图，它显示当前实例中每个固定表的详细信息，这些固定表可用于Oracle引擎中的活动对象，如等待或请求。V$FIXED_TABLE视图中包括每个表格的名称，大小，列数以及与之关联的表空间名称。

使用 Oracle 视图V$FIXED_TABLE，首先需要使用ENABLE_VFIXED_TABLE参数启用该视图，然后可以执行查询语句：SELECT * FROM V$FIXED_TABLE; 以获取 Oracle 固定表的信息。

V$FIXED_TABLE displays all dynamic performance tables, views, and derived tables in the database.

Some V$ tables (for example, V$ROLLNAME) refer to real tables and are therefore not listed.

Column	Datatype	Description
`NAME`	`VARCHAR2(128)`	Name of the object
`OBJECT_ID`	`NUMBER`	Identifier of the fixed object
`TYPE`	`VARCHAR2(5)`	Object type (`TABLE` \| `VIEW`)
`TABLE_NUM`	`NUMBER`	Number that identifies the dynamic performance table if it is of type `TABLE`
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：