- 浏览: 317168 次
- 性别:
- 来自: 广州
文章分类
- 全部博客 (224)
- Java (34)
- Test (3)
- Linux/Unix (32)
- Windows (8)
- Oracle (78)
- Oracle Backup & Recovery (3)
- SqlServer (1)
- Database (3)
- Open Source (2)
- Server Management (1)
- Apache ActiveMQ (1)
- IBM WebSphere MQ (7)
- IBM WAS (15)
- 其它 (11)
- UML (1)
- Tools (1)
- Reference (0)
- Spring (11)
- Hibernate (5)
- VBScript (3)
- Network (1)
- Securities (2)
- Maven (6)
- logging (2)
- Web (1)
- AWS (3)
最新评论
1. 创建plan
EXPLAIN PLAN SET statement_id = 'Plan_ID' FOR
SELECT * FROM Table_Name;
2. 查询结果
方法1: SELECT * FROM table (DBMS_XPLAN.DISPLAY);
方法2: SELECT * FROM PLAN_TABLE WHERE STATEMENT_ID = 'Plan_ID';
发表评论
-
DBCP连接池介绍
2018-09-12 13:17 419目前 DBCP 有两个版本分别是 1.3 和 1.4。 D ... -
Update两表(多表)关联update -- 被修改值由另一个表运算而来
2016-10-22 00:50 901UPDATE trd_sess A SET A.r ... -
GV$LOCKED_OBJECT
2016-09-27 01:21 1031SELECT OBJECT_NAME, MACHINE, ... -
v$sql v$sqlarea v$sqltext v$sql_plan
2015-08-13 16:55 755v$sqltext存储的是完整的SQL,SQL被分割 SQ ... -
Oracle performance tuning
2015-08-10 17:47 559db block get+consistent gets ... -
JDBC driver 的类型 Type 1 Type2 Type3 Type4
2014-06-12 16:01 811在网上下载jdbc驱动程序,常看见type4字样,开始以为是 ... -
undo segment behavior
2014-04-04 19:04 734FAQ – Automatic Undo Managemen ... -
Connect to Oracle DB - Java
2014-04-04 15:14 669import java.sql.*; public ... -
Dataguard网络优化调整
2014-03-31 16:02 915Dataguard网络优化调整 Datagu ... -
Production error ORA-01001, ORA-03120, ORA-01460
2014-03-19 20:38 933ORA-01001: invalid cursor OR ... -
Oracle 常见的33个等待事件
2014-03-12 15:42 4000一. 等待事件的相关知识: 1.1 等待事件主要可以 ... -
WBFC on Exadata
2014-02-27 14:57 8251. "Should we turn on Sto ... -
Oracle dump files
2014-02-27 12:58 613audit_file_dest = C:\ ... -
Adaptive Log File Sync
2014-02-26 19:52 1012Adaptive Log File sync was int ... -
ORA-39046: Metadata remap REMAP_TABLESPACE has already been specified.
2014-01-22 16:01 6610Import: Release 10.2.0.4.0 - 6 ... -
EXPDP – ORA-39142: incompatible version number 3.1
2014-01-22 12:25 1595Using EXPDP export a schema in ... -
Oracle 11g Real Time SQL Monitoring
2014-01-20 17:01 737http://kerryosborne.oracle-guy ... -
java.sql.SQLException: ORA-01001: invalid cursor
2013-12-20 13:59 3725There are three parameters tha ... -
ORA-01013 user requested cancel of current operation
2013-12-20 13:34 2291今天我碰到的case就是timeout引起的。 T ... -
Cannot run sqlplus on Linux with EOF
2013-12-20 11:02 791今天碰到个小问题,记下来,在linux上,不可以run fi ...
相关推荐
Oracle中EXPLAIN PLAN的使用技巧
oracle执行计划,oracle explain plan,在ORACLE数据库中,需要对SQL语句进行优化的话需要知道其执行计划,从而针对性的进行调整.ORACLE的执行计划的获得有几种方法,下面就来总结下
NULL 博文链接:https://babydeed.iteye.com/blog/1567772
explain plan interpreting sql 分析
NULL 博文链接:https://qidaoxp.iteye.com/blog/758552
详细讲解在Oracle中如何使用explain_plan,值得参考和收藏学习。
详细介绍了oracle解释计划的原理,对理解oracle解释计划非常有用。
explain plan set statement_id = &item_id for &sql; select * from table(dbms_xplan.display); 或者: SQL>EXPLAIN PLAN FOR SELECT * FROM EMP; SQL>SELECT plan_table_output FROM TABLE(DBMS_XPLAN....
good material in learning db2 explain plan
explain plan for select ename,job,sal,comm from empcon where (sal-700);--已解释 desc plan_table; col id for 999 col operation for a16 col option for a16 col object_name for a16 Select id,operation,...
explain plan set statement_id = &item_id for &sql; select * from table(dbms_xplan.display); explain plan set statement_id= '测试一 ' for select (这里可以是很复杂的查询) 执行. 然后select * ...
EXPLAIN PLAN是一个很好的分析SQL语句的工具,它可以在不执行SQL的情况下分析语句 通过分析,我们就可以知道ORACLE是怎样连接表,使用什么方式扫描表(索引扫描或全表扫描),以及使用到的索引名称 按照...
1. INTRODUCTION 2. INSTALLATION 2.1 SYSTEM REQUIREMENTS 2.2 WORKSTATION INSTALLAT ION ...5.1 USING THE EXPLAIN PLAN WINDOW 5.2 AUTOMATIC STATISTICS 5.3 THE PL/SQLPROFILER 5.4 SQLTRACE ......
非常容易对SQL语句的分析其执行计划:单击工具栏上的 按钮就可以看到Explain Plan的结果 支持部分SQL*Plus命令,可以方便的执行大量的为SQL*Plus编写的数据库脚本 可以通过SQLab xpert来对当前SQL语句...
1. 预估执行计划 – Explain PlanExplain plan以SQL语句作为输入,得到这条SQL语句的执行计划,并将执行计划输出存储到计划表中。 首先,在你要执行的SQL语句前加explain plan for,此时将生成的执行计划存储到计划...
- plan <sql_id> []: get explain plan of a particular cursor - pxplan <sql_id> : get explain plan of a particular cursor and all connected cursor slave SQL - wplan <sql_id> []: get explain plan with...
<7> 运行命令 "explain plan for SQL" 或按菜单项 "Explain Plan",能快速地显示 SQL 的执行计划; "Export" 按钮或菜单项,能直接将 SELECT 语句结果转化为 INSERT 语句,方便于数据移植、备份等 <8> 运行命令...
截取部分题目如下,有答案: 1. 解释冷备份和热备份的不同点以及各自的优点 2. 你必须利用备份恢复数据库,但是你没有...17. 如何生成explain plan? 18. 如何增加buffer cache的命中率? 19. ORA-01555的应对方法?
query processing,Explain plan,autotrace
SQL> explain plan for alter index idx_policy_id2 rebuild online; Explained SQL> select * from table(dbms_xplan.display); PLAN_TABLE_OUTPUT -----------------------------------------------------...