Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bad performance in Interactive Report

cdisclaMay 3 2018 — edited May 3 2018

Hello,

i have performance problems with a query that is fast when run in SqlDeveloper / SqlPlus but takes 6-7 seconds in an interactive report.

If i enable debug window, i see that 7.4 seconds are taken by IR binding: "APXWS_MAX_ROW_CNT" value="100000", if i clear Max Row Count value , the 7 seconds are taken by "IR binding: P67_FIELD_NAME1"; if i remove that field from the query it is taken by another field used as condition in the query.

How can it be solved?

Query returns 300-400 records and runs fine outside Apex.

Thanks in advance and greetings

Cris

Screen Shot 2018-05-03 at 09.46.21.png

Comments

Newbie_820-Oracle

And here: https://docs.oracle.com/database/121/AEAPI/apex_mail.htm#AEAPI341
Just not sure how to trigger it from a calendar's due date.

Jeroen.

I'm using Automations to 'trigger' emails. Works great!
Automate your business process in Oracle APEX 20.2 | Oracle Application Express Blog
Regards,
Jeroen

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 31 2018
Added on May 3 2018
7 comments
401 views