今天是2014-01-08，在开启autotrace的时候报如下错误，解决过程如下： sql conn scott/root connected. sql sql sql set autotrace trace statistics error ora-942 while gathering statistics sp2-0611: error enabling statistics report sql sql sql set
今天是2014-01-08，在开启autotrace的时候报如下错误，解决过程如下：
sql> conn scott/root
connected.
sql>
sql>
sql> set autotrace trace statistics
error ora-942 while gathering statistics
sp2-0611: error enabling statistics report
sql>
sql>
sql> set autotrace
usage: set autot[race] {off | on | trace[only]} [exp[lain]] [stat[istics]]
sql> set autotrace trace
error ora-942 while gathering statistics
sp2-0611: error enabling statistics report
sql> conn sys/root as sysdba
connected.
sql>
sql>
sql> !oerr ora 942
00942, 00000, table or view does not exist
// *cause:
// *action:
sql> grant select on v_$sesstat to scott;
g
grant succeeded.
sql> rant select on v_$statname to scott;
grant succeeded.
sql> grant select on v_$mystat to scott;
grant succeeded.
sql>
sql>
sql> conn scott/root
connected.
sql>
sql>
sql> set autotrace trace
sql>