DBAs want control over SQL execution plans both proactively and reactively. In other words, DBAs want to be able to fix plans from the outset, repair a regression quickly or use a mixture of the two approaches. Tough-to-deliver service level requirements for critical systems can necessitate a strategic approach to constrain all execution plans, but often a more targeted and tactical technique is appropriate. The Oracle Database has a number of features to control and constrain SQL execution plans, but how are they used and what are the differences between them? What is the best choice for a given requirement? This session answers these questions and presents some creative ways in which to use the features at your disposal in the Oracle Database. The session covers Oracle Database 11g and on to Oracle Database Cloud Services (Oracle Database 12c Release 2).