December 2002
Intermediate to advanced
928 pages
85h 29m
English
Specific dynamic performance data dictionary views are available based on the status of the instance, as follows:
Dynamic performance data dictionary views that provide information specifically about the instance (e.g., V$PARAMETER). These are available immediately upon the instance being started.
Dynamic performance data dictionary views that provide information stored in the control files. These are available once the database has been mounted (as noted in the view description).
Dynamic performance data dictionary views that provide information about how the kernel is processing SQL statements. These are available once the database has been opened (as noted in the view description).