11gR2 : How to disable only one QUERY in a session when parallel_degree_policy=AUTO
I have a batch (script) executing many queries in parallel mode (11g) : parallel_degree_policy=AUTO (only QUERY MODE).
I have to disable parallelsim for only one query like (select ...from select ....select ....select ).
Which best method to do this :
1/ Adding hint NO_PARALLEL in each SELECT of the query ?
2/ Adding ALTER SESSION SET parallel_degree_policy='MANUAL' before query and Adding ALTER SESSION SET parallel_degree_policy='AUTO' after th e query ?
3/ Another tip ?
Best regards.
GD.