With the push
towards large SMNP Oracle server with 8, 16 or 32 CPU’s, Oracle
professionals need to be aware of the types of parallelism that they
can do within Oracle, Oracle parallel query is back, big time, and
understanding how Oracle can use OPQ to perform large-table
full-table scans is critical.
http://www.dba-oracle.com/t_opq_parallel_query.htm
Because of RAID
striping (RAID 10, Stripe and mirror everywhere) the number of
processors has become the primary factors in setting the degree of
parallelism for large-table full-table scans:
http://www.dba-oracle.com/art_builder_opq_cpu.htm
Oracle parallel
query is back, big time, and understanding how Oracle can use OPQ to
perform large-table full-table scans is critical.
*************************
Do animals have standards for good
manners?
I have always
suspected that there are rules of etiquette for house pets. See if
you agree:
http://www.dba-oracle.com/horse_manners.htm
