Re: CPU busy by oracle

Posted by big on Oct 14, 2021; 3:10pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/CPU-busy-by-oracle-tp10345p10352.html

Thank you.

Yes and a query like this:
select
 substr(a.spid,1,9) pid,
 substr(b.sid,1,5) sid,
 substr(b.serial#,1,5) ser#,
 substr(b.machine,1,15) box,
 substr(b.username,1,10) username,
-- b.server,
 substr(b.osuser,1,15) os_user,
 substr(b.program,1,30) program
from v$session b, v$process a
where
b.paddr = a.addr
and type='USER'
order by username;

Regards.