Discrete Manufacturing - EBS (MOSC)

MOSC Banner

WIP Move Transaction Workers (WICTWS) Performance Issue

edited Jan 30, 2014 3:18PM in Discrete Manufacturing - EBS (MOSC) 4 commentsAnswered
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. 

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center