Unable to allocate 4096........

[stressman]

Hy every body,
I've got different database server with the same hardware configuration and same database structure. But if some databases work fine (one year with no particular intervention) I've got one the every two or tree week is down because of the error unable to allocate 4096 byte of shared pool size. I read on the net that it was because there is not enough contiguious memory is avalable.
I try to flush the memory with the command :
alter system flush shared_pool;

but that don't solve the problem. Does someone can help me?
I'm using Windows 2000Server, Oracle server 8i 1.7.00, oracle client 8.1.700 under linux red hat 7.3.

Thanks for your help or any information.

 

[SantaMufasa]

Stressman,

Check to ensure that your java_pool_size=20m (at least) but preferrably 50M. If java_pool_size is already at an acceptable size, then increase your shared_pool_size by 30-50%.

Let us know if these changes improve your "up-time" record.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 10:58 (11Feb05) UTC (aka "GMT" and "Zulu"),
@ 03:58 (11Feb05) Mountain Time

Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[stressman]

Thank for your answer, but can you explain me the link between the two variables shared_pool_size and java_pool_size.
I don't use any java code in my program, i just call store procedure and function from C code. Or the name java is not really good if it is used for other things.

I will made the test the increast the java_pool_size and let you know if this is enought to correct the problem.

Regards,

 

[SantaMufasa]

Stressman,

Although you might not use any Java code, Oracle does, and that is why we need the allocation.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 16:05 (14Feb05) UTC (aka "GMT" and "Zulu"),
@ 09:05 (14Feb05) Mountain Time

Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[stressman]

Hello,
i'm going mad with the error unable to allocate....

I follow your advise and i grow the size of java_pool_size and shared_pool_size
But the error occurred one more time.

For memory the OS is Windows 2000 Server, Oracle Standard Edition 8.1.7.0

My source code use bind variable, i flush shared_pool every night. But three mounth after the modification the fatal error
Unable to allocate 4096 bytes ... Procedure ...(...,BAMINA,...)

Please why this error occur and what is this BAMINA parameter

Every new idea would be wellcome

 

[sem]

Most probably your code DOESN'T use BIND variables and shared pool becomes fragmented. 8.1.7.0 is also not the best choice for production system.

Regards, Dima

http://seminihin.narod.ru