ORA-00023: session references process private memory; cannot detach session
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.
Ni Hau,
ReplyDeleteHot! That was HOT! Glued to the ORA-00023: session references process private memory; cannot detach session your proficiency and style!
select name,value from v$parameters abc
minus
select name,value from v$parameters@test xyz
and xyz.value >abc.abc
Can anybody please help me above sql?
Follow my new blog if you interested in just tag along me in any social media platforms!
Many Thanks,
Irene Hynes
Hello There,
ReplyDeleteFully agree on session references process private memory; cannot detach session . We’re seeing a lot of projects tackle big complex problems but few seem to have taken into consideration and in particular reasons to adopt.
I want to execute the different files at the run time in the SQL PLUS
Ex: I have two different files like ABC.SQL, XYZ.SQL,
I had declared one bind variable to hold file_name .
var file_name VARCHAR2(200);
DECLARE
sr VARCHAR2(20) :='ABC';
BEGIN
IF sr ='ABC' THEN
:file_name :='ABC.SQL';
ELSE
:file_name :='XYZ.SQL';
END IF;
END;
/
PRINT file_name
Now i want to execute the file which is there in :file_name bind variable
SQL>@:file_name
It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
Keep up the good work!
Obrigado,
Preethi.