First page Back Continue Last page Graphics
…Monitoring Parameter Values
Monitor with data dictionary views
- V$PARAMETER
- V$SPPARAMETER
- V$PARAMETER2
- Contains ORDINAL column
- See example next…
- SHOW PARAMETER command
- Same as SELECT FROM V$PARAMETER
Notes:
Initialization parameters for pfiles and spfiles can be monitored with the V$PARAMETER, V$PARAMETER2, and V$SPPARAMETER data dictionary views.
Warning: The values listed in v$spparameter are not necessarily the current, in-use values. If you have used a text parameter file and included the SPFILE parameter and other parameters following SPFILE, the values in v$spparameter could be different from the value in v$parameter. This is because the parameters following SPFILE will override the SPFILE versions of the parameters.