Retail Merchandising System (MOSC)

MOSC Banner

EDI Sales and Stock On Hand Report Download job running longs

edited Dec 3, 2013 3:32PM in Retail Merchandising System (MOSC) 1 commentAnswered

Hi,

We have this job running for around 2 Hours daily, we have this executed for 8 suppliers and of which we found that the job is getting executed for 6 suppliers(6 threads) within the first 10 mins and the remaining 2 suppliers(2 threads) its taking 1hour and 50 mins to complete,I have attached the trace file for this batch.

Please suggest.

TKPROF: Release 11.2.0.2.0 - Development on Thu Nov 21 04:38:34 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Trace file: /u01/app/oracle/diag/rdbms/rmsuat/RMSUAT2/trace/RMSUAT2_ora_45941086.trc
Sort options: default

********************************************************************************
count    = number of times OCI procedure was executed
cpu      = cpu time in seconds executing

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center