Pages
Categories
Apex Audit Book review Bugs Character sets Database links Dataguard Email General musings Grid control Installs Linux Materialized views Old Oracle forms Oracle User Group Performance tuning PL/SQL RAC Rman Scripts Security Sharepoint Space Spfile SQL*Net SQL Developer SQL server Stats Uncategorized VMWare 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 (11)
- Linux (18)
- Materialized views (3)
- Old (1)
- Oracle forms (4)
- Oracle User Group (1)
- Performance tuning (18)
- PL/SQL (4)
- RAC (7)
- Rman (11)
- Scripts (33)
- Security (3)
- Sharepoint (1)
- Space (6)
- Spfile (2)
- SQL Developer (1)
- SQL server (7)
- SQL*Net (4)
- Stats (4)
- Uncategorized (17)
- VMWare (1)
- Windows (7)
- Wordpress (3)
Archives
- June 2013
- May 2013
- March 2013
- February 2013
- January 2013
- November 2012
- October 2012
- July 2012
- June 2012
- 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
- balram on Oracle Developer Suite 10g 9.0.4.0.1 windows software download media
- tory burch tote sale on Data block corruption cleared with alter system flush buffer_cache
- Bearer of Pain on Oracle Developer Suite 10g 9.0.4.0.1 windows software download media
- Andrew Fraser on Make indexes unusable before big insert
- Jon Adams on Make indexes unusable before big insert
Monthly Archives: February 2012
Change many oracle database parameters using a temporary pfile/init.ora from spfile
Spfiles are better than pfiles (init.ora’s) for most purposes, since they allow parameters to be changed with “alter system set parameter” SQL commands. However if you want to change a whole load of parameters in one go, it is easier … Continue reading
Posted in Spfile
Leave a comment
List all crons and database links with scripts
I’m currently listing all interfaces – database links and cron jobs – into excel, and used these two scripts to automate the process. Shell script to list all crons (note that this assumes crons in /etc/cron.d run as root): for … Continue reading
Posted in Database links, Scripts
Leave a comment