How to Supplied Packages

DBMS_APPLICATION_INFO

Setting application info

BEGIN
DBMS_APPLICATION_INFO.SET_MODULE(module_name => 'SQL*Plus', action_name => '');
DBMS_APPLICATION_INFO.SET_CLIENT_INFO ('');
end;

You can use it inside a script to run at TOAD startup, go to View - Options - Startup, remember to rename your executable not be identified from v$session

DBMS_ALERT

Receiving session

declare
	   name VARCHAR2(100);
	   message VARCHAR2(100);
	   status INTEGER := 0;
	   secs integer := 5;
begin
	 name := 'PIPPO';
	 DBMS_ALERT.register(name);
	 while status = 0 loop
	 	   DBMS_ALERT.WAITany (name, message, status, secs);
		   if status = 1 then
		   	  dbms_output.put_line('Time out occurred, no alerts received in the last ' || secs || ' seconds');
	 	   elsif status = 0 then
		   	  dbms_output.put_line('Alert ' || name || ' correctly received, message is '||message);
	 	   end if;
	 end loop;
end;

Transmitting session

begin
DBMS_ALERT.SIGNAL ('PIPPO', 'bye');
commit;
end;