#!/bin/ksh

#SAMPLE_TIME=300
SAMPLE_TIME=10

while true
do

#********************************************************
# Collect the begin-stats 
#********************************************************
sqlplus -s / <<EOF
@bstat_file
exit
EOF

#********************************************************
# Now sleep for the specified interval between samples
#********************************************************
sleep ${SAMPLE_TIME}

#********************************************************
# Collect the end-stats and add rows to the table
#********************************************************
sqlplus -s / <<EOF
@estat_file ${SAMPLE_TIME}
exit
EOF

Done