The default value is NULL, which displays the most recent execution plan in the PLAN_TABLE. statement_id - Statement id of the plan to be displayed.table_name - Name of the PLAN_TABLE, default value 'PLAN_TABLE'.The DBMS_XPLAN.DISPLAY function can accept 3 optional parameters: Predicate Information (identified by operation id): | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Next we use the DBMS_XPLAN.DISPLAY function to display the execution plan. The DISPLAY function allows us to display the execution plan stored in the plan table. GRANT ALL ON sys.plan_table TO public DISPLAY Function If it is not already present create the SCOTT schema.Ĭonn sys/password as a PLAN_TABLE if it does not already exist.Ĭonn sys/password as PUBLIC SYNONYM plan_table FOR sys.plan_table
SQL trace, 10046, trcsess and tkprof in Oracle.Real-Time SQL Monitoring using DBMS_SQLTUNE.DBMS_XPLAN : Compare Execution Plans in Oracle Database 19c and 21c (COMPARE_PLANS, COMPARE_CURSORS and COMPARE_EXPLAIN).Subsequent database versions have increased the functionality of the package. The "utlxpls.sql" script or custom queries of the plan table. It was introduced in Oracle 9i as a replacement for The DBMS_XPLAN package is used to format the output of an explain plan. Home » Articles » 9i » Here DBMS_XPLAN : Display Execution Plans
0 kommentar(er)
