ba6.us - Dave's Database Related Stuff

A quickie script that can be run by Cron to take a StatsPack snapshot: snap.sh:

#!/bin/ksh

export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_SID=dbsid
export PATH=/u01/app/oracle/product/8.1.7/bin

sqlplus -s /nolog <