RE: Run command on sqlplus repetitively without reconnection.
- From: "Karla, Srini \(HAS-SAT\)" <Srini_Karla@xxxxxxxxxxxx>
- To: <jim.silverman@xxxxxxxxxxx>, <Ajay_Thotangare@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 9 May 2007 11:10:13 -0500
I didn't test your script but this will fulfill your requirement. See
changes in blue bold.
while true
do
sqlplus -S "/as sysdba" <<EOF >> test.log
select event,count(*) from v$session group by event;
exit;
EOF
sleep 2
done
Thanks,
Srini Karla
Sr. Database Administrator,
Harcourt Assessments, Inc.,
San Antonio, TX 78259
210-339-5252 work
210-683-3936 cell
---------------------------------------------------
Our Sharepoint: http://hassatappp022/sites/epa/ea/default.aspx
---------------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
jim.silverman@xxxxxxxxxxx
Sent: Wednesday, May 09, 2007 10:50 AM
To: Ajay_Thotangare@xxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Run command on sqlplus repetitively without reconnection.
How about using "spool filename append" and "spool off" in the body of
your loop? Of course, I'm not sure how you're constructing your loop,
so I'm not sure if this will work or not...
=====================================
Jim Silverman
Senior Systems Database Administrator
Solucient, LLC - A Thomson Company
Telephone: 734-669-7641
FAX: 734-930-7611
E-Mail: jim.silverman@xxxxxxxxxxx
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thotangare, Ajay
(GTI)
Sent: Wednesday, May 09, 2007 11: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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
