Post date: 02-Mar-2010 12:02:51
Run top or topas or whatever to identify top sessions
top - 17:30:33 up 7:41, 1 user, load average: 4.29, 3.57, 2.99
Tasks: 175 total, 2 running, 173 sleeping, 0 stopped, 0 zombie
Cpu(s): 4.3%us, 26.1%sy, 0.0%ni, 47.9%id, 20.5%wa, 0.7%hi, 0.7%si, 0.0%st
Mem: 1130468k total, 1115528k used, 14940k free, 34180k buffers
Swap: 2031608k total, 43392k used, 1988216k free, 478624k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
8353 oracle 16 0 316m 74m 70m S 7.0 6.7 1:01.12 oracle
8364 oracle 15 0 318m 77m 73m S 3.2 7.0 0:56.03 oracle
[oracle@rc1 ~]$ ps -ef | grep 8353
oracle 8353 1 3 17:04 ? 00:01:02 oraclerdb1 (LOCAL=NO)
select
p.username,
s.sid,
s.serial#,
p.spid,
s.osuser,
s.status,
p.program,
p.terminal,
to_char(s.logon_time,'DD-MM-YYYY HH24:Mi:SS') "Logon Time",
s.module
from
v$process p,
v$session s
where
p.addr = s.paddr
and p.spid = '8353';
USERNA SID SERIAL# SPID OSUSER STATUS PROGRAM TERMINAL Logon Time MODULE
------ ---- ------- ----- ------ -------- ---------------------------------- -------- --------------------------------------------------------------------------- ----------------------------------
oracle 106 4051 8353 oracle ACTIVE oracle@rc1.myrac.com UNKNOWN 02-03-2010 17:05:00 Browse Products