Oracle form user_id 監控 monitor session
輸入user_id取得該User目前使用的功能
SELECT ff.*,
a.TIME
FROM (SELECT form_id,
TIME
FROM fnd_signon_audit_view
WHERE 1 = 1
-- AND responsibility_id = &responsibility_id
AND user_id = &user_id) a,
fnd_form_tl ff
WHERE a.form_id = ff.form_id(+)
ORDER BY ff.user_form_name;
Toad也有功能可以更方便的去知道所有User目前的狀態與lock的物件
Database >> Monitor >> Session Browser