Re: Shared pool memory negative values why ?

From: Don Seiler <don_at_seiler.us>
Date: Mon, 26 Aug 2013 11:11:10 -0500
Message-ID: <CAHJZqBCe4=RTh8AcspTqpmNEPX8-+1D5N9bQymeYK-JuAUHmSA_at_mail.gmail.com>

Can you explain how you got these values? What query did you use? Just to be safe you might also want to include your version of Oracle RDBMS. Don.

On Wed, Aug 21, 2013 at 1:26 AM, Bala Krishna <krishna000_at_gmail.com> wrote:

> 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
>
>
>

-- 
Don Seiler
http://www.seiler.us


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

Received on Mon Aug 26 2013 - 18:11:10 CEST