ryanthames/display_exec_plan.sql

Created April 1, 2016 14:39

Star (0) You must be signed in to star a gist
Fork (1) 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/ryanthames/1dac69af070b035a224eda7a6c96010a.js"></script>
Save ryanthames/1dac69af070b035a224eda7a6c96010a 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