As of November 8th, 2025, a call to dbms_xplan.display_cursor returns ‘User has no SELECT privilege on V$SESSION’. This is confirmed by an attempt to query V$SESSION, which returns ‘ORA-00942: table or view "SYS"."V_$SESSION" does not exist’.
If I remember correctly, LIVESQL had this same limitation for a time, but eventually a solution was found to allow dbms_xplan.display_cursor to function while respecting security concerns.
Is this limitation expected to be permanent, or will there be some future attempt to allow the functionality?
Thanks in advance,
Stew Ashton