Write a 250 - 280 word essay (that is approximately one page with a double spaced format) that contains answers to the following questions.
What is the purpose of the Oracle Optimizer?
How does it work?
What is an execution plan?
What is the purpose the Oracle Database 12c SQL Plan Management? Use citations and references to support your answer.