Home » Developer & Programmer » Reports & Discoverer » ORA-04030 error when open the report (Oracle report 6i)
ORA-04030 error when open the report [message #290029] Thu, 27 December 2007 03:32 Go to next message
payazal
Messages: 8
Registered: October 2007
Location: KL
Junior Member

Dear all,

I have one report execute using oracle report 6i and at server-client based. that report can compiled well at my computer but when it run it at server it cause error below :

ORA-04030: out of process memory when trying allocate 131096 bytes (hash join subh, kllcqs:klltba)
==> Select count '01-02' as qTempoh ,

the query it attached

Thank all...
Re: ORA-04030 error when open the report [message #290033 is a reply to message #290029] Thu, 27 December 2007 03:47 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The error says that there's no enough RAM to complete the task. So, you might
  • add more RAM
  • check whether hard disk is full (and it can not expand virtual memory)
  • decrease SHARED_POOL_SIZE and DB_CACHE_SIZE initialization parameters so that Oracle uses less memory
The fact that report compiled has nothing to do with the error - it only prooved that there are no syntax and similar errors. Runtime is something different.

There are many values you select in a query. You might try to create several FUNCTIONS (stored in a database, not function columns in the report) which would calculate those values and return them to report. Perhaps you'd avoid such a problem.
Re: ORA-04030 error when open the report [message #290036 is a reply to message #290029] Thu, 27 December 2007 03:51 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi payazal,

Sorry littlefoot,
I am also sending the same solution to him Smile


This can be caused by a shortage of RAM on a dedicated (non shared server) environment.

RAM shortage - Depending on your release of Oracle, you have several options:

Increase pga_aggregate_target
Decrease sort_area_size and/or hash_area_size
Move to multi-threaded server (a.k.a. MTS or shared servers)

Ashu
Re: ORA-04030 error when open the report [message #290161 is a reply to message #290029] Thu, 27 December 2007 18:48 Go to previous messageGo to next message
payazal
Messages: 8
Registered: October 2007
Location: KL
Junior Member

thanks all...
i will try it.
Re: ORA-04030 error when open the report [message #290650 is a reply to message #290161] Mon, 31 December 2007 00:49 Go to previous messageGo to next message
payazal
Messages: 8
Registered: October 2007
Location: KL
Junior Member

dear all,

there are any solution besides solution above.
I still can't solve this problem.
other report is ok and only this report have this error. Confused
Re: ORA-04030 error when open the report [message #290665 is a reply to message #290650] Mon, 31 December 2007 01:24 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you did all we said previously but nothing helped, I guess this won't help either, but won't cost much to try: recompile the report using the "compile ALL" option (<Ctrl + Shift + K>) and run it again.
Previous Topic: what is the substitute for BUTTON in 10g?
Next Topic: How can i see the parameter form before run the report in 9iR1as environment
Goto Forum:
  


Current Time: Sun Dec 04 10:29:16 CST 2016

Total time taken to generate the page: 0.08435 seconds