When is parallelism not used by optimizer - but defined?
From: Bernhard de Cock Buning <bdcbuning_at_grid-it.nl>
Date: Tue, 14 Nov 2023 19:01:19 +0100
Message-Id: <8F8FF179-CF3C-4E3A-854E-BD6356808064_at_grid-it.nl>
Hello all,
Kind regards,
Bernhard
Date: Tue, 14 Nov 2023 19:01:19 +0100
Message-Id: <8F8FF179-CF3C-4E3A-854E-BD6356808064_at_grid-it.nl>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 14 2023 - 19:01:19 CET