oracle.rst
changeset 2276 3662cdbd7b64
parent 2275 adb168e2b3a0
child 2277 39da290b29bb
equal deleted inserted replaced
2275:adb168e2b3a0 2276:3662cdbd7b64
   493   select time from plan_table where id = 0;
   493   select time from plan_table where id = 0;
   494 
   494 
   495 .. note::
   495 .. note::
   496    From docs:
   496    From docs:
   497 
   497 
   498      PLAN_TABLE is automatically created as a global temporary table to hold the output of an EXPLAIN
   498      PLAN_TABLE is automatically created as a global temporary table to hold the output of an
   499      PLAN statement for all users. PLAN_TABLE is the default sample output table into which the
   499      EXPLAIN PLAN statement for all users. PLAN_TABLE is the default sample output table into which
   500      EXPLAIN PLAN statement inserts rows describing execution plans.
   500      the EXPLAIN PLAN statement inserts rows describing execution plans.
   501 
   501 
   502 See:
   502 See:
   503 
   503 
   504 http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2113.htm
   504 http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2113.htm
   505   $SQL lists statistics on shared SQL area without the GROUP BY clause.
   505   $SQL lists statistics on shared SQL area without the GROUP BY clause.