Introduction to DBAHelper
What is DBAHelper?

DBAHelper is a collection of scripts to ease the day-to-day work of an Oracle DBA. Not everything can be done automatically (otherwise we'ld lose our jobs ;) - but certain tasks re-occur in the same order very often. In these cases we like to save some keystrokes and let the scripts do the job.

What scripts are available with DBAHelper?

In the following table you find a short listing of all scripts available with the DBAHelper collection, including a short description. For more detailed explanations, see the scripts usage page.

ScriptDescription
Generate_createdb.sh Reverse engineer the database creation script from a running instance
analobj.sh Analyze tables and/or indices of a given schema and, for tables, report concerning chained/migrated rows
idxmove.sh Move all indices from one tablespace to another
idxrebuild_all.sh Rebuild all indices for a given tablespace (or for the entire database) and adjust storage settings for faster access and less fragmentation
idxrebuild_inv.sh Rebuild all invalid indices for a given tablespace (or for the entire database)
lazywaste.sh Show resources wasted by "lazy" (long time inactive) sessions
tabmove.sh Move all tables from a given tablespace into another tablespace
tabreorg.sh Re-organize all tables where the amount of chained/migrated rows exceeds a given treshhold and adjusts their storage settings for faster access and less fragmentation
rman/rman.sh A front-end to the Oracle Recovery Manager aka RMAN to ease its use.
Where to find the latest information/version?

From time to time this collection may be updated. This will mostly happen, when I needed some new script for a certain purpose and thus added it to the collection - or if there were bugs found with existing scripts, or new features additionally required. When time permits, the documentation will be updated, too... Then, whenever I find it's worth it, I will release a new package.

For the always latest information on DBAHelper, as well as on my other products, just visit the IzzySoft website. In case of questions/suggestions, you also may use the contact form available there.