pfile

[kumar.j...@gmail.com]

is any parameter is there like database is working on pfile or spfile.
if database working on pfile will it works "SHOW PARAMETER PFILE" or
not.

[swathi]

Hi

when you type show parameter spfile
and it shows you the path, then it uses spfile. If it doesn't show ,
it uses pfile.

Also select distinct isspecified from v$spparameter ;
if this shows false , you are not ussing spfile.
if it is true, you are using spfile.



On 12 May, 18:34, "kumar.janid...@gmail.com"

[sampath]

Adding more to the above reply.

In oracle both "SHOW PARAMETER PFILE" and "SHOW PARAMETER SPFILE"
will give same result as the argument you specify is taken as search
pattern... It takes %<argument>%


Sampath Kumar Bodiga

> > not.- Hide quoted text -
>
> - Show quoted text -