Re: multiple dbwr's and deadlock

When you get a deadlock message, you should also see a trace file produced in the user dump dest directory. The beginning part of the file will tell you what caused the deadlock, right down to the sql statement / procedure and rowid, if applicable.

• ricky

Maurice Samuels wrote:
>
> hi,
> recently i turned on multiple dbwr's (4) and increased the db_block_lru_latches (24) on an 8-CPU Sun 5500
> server with 8G of memory (oracle 8.0.x). a few times when i've tried to run 5 insert /*+append ..
> operations, i get
> deadlock messages written to the alert.log and some of the operations outright fail. but i have no problems
> running 4 of those types of operations at a time (is this related to how many writer's there are).
Received on Mon May 07 2001 - 20:11:14 CDT