Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: update takes table level lock
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 CorpReceived on Mon Jan 14 2002 - 10:34:58 CST