makiju
28th July 2008, 15:46
Hi,
I am not a programmer...I would like to ask what is the idea of executing row counting in session in general? It's causing FTS in oracle-level in many places in LN.

One example:
Starting of session whinh4525m000:

SELECT /*+FIRST_ROWS(2)*/
COUNT (*)
FROM erpln6a.twhinh225260 a0,
erpln6a.twhwmd400260 a1,
erpln6a.twhwmd200260 a2,
erpln6a.twhwmd400260 a3,
erpln6a.ttcibd001260 a4,
erpln6a.twhwmd200260 a5,
erpln6a.ttcmcs003260 a6
WHERE (a0.t$pckd = :1 OR a0.t$pckd = :2)
AND (a0.t$rlsd = :3 OR a0.t$rlsd = :4)
AND a6.t$cwar(+) = a5.t$cwar
AND a5.t$cwar(+) = a0.t$cwar
AND a4.t$item(+) = a3.t$item
AND a3.t$item(+) = a0.t$item
AND a2.t$cwar(+) = a0.t$cwar
AND a1.t$item(+) = a0.t$item

dave_23
28th July 2008, 19:47
it's used to generate a progress bar.

makiju
30th July 2008, 12:34
This one to bse_vars solved the problem.

SCROLL_LIMIT=-1

It's a question of scroll bar postitioning:
Solution ID 209677

dave_23
30th July 2008, 18:39
Makes sense, it also pops up from progress bars, usually you can turn those off via performance boosters.