CODEWITHSUNDEEP
oracle-databaseoracle-apexoracle-apex-5.1
Lalith Kumar
Lalith Kumar

Reputation: 21

Oracle Apex performance issue due to session state values

I have a long-running page in Oracle Apex, this is an interactive report page, which fetches the report based on the Username, From_Date and To_Date parameters users provide.

The query used for this report page is executing without any issues(0.07 Sec) in SQL developer. When I checked the Debug log to debug the long run, I found the statement "... do not save: same value / password / no session" in the log which is the reason for the long run. The page never loads and end up in a gateway time out. The expected number of rows for the given parameters in mere 161 rows. Please find the screenshot of the debug log below. Please help me with this.

enter image description here

At the beginning I found a different issue in the Debug Log, which was due to 'IR binding: "APXWS_MAX_ROW_CNT" value="1000000"'. Later I removed the Maxrowcount value and made it null. So this was taken care.

Upvotes: 2

Views: 2103

Answers (1)

Littlefoot
Littlefoot

Reputation: 142743

A few ideas; see whether any of those helps.

  • How do you run the report? Did you set "Page action on selection" for those parameters to "Submit"?
  • If not, how about creating a SUBMIT button which would submit the page (and, thus, put items' values into session state)?
  • If you use a source for those items, try to set them to be used "always, replacing any existing value in session state".

Upvotes: 1

Related Questions