O'Reilly logo
  • Denis Kozlov thinks this is interesting:

You will need SELECT privileges on V$SESSION, V$SQL, and V$SQL_PLAN to use the DBMS_XPLAN.DISPLAY_CURSOR function. Generally, I would recommend that any user doing diagnostic work is granted the SELECT_CATALOG_ROLE.

From

Cover of Expert Oracle SQL

Note

GRANTS for read execution plans