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!
Hi,
I have an interactive report that includes a column with a check box, in order to make an operation. The problem is produced when i check some rows in the page 1, when i click the next page to select other rows, the first rows selected are unchecked. How can I avoid that?
The example is at http://apex.oracle.com/pls/apex/f?p=64586:1:0::NO:::&success_msg=Done%2FE0A883D1D5E93D953161D89A31237BB3%2F
Please your help
Hi Keith,
Since you have read the other information about this problem, I assume you know that upgrading to JE 6 (use the most recent release of course) is the only sure solution, but setting CLEANER_ADJUST_UTILIZATION to false will work for some applications. If it is working for you, that's great, but please plan to upgrade.
The reason that EVICT_LN would bring out this problem is that, after the LN (data record) is evicted, the Btree no longer contains its size. Then when you delete the record, JE has to guess the size using an average. If the LN were still in cache, the size would be known at the time it is deleted. In JE 6 and above, the size is stored in the Btree even after the LN is evicted, which solves the problem.
--mark
Thanks for the swift reply. That completely answers my question.