-
database hangs on free buffer waits
hi all.
i'm experiencing major performance problems on my application.
i have 2 db's on the same HP-UX machine, each one has an SGA of
about 2.3GB, the machine has 6 CPUs and 6GB ram.
oracle version - 8.1.7.4 64bit.
i have a very insert-intensive application (about 2000 rows/s).
my redo logs & rbs are placed on raw partitions, the rest of the
db files are on vxfs fs.
after i start the application, the load on the database is huge,
but no stress in the storage machine (Va7400) nor the host's cpu.
after about 10-15 minutes, i start recieveing "free buffer waits"
on my application threads, and basically, it hangs forever.
had anyone ever encountered these waits?
please share your experience.
regards,
ido
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|