on 12/10/03 3:14 PM, Ashish Sahasrabudhe at [EMAIL PROTECTED] wrote:
The statspack report is showing 10,684 reload for SQL AREA with 2.2% misses.
==================================================================================
Library Cache Activity for DB: MAIN Instance: MAIN Snaps: 18089 -18090
->"Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY 12,186 0.0 12,186 0.0 0 0
CLUSTER 95 0.0 10 0.0 0 0
INDEX 466 0.0 461 0.0 0 0
SQL AREA 44,142 0.1 500,987 2.2 10,684 0
TABLE/PROCEDURE 208,498 0.1 584,219 0.0 1 0
TRIGGER 2,746 0.0 2,746 0.0 0 0
==================================================================================
The 250 MB of shared pool is free. Why would it cause reloads if there is so much
free space available?
Any help is appreciated.
Ashish