Here you find some Scripts I wrote or co-authored. The scripts are available free to anyone to use. I do not accept any responsibility for any damage, errors or anything whatsoever caused by running or using these scripts. The scripts have been tested thoroughly but as there are many platforms, oracle versions and possible configurations, it does not mean that they will work for you when they work for me. Please review the file header for further information on the scripts, references etc before running them especially on production system.
| Date | Title | Language |
|---|---|---|
| 14. October 2013 |  dbl_drop.sql (Size 2.5 KiB / Hits 1,576) |
Script to drop all or some private database links as sysdba |
| 6. August 2013 | cpui.sql (Size 1.3 KiB / Hits 6,755) |
List of applied PSU / CPU patches |
| 24. July 2013 | taln.sql (Size 1.8 KiB / Hits 7,975) |
List/query the latest n lines of the alert log |
| 24. July 2013 | tal.sql (Size 1.7 KiB / Hits 8,734) |
list/query alert log |
| 24. July 2013 | utlpwdmg.sql (Size 17.9 KiB / Hits 27,529) |
This is a script for enabling the password management features by setting the default password resource limits. |
| 23. January 2012 | hip.sql (Size 2.1 KiB / Hits 2,813) |
List init.ora parameter including hidden parameters. |
| 23. January 2012 | oradba.tgz (Size 3.1 KiB / Hits 2,042) |
Collection of shell and SQL scripts |
| 1. May 2011 | mos_download_url.sh (Size 3.5 KiB / Hits 2,740) |
Burn shell script to download patch's from MOS |
| 1. May 2011 | tsq.sql (Size 2.7 KiB / Hits 3,315) |
SQL query to find user with unlimited quota on a tablespace |