Home » RDBMS Server » Performance Tuning » Measurements
Measurements [message #296093] Thu, 24 January 2008 10:20 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Guys,

My database gives me the following observations

Dictionary misses - 9170
Dictionary hits - 147797
Library cache get hit ratio - 53.45
Parse to execute ratio - 89.35

Do you fine these normal? If not then what should I do to rectify these

Thanks
- Das

Re: Measurements [message #296444 is a reply to message #296093] Sun, 27 January 2008 08:09 Go to previous messageGo to next message
KrishnaBoppana
Messages: 12
Registered: March 2007
Location: Boston, MA
Junior Member
1. Performance tuning numbers make sense as percentage, not by numbers themselves.

2. The library cache hit ration way too low - tune the SGA -

3. There are plenty of resources on tuning SGA - I am sure you can find them here.

-Krishna

[Updated on: Sun, 27 January 2008 09:17] by Moderator

Report message to a moderator

Re: Measurements [message #296450 is a reply to message #296444] Sun, 27 January 2008 09:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. Wrong 1% of 100 and 1% of 100000000000 are somewhat different

2. This is very useful advice. Why? How? What does this mean?

3. Meaningless and useless.

One more great post.

Regards
Michel
Re: Measurements [message #296477 is a reply to message #296444] Sun, 27 January 2008 22:37 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks

- Das
Previous Topic: Help- slow running sql
Next Topic: about update perform
Goto Forum:
  


Current Time: Sat Dec 10 18:17:38 CST 2016

Total time taken to generate the page: 0.11990 seconds