title: Oracle Apex performance issue due to session state values
body: <p>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. </p>
  
  <p>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 <code>"... do not save: same value / password / no session"</code> 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.</p>
  
  <p><a href="https://i.stack.imgur.com/0ptqx.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0ptqx.jpg" alt="enter image description here"></a></p>
  
  <p>At the beginning I found a different issue in the Debug Log, which was due to <code>'IR binding: "APXWS_MAX_ROW_CNT" value="1000000"'</code>. Later I removed the Maxrowcount value and made it null. So this was taken care.</p>