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.

raja wrote:

> 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.

Which oracle process?

Connect as oracle user, and compare the results of "ulimit -a" with the installation guide.

What are the SGA parameters?

On 11/29/2009 05:11 PM, Gerard H. Pille wrote:
> raja wrote:
> 
>> 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.
> 
> Which oracle process?
> 
> Connect as oracle user, and compare the results of "ulimit -a" with the 
> installation guide.
> 
> What are the SGA parameters?

And how much physical memory does that box have?  Sounds like either SGA 
is configured larger than physical memory on that machine or something 
else is eating up memory which then is not available to Oracle (which 
would also be some form of misconfiguration for all but the lightest 
test environments; usually you'd rather want a dedicated DB machine).

Kind regards

	robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

On Nov 29, 2:09=A0am, raja <dextersu...@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.

On Sat, 28 Nov 2009 23:09:01 -0800, raja wrote:

> 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 ?

No problem. Here is the detailed answer: 42

For even more details, please specify the platform, platform version, 
configuration parameters, with special emphasis on the virtual memory 
configuration and process limits. Also, there is a little known search 
engine on the web called "Google" which can yield remarkable results with 
very little effort:

http://tinyurl.com/yb2jmdo
http://tinyurl.com/ylk6bgh

You probably have Google configured right into your browser. There is 
also an Oracle support site on http://metalink.oracle.com, also known as 
"metastink", especially after the recent migration to flash. Metastink
can be a real help when you're looking for answers. Please, read the fine
manual and invest a little of your own effort. If you need a forum which 
will cater to laziness and which is very friendly toward rude people who 
think that the others have nothing better to do but to convey their 
knowledge for free and on request, I can wholeheartedly recommend 
oracle-l, a mailing list hosted on www.freelists.org. The moderator of 
that list has made  the protection of the lazy noobs into his sole 
purpose in life.



-- 
http://mgogala.freehostia.com

Thanks a lot for your immediate response and your feedbacks.

Let me check again and get back to you.

Thanks again.

With Regards,
Raja.