Min-Max Planning Report (INVISMMX) Performance Issues -- Master Note

(Doc ID 413522.1)

Last updated on MARCH 09, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
INVISMMX

Symptoms

Min-max planning report (INVISMMX) runs for unacceptably long time.

Following is an example TKPROF output showing long elapsed time and large counts for data, from this query:


TKPROF data for this query (example only)

call    count       cpu    elapsed       disk      query    current       rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse        1     0.00       0.00          0          0          0          0
Execute   8158     0.66       0.89          0          0          0          0
Fetch     8158   104.16    3212.53     546917     697829          0       8158
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total    16317   104.82    3213.43     546917     697829          0       8158

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms