Re: Automatic Shared Memory Management

On 24 Mar 2006 08:36:18 -0800, zak.khalid_at_gmail.com wrote:

>How do I know if Automatic Shared Memory Management is on? I've just
>migrated to 10g from 9i, and I started getting ORA-4030 errors all over
>the place, for sql statements, PL/SQL and cronned oracle jobs.....
>

select name,value, decode(value,0,'ASMM is OFF','ASMM is ON') from v$parameter
where name = 'sga_target';

• Kenneth Koenraadt