2012-11-10 - 11-11 11gR2 "ADMINISTRATOR'S GUIDE" page 905 - 1066

 

 

这一章节大部分讲的是分布式数据库的管理以及重点（DATABASE LINK的设置）

 

Analyzing the Execution Plan -- 分析执行计划
Preparing the Database to Store the Plan -- 创建存放执行计划的表
SQL> @UTLXPLAN.SQL

Generating the Execution Plan -- 生成执行计划
EXPLAIN PLAN FOR
SELECT d.dname
FROM dept d
WHERE d.deptno
IN (SELECT deptno
FROM emp@orc2.world
GROUP BY deptno
HAVING COUNT (deptno) >3
)
/

Viewing the Execution Plan -- 查看执行计划
@UTLXPLS.SQL

Executing the utlxpls.sql script displays the execution plan for the SELECT
statement that you specified. The results are formatted as follows:
Plan Table
-------------------------------------------------------------------------------
| Operation | Name | Rows | Bytes| Cost | Pstart| Pstop |
-------------------------------------------------------------------------------
| SELECT STATEMENT | | | | | | |
| NESTED LOOPS | | | | | | |
| VIEW | | | | | | |
| REMOTE | | | | | | |
| TABLE ACCESS BY INDEX RO|DEPT | | | | | |
| INDEX UNIQUE SCAN |PK_DEPT | | | | | |
-------------------------------------------------------------------------------

To view the SQL statement that will be executed at the remote site, execute the
following select statement: -- 查看REMOTE端的执行计划
SELECT OTHER
FROM PLAN_TABLE
WHERE operation = 'REMOTE';
Following is sample output:
SELECT DISTINCT "A1"."DEPTNO" FROM "EMP" "A1"
GROUP BY "A1"."DEPTNO" HAVING COUNT("A1"."DEPTNO")>3