Monthly Archives: March 2019

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

Exploration of SQLite

Recently got a chance to work on SQLite for a requirement to Purge Data based on Date Conditions.Collaborating all learning as part of perks of working on something new. 1. Date Function to Add Days in SQLite. As part of … Continue reading

Rate this:

Posted in SQLite Learning | Tagged , , , | Leave a comment