Subscriber Count

    459

Subscribe to Posts by Email

Pages

12c Database : Upgrades – 460 Slides deck from Oracle

Really,  about 460 slides on just upgrades, all information about upgrade matrix, upgrade paths, references etc etc. A must read for all.

https://blogs.oracle.com/UPGRADE/entry/new_version_of_slide_deck?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+orana+(OraNA)

I will also upload the same soon.

-Geek DBAGeek DBA

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 […]