Tag Info

Hot answers tagged


Yes, you can specify the SQL_ID. The usage would be something like this: SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('gwp663cqh5qbf',0)); To find the SQL IDs for the current session, you'll first need to get the SID for your session, and then search v$session for the related SQL_IDs: select sys_context('USERENV','SID') from dual; select SQL_ID from ...

Only top voted, non community-wiki answers of a minimum length are eligible