Hello Team
We have an insert statement which pulls records from 5 tables using inner join. Parallel hint ( 4 level parallelism) is being used in the source table . Because it pulls huge data , it is expected to run for 2 hours.
Few days it works fine but some days it fails with ORA-02392 : exceeded session limit on CPU usage. CPU usage cannot be set to unlimited due to policy issues.
Should I reduce the Parallelism ? Will that help?
Appreciate any thoughts to get rid of this failure .
Regards
Sasidharan