V$FIXED_TABLE
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:
|