FCEXEC
The question is about threading scheme of fcexec and fcthreadexec.
Operationg guide v1(140 fcexec): Threading Scheme Threaded by item, supplier, country and location
I guess it refers to the future cost engine, but not applied to batch threading scheme. I tried to launch fcexec by one object of the list(location).
There are 218 stores, 218 threads of fcexec started, and most of them block each other. After some time it classified like deadlock by db.
invalid character in expression - ORA-00060: deadlock detected while waiting for resource@2FUTURE_COST_SQL.PROCESS_COST_EVENTS, cost_event_id=1152496992
invalid character in expression - ORA-00060: deadlock detected while waiting for