First page Back Continue Last page Graphics
…Using SPFILE
Use caution including parameters other than SPFILE
Assume init.ora contains
Oracle uses last parameter it finds
- Shared pool will be 50000000, regardless of SPFILE setting
Notes:
When specifying the SPFILE parameter, you can still define other parameters in your parameter file. However, remember the parameter file is read sequentially. Why is this important? If you specify the same parameter in your SPFILE and in your parameter file, then the parameter value that is read last will take precedence over others.
Example, initprod.ora entries:
SPFILE=c:\oracle\admin\ora91\pfile\spfileprod.ora
SHARED_POOL_SIZE=50000000
TIMED_STATISTICS=TRUE
OPEN_CURSORS=300
In the above example, since the SPFILE parameter is listed before any of the other initprod.ora parameters, and if it contains settings for SHARED_POOL_SIZE or OPEN_CURSORS, etc…, they will be over-ridden and not used during the instance startup since the parameters are set again later in the initprod.ora file.