Re: CPU busy by oracle

Posted by ErmanArslansOracleBlog on Oct 13, 2021; 1:24pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/CPU-busy-by-oracle-tp10345p10349.html

you will use v$process and v$session for that.
v$process   SPID VARCHAR2(12) Operating system process identifie
You will join them and use the OS PID information for querying the details.
Once you get the Oracle SID (session id), your job will be easier. You will then check the relevant data dictionary views to see what those sessions are doing..

If you have a tool like Toad in place, you can also use the capabilities of that Tool to display the relevant detailed info about that process/session.. Those types of tools have Session Monitor tabs, so you can use them as well..