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`