Parallel Query Tuning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Parallel Query Tuning

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Any tips, tricks, or words of wisdom out there regarding the tuning of Parallel Queries? Besides just setting parallel_automatic_tuning = true and hoping for the best .

    - Chris

  2. #2
    Join Date
    Apr 2001
    Location
    CT, USA
    Posts
    2
    SQL hint like this: /*+PARALLEL (TABLE_NAME, 2) */ ...

    For example:

    SELECT /*+PARALLEL (TABLE_NAME, 2) */ TABLE_FIELD1 FROM TABLE_NAME

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    There's a good discussion in Oracle Performance Tuning Tips & Techniques by Richard Niemiec if somebody in your company has it. (Chapter 11)
    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."

  4. #4
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Thanks Jeff.

    Ironically enough - that is one of the 2 Oracle books that I *do* own. I'll have to check it out when I get home. To tell you the truth, though, I only got but so far in that book. His section on SQL Tuning completely turned me off. His ideas and methodologies on that subject were so old-school and antiquated that I couldn't read more than a few pages at a time without my blood pressure rising to undesirable levels . I'll give him the benefit of the doubt on this topic, however, since it's coming from you .

    Thanks for the tip,

    - Chris

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by chrisrlong
    Thanks Jeff.

    Ironically enough - that is one of the 2 Oracle books that I *do* own. I'll have to check it out when I get home. To tell you the truth, though, I only got but so far in that book. His section on SQL Tuning completely turned me off. His ideas and methodologies on that subject were so old-school and antiquated that I couldn't read more than a few pages at a time without my blood pressure rising to undesirable levels . I'll give him the benefit of the doubt on this topic, however, since it's coming from you .

    Thanks for the tip,

    - Chris
    I agree. You have to know enough to weed out the O7 stuff from the newer stuff. That's what happens when you keep "upgrading" your book I guess...
    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."

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Hearing this from Chris it comes like a music to my ears . Rich Niemiec's book was the only book about Oracle so far that realy made me *very* upset when I read it last summer. There is so many missconceptions, doubtfull "facts" and rull of thumbs and so many wrong conclusions that I started to make a note of each of the things that I thought were wrong or doubtfull. At the end it came out as a 12 page long MS Word document (together with my explanations of why I thing they are wrong) and I've sent it to Rich. I got an answer that he is bussy and at the moment but that he will study my remarks carefully later and let me know about his opinion on my comments. I never got that second mail, but I've talk to Rich at last year's EOUG meeting in Madrid. He said that he aggrees with some of my observation, yet disaggree strongly with some (most?) of them, but he never took the time to send me any serious answer to my remarks on his book.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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