Home » Developer & Programmer » Reports & Discoverer » Reports JVM Options. (Oracle 10G R2)
icon5.gif  Reports JVM Options. [message #340271] Tue, 12 August 2008 03:12
Messages: 19
Registered: August 2008
Junior Member
Hi Experts,
I am running a 10G Paper report from forms. Its a simple report which picks up data from 8 tables based on the parameters chosen by the user in the form.
The output of the report query is around 26,000 rows and the report goes upto 1300 pages.
Somtimes the report runs fine and sometimes it hangs up, and then the reports server also crashes and the reports queue hangs up.
I looked and found that this was a known oracle bug for long reports and it had to do with JVMOPTIONS on the reports server.
I increased it manually and it ran fine.
There is a patch available for this bug which patches the OAS and the DS.

Now my question is can I go with hardcoding the value or applying the patch?
Any ideas on why this bug is there as this report is a very simple query!!
I was also monitering the application server and saw that when this hangs the memory used by the javaw process crossed100mb and hung. When it ran normally it did never cross 35mb.
Previous Topic: graphs in report
Next Topic: How to draw chart with matrix?
Goto Forum:

Current Time: Wed Aug 23 14:33:13 CDT 2017

Total time taken to generate the page: 0.01528 seconds