Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exadata Software Compatibility Matrix

Muhammad AhmadJan 22 2020 — edited Jan 22 2020

Greetings

I can not find subject information under certification tab of support.oracle.com. I need to check software version compatibility/certification b/w exadata storage cell software and oracle DB/GI/Linux.

Can any one comment on this Pl?

Regards,

Muhammad Ahmad

Comments

user9540031

The documentation for the OPTIMIZER_ADAPTIVE_STATISTICS parameter (remark: modifiable in a PDB) states:
OPTIMIZER_ADAPTIVE_STATISTICS does not control the creation of SQL plan directives. SQL plan directives will be created even if this parameter is false, but they will not be used to refine SQL execution plans with dynamic sampling.
Therefore, if the AUTO_STAT_EXTENSIONS statistics preference is set to ON, it would be normal that statistics extensions be created.
Related blog articles by Frank Pachot and Christian Antognini:
https://blog.dbi-services.com/matching-sql-plan-directives-and-queries-using-it/
https://blog.dbi-services.com/dba_sql_plan_directive-last_used/
https://antognini.ch/2017/11/spd-state-does-not-change-if-adaptive-statistics-are-disabled/
Remarks:
Sadly, the +metrics format option (so far undocumented) seems to work only in dbms_xplan.display; it does nothing apparently in calls to dbms_xplan.display_cursor—I didn't try, but I wouldn't expect it to do anything in calls to dbms_xplan.display_awr either.
Christian Antognini's post includes a test script; I ran it on a 19.5 test DB, which behaved exactly as described.

1 - 1

Post Details

Added on Jan 22 2020
#exadata, #performance-availability
2 comments
1,686 views