![]() ![]() Query Block Name / Object Alias (identified by operation id):ģ - SEL$1 / - SEL$1 / - SEL$1 / Information (identified by operation id):Ĭolumn Projection Information (identified by operation id):ġ - "E"."EMPNO", "E"."ENAME", "E"."JOB", |* 4 | INDEX UNIQUE SCAN | PK_DEPT | 1 | | 0 (0)| | SELECT * FROM emp e, dept d WHERE e.deptno = d.deptno AND e.ename GRANT SELECT ON v_$sql_plan_statistics_all TO scott įROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(format => 'ADVANCED')) The following example show the advanced output from a query on the SCOTT schema. These additional format options require "STATISTICS_LEVEL=ALL". format - In addition to the setting available for the DISPLAY function, this function also has 'RUNSTATS_LAST' and 'RUNSTATS_TOT' to display the last and total runtime statistics respectively.If not specified, all cursors for the specified SQL_ID are diaplyed. child_number - The child number of the cursor specified by the SQL_ID parameter.If omitted, the last cursor executed by the session is displayed. The SQL_ID as available from the V$SQL and V$SQLAREA views, or from the V$SESSION view using the PREV_SQL_ID column. sql_id - The SQL_ID of the statement in the cursor cache.This information is gathered from the V$SQL_PLAN_STATISTICS_ALL, V$SQL and V$SQL_PLAN views, so the user must have access to these. Rather than displaying an execution plan from the PLAN_TABLE, it displays the actual execution plan used to run a query stored in the cursor cache. In Oracle 10g Release 1 Oracle introduced the DISPLAY_CURSOR function. | 5 | TABLE ACCESS BY INDEX ROWID| DEPT | Check the documentation for your version.įROM TABLE(DBMS_XPLAN.DISPLAY('PLAN_TABLE','TSH','BASIC')) The list of available columns varies depending on the database version and function being called. As a result, the format column can now be a space or comma delimited list. There is also an undocumented 'ADVANCED' setting.įrom Oracle 10g Release 2 onwards the format of the output can be tailored by using the standard list of formats along with keywords that represent columns to including or excluding (prefixed with '-'). Other values include 'BASIC', 'ALL', 'SERIAL'. format - Controls the level of detail displayed, default value 'TYPICAL'. ![]() The default value is NULL, which displays the most recent execution plan in the PLAN_TABLE.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |