Alert Message

 

We're retiring Oracle Learning Library by the end of 2025.

Explore tutorials and labs on docs.oracle.com/learn or access free learning content on the Oracle Learning YouTube channel.
For product documentation, visit Oracle Help Center.

Breadcrumb

  • 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.9 years ago
    a.nijat
    <p> It is all because of caches and statistics.</p>
    • 13.4 years ago
      roliynichenko
      <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>
      • 13.5 years ago
        ahmed_farouk1
        <p> Good Demo.................!</p>
        • 13.5 years ago
          forashish
          <p> short & sweet demo.</p>
          • 13.9 years ago
            scarlson
            -
            • 14 years ago
              davidbd
              This demo is a brief and clear demonstration of parallel query processing in 11g.a

              Buttons