Re: Can I use more memory than I have?

Steve Adams touches on this at: http://www.ixora.com.au/q+a/pool.htm#23_06_1999

-Mark

Knut Talman <knut.talman_at_mytoys.de> wrote in message news:<3D120C50.EDDC02D0_at_mytoys.de>...
> When I issue the following:
>
> select sum(a.bytes)/(1024*1024) shared_pool_used,
> max(b.value)/(1024*1024) shared_pool_size,
> (max(b.value)/(1024*1024))-(sum(a.bytes)/(1024*1024)) shared_pool_avail,
> (sum(a.bytes)/(max(b.value)))*100 shared_pool_pct
> from v$sgastat a, v$parameter b
> where a.pool = 'shared pool'
> and a.name != 'free memory'
> and b.name = 'shared_pool_size';
>
>
> I get
>
> SHARED_POOL_USED SHARED_POOL_SIZE SHARED_POOL_AVAIL SHARED_POOL_PCT
> ---------------- ---------------- ----------------- ---------------
> 51.83 50.00 -1.83 103.67
>
> And
>
> select * from v$sgastat
> where name='free memory'
> and pool = 'shared pool';
>
> shows
>
> POOL NAME BYTES
> ----------- -------------------------- ----------
> shared pool free memory 2891628
>
> So I have 50MB and I am using 103.67 percent of it. And there are still some
> free bytes left... Where is my mistake?
>
> Regards,
>
> Knut
Received on Fri Jun 21 2002 - 23:02:04 CDT