OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Report Server Issue (Oracle 11g, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Report Server Issue [message #463440]

Thu, 01 July 2010 06:25

jagadeesanes
Messages: 10
Registered: July 2010
Location: Bangalore

Junior Member

Hi all,

I have restarted my oracle report server, check all the logs, all reports, procedure, etc.... But still its performance is very very slow. No errors but it is taking 1 hour or 2 hours to display the report. before this issue it was took less than a minute.

Should I change any iniEngine value..?

Cache Size now is - 50MB
maxEngine now is - 1
iniEngine -1 (two iniEngine is there... which one i have to change..?)

Please kindly help me on this...

Thanks in advance.

Jagan S

[Updated on: Thu, 01 July 2010 07:55]

Report message to a moderator

Re: Report Server Issue [message #463553 is a reply to message #463440]

Thu, 01 July 2010 15:57

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

what exactly is slow. Is the report itself running slow, or is the opening of the output slow?
In general, there is no need to change the report server parameters. Especially after a restart of the report server.
If the report itself is slow, test the SQL it is executing.
If the opening of the output is slow, check your APPS Listener.

Regards,

Arian

Report message to a moderator

Re: Report Server Issue [message #463568 is a reply to message #463553]

Thu, 01 July 2010 23:23

jagadeesanes
Messages: 10
Registered: July 2010
Location: Bangalore

Junior Member

Hi Alien... Razz

Thanks for your kind reply.

The opening of the output only slow. We have checked the SQL queries as well as we have recompiled the .rdf files. Our working time is 9am to 7pm. Before 9am & after 7pm its working properly. During working hours only its dead slow.

We have checked the server memory and also Cleaned the tmp files. Still the problem is there..!

I will check APPS Listner. Please kindly advice me on this.

Jagan S.

Report message to a moderator

Re: Report Server Issue [message #463634 is a reply to message #463553]

Fri, 02 July 2010 05:58

jagadeesanes
Messages: 10
Registered: July 2010
Location: Bangalore

Junior Member

Its not solved yet...!!

Please kindly help me on this...

Thanks in advance.

Report message to a moderator

Re: Report Server Issue [message #463659 is a reply to message #463568]

Fri, 02 July 2010 08:00

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

do you have logging enabled on the APPS-listener? If so, are there errors in it?

When you go to the $APPLCSF/$APPLOUT directory does it also take long to open the files?

Regards,

Arian

Report message to a moderator

Previous Topic:	Cost Rollup- No Report
Next Topic:	Oracle Fussion Middleware 11g Installation.?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 04:33:23 CDT 2024