Skip to content

Instantly share code, notes, and snippets.

@davidhooey

davidhooey/oracle_execution_plan_for_sqlid.sql

Last active November 3, 2017 09:50
Show Gist options
  • Save davidhooey/6629359 to your computer and use it in GitHub Desktop.
Save davidhooey/6629359 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle Execution Plan for SQL_ID
Raw
oracle_execution_plan_for_sqlid.sql
-- Shared Pool
select * from table(dbms_xplan.display_cursor('SQL_ID',null,'ALL'));
-- AWR
select * from table(dbms_xplan.display_awr('SQL_ID',null,null,'ALL'));
select * from table(dbms_xplan.display_awr('SQL_ID',null,DBID,'ALL'));
@abinasroy
Copy link

what all utility which can give recommendation for specific sql_id or query.

@davidhooey
Copy link
Author

I assume you're asking for which utility to determine SQL_IDs. Oracle Enterprise Manager will give you the SQL_ID or an AWR report will also.

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