软件测试初学者必读:sqlplus的autotrace的设置

发表于:2009-10-16来源:作者:点击数: 标签:软件测试autotracesqlplus初学者设置
软件 测试 初学者必读:sqlplus的autotrace的设置 sql数据库 关键字:初学者 sqlplus autotrace 设置 autotrace是 SQL *PLUS中的一个工具,可以显示所执行查询的解释计划(explain plan)以及所用的资源。 (如果是其它版本的话可能要先执行/rdbms/admin/utlxpla
软件测试初学者必读:sqlplus的autotrace的设置 sql数据库

关键字:初学者 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 aclearcase/" target="_blank" >ccess 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;

原文转自:http://www.ltesting.net