Script

Description

hotbackup.sh

Korn shell script to perform a hot backup (online backup)

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 + statements

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

sqlpluscondition.sql

SQL example of conditional logic in SQL*Plus