监控oracle erp 在线用户sql

SELECT user_name,
responsibility_name,
user_form_name,
login_name,
TIME,
pid,
terminal_id,
user_id,
resp_appl_id,
responsibility_id,
form_id,
form_appl_id
FROM fnd_signon_audit_view
ORDER BY to_number(substr(TIME, 1, instr(TIME, ':') - 1)) * 60 +
to_number(substr(TIME, instr(TIME, ':') + 1))[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7180624/viewspace-906106/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7180624/viewspace-906106/