ITPub博客

首页 > Linux操作系统 > Linux操作系统 > set autotrace traceonly无法使用

set autotrace traceonly无法使用

原创 Linux操作系统 作者:myownstars 时间:2011-08-29 16:04:08 0 删除 编辑

SQL> set autotrace traceonly
SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
SQL> conn / as sysdba
Connected.
SQL> @$ORACLE_HOME/rdbms/admin/utlxplan

Table created.
SQL> create role plustrace;

Role created.

SQL> grant select on v_$sesstat to plustrace;

Grant succeeded.

SQL> grant select on v_$statname to plustrace;

Grant succeeded.

SQL> grant select on v_$mystat to plustrace;

Grant succeeded.

SQL> grant plustrace to dba with admin option;

Grant succeeded.

SQL> set echo off
SQL> grant plustrace to public;

Grant succeeded.

SQL> conn justin/justin
Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> set autotrace traceonly
SQL> set linesize 300 pagesize 300

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

请登录后发表评论 登录
全部评论

注册时间:2010-03-18

  • 博文量
    375
  • 访问量
    3164768