Hi there,

Problem:
I tried to use the SYS.DBMS_LOCK.SLEEP procedure for longer periods of inactivity. In the spec the parameter is seconds number, with no limit given. If started with 30000-40000 seconds, it sleeps only a few minutes.

I tried DBMS_ALERT.WAITONE also, which has 17 minutes delay every 12 hours.

Questions:
Is the sleep-bug a known one ?
May the waitone-delay vary on different machines ?
Which timers are used by oracle ?
Is there any really exact timer pl/sql can work with ?

Commit;
6502