2 Replies Latest reply: Sep 3, 2013 10:52 AM by faoilean RSS

    Oracle Reports Server - Slow Response Time

    jstem1177
      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.