|
|
| Re: Any Suggestion on this STATSPACK Report [message #229171 is a reply to message #229103] |
Thu, 05 April 2007 11:23   |
michael_bialik
Messages: 621
Registered: July 2006
|
Senior Member |
|
|
Just a starter:
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 512M Std Block Size: 8K
Shared Pool Size: 304M Log Buffer: 102,400K
Log Buffer of 100M look way TOO large. I would decrease it and use the freed space to increase buffer cache.
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 45.10 In-memory Sort %: 73.43
Library Hit %: 99.65 Soft Parse %: 99.55
Execute to Parse %: 76.86 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 12.10 % Non-Parse CPU: 99.52
Buffer Hit %: 45.10 - VERY LOW (IMHO - even for DW).
Either you have insufficient db_cache_size (see prev comment about log) or you have very inefficient SQL statements.
HTH.
Michael
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
