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-14615: List value 'string' specified twice in subpartitions 'string', 'string'

1 Answers  


RMAN-06609: AS COPY can be configured only for disk device

1 Answers  


ORA-21611: key length [string] is invalid

1 Answers  


NNL-01059: Region data reload check failures: number

1 Answers  


ORA-06793: TLI Driver: server cannot create new process

1 Answers  






ORA-13127: failed to generate target partition

1 Answers  


TNS-00315: Failed to allocate larger connect data area for getting pump data: number

1 Answers  


ORA-13754: "SQL Tuning Set" "string" does not exist.

2 Answers  


ORA-06438: ssaio: the asynchronous read was unable to read from the database file.

1 Answers  


ORA-16002: database already open for read-write access by another instance

1 Answers  


ORA-22897: no scope clause specified for user-defined REF column "string"

1 Answers  


ORA-14613: Attempt to generate name from parent name string and template name string failed as the combine named would have been longer than allowed

1 Answers  


Categories