Pages
Categories
Apex Audit Book review Bugs Character sets Database links Dataguard Email General musings Grid control Installs Linux Materialized views Old Oracle forms Performance tuning PL/SQL RAC Rman Scripts Security Sharepoint Space Spfile SQL*Net SQL Developer SQL server Stats Uncategorized Windows WordpressCategories
- Apex (1)
- Audit (1)
- Book review (2)
- Bugs (6)
- Character sets (6)
- Database links (2)
- Dataguard (1)
- Email (3)
- General musings (6)
- Grid control (2)
- Installs (10)
- Linux (16)
- Materialized views (2)
- Old (1)
- Oracle forms (4)
- Performance tuning (17)
- PL/SQL (4)
- RAC (6)
- Rman (10)
- Scripts (30)
- Security (3)
- Sharepoint (1)
- Space (6)
- Spfile (2)
- SQL Developer (1)
- SQL server (5)
- SQL*Net (4)
- Stats (4)
- Uncategorized (7)
- Windows (7)
- Wordpress (3)
Archives
- April 2012
- March 2012
- February 2012
- December 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- April 2009
- March 2009
- November 2008
- January 2008
- November 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
Recent Comments
- Shaikh Mujahid on Oracle Developer Suite 10g 9.0.4.0.1 windows software download media
- Ranjith on ORA-38029 Object Statistics Are Locked – due to import with rows=n
- Shaikh Mujahid on Oracle Developer Suite 10g 9.0.4.0.1 windows software download media
- Tom on Fix for TOAD error ORA-02404: specified plan table not found
- fayaz on Oracle Forms popup dialog alert box
Monthly Archives: January 2007
Is database using pfile (init.ora), or spfile?
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
9i unix startup / shutdown with listener password
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)
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