in 9i do
SQL> show parameter spfile.
if the value is blank then the instance has started using pfile, else it will show the absolute path of the spfile it has used during startup.
|
Results 1 to 3 of 3
Thread: db started |
Click Here to Expand Forum to Full Width |