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).
had anyone ever run into anything like this?
what performance views should i be watching to see how oracle is managing the buffer cache and locks?
can anyone point to a good book on the topic of multiple dbwr's and locks?
the oracle documentation regarding the multiple dbwr's is a bit confusing on this topic.
thanks in advance
-maurice
samuels_at_seas.upenn.edu
Received on Thu May 03 2001 - 10:17:05 CDT
