Home

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?

Script	Explanation
Generate_createdb.sh	Reverse engineer the database creation script from a running instance
ExportOracleDB	Create a full database backup for the local instance specified by ORACLE_SID using the exp utility
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
sqltune	Run an SQL Tuning Advisor Task and display results (for Oracle 10g and higher)
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
undo_used.sh	List up undo records used by current processes to identify the "eaters" (Oracle 9i and higher)
rman/rman.sh	A front-end to the Oracle Recovery Manager aka RMAN to ease its use.

Is there more Information available?

There is an article available on the RMan Framework (rman/rman.sh).