Contention on SYS.DUAL table (11204)
Too much Contention on SYS.DUAL table and on an average the number of executions on SYS.DUAL is around 70 – 100 million times during our ETL daily jobs running time
Current Database version : 11.2.0.4
Please suggest that the below workaround can be reduced the contention on sys.dual table
create table my_dual (x number primary key) organization index;
thank you in advance
Regards
N Jandial