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-12678: Authentication disabled but required

1 Answers  


ORA-07218: slkhst: could not perform host operation

1 Answers  


NNO-00317: statistic counter reset interval changed to number seconds

1 Answers  


ORA-22880: invalid REF

1 Answers  


DRG-51024: out of memory in stemmer

1 Answers  






RMAN-00701: SCRIPT requires that CATALOG be specified on the command line

1 Answers  


ORA-14011: names assigned to resulting partitions must be distinct

1 Answers  


ORA-03233: unable to extend table string.string subpartition string by string in tablespace string

1 Answers  


ORA-14185: incorrect physical attribute specified for this index partition

1 Answers  


ORA-13029: Invalid SRID in the SDO_GEOMETRY object

1 Answers  


ORA-13290: the specified unit is not supported

1 Answers  


RMAN-11002: could not open a cursor to the target database

1 Answers  


Categories