dbms_stats Archives - AskDba.org Weblog

Checking column usage information using dbms_stats

Post author:Amit Bansal
Post published:6 June, 2012
Post category:11g / Performance
Post comments:2 Comments

Oracle 11gR2 DBMS_STATS introduced useful function report_col_usage to report column usage i.e if column is being used for equality,like predicates. I came to know it while reading Optimizer whitepaper .As per…

GATHER_STATS_JOB – Is it enabled?

Post author:Amit Bansal
Post published:18 August, 2009
Post category:10g / 11g
Post comments:9 Comments

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…

dbms_stats.copy_table_stats does not alter low/high value

Post author:Amit Bansal
Post published:24 June, 2009
Post category:Performance
Post comments:8 Comments

I 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…