SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is

[7280]

Hi,
i want to check the execution plan for some queries but
when i put set autotrace on i have following error:
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report

But i have the role granted to the user:
SQL> select * from user_role_privs where granted_role='PLUSTRACE';

USERNAME GRANTED_ROLE ADM DEF OS_
-------------------------------------------
DEV PLUSTRACE NO YES NO


Execution Plan
----------------------------------------------------------
ERROR:
ORA-01039: insufficient privileges on underlying objects of the view


SP2-0612: Error generating AUTOTRACE EXPLAIN report

What's the issue?
Thanks

 

[flstffatboy]

Did you run the utlxplan.sql script as the DEV user? this creates the plan table for the DEV user. After the plan table is created set autotrace on and run the query you need explained.

FLSTF