The platform is SUN Sparc Solaris 2.6, version of Oracle is 7.3.4.0.1 .
I am running an application which demands CURSOR_SPACE_FOR_TIME be set
to TRUE, or it could be set to TRUE by the previous DBA. The instance
has been up since July 27 1999. I look at the pins and reloads values
in V$LIBRARYCACHE; sum(pins) is 38855892, sum(reloads) is 486399, so
sum(reloads) is more than 1% of sum(pins). The reloads came from the
SQL AREA, TABLE/PROCEDURE, BODY namespaces, mostly from SQL AREA.
Reading the tuning guide, I came to the conclusion that if
CURSOR_SPACE_FOR_TIME is TRUE then there should be ZERO reloads, so I
must be missing something. Can somebody offer a explanation ?
Received on Thu Sep 09 1999 - 02:37:25 CDT
