RE: ORa-4030 on 9.2.0.5

ORA-4031 error is not happening now and we are not using the RMAN.

After the shared_pool size is increased and merged the 2 sub pools into a single pool, The ORA-4030 occurs. As I mentioned in the earlier mail for the 'Shared pool from 8i to 9i' , this could be related to the monitoring script of shared_pool fragmentation and the monitoring script is now stopped.

Could any one give some commands to findout the server memory usage (HP UX 11i)? When the ORA-4030 occurs, I would like to findout how the memory utilization of the server is? I am leaning towards either the OS memory is exhausted or It could be an Oracle Bug. Any other causes why the ORA-4030 occurs?

Thanks,
Raja

> -----Original Message-----
> From: Mark J. Bobak [SMTP:mark_at_bobak.net]
> Sent: Monday, January 24, 2005 10:19 PM
> To: Nagarajan.Subbiah_at_aetn.com
> Cc: Oracle-L Mailing List
> Subject: Re: ORa-4030 on 9.2.0.5
>
> Er, never mind..I was thinking ORA-4031, not ORA-4030.....
>
> -Mark
>
> On Mon, 2005-01-24 at 22:13, Mark J. Bobak wrote:
>
> Are you running RMAN for your backups? Have you set
> LARGE_POOL_SIZE?
> Just a thought...
>
> -Mark
>
> <http://www.freelists.org/webpage/oracle-l>

--
http://www.freelists.org/webpage/oracle-l