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!

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.

Performance issue on IG page after Export/Import

J-LigApr 23 2018

Hello,

I think this has been happening on several of my recent applications, but I have only been able to pinpoint what was "causing" the problem with my current app. I have an Interactive Grid page that performs just fine until I Export/Import (for migrations). After I Import the app, my page is SUPER slow and basically just hangs. If I edit the page in the builder and go to the query and hit the space bar just to "register a change" (although nothing is really changing). After saving, it works fine again. I attempted to run the page with debug on and dont see anything indicative of a problem. It just takes forever.

We are running 5.1.4.00.08, but I believe this was happening in previous versions but I could never figure out when or how to reproduce it until now. I just noticed that one day my page was fine and the next it was SUPER slow and the only action I had taken was Export and Importing. I can reproduce it every time now. It even happens when I change nothing, but Export and Import into the same environment. Unfortunately, this is a fairly complicated app and it runs against our eBusiness suite database so I cannot reproduce it on oracle.apex.com.

Not sure if this is related, but I have several fairly complex (filters, aggregates, etc) saved custom report views within the IG.

I was just wondering if anyone else has seen this before? Perhaps people have experienced "seemingly random" performance issues, but have yet to connect it to Export/Import functions? Does anyone know what might change about a page/query during Export/Import that might be causing this? When I Export the file each time it looks exactly the same to me. At least I cannot see any indication of what might be changing between Export/Import.

Any thoughts?

Thank you,

Jen

Comments

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

Post Details

Locked on May 21 2018
Added on Apr 23 2018
0 comments
161 views