RE: Run command on sqlplus repetitively without reconnection.
- From: "Thotangare, Ajay \(GTI\)" <Ajay_Thotangare@xxxxxx>
- To: "Pal, Raj" <Raj.Pal@xxxxxxxxxxxx>
- Date: Wed, 9 May 2007 12:29:08 -0400
Hi,
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.
regards,
Ajay
_____
From: Pal, Raj [mailto:Raj.Pal@xxxxxxxxxxxx]
Sent: Wednesday, May 09, 2007 11:43 AM
To: Thotangare, Ajay (GTI)
Subject: RE: Run command on sqlplus repetitively without reconnection.
I don't really know why you don't want to reconnect... but you might
consider a plsql loop that includes a "!sleep" after your command.
Does that make sense?
---------------------------------------------------
RAJ@xxxxxxxxxxxx <mailto:RAJ.PAL@xxxxxxxxxxxx>
_____
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thotangare, Ajay
(GTI)
Sent: Wednesday, May 09, 2007 9:23 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Run command on sqlplus repetitively without reconnection.
I want to run a command on sqlplus without making re-connection. At the
same time I also want to see the output.
I can do this using UNIX but only problem is I have to make reconnection
after every interval(which I don't want)
For e.g I run following script on unix prompt
#########################################################
while true
do
sqlplus -S "/as sysdba" <<EOF
select event,count(*) from v$session group by event;
exit;
EOF
sleep 2
done
#########################################################
I want to achive same functionality without making reconnection after
every 2 secs.
I tried to use loop,spool file and dbms_lock.sleep() but spool file does
not display output till the procedure is completed
Can anybody help to achive this functionality ?
regards,
Ajay
_____
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 <http://www.ml.com/email_terms/>
for important additional terms relating to this e-mail.
http://www.ml.com/email_terms/
_____
Other related posts:
