由买买提看人间百态

topics

全部话题 - 话题: autotrace
(共0页)
y**e
发帖数: 13
1
来自主题: Database版 - how to set auto trace in oracle
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.
y********o
发帖数: 2565
2
来自主题: Database版 - 问一个Oralce index的问题
噢,这个我知道,在Oracle里面做:
set autotrace on explain
我可以看到oracle 确实用了lastnameindex:
(共0页)