Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Run command on sqlplus repetitively without reconnection

Re: Run command on sqlplus repetitively without reconnection

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 21 May 2007 15:47:09 -0700
Message-ID: <bf46380705211547q4ed167c4y1dc328dc7be56ebc@mail.gmail.com>


On 5/21/07, David Taft <oradbt054_at_gmail.com> wrote:
>
>
> I am got the following error when I tried to download from that link:
>
> The requested URL /downloads/sqlshell<em>scripts.tgz was not found on this
> server.
>

Someone else beat you to it, already fixed. :)

Also, usually when troubleshooting problems in production, I will run some
> query(s) and then have to keep hitting the forward-slash/enter to monitor
> for changes. At the same time I am usually running SQL in one or two
> other xterm windows to troubleshoot the problem. I hope to use
> the coprocessing script to monitor for these various changes
> without continuous manual interaction (or at least this is what I hope to
> accomplish). Depending on the problem, I should be able to plug in the
> customized SQL, while the rest of the code remains the same .
>
>

Let us know if you find something useful for it.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 21 2007 - 17:47:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US