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.
-----Original Message-----Sure, it's free now. But has that always been the case?
From: Tim Gorman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 11:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: SQL Area Reloads
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