• Why Use Parallel Processing?

    This demonstration compares the use of parallel and serial processing for the same SQL query. This demonstration is associated with lessons 2 and 3 of the Oracle University seminar: Parallel Processing in Oracle 11g.

    Duration: 3.5 minutes

    Release Date: 07-JUN-2011

Embed You Tube Videos

Reviews (6)

  • 12 years ago
    <p> It is all because of caches and statistics.</p>
    • 12.5 years ago
      <p> It is almost impossible to reduce query responce time from 75  to 2 seconds with 8 parallel processes. Even if every slave  process would read data blocks as fast as single server process the responce time can be aboute 8 times less (not 30 times). I think the reason of such expressive result is just file system cache. To get the accurate result we should use direct reads (ASM, raw devices) or compare the responce time of the second non-parallel query execution (after restarting database or flushing buffer cache).</p>
      • 12.6 years ago
        <p> Good Demo.................!</p>
        • 12.6 years ago
          <p> short & sweet demo.</p>
          • 13 years ago
            • 13.1 years ago
              This demo is a brief and clear demonstration of parallel query processing in 11g.a