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