That gives you the total free memory of the shared pool, but I want to know
what the largest free chunk is. I frequently get ORA-4031 trying to allocate
4k of memory when there's over 20m of free memory in the shared pool.
Problem is it's all in chunks < 4k. Any ideas?
--
Chuck Hamilton
chuck_hamilton_at_yahoo.com
"Do not be deceived, God is not mocked; for whatever a man sows, this he
will also reap. (Gal 6:7 NASB)
"MT" <mtechera_at_wpmc.com> wrote in message
news:9mjmhk$8n1$1_at_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 Thu Aug 30 2001 - 09:00:10 CDT
