Shared pool memory negative values why ?

  • From: Bala Krishna <krishna000@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 21 Aug 2013 11:56:23 +0530

Hi All,
Our mgmt is intrested is looking at the shared pool free memory and its
usage over past sometime . Therefore here is the output what i got it in
one of our instance.

I could notice there are some of the negative values under free memory ,
library_cache and sql_area as well for which i'm not able to intrepret
thats significane. Can somebody help me please ?

  *Time* *Instance No* *Free_Memory * *Library_Cache* *sql_area*  2013_08_18
23:00 2 2921456 116904 768440  2013_08_18 22:00 2 -184008 21136
-725048  2013_08_18
21:00 2 -1680760 183368 -443464  2013_08_18 20:00 2 -224120 -50560
408680  2013_08_18
19:00 2 796056 9544 -59872  2013_08_18 18:00 2 -2703752 88184 551792
2013_08_18
17:00 2 2079912 -90384 -4520  2013_08_18 16:00 2 -2317824 95864
-212000  2013_08_18
15:00 2 -802824 13752 -491904  2013_08_18 14:00 2 384304 36440 60808
2013_08_18
13:00 2 -1577248 35072 673632  2013_08_18 12:00 2 679992 -26176
-779432  2013_08_18
11:00 2 -1874672 15904 -39936  2013_08_18 10:00 2 650376 8536 154184
2013_08_18
09:00 2 -1439272 -14624

-73520

Regards
Bala


--
//www.freelists.org/webpage/oracle-l


Other related posts: