Hi Guy's..
In this output you can see the User Logon-Time along with SID,SERIAL# and more details in RAC database.
SQL> select username, to_char (logon_time,'dd-mon-yyyy hh24:mi:ss'),osuser,terminal,sid,serial#,inst_id,count(*) from gv$session having username in ('RNLIGO') group by username,to_char (logon_time,'dd-mon-yyyy hh24:mi:ss'),osuser,terminal,sid,serial#,inst_id order by count(*);
USERNAME TO_CHAR(LOGON_TIME,' OSUSER TERMINAL SID SERIAL# INST_ID COUNT(*)
--------------- -------------------- ------------------------------ ---------------- ---------- ---------- ---------- -------------------------
RNLIGO 07-oct-2019 10:12:22 nurse37 RISB3N37 1357 34350 1 1
RNLIGO 07-oct-2019 10:11:44 nurse37 RISB3N37 202 1808 1 1
Happy Learning
No comments:
Post a Comment