Posts Tagged ‘autotrace’
今天执行autotrace时，出现如下错误：
SQL> set autotrace on
SP2-0618: 无法找到会话标识符。启用检查 PLUSTRACE 角色
SP2-0611: 启用STATISTICS报告时出错
SQL> show user
USER 为”D_INSIGHT” –D_INSIGHT为普通用户
检查dba_role_privs：
SQL> conn sys/xxx@dd as sysdba
已连接。
SQL> select * from dba_role_privs where grantee=’D_INSIGHT’;
GRANTEE GRANTED_ROLE ADM DEF
—————————— —————————————————— —
D_INSIGHT PLUSTRACE NO NO
SQL>
Page 1 of 11
