if sleep is like in a LATCH then it will yield the CPU
> ----------
> From: Ramlal K Chithu[SMTP:TS2182_at_emirates.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Tuesday, January 16, 2001 1:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: DBMS_LOCK.SLEEP will release the resource?
>
>
>
> Dear DBAs,
>
> 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
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ramlal K Chithu
> INET: TS2182_at_emirates.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jan 16 2001 - 01:37:19 CST
