parallel_max_servers and the number of sessions involved in a SQL
From: <ahmed.fikri_at_t-online.de>
Date: Fri, 27 Nov 2020 20:47:15 +0100 (CET)
Message-ID: <1606506435088.3697410.3798e6fe84885125d6db1b25668936caa56f2d3f_at_spica.telekom.de>
Hi all,
Date: Fri, 27 Nov 2020 20:47:15 +0100 (CET)
Message-ID: <1606506435088.3697410.3798e6fe84885125d6db1b25668936caa56f2d3f_at_spica.telekom.de>
Hi all,
I'm trying to understand how Oracle defines the limit on the number of
sessions involved in a SQL statement (a select on big table using a
parallel hint)
I ran some tests and I found the following:
number_of_sessions =greatest(floor(min(parallel_max_servers,n_max)/2),1)
where
cpu (host) n_max
1 40 2 80 3 120 4 160 5 200 6 228 7 228 8 228
for my test I used 12.2.0.1 installed on a virtual box (the host machine
has 12 cpus)
can someone explain the n_max/cpu relationship?
Best regards
Ahmed
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 27 2020 - 20:47:15 CET