EXPLAIN PLAN VERSUS THE TRACE FILE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: EXPLAIN PLAN VERSUS THE TRACE FILE

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    Hi all,

    what is the difference between the Explain Plan and SQL trace????

    thanks

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    SQL Trace gives you more information than explain plan. It's especially useful when you want to get plan information for batch processes or stored procedures since you can dump out the whole process in one go, rather than picking out individual DML and explaining it.

    The only point of note is you must run a statement to get an SQL trace. The explain plan does not require the statement to be run.

    See:

    http://www.oracle-base.com/articles/...nPlanUsage.php
    http://www.oracle-base.com/articles/...dTkprof10g.php
    http://www.oracle-base.com/articles/9i/DBMS_XPLAN.php

    Cheers
    Last edited by TimHall; 12-13-2011 at 05:02 AM.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width