怎么捕获用户登录信息，如SID，IP地址等

可以利用登录触发器，如

CREATE OR REPLACE TRIGGER tr_login_record

AFTER logon ON DATABASE

DECLARE

miUserSid NUMBER;

mtSession v$session%ROWTYPE;

CURSOR cSession(iiUserSid IN NUMBER) IS

SELECT * FROM v$session

WHERE sid=iiUserSid;

BEGIN

SELECT sid INTO miUserSid FROM v$mystat WHERE rownum<=1;

OPEN cSession(miUserSid);

FETCH cSession INTO mtSession;

--if user exists then insert data

IF cSession%FOUND THEN

INSERT INTO log$information(login_user,login_time,ip_adress,ausid,terminal,

osuser,machine,program,sid,serial#)

VALUES(ora_login_user,SYSDATE,SYS_CONTEXT ('USERENV','IP_ADDRESS'),

userenv('SESSIONID'),

mtSession.Terminal,mtSession.Osuser,

mtSession.Machine,mtSession.Program,

mtSession.Sid,mtSession.Serial#);

E