Subscriber Count


Subscribe to Posts by Email


12c Database : Reporting mode for statistics jobs and compare statistics jobs

Before to 12c, we have a problem to revert back to a question, how much time does the statistics operation will run?

This is common problem, as we cannot anticipate the time and its depend on the various factors that will take place at time of statistics job execution.

To accomplish this we will have […]

12c Database : Adaptive Query Optimization

Before to 12c, all the sql tuning features like ACS, SQL Profiles, SQL Outlines, SPM etc are for proactive tuning and plan stability. There is no way around to decide and change the optimizer decision on fly during the execution of a sql statement.

Since 12c, Oracle introduced the set of capabilities called "adaptive query […]