Tag Archives: user_constraints

Data Dictionary – user_constraints/user_cons_columns is slow in Oracle 12cR1

Recently one of our client after upgrade, complaint about sluggish performance for one of the module comprise of getting table information in Oracle 12c R1. Impacted SQL, comprise of Data Dictionary tables getting Table metadata. SELECT UTC.TABLE_NAME, UTC.COLUMN_NAME, UTC.COLUMN_ID AS … Continue reading

Rate this:

Posted in Oracle 12c New Features, Oracle Internal | Tagged , , , | Leave a comment