oracle查询正在使用用户,怎样查看正在使用Oracle erp(EBS)的在线用户，及其详细情况？...

method 1:system administrator->security->user->monitor[@more@]

method 2:

SELECT usr.user_name uname,

app.application_short_name shrtnam,

resp.responsibility_name respnam,

form_name frmnam,

vproc.pid pid,

vsess.sid sid,

vsess.serial# sn,

vproc.spid spid,

vsess.osuser suser,

vsess.process process,

vsess.machine smach,

vsess.program sprog --,

-- vsess.client_info cli

FROM applsys.fnd_logins l,

applsys.fnd_application app,

applsys.fnd_login_responsibilities lresp,

applsys.fnd_login_resp_forms lform,

applsys.fnd_responsibility_tl resp,

applsys.fnd_form frm,

applsys.fnd_user usr,

v$process vproc,

v$session vsess

WHERE l.login_id = lresp.login_id (+)

AND l.login_id = lform.login_id (+)

AND app.application_id (+) = resp.application_id

AND l.user_id = usr.user_id

AND lresp.responsibility_id = resp.responsibility_id (+)

AND lresp.resp_appl_id = resp.application_id (+)

AND lform.form_id = frm.form_id (+)

AND lform.form_appl_id = frm.application_id (+)

AND lresp.end_time IS NULL

AND lform.end_time IS NULL

AND vproc.addr = vsess.paddr

AND l.spid = vsess.process

AND l.pid = vproc.pid

AND ( l.pid, l.start_time ) IN ( SELECT pid, MAX(start_time)

FROM fnd_logins

WHERE end_time IS NULL

AND terminal_id != 'Concurrent'

GROUP BY pid )

ORDER BY vproc.pid

method 3(此方法并不完善,还要继续写加table几个进去)

select * from fnd_logins

reference:

http://www.itpub.net/456420,3.html

http://www.itpub.net/571729.html