Database Administrator

create or replace procedure sp_ltmlogin AS   MODULE SYS.V_$SESSION.MODULE%TYPE ; L_USER NUMBER ; BEGIN  SELECT MODULE INTO MODULE FROM ...

create or replace trigger tg_dropuser before drop on database when (ora_dict_obj_type ='USER')   declare  l_name varchar2(30); ...

If user does not logout properly / kill task / services restarted then record of that user will present in tblrklogindetails table. We...