Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
V$FIXED_VIEW_DEFINITION
contains the definitions of all the fixed views (views beginning with V$
). Use this table with caution. Oracle tries to keep the behavior of fixed views the same from release to release, but the definitions of the fixed views can change without notice. Use these definitions to optimize your queries by using indexed columns of the dynamic performance tables.
Column | Datatype | Description |
---|---|---|
VIEW_NAME |
VARCHAR2(30) |
Name of the fixed view |
VIEW_DEFINITION |
VARCHAR2(4000) |
Definition of the fixed view |