By JeffG-Oracle on Aug 13, 2013
Query to show log:
select (select schema_name
where schema_id = a.schema_id),
to_char(a.record_created, 'DD-MON-YYYY HH24:MI:SS'),
to_char(a.record_updated, 'DD-MON-YYYY HH24:MI:SS'),
from demantra.wf_process_log a
where process_id >= 922599
order by a.record_created desc
Does the above output indicate that you are running multiple batch processes in parallel?
Please review your environment and make sure you run processes in the correct order and
that the processes are not competing for hardware resources.
If you are trying to run processes that compete for same data in same tables you can try extending
your undo space and settings to be much larger, assuming your hardware can support this path.
However, running overlapping engines is not recommended.
* Attain the process ID from the OS for the most recently ran batch process