Document Type | Troubleshooting
Category | Administration
Applicable Product Version | 6FS07
Document Number | TADTS042
Issue
When using set autotrace on to check execution plans, etc., a situation occurs where it cannot be verified due to permission issues.
The error code is as follows.
TBS-70035: Unable to display plan: check PLUSTRACE role.
Cause
This issue occurs because the user has not been granted the plustrace privilege.
Solutions
Grant the plustrace privilege to the user to resolve the error.
1. Execute plustrace.sql (DBA privilege required)
Run $TB_HOME/scripts/plustrace.sql as a user with DBA privileges.
--plustrace.sql drop role plustrace; create role plustrace; grant select on vt_autotracestat to plustrace; grant select on v$sql_plan to plustrace; grant select on v$sql_plan_statistics to plustrace; grant plustrace to dba with admin option;
2. After execution, grant plustrace privilege
grant plustrace to [USER];