I have found this very useful SQL to identify what type of initialization parameter file an oracle instance has started with.
Found this on Thomas Kyte’s site at http://asktom.oracle.com most useful information as ever!
Run the following as SYSDBA.
SELECT DECODE(COUNT(*), 1, 'spfile', 'pfile')
FROM V$SPPARAMETER
WHERE ROWNUM = 1
AND ISSPECIFIED = ‘TRUE’
Database Systems is a blog about Databases and Data of any size and shape
No comments:
Post a Comment