Taking up too much resources

[gaegoori]

Hi,

I'm running DB 8.1.7 on Windows and Oracle.exe process is taking 99% CPU usage. What is going on? I can't do anything on OS...it's frozen, what's wrong with this?

[gandolf989]

Have you looked to see if Oracle has enough memory in which to operate? Have you looked at the alert file? Post the last 100 lines of the alert file and maybe someone will see something.

[badrinathn]

It might be worth to check the session using the CPU

select ss.sid,se.command,ss.value cpu ,se.username,se.program
from v$sesstat ss, v$session se
where ss.statistic# in
(select statistic#
from v$statname
where name = 'CPU used by this session')
and se.sid=ss.sid
and ss.sid>6 -- No statistics are kept for background processes [BUG:1158628]
order by ss.sid


This might help

Badrinath

[badrinathn]

http://technet.oracle.com/docs/produ...8_cpu.htm#4404

HTH

[thanigai]

check /usr/ucb/ps -aux for the %CPU used?.
Thanks.
Thanigaivasan.

[thanigai]

My bad..
That is on UNIX...
Thanigaivasan.