Adaptive Execution Plans

Adaptive Query Optimization

  • adaptive plans
    join methods
    parallel distrubution methods

  • adaptive statistics
    dynamic statistics
    automatic reoptimization
    sql plan directives

=============
Adaptive Plans in Oracle Database 12c Release 1 (12.1)
Adaptive SQL Plan Management (SPM) in Oracle Database 12c Release 1 (12.1)
Adaptive Query Optimization in Oracle Database 12c Release 1 (12.1)

=============
Parameters :
optimizer_adaptive_features
optimizer_adaptive_reporting_only

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s