This view 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 |