ORA-00023: session references process private memory; cannot
detach session

Answers were Sorted based on User's Feedback



ORA-00023: session references process private memory; cannot detach session..

Answer / guest

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

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

ORA-00023: session references process private memory; cannot detach session..

Answer / testing

my answer

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-34802: (OCI11) OLAP OCI operation caused ROLLBACK past an UPDATE of an attached analytic workspace. Current operation canceled.

1 Answers  


ORA-26056: Can not unload from a view through the direct path.

1 Answers  


DRG-12409: syntax error for label in string

1 Answers  


NNC-00402: program interface de-initialization failed

1 Answers  


ORA-38102: Invalid column in the INSERT WHERE Clause: string

1 Answers  






PLS-00516: Type mismatch between object table and value 'string' in INSERT statement.

1 Answers  


PROC-00105: Logging error

1 Answers  


ORA-36774: (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.

1 Answers  


ORA-25126: Invalid name specified for BUFFER_POOL

1 Answers  


LSX-00262: attribute "~1S" cannot have complex type "~2S"

1 Answers  


TNS-00276: Navigator: Tracing is now OFF

1 Answers  


RMAN-08516: controlfile copy filename=string recid=string stamp=string

1 Answers  


Categories