Oracle Error ORA-00023: session references process private memory; cannot detach session

Oracle Error Message

ORA-00023: session references process private memory; cannot detach session

Reason for the Error

You attempted to disconnect a session but were unsuccessful because it had references to the process memory (PGA) due to an open network connection, a particularly large context area, or operating system privileges.

Solution

If a session has an open network connection, a very wide context area, or operating system privileges, it may contain references to process memory (PGA).

It might be essential to end the session’s database linkages and/or cursors in order to allow the disconnect.

A session with operating system privileges cannot ever be detached.