BI Publisher 10 G standalone : request schedule report, take a long time....
Hello,
When i request scheduled report on history (the report is stored on db), cf screenshot, the request take a long time (1min50)
i catch a query (maybe this), the cost is very hight (full table scan on XMLP_SCHED_JOB and XMLP_SCHED_OUTPUT).
I need to known if there is a way to optimize this ( put XMLP_SCHED_OUTPUT.DELETED to yes for obsolete reports)? delete rows? create an index?
do you have another idea to resolve this ?
Best Regards
- Query (built-in by BI) ;:
When i request scheduled report on history (the report is stored on db), cf screenshot, the request take a long time (1min50)
i catch a query (maybe this), the cost is very hight (full table scan on XMLP_SCHED_JOB and XMLP_SCHED_OUTPUT).
I need to known if there is a way to optimize this ( put XMLP_SCHED_OUTPUT.DELETED to yes for obsolete reports)? delete rows? create an index?
do you have another idea to resolve this ?
Best Regards
- Query (built-in by BI) ;:
SELECT
t1.OUTPUT_ID, t1.MESSAGE, t1.STATUS, t1.DOCUMENT_DATA_AVAILABLE,
t1.STATUS_DETAIL, t1.DOCUMENT_DATA_CONTENT_TYPE, t1.CREATED,
t1.XML_DATA_AVAILABLE, t1.XML_DATA_CONTENT_TYPE, t1.LAST_UPDATED,
t0.JOB_ID, t0.OWNER, t0.REPORT_PARAMETERS, t0.BURSTING_PARAMETERS,
t0.REPORT_URL, t0.DELIVERY_DESCRIPTION, t0.RUN_TYPE, t0.END_DATE,
t0.SCHEDULE_DESCRIPTION, t0.JOB_GROUP, t0.SCHEDULE_PARAMETERS,
t0.LAST_UPDATED, t0.SHARED_OPTION, t0.BURSTING, t0.START_DATE,
t0.DELIVERY_PARAMETERS, t0.USER_DESCRIPTION, t0.USER_JOB_NAME,
t0.CREATED, t0.ISSUER, t0.XSCHURL, t0.LOCALE
0