Re: Shared pool memory usage

From: MT <mtechera_at_wpmc.com>
Date: Wed, 29 Aug 2001 23:26:42 +0200
Message-ID: <9mjmhk$8n1$1@news.online.de>

Hi Chuck:

Here is what I use for the free space:

select

    to_number(p.value) "Total Pool",
    s.bytes "Free Bytes",
    round(( s.bytes / p.value ) * 100,1) "Free" from

v$parameter p,
v$sgastat s
where
p.name = 'shared_pool_size' and
s.name = 'free memory'

Regards,
Mario

"Chuck Hamilton" <chuck_hamilton_at_yahoo.com> wrote in message news:9mj7sh$2ganv$1_at_ID-85580.news.dfncis.de...
> Is there a query that will show me the total free space, and largest single
> chunk of free space in the shared pool?
>
>
Received on Wed Aug 29 2001 - 16:26:42 CDT