on 04-06-2017 2:07 PM
ecc extarctor log take long Running
in the log i see teh message
18 LUWs confirmed and 18 LUWs to be deleted with function module RSC2_QOUT_CONFIRM_DATA
during in db02 of that session id show a qry on CDCLS(1.000.000.000.000 record)
SELECT
"MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "PAGENO", "TIMESTMP", "PAGELG", "VARDATA"
FROM "CDCLS"
WHERE "MANDANT"=:A0 AND "OBJECTID"=:A1 AND "CHANGENR"=:A2
ORDER BY
"MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "PAGENO"
this take 1 hour
any advise how to improve it?
tks
S
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.