:
完成,select *,得到表(dbms_xplan.display_cursor(空,空,' ALLSTATS 去年'));
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID bv300dy9b7gyn child number 0
-------------------------------------
select /* +, first_rows */, e.ename, e.job, d.dname 得到emp e, dept d 在那里
e.deptno=d.deptno 以及e.sal<2000年
Plan hash 值:3625962092
-----------------------------------------------------------------------------------------------------------
| |,Id 还以为;Operation ,,,,,, |, Name ,,, |, Starts |, E-Rows |, A-Rows |,,, A-Time ,, |, Buffers |, Reads |
-----------------------------------------------------------------------------------------------------------
|,,,0,|,SELECT STATEMENT ,,,,, |,,,,,,,, |,,,,,, 1, |,, |, 7, | 00:00:00.14 |,,,,,, 18, |, 8 |
|,,,1,|,,NESTED LOOPS ,,,,,, |,,,,,,,, |,,,,,, 1, |,,,,,, 4, |, 7, | 00:00:00.14 |,,,,,, 18, |, 8 |
|,,,2,|,,,NESTED LOOPS ,,,,,, |,,,,,,,, |,,,,,, 1, |,,,,,, 4, |, 7, | 00:00:00.14 |,,,,,, 11, |, 7 |
| *,,3,|,,,,TABLE ACCESS FULL ,,,,, |, EMP ,,,, |,,,,,, 1, |,,,,,, 4, |, 7, | 00:00:00.12 |,,,,,,, 7, |, 6 |
| *,,4,|,,,,INDEX UNIQUE SCAN ,,,,, |, PK_DEPT |,,,,,, 7, |,,,,,, 1, |, 7, | 00:00:00.01 |,,,,,,, 4, |, 1 |
|,,,5,|,,,TABLE ACCESS BY INDEX ROWID |, DEPT ,,, |,,,,,, 7, |,,,,,, 1, |, 7, | 00:00:00.01 |,,,,,,, 7, |, 1 |
-----------------------------------------------------------------------------------------------------------
Predicate 方式;(identified by operation id):
---------------------------------------------------
,,3,安康;过滤器(“E”。“萨尔”& lt; 2000)
,,4,的;访问(“E”。“DEPTNO”=癉”“DEPTNO”)。
24,rows 选择。
,
,
,
,
,
,
,
,附:查询访问表所有字段的sql信息:
WITH t
,(SELECT a.object_name “表名”,
,,,,,,,,a.sql_id,
,,,,,,,,c.sql_text,
,,,,,,,,c.executions,
,,,,,,,,(regexp_count (prjection,,,,, 1), +, - 1),/, 2,“访问列数”,
,,,,,,,,计数(b.column_name),“总列数”,
,,,,,,,,d.bytes /, 1024,/, 1024,“表体积_MB”
,,,得到v $ sql_plan ,, dba_tab_columns b, v $ sql c, dba_segments d
,,WHERE a.object_owner =b.owner
,,,,以及a.object_name =b.table_name
,,,,以及a.object_owner =,“终点”
,,,,以及a.sql_id =c.sql_id
,,,,以及a.object_name =d.segment_name
,,,,以及a.object_owner =d.owner
,才能GROUP BY (regexp_count (prjection,,,,, 1), +, - 1),/, 2, a.object_name,
null
null
null
null
null
