| Measurements [message #296093] |
Thu, 24 January 2008 10:20  |
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  |
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
