@%oracle_home\rdmbs\admin\utlexpt1.sql然后
set autotrace on
set autotrace on
解决方案 »
- 动态参数:表名,字段名,filter条件的存储过程
- gnore=y
- 求oracle视频教程包裹怎么安装oracle数据库 和使用oracle教程 有的给个谢谢了!
- 关于sqlplus命令的问题,在线等,急用~~
- sql怎么写
- 如何在一个bat文件中执行一个sql语句?
- 数据更新?
- 在线求教sql简单语句
- 我导入数据的时候出现“不支持要求的字符集转换(从类型31到852)”的错误,请问该怎么办啊?
- win2000的Oracle 9i中 Enterprise Manager Console和rehat linux 7.3的oracle 9i如何连接??
- 狂晕,300分,为什么改变条件的顺序会影响查询结果???
- 用哪个命令来分析SQL语句的执行效率?
2. 运行utlxplan.sql. 建立plan 表 针对特定SQL语句,使用 explain plan set statement_id = 'tst1' into plan_table 运行utlxplp.sql 或 utlxpls.sql察看explain plan
Displays a report on the execution of successful SQL DML statements (SELECT, INSERT, UPDATE or DELETE). The report can include execution statistics and the query execution path.OFF does not display a trace report. ON displays a trace report. TRACEONLY displays a trace report, but does not print query data, if any. EXPLAIN shows the query execution path by performing an EXPLAIN PLAN. STATISTICS displays SQL statement statistics. Information about EXPLAIN PLAN is documented in the Oracle9i SQL Reference manual.Using ON or TRACEONLY with no explicit options defaults to EXPLAIN STATISTICS.The TRACEONLY option may be useful to suppress the query data of large queries. If STATISTICS is specified, SQL*Plus still fetches the query data from the server, however, the data is not displayed.The AUTOTRACE report is printed after the statement has successfully completed.Information about Execution Plans and the statistics is documented in the Oracle9i Database Performance Tuning Guide and Reference manual.When SQL*Plus produces a STATISTICS report, a second connection to the database is automatically created. This connection is closed when the STATISTICS option is set to OFF, or you log out of SQL*Plus.The formatting of your AUTOTRACE report may vary depending on the version of the server to which you are connected and the configuration of the server.AUTOTRACE is not available when FIPS flagging is enabled.See "Tracing Statements" for more information on AUTOTRACE.
参考:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm#1012209