GATHER_STATS_JOB – Is it enabled?
Few days back , Martin had posted a series of post on a issue where GATHER_STATS_JOB was failing silently for a large object. If you have missed it, you can…
Read Full RecipeFew days back , Martin had posted a series of post on a issue where GATHER_STATS_JOB was failing silently for a large object. If you have missed it, you can…
Read Full RecipeThis post discusses issue faced by me while working on Materialized view (mview) creation at new site(database). Starting Oracle 10g, how atomic_refresh works with complete refresh has undergone a change.…
Read Full RecipeI was working on a performance issue arising due to missing table stats on a new partition for large Partitioned table.This was a 10.2.0.4 database on IBM AIX 5L. So…
Read Full RecipeWell I tried to Sensationalize this post by using such a heading :) Though I just wanted to point out that Awrrpt script can be run without sysdba privilege too.…
Read Full RecipeRecently I faced one issue where all the connection to database hung and it was also not possible to login to database using "/ as sysdba". To get access of…
Read Full RecipeThere is a common misconception that Index access is the best access method for query execution. This approach leads to people concentrate on removing Full Table Scans (FTS) from the…
Read Full Recipe