Answer:

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