Where can I find the error message?

[greenpee]

Hi,

I am useing oracle 8i. My database constantly has (OCIStmtExecute: ORA-04031: unable to allocate 4200 bytes of shared memory) problem. I keep an eye on v$sgastat but could not tell what time I have to take an action. I checked my alert.log but could not find any trace. Is there anyway I can find some alert before this happens?

Thanks,

 

[oradba101]

Hi, greenpee

You need to increase the shared pool size. Unfortunately, this error occurs only when you run out of shared memory.

Regards,


William Chadbourne
Oracle DBA

 

[sem]

You may try to increase java_pool_size and decrease fragmentation by preloading large or frequently used packages. You may also follow Advanced Search link and find dozen of earlier threads on that issue. I'd also recommend you to do it before posting a new one

Regards, Dima

http://seminihin.narod.ru