7 lines
305 B
SQL
7 lines
305 B
SQL
select B.sid, B.serial#, C.spid, B.username, B.program, B.osuser, B.machine, A.value
|
|
from v$sesstat A, v$session B, v$process C, v$statname D
|
|
where A.sid = B.sid
|
|
and B.paddr = C.addr
|
|
and C.spid = '&processid'
|
|
and A.statistic# = D.statistic#
|
|
and D.name = 'CPU used by this session'; |