Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to run more than 1 report simultaneously?
kristofvdw_at_matt.es (K) wrote in
news:ef74fcf7.0410290139.798c65fb_at_posting.google.com:
> Hi,
>
> I'm using Oracle9iAS Reports Services to run our reports, called from
> Forms9.
> However I haven't found a way for running more than one report
> simultaneously.
> We have quite frequently more than one user requesting for reports,
> and some reports take up a lot of time to complete (formatting up to
> 100s of pages). If such a job is in the queue, the 1-page reports of
> other users take ages to get to execute (after the big report is
> finished).
> Is there a way to run, say, 2 reports simultaneously, so that if one
> is a big one, small ones get executed in the mean time anyway?
>
> Thanks,
> K
>
A couple of different ways to get close to this goal. 1) Create more ReportServer engines to service the queue. 2) Submit the report(s) into the "BACKGROUND". Received on Fri Oct 29 2004 - 07:55:49 CDT