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 at various client sites. Someof these scripts 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 colated 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 use know).

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

If you'd like to submit scripts, send them into us at ora_scripts@barwell.com.au and we'll put them here for all to see and use.

Recent Additions
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)
		Orphaned Synonyms: Michael Barwell: Shows orphaned synonyms i.e. syns which point TO objects that no longer exist . ... (0.8 Kb)
		Big Objects: Michael Barwell: This script shows database objects that are over a configurable size (default 10... (0.7 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)