Re: SQL Area Reloads
Shared
pool is free all the time.
There
are no DDLs executed, no analyze or no package compiles still there are
SQL AREA reloads.
The
database is on 9i RAC. The reloads are appearing on RAC
instances.
Sure, it's free now.
But has that always been the case?
on 12/10/03 3:14 PM,
Ashish Sahasrabudhe at asahasrabudhe@weightwatchers.com 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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ashish Sahasrabudhe
INET: asahasrabudhe_at_weightwatchers.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Dec 11 2003 - 10:04:26 CST
