-
:D Hi Folks,
I wounder what are the measures that are needed to be taken improve the Buf. Cache hit ratio, for an instance whose tables and indices are analyzed every day. The current hit ratio for an 33 sessions is 88%.
I know one of the solutions is to increase the db_block_buffers. But I'm looking for a way to do things without increasing the db_block_buffers. The sessions are read and write intensive.
The current setup of it is
DB version : 8.1.6 STD for sun 2.8
8K block size
64M shared pool
100M Buffer cache
15M Large pool
20M Java pool
Max# SESSIONs 250
MTS setup
Any suggestions would really be appreciated.
Thanx,
Sam
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
|