Cannot SET AUTOTRACE 处理办法
来源:互联网 发布:四驱车奥迪双钻 淘宝 编辑:程序博客网 时间:2024/05/22 06:43
Microsoft Windows [版本 6.1.7601]版权所有 (c) 2009 Microsoft Corporation。保留所有权利。C:\Users\Administrator>sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on 星期日 9月 27 13:18:37 2015Copyright (c) 1982, 2010, Oracle. All rights reserved.SQL> connect sys as sysdba输入口令:已连接。SQL> @?\rdbms\admin\utlxplan表已创建。SQL> create public synonym plan_table for plan_table;create public synonym plan_table for plan_table *第 1 行出现错误:ORA-00955: 名称已由现有对象使用SQL> grant all on plan_table to public;授权成功。SQL> @?\sqlplus\admin\plustrceSQL>SQL> drop role plustrace;drop role plustrace *第 1 行出现错误:ORA-01919: 角色 'PLUSTRACE' 不存在SQL> create role plustrace;角色已创建。SQL>SQL> grant select on v_$sesstat to plustrace;授权成功。SQL> grant select on v_$statname to plustrace;授权成功。SQL> grant select on v_$mystat to plustrace;授权成功。SQL> grant plustrace to dba with admin option;授权成功。SQL>SQL> set echo offSQL> grant plustrace to public;授权成功。SQL> connect aaa/aaa已连接。SQL> set autotrace onSQL> set timing onSQL> set autotrace traceonlySQL> select * from info;已选择6行。已用时间: 00: 00: 00.03执行计划----------------------------------------------------------Plan hash value: 3267820445-----------------------------------------------------------------------| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time-----------------------------------------------------------------------| 0 | SELECT STATEMENT | | 6 | 138 | 3 (0)| 00:00:0| 1 | TABLE ACCESS FULL| INFO | 6 | 138 | 3 (0)| 00:00:0-----------------------------------------------------------------------统计信息---------------------------------------------------------- 1 recursive calls 0 db block gets 8 consistent gets 0 physical reads 0 redo size 863 bytes sent via SQL*Net to client 419 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 6 rows processedSQL>
//////////////////////// 这个解析 。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
通过以下方法可以把Autotrace的权限授予Everyone,如果你需要限制Autotrace权限,可以把对public的授权改为对特定user的授权。D:\oracle\ora92>sqlplus /nologSQL*Plus: Release 9.2.0.1.0 - Production on 星期二 6月 3 15:16:03 2003Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> connect sys as sysdba请输入口令:已连接。SQL> @?\rdbms\admin\utlxplan表已创建。SQL> create public synonym plan_table for plan_table;同义词已创建。SQL> grant all on plan_table to public ;授权成功。SQL> @?\sqlplus\admin\plustrceSQL>SQL> drop role plustrace;drop role plustrace*ERROR 位于第 1 行:ORA-01919: 角色'PLUSTRACE'不存在SQL> create role plustrace;角色已创建SQL>SQL> grant select on v_$sesstat to plustrace;授权成功。SQL> grant select on v_$statname to plustrace;授权成功。SQL> grant select on v_$session to plustrace;授权成功。SQL> grant plustrace to dba with admin option;授权成功。SQL>SQL> set echo off DBA用户首先被授予了plustrace角色,然后我们可以把plustrace授予public这样所有用户都将拥有plustrace角色的权限. SQL> grant plustrace to public ;授权成功。然后我们就可以使用AutoTrace的功能了. SQL> connect eqsp/eqsp已连接。SQL> set autotrace onSQL> set timing onSQL> 关于Autotrace几个常用选项的说明:SET AUTOTRACE OFF ---------------- 不生成AUTOTRACE 报告,这是缺省模式SET AUTOTRACE ON EXPLAIN ------ AUTOTRACE只显示优化器执行路径报告 SET AUTOTRACE ON STATISTICS -- 只显示执行统计信息SET AUTOTRACE ON ----------------- 包含执行计划和统计信息 SET AUTOTRACE TRACEONLY ------ 同set autotrace on,但是不显示查询输出 SQL> set autotrace traceonlySQL> select table_name from user_tables;已选择98行。已用时间: 00: 00: 00.04Execution Plan----------------------------------------------------------0 SELECT STATEMENT Optimizer=CHOOSE1 0 NESTED LOOPS2 1 NESTED LOOPS (OUTER)3 2 NESTED LOOPS (OUTER)4 3 NESTED LOOPS (OUTER)5 4 NESTED LOOPS (OUTER)6 5 NESTED LOOPS7 6 TABLE ACCESS (BY INDEX ROWID) OF 'OBJ$'8 7 INDEX (RANGE SCAN) OF 'I_OBJ2' (UNIQUE)9 6 TABLE ACCESS (CLUSTER) OF 'TAB$'10 9 INDEX (UNIQUE SCAN) OF 'I_OBJ#' (NON-UNIQUE)11 5 TABLE ACCESS (BY INDEX ROWID) OF 'OBJ$'12 11 INDEX (UNIQUE SCAN) OF 'I_OBJ1' (UNIQUE)13 4 INDEX (UNIQUE SCAN) OF 'I_OBJ1' (UNIQUE)14 3 TABLE ACCESS (CLUSTER) OF 'USER$'15 14 INDEX (UNIQUE SCAN) OF 'I_USER#' (NON-UNIQUE)16 2 TABLE ACCESS (CLUSTER) OF 'SEG$'17 16 INDEX (UNIQUE SCAN) OF 'I_FILE#_BLOCK#' (NON-UNIQUE)18 1 TABLE ACCESS (CLUSTER) OF 'TS$'19 18 INDEX (UNIQUE SCAN) OF 'I_TS#' (NON-UNIQUE) Statistics----------------------------------------------------------0 recursive calls0 db block gets1389 consistent gets0 physical reads0 redo size2528 bytes sent via SQL*Net to client569 bytes received via SQL*Net from client8 SQL*Net roundtrips to/from client0 sorts (memory)0 sorts (disk)98 rows processedSQL>
0 0
- Cannot SET AUTOTRACE 处理办法
- cannot set autotrace
- Cannot set autotrace
- cannot SET AUTOTRACE问题解决
- oracle,Cannot SET AUTOTRACE解决问题
- oracle,Cannot SET AUTOTRACE解决问题
- Oracle11g Cannot SET AUTOTRACE解决办法
- 输入set autotrace on 报cannot set autotrace 错误
- set autotrace on 报cannot set autotrace错误
- 在sqlplus中执行set autotrace on 报cannot set autotrace 错误解决方法
- SET AUTOTRACE
- SET AUTOTRACE
- plsqldeveloper命令行Cannot SET AUTOTRACE 开启执行计划失败
- set autotrace 时SP2-0618和_SP2-0611错误处理
- set autotrace on
- oracle set autotrace
- set autotrace on设置
- ORACLE set autotrace
- ubuntu 14.04桌面显示快捷方式
- 装饰装修企业痛点与分析-收款问题
- 剑指 offer:从上到下打印二叉树(层序遍历)
- iOS9友盟微信分享
- Servlet、JSP学习总结
- Cannot SET AUTOTRACE 处理办法
- 第一个PHP程序——Hello World
- iOS提交应用至APP Store流程
- D3D动画相关接口理解
- SSH整合(二)——利用Spring来装配Action类
- 【c++ templates读书笔记】【4】技巧性基础知识
- 移动构造-C++11
- JavaScript高级程序设计之面向对象的程序设计之创建对象之 构造函数模式第6.2.2讲笔记
- 软件测试基础知识点整理