Raised A Lot Of Parallel Slave Sessions Once Upgraded On 10.2.0.5 Release
(Doc ID 1299489.1)
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|