ORA-00023 Error ->Session references Process Private Memory; Cannot Detach Session

By Santhosh N

This explains the oracle error, ORA-00023 in detail, the possible reason(s) and steps to solve the same in Oracle Database.

Oracle Error: ORA-00023

Description: Session references Process Private Memory; Cannot Detach Session.

Reason(s) for this Oracle error: This error will be raised when you try to detach a session which already contains references to the process memory (PGA) through any of the open network connection, a very large context area or OS privileges.

Possible steps to solve this error:
1) Try to close the session’s database links and cursors when the session has an open network connection or a very large context area.
2) If the session has already operating system privileges, you may not be able to detach the session

Related FAQs

This explains the oracle error, ORA-00022 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00021 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00020 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00019 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00018 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00017 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
ORA-00023 Error ->Session references Process Private Memory; Cannot Detach Session  (931 Views)