Skip to main content

Search

Welcome to Tibero GTS!

Error Occurs When a User Without PLUSTRACE Privilege Uses set autotrace on

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];

 

 

 
 
 

Related to