Home » RDBMS Server » Performance Tuning » plz help me.
plz help me. [message #65235] Thu, 24 June 2004 02:49 Go to next message
Messages: 82
Registered: May 2000
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
Re: plz help me. [message #65240 is a reply to message #65235] Mon, 28 June 2004 21:33 Go to previous messageGo to next message
satish kumar
Messages: 10
Registered: March 2002
Junior Member

Try to increase the value of Multi_Block_Read_Count parameter in your parameter file. It may help you in improving the performance.

Re: plz help me. [message #65246 is a reply to message #65235] Sat, 03 July 2004 09:07 Go to previous messageGo to next message
Satheesh Babu.S
Messages: 35
Registered: July 2004
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
Re: plz help me. [message #65291 is a reply to message #65235] Fri, 23 July 2004 12:45 Go to previous message
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
Previous Topic: scn
Next Topic: CPU utilisation
Goto Forum:

Current Time: Sun Mar 03 03:07:32 CST 2024