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.

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 checks whether there will be a problem WHEN the OBJECT extends, whether it's reasonably big, IF it's near max entents or it has many extents. (1.6 Kb)
	Big Objects: Michael Barwell: This script shows database objects that are over a configurable size (default 10M) and objects that have many extents (default 20). (0.7 Kb)
	Orphaned Synonyms: Michael Barwell: Shows orphaned synonyms i.e. syns which point TO objects that no longer exist . If objects are on remote databases you may wish to alter the script and add " AND DB_LINK is null". (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 not real pretty at the moment, but you'll get the idea of how to get it to work. (26.0 Kb)
Oracle Scripts > Tablespace and Datafiles
	Tablespace General: Michael Barwell: General Tablespace details (1.1 Kb) (1.1 Kb)