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