RE: Run command on sqlplus repetitively without reconnection.

  • From: "Thotangare, Ajay \(GTI\)" <Ajay_Thotangare@xxxxxx>
  • To: "Jared Still" <jkstill@xxxxxxxxx>
  • Date: Wed, 9 May 2007 16:29:29 -0400

Sorry for me not being specific in explaining my problem. Also sorry if
my language gave same wrong impression.

I think the latest solution using UTL_FILE from Siva Valiveru works for

Thanks everybody for your support.



From: Jared Still [mailto:jkstill@xxxxxxxxx] 
Sent: Wednesday, May 09, 2007 3:55 PM
To: Thotangare, Ajay (GTI)
Cc: Pal, Raj; oracle-l@xxxxxxxxxxxxx
Subject: Re: Run command on sqlplus repetitively without reconnection.



On 5/9/07, Thotangare, Ajay (GTI) <Ajay_Thotangare@xxxxxx> wrote:

I don't want constant re-connection. I want to use this logic and fire
some queries every secs during certain period for proactive monitoring.
making so many connections is not acceptable.

Most knowledgeable folks are willing to help.

They usually are not willing however to guess about your 
intent, platform, Oracle versions, etc..

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

If you are not an intended recipient of this e-mail, please notify the sender, 
delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 

Other related posts: