Oracle 10g has introduced Automatic Statistics Gathering job that run daily sometime between 8pm to 6am to collect the Database statistics. If we have to make some alteration, we have to either remove this auto Job or have to schedule several other statistics jobs based on application requirement. With 11g new Statistics preferences features, we can reduce the complexity.
Click here to get more step by step details od setting preferences and their benefits
Wednesday, October 10, 2007
Sunday, October 07, 2007
11g Database Statistics enhancements - Overview
Oracle 11g has made lots of Database statistics enhancements which are very beneficial to DBA as well as production application. In this paper , I will discuss the initial configuration and high level overview and will go in more details in the next paper.
Click here to get complete details about the enhancements
Click here to get complete details about the enhancements
Subscribe to:
Posts (Atom)
