Very useful SQL, from Tom Kyte: select decode(count(*), 1, ‘spfile’, ‘pfile’ ) from v$spparameter where rownum=1 and isspecified=’TRUE’ ; If it it using an spfile, an easy way to see the parameters is to generate an init.ora copy: SQL> conn / as sysdba (or connect as sysoper) SQL> create pfile = ‘/tmp/init.ora’ from spfile;
Read More Is database using pfile (init.ora), or spfile?Thanks to Laurent Schneider for tips on how to handle listener passwords in scripts. [Update 12-Jan-2007 – ammended script following Laurent’s comment, and update 09-Feb-2007 – ammended script following Kevin’s comment] A system startup/shutdown shell script I just used that copes with listener passwords is below. The location of the listener.ora file was /etc in […]
Read More 9i unix startup / shutdown with listener passwordThis shell script runs against every database that is up and running (has an entry in the ps list). Which I think is better than searching through oratab (since not all of those may be up and running, esp. on dev machines). You can run any SQL within it, but this particular version prints out […]
Read More Script run against every running database, listing total oracle memory (sga+pga)