9i Archives - AskDba.org Weblog

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

CleanUp Temporary Segments Occupying Permanent Tablespace

Post author:Saurabh Sood
Post published:3 July, 2009
Post category:10g
Post comments:2 Comments

There are situations when we see "temporary segments" in permanent tablespaces hanging around and not getting cleaned up. These temporary segments in permanent tablespace can be created by DDL operations…

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…