Skip to Main Content
  • Questions
  • unable to use AUTOTRACE in SQL Developer Version 4.2.0.17.089

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, kavitha.

Asked: June 13, 2017 - 4:01 pm UTC

Last updated: June 17, 2017 - 1:17 am UTC

Version: oracle 11.2.0

Viewed 1000+ times

You Asked

unable to use AUTOTRACE in SQL Developer Version 4.2.0.17.089
it works fine in sqldeveloper-4.1.0.19.07 with the below enclosed setup
GRANT SELECT ON SYS.V_$MYSTAT TO RL_AUTOTRACE;
GRANT SELECT ON SYS.V_$SESSION TO RL_AUTOTRACE;
GRANT SELECT ON SYS.V_$SESSTAT TO RL_AUTOTRACE;
GRANT SELECT ON SYS.V_$SQL TO RL_AUTOTRACE;
GRANT SELECT ON SYS.V_$SQL_PLAN TO RL_AUTOTRACE;
GRANT SELECT ON SYS.V_$SQL_PLAN_STATISTICS TO RL_AUTOTRACE;
GRANT SELECT ON SYS.V_$STATNAME TO RL_AUTOTRACE;
GRANT RL_AUTOTRACE TO TEST_KAVI;

above setup for the TEST_KAVI account - AUTOTRACE works fine in sqldeveloper-4.1.0.19.07
above setup for the TEST_KAVI account - AUTOTRACE does not work for sqldeveloper- 4.2.0.17.089 please help me identify the additional permissions

error msg - ORA-00942: table or view does not exist (no data in V$sql_plan).

Additional requested info - I run a sql statement in the editor and right click on the statement to use the AUTOTRACE option

I get the error with the above mentioned AUTOTRACE set up in SQL Developer Version 4.2.0.17.089 - i get that error when I click autotrace

Best REgards,

and Chris said...

Add

SYS.v_$sql_plan_statistics_all

to the list of grants

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Awesome Identification

kavitha manju, June 15, 2017 - 3:11 pm UTC

Thank you so much Connor and Chirs..you guyz are the best. I updated the role with

GRANT SELECT ON SYS.V_$SQL_PLAN_STATISTICS_ALL TO RL_AUTOTRACE;

Issue was resolved in sql developer 4.2


Thanks a Ton
Connor McDonald
June 17, 2017 - 1:17 am UTC

glad we could help