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

PCC-01016: "N" character literals not supported in embedded PL/SQL

1 Answers  


RMAN-20401: script already exists

1 Answers  


QSM-02088: mv omits at least one grouping key from the select list

1 Answers  


TNS-01163: Failed to spawn process: string

1 Answers  


SQL*Loader-00289: SQL string for column string occludes SQL string for column string.

1 Answers  






NNO-00614: enabling FORWARDING-DESIRED on system queries

1 Answers  


LSX-00126: facet "~1S" has invalid value "~u"

1 Answers  


ORA-00041: active time limit exceeded - session terminated

1 Answers  


ORA-01310: requested return type not supported by the lcr_mine function

1 Answers  


ORA-19647: non-zero LEVEL cannot be specified when INCREMENTAL is FALSE

1 Answers  


ORA-19002: Missing XMLSchema URL

1 Answers  


QSM-01023: materialized view, string, has GRANT errors

1 Answers  


Categories