ORACLE MEMORY ERROR

[harry d brown jr · Accepted solution]

30%? Wow, that's 4.8GB. I'd trim that right down to about 2% max and 1% min.

To attach a doc, if using a PC, requires you to get the file onto your PC first.

Otherwise you can probably just cut & paste into this window. It's just that attachments don't get reformated. Also, please make sure they are "TEXT" files and NOT WORD files (filename.doc).

live free or die
harry

[Nobody's Hero]

So that would be 20 and 10 for dbc, I'm guessing. You say 4.8 gb whent set to 30%? What are you saying, that the system is reserving 4.8gb of memory for system processes?

[Uday_S_Ankolekar]

Well,
30 % dbc_max is way too more.
I would change dbc_max to 5 and dbc_min to 4 or less and see the performance.

-USA..

[Dave Chamberlin]

You definately want to reduce dbc_max_pct to a reasonable value like 3% in your case. Also attach a copy of the initORA parameters - the SGA may not be the problem.

[MANOJ SRIVASTAVA]

Robert

What is the value of SHHMAX , you need to increase it to accomadate the new instance.

Manoj Srivastava


( press browse to attach a file )

[Nobody's Hero]

shmmax = 1,073,741,824

Does this seem too low???

[Jeanine Kone]

I'm sure someone else will answer thisin more technical terms than I can but:

The way I understand it is that shmmax is the max size of a single shared memory segment. It must be large enough to fit the whole SGA. But, you can have more than one segment allocated - so for an SGA of under 1G, that would be fine.

[harry d brown jr]

Robert,

Bump it up to 2GB, and reduce your dbc max and min (of which 5% would be a high max setting).

live free or die
harry

[Nobody's Hero]

Here is my initORA

[Nobody's Hero]

Thanks Harry, that seems to have helped. My 5th instance was slow but it started. What is your approximate salary with all your knowledge around 500K. Just kidding. Anyway, what would be the max setting in my circumstance, for shmmax?

Again, thanks to everyone....

Bob Menefee