ORA-04030 Out of process memory

building reports desktopintelligence
1

Hi All guys,

I am here with another problem :slight_smile:
On refreshing the report, my users are facing following problem:
“Error during sql execution.(DA0003)
ORA-04030 Out of process memory when trying to alocate 1040896 bytes”

Please provide solution on this.

Thanks in advance

Bhautik Shah

tik :india: (BOB member since 2004-09-01)

2

Hello!

This is not BO issue but win2k limitation. You need to chek RAM on your Oracle database server…
If you have inough free RAM , check the oracle.exe process in task manager.
Check the memory usage and vitual memory usage of oracle.exe.
in windows 2000 server has a single memory process limit. It is 2GB.
And also oracle old versions has the instance memory limit around 1.8 GB.
If you near one of these limits reduce oracle SGA. So the PGA can use the released memory to connect database.

To reduce SGA you need to reduce Shared pool in init.ora.

This error occures when PGA don’t have innough memory.

Regards,
andu

andu (BOB member since 2005-04-13)