Shared pool memory negative values why ?

From: Bala Krishna <krishna000_at_gmail.com>
Date: Wed, 21 Aug 2013 11:56:23 +0530
Message-ID: <CAG+FZagASJLX+h+0CqCUFuWEK8f31wsiZwhi=euujQRvi-DuRQ_at_mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 21 2013 - 08:26:23 CEST