Sunday, June 1, 2008

Shared server tied to session WAIT(RECEIVE)

Bug
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)".