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(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`

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

Installation
Getting Started
Administration
Application Development
Grid Computing
High Availability
Data Warehousing
Content Management and Unstructured Data
Information Integration
Security

This Document

Oracle® Database Reference 11g Release 2 (11.2)
Initialization Parameters
Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE
Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to XS_SESSION_ROLES
Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO
Dynamic Performance (V$) Views: V$INDEXED_FIXED_COLUMN to V$RULE_SET_AGGREGATE_STATS
Dynamic Performance (V$) Views: V$SCHEDULER_RUNNING_JOBS to V$XSTREAM_TRANSACTION
Database Limits
SQL Scripts
Oracle Wait Events
Oracle Enqueue Names
Statistics Descriptions
Background Processes

New and changed documents:

HTML

PDF