very very urgent

[shailendra]

I have compaq ML 350 SERVER( PIII 933/896MB/36 GB
--with 5 Partitions).windows nt 4.0 with sp4.

We have loaded oracle 8i with site replicator options.
We are facing problem that the CPU is shooting upto
100% constant & We are required to reboot the server.
This problem is persisting twice or thrice in a week
,Otherwise all front application like office ,backup
software were performing well.
At this not even alteast 2 users would be using the
server.
No hardware error found ,ran dignosis from compaq
utilities.

Pls.do reply all,

Awaiting for your favourable response.

Thanks in Advance

Shailendra

[molonede]

That is a pretty wide open question without much details on the Oracle Setup or what process is using the 100% of the cpu. If you believe it is Oracle or you let us know some details on the Oracle setup we may be able to help. First of course is the which process is using the 100% of the cpu, have you check the alert log for any oracle error messages?

[shailendra]

But do you have any idea why it happens?

[marist89]

Could be any number of things:
A user session running a bad query
A poorly tuned database
dbwr spiking because of poor I/O

We need many more details in order to offer an educated opinion. With all that other stuff on the box, do you know if it is even Oracle that is using all that CPU?

[shailendra]

What all information is required for this can you tell me so that I can give you all the required information and if possible also tell me how to get the information.

[oratune]

My first act would be to install SP6.

[shailendra]

Oratune thanks for reply

But can you tell me the relation between both of them beause I do nto have any idea about it. so an you plz. tell me.


Plz. explain me in detail I would be very thankful to you



[Edited by shailendra on 11-09-2001 at 10:24 AM]

[omegamark]

It like applying patch or like upgrade .Most of the known bugs would be soved by appling them ...Ask your NT admin to do that ...