Options
- if you want to run the script in the background, then 'cron' or windows scheduler will do the job
- if you want it in your current unix session, then some simple shell scripting, eg
while true
do
sqlplus -s -L /nolog @myscript.sql
sleep 30
done
- or if you want something that just never finishes (like 'top' etc), then you could check out the internals of MOATS
http://blog.tanelpoder.com/2011/03/29/moats-the-mother-of-all-tuning-scripts/ which uses some formatting trickery to give the appearance of being 'top-like'