Well, in this case the error was unable to fork a process, which implies a memory problem. Then I found this blog: http://dbakerber.wordpress.com/2008/04/18/swap-space-in-linux-and-unix/ Then I added swap space and I no longer had the problem. Might be specific to my hardware, might be another setting, but it sure looks like a problem with the swap setting to me. On Wed, May 13, 2009 at 6:48 PM, Mark W. Farnham <mwf@xxxxxxxx> wrote: > Let’s assume that it crashes. What makes you think it has anything to do > with swap? I’m just curious. > > > > Regards, > > > > mwf > > > ------------------------------ > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *John Smith > *Sent:* Wednesday, May 13, 2009 5:12 PM > *To:* oracle-l@xxxxxxxxxxxxx > *Subject:* Fwd: OEL 5.2 Oracle 10g database and swap > > > > left off the list the first time. > > ---------- Forwarded message ---------- > From: *John Smith* <john40855@xxxxxxxxx> > Date: Wed, May 13, 2009 at 2:39 PM > Subject: Re: OEL 5.2 Oracle 10g database and swap > To: TESTAJ3@xxxxxxxxxxxxxx > > > I would say use the recommended number. You might try this experiment on a > test server only, not production): > > set the swap to 2G (when you have say, 64G RAM). Set the SGA_TARGET to 20G > or so. Set lock_sga and/or pre_page_sga to true, and start the database and > see what happens. I have heard it can crash the server. > > > > On Wed, May 13, 2009 at 2:12 PM, <TESTAJ3@xxxxxxxxxxxxxx> wrote: > > > We did in our pilot and with 64G of ram we just went with 2G of swap, now > this is not production as we've not got that ironed out yet. > > joe > > _______________________________________ > Joe Testa, Oracle Certified Professional > (Work) 614-677-1668 > (Cell) 614-312-6715 > > Interested in helping out your marriage? > Ask me about "Weekend to Remember" > Dec 11-13, 2009 here in Columbus. > > > From: > > kathy duret <katpopins21@xxxxxxxxx> > > To: > > oracle-l@xxxxxxxxxxxxx > > Date: > > 05/13/2009 03:10 PM > > Subject: > > OEL 5.2 Oracle 10g database and swap > > Sent by: > > oracle-l-bounce@xxxxxxxxxxxxx > > > ------------------------------ > > > > I had always used the rule of thumb for putting 1.5 swap to RAM on Linux > Servers > We are installing OEL 5.2, 10G 3 node RAC cluster with 64G of RAM. > > When I looked at the Metalink install doc 421038.1 it says: > > > Between 1024 MB and 2048 MB > > 1.5 times the size of RAM > > Between 2049 MB and 8192 MB > > Equal to the size of RAM > > More than 8192 MB > > 0.75 times the size of RAM > > > > Has anyone installed this and what are you using. > > Have you also used hugepages? > > Thanks, > > Kathy > > > > > > > > >