Re: SGA bigger than 50G
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: dbvision@xxxxxxxxxxxx
- Date: Wed, 5 May 2010 04:55:32 -0700 (PDT)
Nuno
Here is the Swap Info. One thing is true that SHMALL is small how the swap
space can affect it. Appreciate your comments
cat /proc/swaps
Filename Type Size Used Priority
/dev/mapper/system_vg-swap_lv partition 25165816 0
-1
Sanjay
________________________________
From: Nuno Souto <dbvision@xxxxxxxxxxxx>
Cc: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Wed, May 5, 2010 6:23:37 AM
Subject: Re: SGA bigger than 50G
Sanjay Mishra wrote,on my timestamp of 5/05/2010 12:31 PM:
> Yes it is failing with error like
> ORA-27102: out of memory
> Linux-x86_64 Error: 28: No space left on device
>
> :/proc/sys/kernel$cat shmmax
> 48318382080
> I tried with
> sga_target=38624M
> sga_max_size=38624M
Is your pagefile/swap partition < 38GB by any chance?
-- Cheers
Nuno Souto
in cold Sydney, Australia
dbvision@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
