Re: how can see my database is in pfile or spfile mode ?

sql> show parameter spfile

or

sql> select * from V$parameter where name='spfile';

If there is a value there, you are using a spfile.

HTH. Cheers.

Carlos. Received on Fri Mar 24 2006 - 04:33:09 CST