Re: 100% CPU after thonderstorm ....

Ruedi.Schwitter wrote:
>
> Hy there
>
> after a little thonderstorm, all users (ca. 80) have lost the connect to
> the database, the network was fail for a few secondes. But the CPU on
> the server was climbing to 100% and the xload was 40 times higher than
> normal.
>
> We aren't able to made a connect internal to shutdown and start the
> database properly. At least , we must kill all the ora processes by hand
> (kill -9) and start the database again. Luckely, we havent lost any
> data, but now, we want know, who we can preserve a such database state ?
>
> Has anyone an idea ?

Maybe:

When user connections suddenly die the Oracle PMON-process will clean up after them. If all 80 sessions got lost at the same time, maybe that explains the heavy load on the machine? The PMON process will roll back everything non-committed from the disappeared sessions, that may take quite a while. Maybe you had to do the 'kill -9'. But you ought to give it _some_ time to complete.

By the way, anyone, the DB goes down when killing one of the vital Oracle processes (PMON, SMON...) so killing just one of them will clear them all out. But which is the smartest to kill? PMON?

Njål

--
Njål Arild Ekern, ADB-seksjonen USIT
Postboks 1059 Blindern, 0316 OSLO
Tlf 22852477, fax 22852730 Received on Tue Jun 30 1998 - 09:15:24 CDT