Monthly Archives: January 2007

Is database using pfile (init.ora), or spfile?

Posted on 11 January 2007 by Andrew Fraser

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 … Continue reading →

Posted in Scripts | 1 Comment

9i unix startup / shutdown with listener password

Posted on 11 January 2007 by Andrew Fraser

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 … Continue reading →

Posted in Installs, Scripts, SQL*Net | 6 Comments

Script run against every running database, listing total oracle memory (sga+pga)

Posted on 11 January 2007 by Andrew Fraser

This 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 … Continue reading →

Posted in Performance tuning, Scripts | 1 Comment