Website Design, Development, Hosting Specialists for over 12 yrs | Home | Login | About Us | Site Map | Search
Website Design Newcastle Web Development Newcastle Web Hosting by Telligence.

Document Library

Over the years we have collected lots of scripts that have come in handy when analyzing and working with Oracle databases. We'd like to share some of these scripts with you (in true GNU-like style).

Most of these scripts have been put together based specific work we have had to do with various client sites. Some have evolved over 10 years and many versions of Oracle. If they don't work on your release of Oracle, read the scripts and covert them for your version - some data dictionary column names have altered over time. 

The source of most of these scripts is from us, although as you can imagine, we have collated them based upon our experiences and others. Some scripts originated from the excellent Tales from the Script files from Oracle (see Metalink) and others have been picked up from the net, user groups, conferences and other DBAs.  We have tried to credit all those where possible (if we missed anything let us know).

We also have to put the big disclaimer: These scripts are provided as is. We do not guarantee them at all and accept no responsibility for their use or the conclusions you may make based upon their use.

 

Select A Category

Show All Document Categories

Recent Additions
Oracle Scripts
   Test Document: Leigh Allsop: Blank Test Document... (23.5 Kb)
 
Oracle Scripts > Database Objects
   Bad Objects: Michael Barwell: Show objects that are likely TO cause grief within the database. The script chec... (1.6 Kb)
   Big Objects: Michael Barwell: This script shows database objects that are over a configurable size (default 10... (0.7 Kb)
   Orphaned Synonyms: Michael Barwell: Shows orphaned synonyms i.e. syns which point TO objects that no longer exist . ... (0.8 Kb)
 
Oracle Scripts > General Database
   General8: Michael Barwell: General database status.... (6.8 Kb)
 
Oracle Scripts > Security
   Oracle Connections with SSH Tunnels: Michael Barwell: Details on how to setup an Oracle connection using ssh tunnels. The document is ... (26.0 Kb)
 
Oracle Scripts > Tablespace and Datafiles
   Tablespace General: Michael Barwell: General Tablespace details (1.1 Kb)... (1.1 Kb)