当前位置导航:炫浪网>>网络学院>>编程开发>>Oracle教程

sqlplus的autotrace的设置

        autotrace是SQL*PLUS中的一个工具,可以显示所执行查询的解释计划(explain plan)以及所用的资源。

        (如果是其它版本的话可能要先执行/rdbms/admin/utlxplan.sql;再create public synonym plan_table for plan_table;)

        grant all on plan_table to public;

        运行sqlplus/admin/plustrace.sql;内容如下:

        Copyright (c) Oracle Corporation 1995, 2002. All Rights Reserved.
        NAME
        plustrce.sql
        DESCRIPTION
        Creates a role with access to Dynamic Performance Tables
        for the SQL*Plus SET AUTOTRACE ... STATISTICS command.
        After this script has been run, each user requiring access to
        the AUTOTRACE feature should be granted the PLUSTRACE role by
        the DBA.
        USAGE
        sqlplus "/ as sysdba" @plustrce
        Catalog.sql must have been run before this file is run.
        This file must be run while connected to a DBA schema.
        set echo on
        drop role plustrace;
        create role plustrace;
        grant select on v_$sesstat to plustrace;
        grant select on v_$statname to plustrace;
        grant select on v_$mystat to plustrace;
        grant plustrace to dba with admin option;
        set echo off
        再执行:
        grant plustrace to public;
        set autotrace off;
        set autotrace on explain;
        set autotrace on statistics;
        set autotrace on;

相关内容
赞助商链接