What is Oracle Parallel Query ?
When Oracle has to perform a legitimate, large, full-table scan, Oracle Paralle Query can make a dramatic difference in the response time. Using OPQ, Oracle partitions the table into logical chunks.
Once the table has been partitioned into pieces, Oracle fires off parallel query slaves (sometimes called factotum processes), and each slave simultaneously reads a piece of the large table. Upon completion of all slave processes,
Oracle passes the results back to a parallel query coordinator, which will reassemble the data, perform a sort if required, and return the results back to the end user. Oracle Parallel Query can give you almost infinite scalability, so very large full-table scans that used to take many minutes can now be completed with sub-second response times.
Requriement to Enable parallel query.
1.SMP server with multiple CPUs.
2.Enable parallel_max_servers instance parameter.
What is Symmetric Multiprocessing (SMP)?
Symmetric Multiprocessing, or SMP, is the term used to describe a computer system that is equipped with more than one processor, and also equipped with an operating system capable of distributing load evenly over those processors.
How this can benifit Cameo Database
Parallel Execution of the schema stats.
Parallel load
1.Parallel Execution for a full table scan.
Examples of Parallel Query:
Parallel Query Syntax:
Create table Syntax:
create table c_district_backup parallel (degree 3)
as
select *
from c_district
/
