V$SGASTAT

You can use the query below to show the amount of free memory in your shared pool. It was run on an Oracle 11.1.0.6.0 database:

 

SQL> l

  1  select bytes from v$sgastat

  2  where pool = 'shared pool'

  3* and name = 'free memory'

SQL> /

 

     BYTES

----------

390505176

 

SQL>

 

If this figure remains high and you have insufficient physical memory on your server, you could consider reducing the size of your shared pool. This would allow you to reuse the memory elsewhere.