Re: CPU 100% with an idle instance

In article <xbEG5.3357$6N2.156505_at_monolith.news.easynet.net>,   "Mike Taylor" <mct_at_uniport.co.uk> wrote:
> Shortly after the instance starting the CPU shoots to 100% even with
 no user
> queries running. The database is Oracle 7.3.4 standard edition on a
 Dell
> Poweredge single CPU running Win NT4. Any ideas??

select * from v$sesstat where statistic# = 12. Also look at v$session to see who is active (other than background processes). If you find anything suspicious, alter system kill session and / or use orakill to kill it from command line.

--
Yong Huang

(yong321_at_yahoo.com)


Sent via Deja.com http://www.deja.com/
Before you buy.