Bug 5447395 - Shared server tied to session when BFILE used
Metalink Note
Note:5447395.8
Fixed in
10.2.0.4 (Server Patch Set)
11.1.0.6 (Base Release)
Description
If a shareed server session (MTS) ever opens a BFILE and also closes it then the shared server gets tied to that particular session and remains in receiving state "WAIT(RECEIVE)".