Re: ORa-4030 on 9.2.0.5

From: Alexander Gorbachev <gorbyx_at_gmail.com>
Date: Tue, 25 Jan 2005 07:21:44 +0100
Message-ID: <c2213f680501242221190c4e0b@mail.gmail.com>

Sometimes we were not able able to connect after many ORA-4030 to troubleshoot.

Alex

On Mon, 24 Jan 2005 23:05:13 -0500, Subbiah, Nagarajan <Nagarajan.Subbiah_at_aetn.com> wrote:
> 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
>

-- 
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 25 2005 - 01:24:11 CST