Please help me, i have one query like
If CPU usage is very high. Let say 95%.
How will you tune it?
Thanks in advance
select * from (select sql_text, cpu_time/1000000000 cpu_time, elapsed_time/1000000000 elapsed_time
from v$sqlarea order by cpu_time desc, disk_reads desc ) where rownum < 11;
The above query will show you ,which SQL are consuming much CPU, you can use top command to see which session is consuming much resources to check process id use following SQL. select s.sid || ',' || s.serial# "SID/SERIAL"
, p.spid "OS PID"
from v$session s
, v$process p
Where s.paddr = p.addr
order by to_number(p.spid);
Sign up for STechies