Re: Run command on sqlplus repetitively without reconnection

On 5/22/07, Philip Douglass <philipsd_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l