Athil's Oracle blog

SELECT plan_hash_value,        child_number,        INVALIDATIONS,        is_obsolete,        IS_BIND_SENSITIVE,        FIRST_LOAD_TI...

      Sometimes it is better to estimate the index before creating so to not see any surprise errors. From the below Oracle note got the ex...

In one of our 11204 database, we encountered the deadly ‘Enq: HW contention’ on critical business day. The majority of the DB activity is...

With Mr. RAC, Syed jaffer Hussain

If you want to get a DDL with the desired name for a table this is function will be used. Step 1: Replace YOUR SCHEMA name in line # 1...