Message-Id: <10562.112287@fatcity.com> From: "Igor Neyman" Date: Tue, 18 Jul 2000 12:34:56 -0400 Subject: Re: No PL/SQL Timer Function Steve, You could use DBMS_LOCK.SLEEP(seconds IN NUMBER). seconds could be specified with accuracy up to the hundredth of second (0.58 or 3.25, etc.). Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 ineyman@perceptron.com ----- Original Message ----- From: "Steve Orr" To: "Oracle-L" ; "Oracledba" Sent: Tuesday, July 18, 2000 12:00 PM 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 > > > -------- > If you're bored, then visit the list's website: http://www.lazydba.com (updated daily) > to unsubscribe, send a blank email to oracledba-unsubscribe@quickdoc.co.uk > to subscribe send a blank email to oracledba-subscribe@quickdoc.co.uk