Re: Oracle 10gR1 Memory Problem - Please help
Date: Sun, 29 Nov 2009 12:57:59 -0800 (PST)
Message-ID: <70f75b2d-1b68-444e-9760-87d2c844db59_at_l23g2000yqh.googlegroups.com>
On Nov 29, 2:09 am, raja <dextersu..._at_gmail.com> wrote:
snip
> Hi,
>
> One of the Oracle 10gR1 Production Server faced few memory problems.
>
> Few details that i got regarding this problem are as follows :
> It seems like the server process private memory seems to have
> exhausted.
> The server seems to be running low on memory and is paging a lot.
> UNIX system shows that oracle process is taking 100%, nothing is
> running in databases but everything is aborted, but still it is
> showing the same utilization.
> We have found the below errors in Server alert log file :
> ORA-00600: internal error code, arguments: [17066], [], [], [], [],
> [], [], []
> ORA-00603: ORACLE server session terminated by fatal error
> ORA-04030: out of process memory when trying to allocate 16360 bytes
> (callheap,kcbtmal allocation)
> Also, found lot block recovery has happened from today morning.
>
> Could any one please tell me, how to track (or) find out the root
> cause for this problem ?
> Any steps or method, Please tell in detail ?
>
> Thanks in Advance.
>
> With Regards,
> Raja.
You can use oracle support for 600 errors.
When you say 10g r1 production server that makes me nervous. Any 10g production system should probably be 10.2 not 10.1 ... you are just asking for trouble trying to run production on 10.1 in my opinion. Received on Sun Nov 29 2009 - 14:57:59 CST