Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Has anyone done any scalability work on dbms_lock?
if it is single instance you could also use global application contexts ... (alas they don't work in RAC across node) ...
Raj
-----Original Message-----
Sent: Wednesday, January 21, 2004 9:10 AM
To: Multiple recipients of list ORACLE-L
> On a light-weight test on 8.1.7.4 at 700MHz on W2000 -
>
> About 15,000 request/release per second
> if you are using an ID
sounds plenty good to me. Thanks a lot.
> Bear in mind that each request or release will hit the
> enqueue latch a couple of times, so you could get
> contention for the latch in the two high-speed options.
OK. Will look out for these just in case.
> Bottom line - for high-speed OLTP type of work, I
> don't think you will get away with more than a dozen
> request/release cycles per transaction.
Not a worry, it's a workflow app. A few users but not much load, a little volume. I just need to make sure a given sequence of operations is not undertaken by more than one user per group (one lock/group) and a table lock is way too heavy to do this. Forms 9i, so it's not easy to fudge it with a C exit and I don't like servlets. Much better if I can do the lot in PL/SQL.
Thanks again.
Cheers
Nuno Souto
nsouto_at_optusnet.com.au
**************************************************************************************4
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni_at_espn.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Wed Jan 21 2004 - 08:24:37 CST