Thanks Kirti and Paul for the reply.
The instance is up for only 3 days. We know there are
very heavy inserts in the database.
Yes, There are high waits for 'buffer busy waits'
event in V$SYSTEM_EVENT view. But I didn't see 'buffer
busy waits' in V$SESSION_EVENT. I may try to increase
the
Title: RE: How to set DBWR_WRITE_PROCESSES in Oracle8i?
Since I didn't see this yet, I thought I might add it in.
Try increasing the PCTFREE, perhaps there are two many transactions happening in the same block, and oracle is locking the entire block until the other transaction if finished
Chris,
You should see the waits in V$SESSION_EVENT as well, as these are rolled in
to the V$SYSTEM_EVENT. You have to query V$SESSION_EVENT when these thread
are active. And you will have to query it repeatedly as it reports waits as
and when session encounters some.
I would also consider the
How long has the instance been up?
It appears that the application is trying to read the same data blocks /or
more sessions are trying to update the same data block or the free lists may
need to be set properly to support concurrent INSERTs.
So, before changing anything for DBWR process, I
CC Harvest wrote:
Hi, gurus:
The database is oracle8.1.7.2.1 on win2k machine
with 1 CPU and two hard drives. When I query
v$waitstat, I got the following:
CLASS COUNT TIME
-- -- --
data block 246901435 132690159