You can use hints and initialization parameter to influence optimizer decisions and behavior.

This part contains the following chapters:

• Influencing the Optimizer
  Optimizer defaults are adequate for most operations, but not all.
• Improving Real-World Performance Through Cursor Sharing
  Cursor sharing can improve database application performance by orders of magnitude.