RE: Run command on sqlplus repetitively without reconnection

  • From: "Wolfson Larry - lwolfs" <lawrence.wolfson@xxxxxxxxxx>
  • To: <jkstill@xxxxxxxxx>, <philipsd@xxxxxxxxx>
  • Date: Wed, 23 May 2007 16:22:27 -0500

So do I!
    I did change 
sqlplus -s /nolog |& # Open a pipe to SQL*Plus
    print -p -- '/'
    print -p -- "@$1"
    as now I can have a $1 sql that 
can be changed like:
    so if we need to run a different script we can.
If say, you get 
00020, 00000, "maximum number of processes (%s) exceeded"
    Thanks, Philip, Jared, et. al.


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Wednesday, May 23, 2007 1:23 PM
To: philipsd@xxxxxxxxx
Cc: oradbt054@xxxxxxxxx; cichomitiko@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: 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:
        sqlplus -s / |& # Open a pipe to SQL*Plus
        cat <& p &
        print -p -- "exec
dbms_application_info.set_client_info(client_info =>
        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 -- '/'

Thanks, this is clever.
Just now I have a use for it. :)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.

If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank you.

Other related posts: