2. 不借助第三方工具,怎样查看sql的执行计划
; ?# {# o# k8 K" y9 z# qI) 使用Explain Plan,查询PLAN_TABLE; , d9 u% r: Z4 r: {7 S, f
EXPLAIN PLAN : _8 W% D$ I1 K3 I/ l5 g
SET STATEMENT_ID=’QUERY1’
% E+ C, R. o* D. Z" D FOR * ~4 d" b8 }& i/ p; V
SELECT *
0 D+ z; @8 V1 o* v; o) @. k1 h FROM a 4 x% r3 `( e [6 y$ |% e0 \3 n
WHERE aa=1; " M& w5 X' \5 A2 I
SELECT operation, options, object_name, object_type, ID, parent_id 3 l* t& {0 c. t3 I) F: F4 r9 O
FROM plan_table
: V z# o9 B( Z! X$ z2 s+ J6 y& f3 _ WHERE STATEMENT_ID = ’QUERY1’ 5 N: y6 P! y% s5 h. O4 n
ORDER BY ID; ! @0 s$ m/ h9 ?( V4 M) Q
II)SQLPLUS中的SET TRACE 即可看到Execution Plan Statistics
7 n! o: H5 _$ h8 |6 N SET AUTOTRACE ON; |