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: update takes table level lock

Re: update takes table level lock

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 14 Jan 2002 08:34:58 -0800
Message-ID: <a1v1bi01071@drn.newsguy.com>


In article <178d2795.0201140623.2bebccde_at_posting.google.com>, mark.powell_at_eds.com says...
>
>"__" <2_at_2.com> wrote in message news:<a1t1qj$r1i27_at_kcweb01.netnews.att.com>...
>> Mark and Thomas,
>>
>> Thanks for giving me a better understanding of oracle locking. I was
>> following the 8i tuning training manual from oracle which states that you
>> should see TX lock_type while row level locks are being taken and TM locks
>> imply table level locks. I will increase the log_buffer to see if it helps.
>> I could not see any contention on the redo log device itself.
>>
>> thanks again
>> >
>
>There is nothing in your original post that has anything to do with
>the log buffer; why do you think increasing it will help? Help what?
>
>-- Mark D Powell --

that was my suggestion in my followup to his post.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Mon Jan 14 2002 - 10:34:58 CST

Original text of this message

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