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: Mark D Powell <mark.powell_at_eds.com>
Date: 14 Jan 2002 06:23:59 -0800
Message-ID: <178d2795.0201140623.2bebccde@posting.google.com>


"__" <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?

Received on Mon Jan 14 2002 - 08:23:59 CST

Original text of this message

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