Database - RAC/Scalability (MOSC)

MOSC Banner

Contention on SYS.DUAL table (11204)

edited Jan 25, 2017 11:51PM in Database - RAC/Scalability (MOSC) 10 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center