设置安装autotrace

用system执行以下:

@?/rdbms/admin/utlxplan">system@RAC1>@?/rdbms/admin/utlxplan

Table created.

create">system@RAC1>create public synonym plan_table for plan_table;

Synonym created.

grant">system@RAC1>grant all on plan_table to public;

Grant succeeded.

然后以及sys登录

@plustrce">sys@RAC1>@plustrce;

create">sys@RAC1>create role plustrace;

Role created.

sys@RAC1>
grant">sys@RAC1>grant select on v_$sesstat to plustrace;

Grant succeeded.

grant">sys@RAC1>grant select on v_$statname to plustrace;

Grant succeeded.

grant">sys@RAC1>grant select on v_$mystat to plustrace;

Grant succeeded.

grant">sys@RAC1>grant plustrace to dba with admin option;

Grant succeeded.

sys@RAC1>
set">sys@RAC1>set echo off

grant">sys@RAC1>grant plustrace to public;

Grant succeeded.

这样所有的用户都可以使用autotrace了.

conn">sys@RAC1>conn hr/hr
Connected.
set">hr@RAC1>set autot on;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/104152/viewspace-139953/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/104152/viewspace-139953/