HomeНаука и техникаRelated VideosMore From: Oracle Learning Library

Why Use Parallel Processing?

53 ratings | 14225 views
This video compares the use of parallel and serial processing for the same SQL query. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Html code for embedding videos on your blog
Text Comments (8)
Raja Palani (1 year ago)
Will it work on oracle standard edition 12c?
Jamie T (2 years ago)
can you create a tutorial on how to setup a parallel database
Nasim Chaklader (3 years ago)
can u explain how really works?
+Nasim Chaklader Hello. Please see this demo series that offers more information. https://apexapps.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:5583,29 Thank you. Oracle Learning
anshu anand (4 years ago)
Laeeq Ahmed (6 years ago)
Also I/O, the biggest issue.
GaryL3803 (7 years ago)
The vast improvement is indeed greatly exaggerated by this test. This is PROBABLY due to the effect of the 1st query running using a SAN that cached the I/O for the table on the 1st run. The second execution is reading out of the SAN cache. Probaly would have been faster if executed serially the second time.
FN LN (4 months ago)
he did disconnect from the database before running it the second time.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.