Explain how to disable Parallel Query

<<Previous   Next>>

Oracle - How to disable Parallel Query posted by Babu Kunwar

Explain how to disable Parallel Query

We disable parallel SQL execution with an ALTER SESSION DISABLE PARALLEL DML | DDL | QUERY statement.

We can do this as follows

• The first thing that we can do is to set parallel_max_server to zero.
• Execute the Query: select /*+ NO_PARALLEL */
• alter table A noparallel; select * from table A;

<<Previous   Next >>