Learn the motive and how to resolve the ORA-00023 error message in Oracle.
Description
When you come upon an ORA-00023 error, the following error message will appear:
ORA-00023: session references process’ private memory; cannot detach session
Cause
You tried to detach a session but it contains references to the technique reminiscence (PGA) thru any of: an open community connection, a very large context area, or running system privileges.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
If the session has an open community connection or a very large context area, you can attempt closing the session’s database hyperlinks and cursors.
Option #2
If the session has working gadget privileges, you will not be able to detach the session.