Re: memory problem - oracle 10203 on HPUX
Date: Mon, 21 Jan 2008 14:01:53 +0700
Message-ID: <3edcb66e0801202301y6a7130f3j8d013158762a411e@mail.gmail.com>
$ /usr/sbin/swapinfo
Kb Kb Kb PCT START/ Kb TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME dev 33554432 0 33527628 0% 0 - 1 /dev/vg00/lvol2 dev 33554432 0 33527628 0% 0 - 1 /dev/vg00/lvolswap reserve - 22662700 -22662700
memory 39065844 6594716 32471128 17%
On Jan 20, 2008 4:35 PM, Ronnie Doggart <ronnie_doggart_at_lagan.com> wrote:
> Hi,
>
> /usr/sbin/swapinfo
>
> And see how mush swap is configured.
>
> Ronnie
>
> ________________________________________
> From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Ujang Jaenudin [ujang.jaenudin_at_gmail.com]
> Sent: 20 January 2008 00:36
> To: oracle-l
> Subject: memory problem - oracle 10203 on HPUX
>
>
> folks,
>
> I have a machine (RAC configuration) 10.2.0.4 on HPUX - PARISC.
> in a node I have 38GB physical memory, 8 processors.
> the machine could not run with asynchronous IO, so I set io slave to
> 8, and dbwr to 1.
>
> at AWR report, it said that 2GB memory for PGA is enough, and 12GB of
> SGA mostly enough.
> concurrent user is 1000 until maximum 1500 users connected.
> at one time only 30-50 concurrent active with OLTP transaction.
>
> at the OS perspective, it said that mostly 90-100% memory has been used,
> even when high load, 50% of the swap will be used also.
> almost every 20 days, the server is rebooted itself,
> I think this is due to lack of memory....
>
> why between OS and oracle side there has much big different of memory usage???
>
>
> --
> regards
> ujang
>
> "I believe that exchange rate volatility is a major threat to
> prosperity in the world today"
> Dr. Robert A. Mundell, Nobel Laureate 1999
> --
> http://www.freelists.org/webpage/oracle-l
>
> The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error.
>
> The views and opinions expressed in this email may not reflect the views and opinions of any member of Lagan Technologies Limited, or any of its subsidiaries.
>
> Lagan Technologies Limited is a company registered in Northern Ireland with registration number NI 28773. The registered office of Lagan Technologies Limited is 209 Airport Road West, Belfast, Co. Antrim, BT3 9EZ.
>
>
-- regards ujang "I believe that exchange rate volatility is a major threat to prosperity in the world today" Dr. Robert A. Mundell, Nobel Laureate 1999 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 21 2008 - 01:01:53 CST