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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to speed up the performance in Oracle APEX - Classical Report loading

ghiniMar 19 2013 — edited Mar 20 2013

Hi,
I am using APEX 4.2, DB 11.2.

I have created 2 reports in the page and the time that is taken to load this page is very huge.
To speed up the performance materialized views were used on queries, but still the performance is the same.

checked the app in DEBUG mode, the following event takes a lot of time to execute:

0.08415 4.76698 rows loop: 15 row(s)

the query onky takes very less time to execute

0.08184 0.00181

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2013

Added on Mar 19 2013

#apex-discussions

4 comments

1,838 views