I opened two pl/sql instances
from instance 1 ... set module info using a pl/sql procedure using below command
begin
DBMS_APPLICATION_INFO.Set_Module('myval',null);
end;
when i try to read this info from instance two
DBMS_APPLICATION_INFO.Read_Module from other session via another pl/sql function
I got null
but when i do the same from first instance I am able to get this information!
is it normal behavior ? actually i want to set the module info and it should be available to me or other session and DBA as well