adaptive

Oracle ASH SQL_PLAN_LINE_ID in adaptive plans

There are several methods to find out where time is spent in an execution plan of a query running in an Oracle database. Classical methods like SQL Trace and running a formatter tool like tkprof on the raw trace, or(…)

JAN17 Proactive Bundle Patch + Adaptive Statistics control

By Franck Pachot . If you have to create a new database now (I'm writing this in March 2017) for a migration of OLTP database with minimal risks of regression, I would recommend: The latest patchset of Oracle Database 12cR1(…)

Adaptive Plans and SQL Baselines

By Franck Pachot . I encountered recently an issue with Adaptive Plan and SPM. Documentations says that it works perfectly together but I remembered a presentation from Nelson Calero at UKOUG TECH15 mentioning strange behavior. I reproduced the issue and(…)

Nothing in feature usage statistics since 12c?

By Franck Pachot . It don't want to rub salt in the wound about 12c upgrades and Adaptive Dynamic Sampling being overzealous, but here is a case with an unexpected consequence: you see nothing in the 'Database Feature Usage' since(…)