Raised A Lot Of Parallel Slave Sessions Once Upgraded On 10.2.0.5 Release
Last updated on FEBRUARY 02, 2017
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.5 to 10.2.0.5 - Release: 10.2 to 10.2
Information in this document applies to any platform.
with status ACTIVE for each connected user, and it needs to set
parallel_max_servers=0 in order to get a single session for connected user.
Otherwise, if setting parallel_max_servers=2560, then the first connected
user raised >2500 parallel sessions.
SQL> select count(*) from v$session where username = 'IBS';
SQL> select program, count(*) from v$process where regexp_like(program,
group by program having count(*) > 1
order by program;
no rows selected
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms