WIP Move Transaction Workers (WICTWS) Performance Issue
Hi, there is inconsistent performance for WIP Move Transaction Workers (WICTWS) requests: WIP Move Transaction Manager (WICTMS) is scheduled to run every 1.5 minute. and spawns one or more WIP Move Transaction Workers (WICTWS) requests.
I have traced the program and found below sql is consuming most of time.
1) 1st SQL:
BEGIN WIP_MOVPROC_PRIV.MOVE_WORKER(:errbuf,:rc,:A0,:A1,:A2,:A3); END; -- this proc is taking and we should look into this to tune it.
I have traced the program and found below sql is consuming most of time.
1) 1st SQL:
BEGIN WIP_MOVPROC_PRIV.MOVE_WORKER(:errbuf,:rc,:A0,:A1,:A2,:A3); END; -- this proc is taking and we should look into this to tune it.
Also this proc is generating too much redo also and other user are experiencing 'log sync' wait event.
Application version : 11.5.10.2
DB version : 11.2.0.3
Thanks,
0