Enable Autotrace view SQL execution plan in Oracle

You can grant Autotrace permissions to everyone in the following ways.

If you need to restrict Autotrace permissions, you can change the authorization for public to a specific user's authorization.

D:oracleora92>sqlplus/nolog

Sql*plus:release 9.2.0.1.0-production on Tuesday June 3 15:16:03 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Sql> Connect SYS as SYSDBA

Please enter password:

is connected.

sql> [b]@?rdbmsadminutlxplan[/b]

Table has been created.

sql> create public synonym plan_table for plan_table;

The synonym has been created.

Sql> Grant all on plan_table to public;

The authorization was successful.

SQL>[B] @?sqlplusadminplustrce[/b]

Sql>

sql> drop role Plustrace;

Drop role Plustrace

*

ERROR is on line 1th:

ORA-01919: Role ' plustrace ' does not exist

sql> Create role Plustrace;

Role created

Sql>

Sql> Grant Select on V_$sesstat to Plustrace;

The authorization was successful.

Sql> Grant Select on V_$statname to Plustrace;