sqlplus的autotrace的设置-体系架构

        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 网管u家www.bitscn.net
        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;