Re: SQL Area Reloads
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: Tim Gorman
INET: tim_at_sagelogix.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 Wed Dec 10 2003 - 22:04:33 CST