SQL>select/*+ gather_plan_statistics*/*--注意此处增加了提示gather_plan_statistics并且该语句被执行02.2fromemp e,dept d03.3wheree.deptno=d.deptno04.4ande.ename='SMITH';05.06.7369SMITH CLERK790217-DEC-808002020RESEARCH DALLAS
SET DEF ON TERM OFF ECHO ON FEED OFF VER OFF HEA ON LIN 2000 PAGES 100 LONG 8000000 LONGC 800000 TRIMS ON TI OFF TIMI OFF SERVEROUT ON SIZE 1000000 NUM 20 SQLP SQL>; SET SERVEROUT ON SIZE UNL; REM REM Created according to coe_load_sql_baseline.sql and MOS note 789888.1 2013/06...
SQLSET_NAME SQLSET_OWNER SQL_ID PLAN_HASH_VALUE--- --- --- ---SS_089dbukv1aanh_1388734953 GAVIN 089dbukv1aanh1388734953Plans Loaded:1sys_sql_handle: "SYS_SQL_70445f05461a3cd3" sys_plan_name: "SQL_PLAN_70j2z0p31ng6m125daea2"1plan(s) modified description: "SQL_ID: 089DBUKV1AAN...
15.16.SQL>setlinesize18017.SQL>setpagesize018.SQL>select*fromtable(dbms_xplan.display(null,null,'advanced'));--使用dbms_xplan.display函数获得语句的执行计划19.Planhash value:351108634--SQL语句的哈希植20.21.--- /*执行计划部分*/22.|Id|Operation|Name|Rows|Bytes|Cost (%CPU)|Time|23.---...
for x in (select p.plan_table_output from table(dbms_xplan.display_cursor(null, null, 'advanced -bytes -PROJECTION allstats last')) p) loop dbms_output.put_line(x.plan_table_output); end loop; rollback; end; / 两种窗口: 1、SQL窗口的,执行SQL后只能去output查看; ...
在PL/SQL Developer中写好一段SQL代码后,按F5,PL/SQL Developer会自动打开执行计划窗口,显示该SQL的执行计划。 Step2. 查看总COST,获得资源耗费的总体印象 一般而言,执行计划第一行所对应的COST(即成本耗费)值,反应了运行这段SQL的总体估计成本,单看这个总成本没有实际意义, ...
STV_CURSOR_CONFIGURATION STV_DB_ISOLATION_LEVEL STV_EXEC_STATE STV_INFLIGHT STV_LOAD_STATE STV_LOCKS STV_ML_MODEL_INFO STV_MV_DEPS STV_MV_INFO STV_NODE_STORAGE_CAPACITY STV_PARTITIONS STV_QUERY_METRICS STV_RECENTS STV_SESSIONS STV_SLICES STV_STARTUP_RECOVERY_STATE STV_TBL_PERM STV_TBL_TRANS...
図 4:BASIC 形式を使用した,SQL カーソル・キャッシュにアクセスする実行計画 DBMS_XPLAN.DISPLAY_CURSOR によって引き渡される引数は以下のとおりです. • SQL ID(デフォルトの NULL は,このセッションで実行された最後の SQL 文を意味します), • 子番号(デフォルトは 0 です), ...
Figure 4: Execution plan accessing the SQL cursor cache, using the basic format The arguments accepted by DBMS_XPLAN.DISPLAY_CURSOR are: SQL ID (default null, means the last SQL statement executed in this session), child number (default 0), format, controls the amount of ...
1108 Amount of time spent during optimization, in seconds. 1110 Amount of time spent creating the cursor (open data path), in seconds. 1112 Total time for the SQL statement, in milliseconds. 1114 Total time for the SQL statement, in microseconds. 1120 Statement OPEN time, in milliseconds. ...