Database DataWarehousing (MOSC)

MOSC Banner

parallel hint doesn't start parallel processing

edited Nov 7, 2015 8:50PM in Database DataWarehousing (MOSC) 4 commentsAnswered

Hi,

I am using parallel hint in my SQL but system doesn't generate parallel salves. Do I need to enable any parameter at database level to get parallel processes?

for example if I run below SQL, it doesn't create any slave process.

insert /*+ PARALLEL(a,16)*/ into test a select * from dba_tables;

SQL> show parameter parallel;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

fast_start_parallel_rollback         string      LOW

parallel_adaptive_multi_user         boolean     TRUE

parallel_automatic_tuning            boolean     FALSE

parallel_execution_message_size      integer     2152

parallel_instance_group              string

parallel_max_servers                 integer     135

parallel_min_percent                 integer     0

parallel_min_servers                 integer     0

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