RE: No PL/SQL Timer Function

--openmail-part-0988a0bf-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

> 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?

Steve,

May I also add another tip to your utility? A little-known column called FIXED_TABLE_SEQUENCE in V$SESSION contains a number that increases every time the session completes a call to the database and there has been an intervening select from a dynamic performance table. This column can be used by performance monitors that wish to monitor statistics in the database. Each time the performance monitor looks at the database, it only needs to look at sessions that are currently active or have a higher value in this column then the highest value that the performance monitor saw the
last time. All the other sessions have been idle since the last time the performance monitor looked at the database. (Cut and paste from doco).

John Kanagaraj
Brunei Shell Petroleum
http://www.geocities.com/john_sharmila

God so loved the world that He didn't send a committee! (See John 3:16 for details)

Watch your thoughts, it becomes word. Watch your words, it becomes actions. Watch your actions, it becomes your habit. Watch your habit, it becomes your character. Watch your character, it becomes your Destiny : Michael Buen - alleged co-author of the love bug virus

• Opinions expressed here are solely mine and not necessarily those of my employer **

--openmail-part-0988a0bf-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+IsC8AQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEAHQAAAFJFOiBObyBQTC9T UUwgVGltZXIgRnVuY3Rpb24AEAkBBYADAA4AAADQBwcAEwALAAUAAQADAAUBAQCAAACgAAAA BACgAEIATgBKb2huIEouIEthbmFnYXJhaiAvRklDMzIxLE9QRU5NQUlML289QlJVTkVJIFNI RUxMIFBFVFJPTEVVTSBTRVJJQQBPUEVOTUFJTDpKb2huIEouIEthbmFnYXJhaiAvRklDMzIx LE9QRU5NQUlML289QlJVTkVJXCBTSEVMTFwgUEVUUk9MRVVNXCBTRVJJQQAAAAAAAAAAACcq ASCAAwAOAAAA0AcHABMACwABACIAAwAiAQEJgAEAIQAAADdDQUQyRDA1MDQ1REQ0MTE5Mzc3 MDA2MDk3OTkxMUIzAOoGAQSQBgD8BQAAAwAAABAAAAADAAAwBAAAAAsADw4AAAAAAgH/DwEA AABVAAAAAAAAAI1VTNDsPBHOgf8IAAmxA3oBAAAACwAAAAAAAAAxHW9yYWNsZS1sHjUdbWlt ZR4xNh1IUE1FWFQxHjE3HW9yYWNsZS1sQGZhdGNpdHkuY29tAAAAAB4AAjABAAAACQAAAE9Q RU5NQUlMAAAAAB4AAzABAAAAJgAAAG9yYWNsZS1sIC9taW1lIChvcmFjbGUtbEBmYXRjaXR5 LmNvbSkAAAADABUMAQAAAAMA/g8GAAAAHgABMAEAAAAmAAAAb3JhY2xlLWwgL21pbWUgKG9y YWNsZS1sQGZhdGNpdHkuY29tKQAAAAIBCzABAAAALwAAAE9QRU5NQUlMOm9yYWNsZS1sIC9t aW1lIChvcmFjbGUtbEBmYXRjaXR5LmNvbSkAAAMAADkAAAAACwBAOgEAAAAeAPZfAQAAACYA AABvcmFjbGUtbCAvbWltZSAob3JhY2xlLWxAZmF0Y2l0eS5jb20pAAAAAgH3XwEAAABVAAAA AAAAAI1VTNDsPBHOgf8IAAmxA3oBAAAACwAAAAAAAAAxHW9yYWNsZS1sHjUdbWltZR4xNh1I UE1FWFQxHjE3HW9yYWNsZS1sQGZhdGNpdHkuY29tAAAAAAMA/V8BAAAAAwD/XwAAAAACAfYP AQAAAAQAAAAAAAAEEAAAAAMAADAFAAAACwAPDgAAAAACAf8PAQAAAFoAAAAAAAAAjVVM0Ow8 Ec6B/wgACbEDegEAAAALAAAAAAAAADEdb3JhY2xlZGJhHjUdbWltZR4xNh1IUE1FWFQxHjE3 HW9yYWNsZWRiYUBRdWlja0RvYy5jby51awAAAB4AAjABAAAACQAAAE9QRU5NQUlMAAAAAB4A AzABAAAAKwAAAG9yYWNsZWRiYSAvbWltZSAob3JhY2xlZGJhQFF1aWNrRG9jLmNvLnVrKQAA AwAVDAEAAAADAP4PBgAAAB4AATABAAAAKwAAAG9yYWNsZWRiYSAvbWltZSAob3JhY2xlZGJh QFF1aWNrRG9jLmNvLnVrKQAAAgELMAEAAAA0AAAAT1BFTk1BSUw6b3JhY2xlZGJhIC9taW1l IChvcmFjbGVkYmFAUXVpY2tEb2MuY28udWspAAMAADkAAAAACwBAOgEAAAAeAPZfAQAAACsA AABvcmFjbGVkYmEgL21pbWUgKG9yYWNsZWRiYUBRdWlja0RvYy5jby51aykAAAIB918BAAAA WgAAAAAAAACNVUzQ7DwRzoH/CAAJsQN6AQAAAAsAAAAAAAAAMR1vcmFjbGVkYmEeNR1taW1l HjE2HUhQTUVYVDEeMTcdb3JhY2xlZGJhQFF1aWNrRG9jLmNvLnVrAAAAAwD9XwEAAAADAP9f AAAAAAIB9g8BAAAABAAAAAAAAAUQAAAAAwAAMAYAAAALAA8OAAAAAAIB/w8BAAAASwAAAAAA AACNVUzQ7DwRzoH/CAAJsQN6AQAAAAsAAAAAAAAAMR1zb3JyHjUdbWltZR4xNh1IUE1FWFQx HjE3HXNvcnJAYXJ6b28uY29tAAAeAAIwAQAAAAkAAABPUEVOTUFJTAAAAAAeAAMwAQAAABwA AABzb3JyIC9taW1lIChzb3JyQGFyem9vLmNvbSkAAwAVDAIAAAADAP4PBgAAAB4AATABAAAA HAAAAHNvcnIgL21pbWUgKHNvcnJAYXJ6b28uY29tKQACAQswAQAAACUAAABPUEVOTUFJTDpz b3JyIC9taW1lIChzb3JyQGFyem9vLmNvbSkAAAAAAwAAOQAAAAALAEA6AQAAAB4A9l8BAAAA HAAAAHNvcnIgL21pbWUgKHNvcnJAYXJ6b28uY29tKQACAfdfAQAAAEsAAAAAAAAAjVVM0Ow8 Ec6B/wgACbEDegEAAAALAAAAAAAAADEdc29ych41HW1pbWUeMTYdSFBNRVhUMR4xNx1zb3Jy QGFyem9vLmNvbQAAAwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAAbkVAEDkAYATAQA ACYAAAALAAIAAQAAAAsAIwAAAAAAAwAmAAAAAAALACkAAAAAAAsAKwAAAAAAAwAuAAAAAAAC ATEAAQAAAAEAAAAAAAAAAwA2AAAAAABAADkAoHJKIS7xvwEeAEIAAQAAAEIAAABKb2huIEou IEthbmFnYXJhaiAvRklDMzIxLE9QRU5NQUlML289QlJVTkVJIFNIRUxMIFBFVFJPTEVVTSBT RVJJQQAAAEAASACg3NMjLvG/AR4AcAABAAAAGQAAAE5vIFBML1NRTCBUaW1lciBGdW5jdGlv bgAAAAACAXEAAQAAABYAAAABv/EuIO0FLa1+XQQR1JN3AGCXmRGzAAAeABoMAQAAAEIAAABK b2huIEouIEthbmFnYXJhaiAvRklDMzIxLE9QRU5NQUlML289QlJVTkVJIFNIRUxMIFBFVFJP TEVVTSBTRVJJQQAAAAIBHQwBAAAATgAAAE9QRU5NQUlMOkpPSE4gSi4gS0FOQUdBUkFKIC9G SUMzMjEsT1BFTk1BSUwvTz1CUlVORUlcIFNIRUxMXCBQRVRST0xFVU1cIFNFUklBAAAAHgAe DAEAAAAJAAAAT1BFTk1BSUwAAAAAHgAfDAEAAABFAAAASm9obiBKLiBLYW5hZ2FyYWogL0ZJ QzMyMSxPUEVOTUFJTC9vPUJSVU5FSVwgU0hFTExcIFBFVFJPTEVVTVwgU0VSSUEAAAAAHgBC EAEAAAABAAAAAAAAAAMAgBD/////QAAHMLCsDrAs8b8BQAAIMICplqUt8b8BAwDeP69vAAAL AACACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAAoAIIAYAAAAAAMAAAAAAAABGAAAA ABCFAAAAAAAAAwAIgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAADABaACCAGAAAAAADA AAAAAAAARgAAAAARhQAAAAAAAAMAJ4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAADjFQAAHgAo gAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC41AAsAKYAIIAYAAAAAAMAAAAAA AABGAAAAAAaFAAAAAAAACwAtgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAC+ACCAG AAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4APYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAAB AAAAAQAAAAAAAAAeAD6ACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgA/ gAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAsASoALIAYAAAAAAMAAAAAA AABGAAAAAACIAAAAAAAACwBMgAsgBgAAAAAAwAAAAAAAAEYAAAAABYgAAAAAAAAeAD0AAQAA Received on Tue Jul 18 2000 - 22:05:09 CDT