| 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: DBMS_LOCK.SLEEP will release the resource?
Hi, Ram,
My test some time ago indicated that DBMS_LOCK.SLEEP indeed releases resources. The way I tested was simply truss (Solaris version of process tracing) the process at the OS level. You'll notice the process is put to sleep. In fact it's put in such a deep sleep you can't even kill the process (kill -9 works if I remember right). Running in SQL*Plus, Control-C won't abort the session either.
Yong Huang
yong321_at_yahoo.com
you wrote:
One of our process is continously running for 23 hours in a day. i.e Our process will keep looking on the incoming messages from Airline Reservation Systems. Some time, there will not be any messages , but still our process will be running. Since this process needs lots of resources (like CPU usuage and etc), we would like to change that process to suspend 5 minutes for each hour.
We think to implement this functionality by adding DBMS_LOCK.SLEEP(5).
Now, our question is , Due to this Sleep Statement, will this process release all the CPU usuage so that other processes can use?
Or any idea how to test this?
Thank you DBAs
Ram
 |
 |