Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: row_locking means

Re: row_locking means

From: Sunit Patke <supatke_at_us.ibm.com>
Date: Tue, 02 Jun 1998 11:05:27 -0400
Message-ID: <357414B7.5BAF6EEA@us.ibm.com>


ROW_LOCKING Default value: ALWAYS
Range of values: ALWAYS/DEFAULT/INTENT
Multiple instances: must have the same value

The default of ALWAYS means that only row locks are acquired when a table is updated. DEFAULT is the same as ALWAYS. INTENT means that only row locks are used on a SELECT FOR UPDATE, but at update time table locks are acquired.

Hope this helps.

Sunit Patke

Wladimir Melnikov wrote:

> Hi, All !
>
> Does anybody know what mean 'row_locking' parameter ? (It set to 'always')
Received on Tue Jun 02 1998 - 10:05:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US