| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: No PL/SQL Timer Function
Thanks to all on the DBMS_LOCK.SLEEP tip. I believe Walt gets to go to the
hot seat for answering most quickly... Regardless, all were quicker than the
1/2 hour I spent looking in the docs ...and that's my "final answer."
Steve Orr
-----Original Message-----
From: Weaver, Walt [mailto:wweaver_at_rightnowtech.com]
Sent: Tuesday, July 18, 2000 9:24 AM
To: 'steve_at_arzoo.com'; Oracle-L; Oracledba
Subject: RE: No PL/SQL Timer Function
Steve,
Will DBMS_LOCK.SLEEP work for you?
--Walt Weaver
Bozeman, Montana, USA
-----Original Message-----
From: Steve Orr [mailto:sorr_at_arzoo.com]
Sent: Tuesday, July 18, 2000 10:01 AM
To: Oracle-L; Oracledba
Subject: No PL/SQL Timer Function
I can't find a timer function in PL/SQL. Without a major development effort I'd like to QUICKLY write a monitoring script which executes a query at a given interval over a certain period of time. Here's a hypothetical example... a query against the v$session and v$access tables every 15 seconds for the next 60 minutes. I need something like a UNIX shell "sleep 15" but I want the timer looping to be from a persistent connection so there's no connect/disconnect from the database every few seconds. I guess I could get a modulus of the results from DBMS_UTILITY.GET_TIME to develop my own timer function. Has anyone done something like this in PL/SQL? Any ideas? Please? Pretty please?
TIA,
Steve Orr
 |
 |