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)