Re: Run command on sqlplus repetitively without reconnection

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

Other related posts: