Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CPU 100% use
trust me windows is not my choice - I have 4 other DB machines running
solaris happily but due to a piece of software we have to run they only
support it on NT which is a bit rubbish...
anyway strange as it may seem when i got back into the office this morning the CPU time had reduced to about 25-30% and the instance in question has behaved itself since. Maybe ots some strange bug in 2k and 8.1.7 as i don't know what it was.
Tom
"Mladen Gogala" <mgogala_at_adelphia.net> wrote in message
news:a79g9v$jmqcm$1_at_ID-82084.news.dfncis.de...
> On Tue, 19 Mar 2002 17:39:41 -0500, Tom Brown wrote:
>
> > i'll have to check when i get back in the office but i believe it was
> > oracle.exe ? This only happens when i start one of the instances... The
> > other is fine? But when the other does eventually start as (it takes
ages
> > to start) and the machine just is slow slow on the desktop it is
> > virtually unusable.
> >
> > what i did notice was there once was 4 entries for memory... Java,
Shared
> > Pool and two others.. i can;t remember sorry, there is now only 2? One
of
> > the missing ones is the reference to Java pool and the other i 'think'
is
> > shared pool... Are thes confugired in initSID.ora and if so is there any
> > reason why they would dissapear? I was the only one on the box today and
> > i did not remove them???
> >
> > Thanks
> >
> It will probably sound as a stupid and exotic idea, but you could check in
> the alert log (/oracle/admin/$DB/bdump/alert_$SID.log) for any problems
> and I'd also check the same directory for things like smon or pmon trace.
> It may sound pesimistic, but I don't believe that you'll be able to get
> much performance from a database if SMON or PMON threads are down. You can
> stabilize your PC by installing SuSE 7.3 or Red Hat 7.2. Then, you'll have
> tools like gtop, sar, top, or vmstat which will tell you exactly what
> process is using your CPU. You'll also save your company a bundle.
> When your PC displays something like this:
>
> Linux medo 2.4.16-4GB #15 Fri Mar 8 22:59:29 EST 2002 i686 unknown
>
> you will not have many problems left with OS stability and diagnostics
>
> --
> Mladen Gogala
Received on Wed Mar 20 2002 - 13:41:17 CST