session references process private memory; cannot detach session

Solution ID:ORA-00023

Type: Oracle

Cause

An attempt was made to detach the current session when it contains references to process private memory.

Actions

A session may contain references to process memory (PGA) if it has an open network connection, a very large context area, or operating system privileges. To allow the detach, it may be necessary to close the session's database links and/or cursors. Detaching a session with operating system privileges is always disallowed.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm


https://community.oracle.com/message/4412635


https://community.oracle.com/message/1054695


https://community.oracle.com/message/295923


https://community.oracle.com/message/9273960


https://community.oracle.com/message/9446075


https://community.oracle.com/message/2025568


https://community.oracle.com/message/1193289


https://community.oracle.com/message/4497062


https://community.oracle.com/message/1117811


https://community.oracle.com/message/1228927


Browse all solutions to database errors from Oracle, MS SQL, or MySQL