Receivables - EBS (MOSC)

MOSC Banner

Create Accounting in Receivables poor performance even after appying patch 17922170

edited Apr 14, 2015 3:49PM in Receivables - EBS (MOSC) 3 commentsAnswered

Dear experts,

Customer raised a performance issue on Create Accounting program, it cost almost two hours to finish it even after applying patch 17922170

As per trace log SQL ID bx6hwwvmyhhf8 has performance issue when the large data volume(330543).

SQL ID: bx6hwwvmyhhf8 Plan Hash: 323166177

call     count       cpu    elapsed       disk      query    current        rows

------- ------  -------- ---------- ---------- ---------- ----------  ----------

Parse        1      0.00       0.00          0          0          0           0

Execute      1      0.24       0.25          0          0          0           0

Fetch      662   6520.03    6540.00      15805  407512680          5      330543

------- ------  -------- ---------- ---------- ---------- ----------  ----------

total      664   6520.28    6540.25      15805  407512680          5      330543

Misses in library cache during parse: 1

Misses in library cache during execute: 1

Optimizer mode: ALL_ROWS

Parsing user id: 173     (recursive depth: 2)

Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation

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