What is Oracle DB Error ORA-00023: session references process private memory; cannot detach session?

What is Oracle DB Error ORA-00023: session references process private memory; cannot detach session?

The following is the cause of this error:

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

Action you can take to solve this: 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.


Tags: Database, Computer Science, Troubleshooting, Business, Oracle, SQL




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution