Don Burleson On Oracle Parallel Query
April 28th, 2004 by Mark Rittman
"One of the latest trends is for systems to have more and more CPUs inside
a single server. Using symmetric multiprocessing (SMP) servers, it is not
uncommon for an Oracle server to have 8, 16, or 32 CPUs, along with many
gigabytes of RAM for the Oracle SGA regions." writes Don Burleson in an
article entitled
"Take Advantage of Multiple CPUs with Oracle Parallel Query" "Oracle has
kept pace with these changes and offers a wealth of facilities to take advantage
of multiple CPUs. Starting with Oracle8i, Oracle implemented parallelism in
virtually every database function, including SQL access (full-table scans),
parallel data manipulation, and parallel recovery. The challenge for Oracle
professionals is to configure their databases to use as many of the CPUs as
possible."
