RichVRed/display_exec_plan.sql

Forked from ryanthames/display_exec_plan.sql

Created April 28, 2017 23:56

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/RichVRed/a607f14bbc0361e0808cbc66e194c719.js"></script>
Save RichVRed/a607f14bbc0361e0808cbc66e194c719 to your computer and use it in GitHub Desktop.

Download ZIP

Oracle - Display execution plan of cached sql (https://app.pluralsight.com/library/courses/oracle-performance-tuning-developers/table-of-contents)

Raw

display_exec_plan.sql

	-- REPLACE <<sql id>> with actual sql id
	select plan_table_output from table(dbms_xplan.display_cursor('<<sql id>>', null, 'typical'));

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment