Find the CPU intensive SQL Query : UNIX Level Mapping of PID and SPID
The process to find the CPU intensive query requires UNIX as well as Database level mapping. Step 1: The first step is to find the PID of the most CPU consuming process from UNIX level. SQL> ! prstat -s cpu -n 5 PID USERNAME SIZE RSS STATE PRI NICE TIME …