Connor,
Thank you for replying.
Our requirement is , we need to make that process to sleep 1 sec per minute.
So that other processes will complete their job soon. DBMS_JOB will not help
us in this case, we believe.
Our question is , Will other processes utilize resources during that 1
sec/per minute or not?
Thank you for once again to all.
Ram.
-----Original Message-----
From: Connor McDonald [mailto:hamcdc_at_yahoo.co.uk]
Sent: 16 January 2001 14:43
To: Ramlal K Chithu; 'ORACLE-L_at_fatcity.com'
Cc: 'oracledba_at_lazydba.com'
Subject: Re: DBMS_LOCK.SLEEP will release the resource?
Why not use DBMS_JOB ? Then your program can "wakeup"
every 'x' minutes and start running.
HTH
Connor
- Ramlal K Chithu <TS2182_at_emirates.com> wrote: >
>
> 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
>
> --------
> Think you know someone who can answer the above
> question? Forward it to them!
> to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to
> oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
>
Connor McDonald
http://www.oracledba.co.uk
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
Received on Tue Jan 16 2001 - 05:38:08 CST
