-
I look into the V$librarycache table and I found some info but unclear so please help.
1. PINS of SQL Area=-300932440 ------ why pins is negative ??? but the GETHITRATIO is reasonable =.95
2. The GETHITRATIO on index is very poor=.281731
everything else look ok
can someone give me some hint about the above issues ???
thanks
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
|