Database DataWarehousing (MOSC)

MOSC Banner

What is the best strategy for using parallelism feature in 10gR2( IBM)

edited Apr 8, 2010 1:34AM in Database DataWarehousing (MOSC) 3 commentsAnswered
Environment Database 10gR2 on IBM )            
  • cpu_count                      =12                                                                                                                                                                      
  • parallel_threads_per_cpu =2                                                                                                                                                                       
  • so Degree of parallelism (DOP) = 2x12 = 24

<!-- /* Font Definitions */ @font-face {font-family:Courier; panose-1:2 7 4 9 2 2 5 2 4 4; mso-font-alt:"Courier New"; mso-font-charset:0; mso-generic-font-family:modern; mso-font-format:other; mso-font-pitch:fixed; mso-font-signature:3 0 0 0 1 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 70.85pt 70.85pt 70.85pt; mso-header-margin:35.4pt; mso-footer-margin:35.4pt; mso-paper-source:0;} div.Section1 {page:Section1;} -->

SQL > show parameter parallel

fast_start_parallel_rollback         string   LOW

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center