Useing Analyze & Explain Plain
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Useing Analyze & Explain Plain

  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    72

    Useing Analyze & Explain Plain

    Hai..

    Any one help me to use Analyze and Explain Plain...

    I don't know how to use these Options...

    Thanks in Advance

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    RTM
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    your so unhelpfull abhaysk

    Analyze - it analyzes stuff
    Explain Plain - explains stuff

    simple eh?

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by mrchrispy
    your so unhelpfull abhaysk
    am always so
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    histogram is the metadata.
    ie, data (distribution) about your tables, columns and indexes.

    when you analyze these objects your metadata gets updated.

    oracle builds its execution plan for SQLs that
    operate on these objects based on this metadata.

    explain plan shows you the execution plan.

    if the data distribution has changed considerably,
    you need to analyze.

    all the best!

  6. #6
    Join Date
    Mar 2004
    Location
    India
    Posts
    72
    Thanks rajabalachandra..

    Can u give the syntax please...

  7. #7
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    that's a RTFM is ever there was one, just look up analyze in the manual ffs.

    oh and remember to eat a couple of times a day and go to the toilet.....or will you need help with that?

  8. #8
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Hmmm... Thomas Kyte advices to use "DBMS_STATS" in stead of "ANALYZE"...

    You can use "desc dbms_stats" to find the parameters...
    for more info : http://tahiti.oracle.com
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by efrijters
    Hmmm... Thomas Kyte advices to use "DBMS_STATS" in stead of "ANALYZE"...
    9.x has some bugs with DBMS_STATS
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  10. #10
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by abhaysk
    9.x has some bugs with DBMS_STATS
    A rather sweeping statement that -- do you mean it shouldn't be used in 9i?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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