## DBA Command Post Script Initiation ## This script is executed each day and is used to gather a ## daily snapshot of your database environments #! /bin/ksh # Parameter 1) Host Machine Id # 2) Database SID . ./DBA_monitor thor FIN . ./DBA_monitor zeus PER ... ... ... ... . ./DBA_monitor zeus PAY Shell script DSBA_monitor : +++++++++++++++++++++++++ #! /bin/sh sqlplus user/pword@${2} @objects.sql > ${1}.objects.`date +%d` sqlplus user/pword@${2} @files.sql > ${1}.files.`date +%d` ... ... ... ... ... ... sqlplus user/pword@T:${1}:${2} @io.sql > ${1}.io.‘date +%d‘ Monitoring Initiation Script: #! /bin/ksh . ./DBA_monitor thor FIN . ./DBA_monitor zeus PER ... ... ... ... . ./DBA_monitor zeus PAY