On 5/22/07, Philip Douglass <philipsd@xxxxxxxxx> wrote:
Here's what I've been using for awhile now to accomplish the repetitive
monitoring script in SQL*Plus pattern:
#!/bin/ksh
sqlplus -s / |& # Open a pipe to SQL*Plus
cat <& p &
print -p -- "exec dbms_application_info.set_client_info(client_info =>
'${USER}@${HOSTNAME}');"
print -p -- "exec dbms_application_info.set_module(module_name =>
'$(basename $0)', action_name => '$1');"
print -p -- "@$1"
while (true); do
sleep $2
print -p -- '/'
done
Thanks, this is clever. Just now I have a use for it. :) -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist
