Performance Archives - Page 3 of 4

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…

Mview Complete Refresh and Atomic_refresh parameter

Post author:Amit Bansal
Post published:8 July, 2009
Post category:10g
Post comments:5 Comments

This 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.…

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…

You Don’t need SysDBA privilege to run Awrrpt..

Post author:Amit Bansal
Post published:8 May, 2009
Post category:10g
Post comments:0 Comments

Well 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.…

Connections to DataBase Hang Including “/ as sysdba”

Post author:Saurabh Sood
Post published:7 April, 2009
Post category:10g
Post comments:2 Comments

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

Index Access best approach?? Not Always…

Post author:Amit Bansal
Post published:17 December, 2008
Post category:Performance
Post comments:6 Comments

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