----- Original Message -----
Sent: Thursday, December 11, 2003 12:14
AM
Subject: SQL Area Reloads
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
