Is it possible to get an execution plan of currently running query by sql_id?
I couldn't succeed with:
select DBMS_SQL_MONITOR.REPORT_SQL_MONITOR (sql_id=>'b3x6apqyskn7x') report from dual;
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community