dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Explain Plan

  1. #1
    Join Date
    May 2002
    Posts
    163
    Hello,

    I need 2 helps. I am presently in a position where I can not access Oracle documents.

    1. After applying SET AUTOTRACE ON can I disable the display of the query? What I mean is , I just need the explain plan .... Not the Data.

    If yes, How???????????


    2. Does anybody has the good explain plan script, which will read from the plan table and properly display the explain plan in formated way?

    Can anybody please send me accross the same to viswassumit412@yahoo.com.

    I will appreciate your help.

    Thanks and Regards
    Vis
    Nwcomer
    Student

  2. #2
    Join Date
    Oct 2000
    Posts
    467
    set autotrace traceonly explain



    Vinit

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    beware of oracle bug 704057 when using
    set autotrace traceonly explain on anything less than a 817 client

    If you turn this on and execute dml it *may* also execute the statement and not just produce the explain plan.

    This has been fixed in 817 client
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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




×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.