Re: Oracle 10gR1 Memory Problem - Please help
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sun, 29 Nov 2009 18:44:34 +0100
Message-ID: <7nfq82F3l1sr3U1_at_mid.individual.net>
On 11/29/2009 05:11 PM, Gerard H. Pille wrote:
> raja wrote:
>
>
> Which oracle process?
>
> Connect as oracle user, and compare the results of "ulimit -a" with the
> installation guide.
>
> What are the SGA parameters?
Date: Sun, 29 Nov 2009 18:44:34 +0100
Message-ID: <7nfq82F3l1sr3U1_at_mid.individual.net>
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/Received on Sun Nov 29 2009 - 11:44:34 CST