Friday, July 25, 2008

V$FIXED_VIEW_DEFINITION

Oracle 11gR1

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

Oracle dynamic performance views

No comments:

Post a Comment