When is parallelism not used by optimizer - but defined?

  • From: Bernhard de Cock Buning <bdcbuning@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 14 Nov 2023 19:01:19 +0100

Hello all,

One of the possibilities is to execute workloads in parallel, But now I am 
looking for input when parallelism will not work. 
Especially in the relation to the oracle optimizer, when does the optimiser to 
decide when not to perform a statement in parallel although parallelisme is 
defined.

I would like to make a "list"  of when not and use this in performance cases.
All input is useful, 


Thanks
Kind regards,
Bernhard

Other related posts: