ORACLE DBA scripts

Scripts

We have a large number of scripts that perform different tasks on your databases. Here are just some of them. If you need an Oracle script to perform a specific task, please contact us.
Each of the SQL-based scripts in the list below have been designed to run in SQL*Plus, and each of the shell scripts have been designed to run in the korn shell.

scripts.zip	All scripts

hotbackup.sh	Korn shell script to perform a hot backup
checkfilesystem.sh	Korn shell script to alert DBA of filling up filesystems
fullexport.sh	Korn shell script to perform full database export
verifydb.sh	Korn shell script to verify database files
toobig.sql	SQL to list segments that cannot extend
explain.sql	SQL to show explain plan without running statement
hackuser.sql	SQL to hack into account without knowing password
sqlpluscondition.sql	SQL example of conditional logic in SQL*Plus
backups.sql	SQL to show online backup status of database files
free.sql	SQL to graphically show tablespace usage
jobs.sql	SQL to show status of scheduled jobs
seswait.sql	SQL to show waiting sessions
cursta.sql	SQL to show currently active sessions and statements