How to check the SQL Statement Plan?

When you do an explain plan, then the appropriate DBMS_XPLAN api is
When you do an actual execution - i.e. not with explain plan - then
DBMS_XPLAN.DISPLAY_CURSOR is the appropriate api.

NOTE: cannot fetch plan for SQL_ID: 3pb80q4uks11n, CHILD_NUMBER: 0
Please verify value of SQL_ID and CHILD_NUMBER;
It could also be that the plan is no longer in cursor cache (check v$sql_p

grant select ON v_$session TO &&1;
grant select on v_$sql_plan to &&1;
grant select on v_$sql to &&1;

set serverouput off;

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.