parallel dml (insert) DOP
Hi,
I used below hints for parallel insert (insert as select * from ), both the cases it used 2 parallel process, one for insert and other for select.
/*+parallel(<table_name>,10) nologging*/
/*+parallel(<table_name>,2) nologging*/
Can you please suggest, how this DOP was determined? I mean, what parameters/hints take precedence over others? What is the order of preference oracle takes while deciding DOP?
Thanks,