'explain plan'에 해당되는 글 2건

  1. 2018.01.20 oracle tune
  2. 2018.01.20 oracle explain plan simple example

oracle tune

computer programming 2018. 1. 20. 01:27

https://oracle-base.com/articles/8i/explain-plan-usage


https://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements006.htm#SQLRF51098


https://oracle-base.com/articles/9i/dbms_xplan



https://oracle-base.com/articles/11g/real-time-sql-monitoring-11gr1





select /*+MONITOR*/ from dual;


Posted by stekilove
,
EXPLAIN PLAN
   SET STATEMENT_ID = 'st1'
   INTO my_plan_table
 FOR
SELECT last_name FROM employees;
SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());

SELECT PLAN_TABLE_OUTPUT 
  FROM TABLE(DBMS_XPLAN.DISPLAY('MY_PLAN_TABLE', 'st1','TYPICAL'));


https://docs.oracle.com/cd/B28359_01/server.111/b28274/ex_plan.htm#i16938


http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-explain-the-explain-plan-052011-393674.pdf




https://blogs.oracle.com/sql/how-to-create-an-execution-plan


Posted by stekilove
,