-
My SQL Area has really bad performance.
Everything else looks GREAT. How can I tune ONLY the Sql Area? My shared pool sizing seems right on. Just the SQL Area is messed up. Any advice out there?
- Magnus
ps: I looked up some archives regarding this but nothing mentioned how to specifically tune just the SQL Area.
some output:
LIBRARY GETS GETHITRATI PINS PINHITRATI RELOADS INVALIDATI
------------ ---------- ---------- ---------- ---------- ---------- ----------
BODY 571 .998 572 .997 0 0
CLUSTER 685 .99 794 .982 0 0
SQL AREA 14203 .535 62793 .778 760 7
TABLE/PROCED 15931 .977 52876 .974 608 0
TRIGGER 953 .993 953 .933 49 0
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|