how to set auto trace in oracle# Database - 数据库
y*e
1 楼
I am using oracle 8, when I use autotrace, I got the following error.
SQL> set autotrace on;
Error while connecting
Error enabling STATISTICS report
I execut @plustrce.sql at sys account,
then grant plustrace to user with admin option;
Then under user account: @utlxplan.sql
Then I execute:
set autotrace on;
But I got error.
Anybody know what's wrong with it. Help please.
SQL> set autotrace on;
Error while connecting
Error enabling STATISTICS report
I execut @plustrce.sql at sys account,
then grant plustrace to user with admin option;
Then under user account: @utlxplan.sql
Then I execute:
set autotrace on;
But I got error.
Anybody know what's wrong with it. Help please.