oracle 配置环境

一、 设置SQL*PLUS的AUTOTRACE

@?/rdbms/admin/utlxplan

create public synonym plan_table for plan_table;

grant all on plan_table to public;

创建并授予PLUSTRACE角色

@?/sqlplus/admin/plustrce

grant plustrace to public;

-------------------------------------------------------

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

--------------------------------------------------------

通过设置AUTOTRACE系统变量可以控制报告

set auttotrace off;

set auttotrace on explan;   显示优化器的执行路径

set auttotrace on statistics 显示统计信息

set auttotrace on;

set auttotrace traceonly;  不显示用户的执行结果

二、 配置statspack

@?/rdbms/admin/spcreate