plz help me. [message #65235] |
Thu, 24 June 2004 02:49 |
Anu
Messages: 82 Registered: May 2000
|
Member |
|
|
hi!
can any body explain what i should do to improve my database performance.
i have a main table with the an average row length of 37 bytes in our database. the table consists of more than 20 lakhs of records. i have set the values for db_cache_size to 64 mb and shared_pool_size to 96mb.
while retrieving the hit ratio from the table v$sysstat i am getting
0.64 or less. if i select the count from the table it takes hardly 4 to 5 seconds for any combination. i disable all the constraints on the table but cant improve the hit ratio.
with regards
anu
|
|
|
Re: plz help me. [message #65240 is a reply to message #65235] |
Mon, 28 June 2004 21:33 |
satish kumar
Messages: 10 Registered: March 2002
|
Junior Member |
|
|
Hi,
Try to increase the value of Multi_Block_Read_Count parameter in your parameter file. It may help you in improving the performance.
Satish
|
|
|
Re: plz help me. [message #65246 is a reply to message #65235] |
Sat, 03 July 2004 09:07 |
Satheesh Babu.S
Messages: 35 Registered: July 2004
|
Member |
|
|
I think 4-5 seconds for 2 million record is quiet reasonable. If the hit ratio is less it doesn't mean that your system is performing very slow.
Thanks and Regards,
Satheesh Babu.S
Bangalore.
|
|
|
Re: plz help me. [message #65291 is a reply to message #65235] |
Fri, 23 July 2004 12:45 |
Master P
Messages: 6 Registered: July 2004
|
Junior Member |
|
|
goto www.hotsos.com and read
• Are you still using cache hit ratios?
The cache hit ratio is meaningless and in most cases a system with a very high cash hit ratio 99% is indicative of severe performance problems and not the opposite.
Please focus on wait events in your database instead if you are seriously interested in tuning
|
|
|