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(30) |
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 |