more then one session

!hello

If u want to trap and find out the users who are accessing database by opening more then one session here it's help U. (TO FIND OUT THEM)


akram>desc more_session;
Name Null? Type
----------------------------- -------- --------------------
SID NUMBER
SERIAL# NUMBER
USER# NUMBER
USERNAME VARCHAR2(30)
STATUS VARCHAR2(8)
SERVER VARCHAR2(9)
OSUSER VARCHAR2(30)
MACHINE VARCHAR2(64)
TERMINAL VARCHAR2(16)
PROGRAM VARCHAR2(64)
LOGON_TIME VARCHAR2(30)

Trigger code:-
---------------

create or replace trigger more_session
after logon on database

declare

i v$session%rowtype;
begin
select sid,serial#,user#,username,status,server,osuser,machine,terminal,program,logon_time
into
i.sid,i.serial#,i.user#,i.username,i.status,i.server,i.osuser,i.machine,i.terminal,i.program,i.logon _time
from v$session where username =(select username from v$session group by username having count(username)>1)
and logon_time=(select max(logon_time) from v$session );

insert into more_session values ( i.sid, i.serial#,i.user#,
i.username,
i.status,
i.server,
i.osuser,
i.machine,
i.terminal,
i.program,
to_char(i.logon_time,'DD-MON-YYYY:HH24:MI:SS PM') ) ;
exception
when no_Data_found then
null;
end ;



by
akram_tri@yahoo.co.in