Database Tuning (MOSC)

MOSC Banner

11gR2 : How to disable only one QUERY in a session when parallel_degree_policy=AUTO

edited Sep 22, 2013 10:13PM in Database Tuning (MOSC) 6 commentsAnswered
Hi ,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center