CODEWITHSUNDEEP
oracle-databaseoracle11goracle-apex
p27
p27

Reputation: 2222

Oracle application performance issue

I have developed a oracle apex application using oracle apex 19.1 version and oracle 11gr2 xe oracle database, which has performance issue like slow login and slow loading of home page.

while troubleshooting I found that when I deployed a copy of same application with new application ID then the both application working fine and after some days (2,3) it become slow again then again I delete duplicate application application and recreate a duplicate application with new application id then again it become fast, I could not find the reason behind it, if any one can help me to understand this behavior, I would really appreciate them.

I must add here that performance improve only when new duplicate application has a new application id, if reusing old application id then no improvement.

Upvotes: 0

Views: 95

Answers (1)

Littlefoot
Littlefoot

Reputation: 143083

Who knows? I don't, but - you might find out.

  • run the application (from App. Builder)
  • when on home page, enable debug (on the toolbar at the bottom of the page)
  • reload
  • view debug
  • check events that take a lot of time to finish - that's where you should start the investigation
    • if it is something obvious, fine - fix it. If not, share that information with us - someone might be able to assist

Upvotes: 1

Related Questions