Oracle Convert Select Union All to Parallel Select
<p>I don't know if it's possible or not in terms of oracle execution architecture so I just wanted to ask.<br>
I have a table that stores some schemas names (eg. sch1, sch2, sch3 ) and I am creating a union all query dynamically within a cursor using this table.<br>
so eg. my query looks like this : </p>

<pre><code>select col1, col2 from sch1.tab1
union all 
select col1, col2 from sch2.tab1
union all 
select col1, col2 from sch3.tab1
</code></pre>

<p>eg. If I Select a table with parallel hint like   </p>

<pre><code>select /*+ parallel(tab,4)*/ * from tab
</code></pre>

<p>if I am not mistaken it will opens 4 sessions and process it in one execution.<br>
so is it possible to query all tables in this approach?  </p>