1748008 Members
4745 Online
108757 Solutions
New Discussion юеВ

ORACLE MEMORY ERROR

 
SOLVED
Go to solution
Nobody's Hero
Valued Contributor

ORACLE MEMORY ERROR

I have an N class running 11.0 16 gb of memory.
The kernel is tuned fairly well. However, I am running 4 instances each set to SGA=150 meg. When trying to start a fifth instance, SGA=150, I got a insufficient memmory error. I had to back the SGA down to 50 for the fifth instance and it came up OK. Are there any kernel parms that I can increase to allow this fifth instance to run at 150 SGA?
UNIX IS GOOD
20 REPLIES 20
Shahul
Esteemed Contributor

Re: ORACLE MEMORY ERROR

Hi

What about nfile, nproc, shmmax ..etc. Then U monitor ur swapinfo while running the fifth instance. U can use sar, top, glance + like utilities to figure out the problem.

Best of luck
Shahul
Dave Chamberlin
Trusted Contributor

Re: ORACLE MEMORY ERROR

some questions - what version of Oracle are you running, and is it 32 or 64 bit? Also, what is the kernel paramter dbc_max_pct set to?
harry d brown jr
Honored Contributor

Re: ORACLE MEMORY ERROR

Robert,

post your kernel parameters and swapinfo

live free or die
harry
Live Free or Die
Jeanine Kone
Trusted Contributor

Re: ORACLE MEMORY ERROR

Something seems a bit odd here - you have 16 Gig of memeory, and your 4 instances take up 150 Meg each - that's 600 Meg total. What else do you have running on your machine that is using the other 15+ gig of memory?
Nobody's Hero
Valued Contributor

Re: ORACLE MEMORY ERROR

running oracle 8.1.7
64 bit
dbc_max_pct = 30
dbc_man_min = 5

Can someone tell me how to attach a file so I can post my kernel and swap?
UNIX IS GOOD
Nobody's Hero
Valued Contributor

Re: ORACLE MEMORY ERROR

OK I see how to attach...will be posting in a couple minutes....
UNIX IS GOOD
Shahul
Esteemed Contributor

Re: ORACLE MEMORY ERROR

Hi

If U go to reply option, below the box U will get a "brows" buutton. Here U can attach

Shahul
Nobody's Hero
Valued Contributor

Re: ORACLE MEMORY ERROR

See Attachment
UNIX IS GOOD
Nobody's Hero
Valued Contributor

Re: ORACLE MEMORY ERROR

Another clip
UNIX IS GOOD