Dynamic Performance (V$) Views, 60 of 179

V$FIXED_TABLE

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

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