Re: Shared memory used

Hi Sunita,

Select bytes from v$SGASTAT where name='free memory' ;

will show you the Free Memory in the Shared Pool . To calculate the amount used,just subtract this number from the Init.ora setting for SHARED_POOL_SIZE .. Hope this helps,

-Thiru

Sunita Ajmani wrote:

> Hi,
>
> Can you let me know how to calculate the shared memory which is in use
> at the current time?
>
> Thanks
> Sunita
Received on Tue Aug 24 1999 - 14:15:37 CDT