This discussion is archived
2 Replies Latest reply: Sep 3, 2013 8:52 AM by faoilean RSS

Oracle Reports Server - Slow Response Time

jstem1177 Explorer
Currently Being Moderated
Hello All,

I'm faced with an odd problem. I have a slow response time from my reports server (roughly 10,000ms). On a shipping/distribution application this amounts to seconds in delay and backlog.

My area of problems seems to be between the time the reports engine processes the reports and places it in cache and the time the report server picks it up and sends it to the printer.

So far the engines seem to be properly configured, and I'm barely using 500mb of memory on my 12G app server. Have no swapping or other host level issues.

Can anybody point me in the right direction. I have checked the logs and once the report server picks up the cached report, it sent to the printer spooler and printed in a matter of 1 second.

here is what I see in the log
10.1.10.231 - - [19/Jun/2012:18:17:14 -0400] "GET /reports/rwservlet?NO_MISSION=1962721&P_PACK_SIZE=25&PRINT_TYPE=A&SERVER=RptSvr%5FGICVIRPHXAP12G%5Fasinst%5F1&REPORT=RAP%5FETIQUETTE%5FCUEILLETTE%5FBER0191&USERID=appuser%2F*******%40GICPRD&BATCH=YES&REPORT_COMM_MODE=ASYNCHRONOUS&PARAMFORM=NO&DESFORMAT=PDF&COPIES=1&DESTYPE=PRINTER&DESNAME=%5C%5C10%2E1%2E10%2E231%5CZM400%5F03S&ENVID=GICPRD&statusformat=xml HTTP/1.1" 200 793 
6/19/12:18:23:57:Started printing with command line D:\Oracle\Middleware\asinst_1\reports\rptsvr_gicvirphxap12g_asinst_1-rwlpr-68094.log true -P "\\10.1.99.4\Canon5050V2S" -#1 "D:\Oracle\Middleware\asinst_1\reports\cache\Canon5050V2SDU5U844B.pdf" MODEBITMAP
06/19/12:18:23:57:printer=\\10.1.10.231\Canon5050V2S:docname=D:\Oracle\Middleware\asinst_1\reports\cache\Canon5050V2SDU5U844B.pdf:filename=D:\Oracle\Middleware\asinst_1\reports\cache\Canon5050V2SDU5U844B.pdf:copies=1
06/19/12:18:23:57:Opening Printer \\10.1.10.231\Canon5050V2S
06/19/12:18:23:57:StartDocPrinter for \\10.1.10.231\Canon5050V2S
06/19/12:18:23:57:StartDocPrinter done for \\10.1.10.231\Canon5050V2S
06/19/12:18:23:57:StartPagePrinter for 0 copy for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter start for for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter in progress for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter in progress for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter in progress for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter in progress for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter in progress for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter in progress for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter in progress for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter in progress for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter in progress for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter in progress for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter in progress for \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:WritePrinter done for  \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:EndPagePrinter start for  \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:EndPagePrinter done for  \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:EndDocPrinter start for  \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:EndDocPrinter done for  \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:ClosePrinter start for  \\10.1.10.231\Canon5050V2S 
06/19/12:18:23:57:ClosePrinter done for  \\10.1.10.231\Canon5050V2S 
Thanks in advance for all you advice.

Jan S.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points