Webinar: AUSOUG - March/April/May-2019 -

  • Apr 24th - DevOps for DBA
  • May 1st - 18c New Features

 

AIOUG - Chennai Chapter

27-Apr-2019 Full Day Event

Performance Troubleshooting & DevOps for DBA

Click here to register

Subscribe to Posts by Email

Subscriber Count

    542

Pages

12c Database : SQL Plan Directives

From 12c onwards, Oracle optimizer maintains the directives that influence the optimizer to take appropriate decision while executing the statement or estimation.

As you read from previous posts, Optimizer maintains the execution statistics now,they can be used to create a directive for future executions. These directives can be used by optimizer and determine which optimization […]