Re: Free memory in SGA

Peter Rak wrote:
>
> Hi all,
>
> How can I calculate amount of memory allocated by all cursors in shared
> pool by SELECT command ???
>
> Thanks in advice, Peter.

Take a look at V$SGASTAT view.
Query

  SELECT bytes FROM v$sgastat WHERE name = 'free memory';

will return jou the amount of free memory, available in shared pool.

 ! Jurij Modic                            Republic of Slovenia !
 !  tel: +386 61 178 55 14                Ministry of Finance  !
 !  fax: +386 61  21 45 84                Zupanciceva 3        !
 !  e-mail: jurij.modic_at_mf.sigov.mail.si  Ljubljana 1000       !
 ===============================================================