Memory Based Snapshot Running Long - Wait Event 'SQL*Net message from client' Selecting Unit of Measure (UOM) Data (Doc ID 2937600.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

Launch the Plan and note that MSCNSPWL64 - Memory Based Snapshot 64 bit Linux is taking a long time to complete.
Set trace in System Administrator (R) /Concurrent / Program / Define -- Query Program , check Enable Trace and save
Run Plan again and gather log file, trace and tkprof for and find the following:

STEPS
1. Responsibility: Advanced Supply Chain Planner
2. Navigation: Supply Chain Plan > Launch
3. Enter the necessary parameters to run the plan

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.