To Check the Timing Details of SID and event waiting

select
a.sid, a.serial#, a.status, a.program, b.event,to_char(a.logon_time, ‘dd-mon-yy
hh24:mi’) LOGON_TIME,

to_char(Sysdate,
‘dd-mon-yy–hh24:mi’) CURRENT_TIME, (a.last_call_et/3600) “Hrs
connected” from v$session a,

v$session_wait
b where a.sid=&sid and a.sid=b.sid;

Identifying Sever
Machine and Client Machine names of a session

col
server_machine for a15

col
client_machine for a15

select
p.spid server_pid, s.sid oracle_sid, s.machine client_machine,i.host_name
server_machine

from
gv$session s, gv$process p, gv$instance I

where

p.inst_id
= s.inst_id and

p.addr
= s.paddr and

i.inst_id
= s.inst_id and

p.spid
= ‘&server_pid’;