When setting the post debug "sp_ctrl> set param SP_OPO_DEBUG_FLAG 0x0f000800" to test performance of the post process, you get some negative numbers for the timing of either execution in oracle, commit in oracle, or time spent in the queues, please ask for fix ST100971. This fix will be available after 7.6.3.
opo 2012-03-13 03:01:06.848015 20225 1 StDispatch
opo 2012-03-13 03:01:06.848181 20225 1 SqlThread::Dispatch: 183
opo 2012-03-13 03:01:06.848327 20225 26 s:22 E: -2034170528
opo 2012-03-13 03:01:06.848541 20225 1 Q: 32
opo 2012-03-13 03:01:06.848706 20225 26 s:22 Individual SQL: 1514102349
opo 2012-03-13 03:01:06.848890 20225 1 StDispatch
opo 2012-03-13 03:01:06.849052 20225 1 SqlThread::Dispatch: 341
opo 2012-03-13 03:01:06.849215 20225 26 s:22 CreateSQL: -2033864551
opo 2012-03-13 03:01:06.849390 20225 1 Q: 35
opo 2012-03-13 03:01:06.849556 20225 26 s:22 CreateSQL: oname="USER"."TABLE" op=ODR_UPDATE_BATCH
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center