RE: How do you use DBMS

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Tue, 17 Feb 2004 13:02:24 -0500
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA656D8199@25exch1.vicorpower.vicr.com>

Ryan,

I've used DBMS_LOCK for two primary purposes:

to insure that one and only one copy of a specified program is = running on a database server at any time.
To allow multi processes to run simultaneously without getting in = each others way.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----

From: Ryan [mailto:ryan.gaffuri_at_cox.net] Sent: Saturday, February 14, 2004 9:50 AM To: oracle-l_at_freelists.org
Subject: How do you use DBMS_LOCK?

Tom Kyte has a use for it in his book. You create your own Insert Lock. = I used it once last year. All I did was create a wrapper to make it = easier for others to use it. I was just a contractor there so I didnt = get the big picture.=20
What have you used DBMS_LOCK for? Anything interesting any useful? = Anyone have any code samples? I've used locks in java and unix when I do = threading, I have not seen much cause for it inside the Oracle database. =

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Feb 17 2004 - 12:02:24 CST

RE: How do you use DBMS_LOCK?