Skip to Main Content
Forums

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!

SQL Runtime/Executentime APEX is much higher than in SQLDeveloper

Lars_Mar 6 2018 — edited Mar 6 2018

Hello everybody,

A page of my APEX Application runs a sql-query which takes about 30 up to 45 minutes (shown in Oracle Enterprise Manager) (Screenshot1).

When I click on the details of this query and copy it into sqldeveloper, the query only takes less than 1 second (Screenshot2).

So the same query takes 30 min (APEX) or 1 second (sqldeveloper). Does anybody have an idea why?

1 oracle em.jpg

2 - sqldeveloper.jpg

Comments

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

Post Details

Locked on Apr 3 2018
Added on Mar 6 2018
#apex, #apex-discussions, #performance, #sqldeveloper
1 comment
162 views