First page Back Continue Last page Graphics
Monitoring Parameter Values…
Is my instance using SPFILE?
SHOW PARAMETER spfile
- Shows current value
- Same as SELECT FROM V$PARAMETER
- SPFILE will be NULL if SPFILE not in use
Notes:
The first question you may have when working with Oracle9i parameter values is “is my instance using a server parameter file?”
The answer to this question can be found in the SPFILE parameter value. Either the SHOW PARAMETER SQL*Plus command or a query on V$PARAMETER will reveal its value. If the VALUE column returns a non-NULL value, then your instance is using a SPFILE. Otherwise it is using a PFILE.