Oracle tools

Up South Africa Photos Sports Interests Guest Book Family Tree

This Page is used to link to many scripts I have written over the years as well as scripts I have picked up from other DBA's in my travels through Southern Africa and now the United States of America.  A lot of these scripts are very basic and some are are not.  New DBA's will find certain scripts very handy, while seasoned DBA's will have their own version of such scripts, if not better one's.

PLEASE NOTE

These scripts are here for all to use freely and come as is.  Most of them were written for Oracle 7 and have not been tested on Oracle 8 (Yet).  Please test them before use and no responsibility is assumed on my part for incorrect results.

Backup and Recovery

bulletFind the size of a export file without actually exporting the data

Storage

bulletOverall picture of the Database showing allocated, free, used space
bulletRecreate a table with all related objects (Indices, Foreign Keys all objects that refer to this table are recompiled
bulletDe-allocating unused space
bulletAll Indexes in a Tablespace
bulletAll Tables in a Tablespace

Installations

bulletCreating a Database
bulletCreating the Database dictionary and related objects
bulletCreating the Tablespaces
bulletCreating the Users

Performance
bulletCalculate the size of the SGA
bulletChained rows
bulletSystem Statistics
bulletPerformance measurements for file I/O and file distribution
bulletDatabase Free Space