Tuesday, October 7, 2008

SPFILE OR PFILE IS USED BY CURRENT INSTANCE

SQL> show parameter SPFILE

If the output returns no rows then pfile is used.
If the output return any value with a filename(with its path) then SPFILE is used by current running instance .

No comments:

search engine

Custom Search