kyle Hailey
- Sep 4, 2009
- 1 min read

Outlines from DBMS_XPLAN

dbms_xplan.display_cursor will output the hints for a plan.

These hints can then be taken and used in an outline for plan stability:

http://oracle-randolf.blogspot.com/2009/03/plan-stability-in-10g-using-existing.html

Recent Posts

Oracle’s Cardinality Hint, Profiles, Outlines and SQL Baselines

This is more of a bookmark for a future blog post on using the Cardinality hint. This post by Greg Rahn give some example and I posted in the comments some more detailed examples: http://structureddat

Explain Plan vs Real Plan on Oracle

Real Time SQL Monitoring