title: How to get the Number of CPU to be used in Parallelism in execute dbms_mview.refresh
body: <p>I'm using Oracle 10g 10.2.0.4 version.</p>
  
  <p>I want to refresh my Materialized View in fast method with parallelism.</p>
  
  <p>for the below type of CPU what will be the recommended number of Parallel CPU to be used ?</p>
  
  <p>execute dbms_mview.refresh('XXARG_ACC_ANALYSIS',method=>'f','No.of CPU');</p>
  
  <pre><code>16:54:33 SQL&gt; show parameter cpu;
  
  NAME                                 TYPE                              VALUE
  ------------------------------------ --------------------------------- ------------------------------
  cpu_count                            integer                           8
  parallel_threads_per_cpu             integer                           2
  </code></pre>