Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: update takes table level lock
"__" <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?