Oracle Record operation duration

CREATE OR REPLACE TRIGGER Xtgl_logon_trigger
After logon on DATABASE
BEGIN
  INSERT into     Xtgl_logon (Sessionid,ipaddress,machinename,programname,logondate,logonid)

  VALUES (Sys_context (' Userenv ', ' SESSIONID '), Ora_client_ip_address,sys_context (' Userenv ', ' TERMINAL '),
  ' Client ', Sysdate,sys_context (' Userenv ', ' SESSIONID '));
END;

Ask

Oracle uses triggers to record user login information (can record online and offline times and online hours) two user login

Reply

CREATE OR REPLACE TRIGGER Xtgl_logoff_trigger
Before logoff on DATABASE
BEGIN
INSERT into     Xtgl_logon (Sessionid,ipaddress,machinename,programname,logondate,logonid)

  VALUES (Sys_context (' Userenv ', ' SESSIONID '), Ora_client_ip_address,sys_context (' Userenv ', ' TERMINAL '),
  ' Offline ', Sysdate,sys_context (' Userenv ', ' SESSIONID '));
END;
This off-line trigger, both on-line and offline are recorded, you want to count what to count what Bai

Oracle Record operation duration