Oracle Parallel Hint Load

[avastani]

I am using SQL SELECT /* + parallel */  * FROM user.bigtable along with the SET StripComments = 0; before the select, however, the performance on my extract is still no different than without in v11.2SR5.

The table has 20M rows and 300 columns

Has anyone else faced the same problem? Any resolutions to it? thanks in advance for your replies.

[maxgro · Accepted solution]

Hi

remove the space between / and +

SELECT /*+ .........

I just tried on a table

with space the execution isn't parallel

without space is parallel

[avastani]

Bummer, thanks! Details Details...

[Veppvepp]

All,

I am using  Oracle Odbc Connector Package 5.12.0 and tried using suggested options like below but still not able to enable Parallel in the Oracle. Could you please let me know what else I should do? 

1) --+ PARALLEL

2) /*+PARALLEL*/

3) /*+PARALLEL(5)*/

Note : While using OLEDB connection, everything works but we don't want it in OLEDB due to project reasons.

Why is it not working or Oracle Connector?