Oracle 7.3.4 instance dies on me without any message

From: <sybrandb_at_my-deja.com>
Date: Fri, 18 Aug 2000 18:06:44 GMT
Message-ID: <8njtv4$ddg$1@nnrp1.deja.com>

All,

I'm in a strange situation I never experienced before in my career: I have a database instance just dying on me. The statement which brings the server on it's knees deletes from a master table. There are many detail and junction tables, and for some reason the designers thought it necessary to maintain the number of detail records in the master record, so you can imagine a hell of a lot of triggers will fire. After about 5 minutes the instance just disappears. No sign in the alert, no traces at all. The only thing is a drwatson screen on the server displaying an access violation. Any help out there?

Oracle 7.3.4.5 on NT 4.0 sp3 (yuck) on a Compaq Proliant 800 single cpu 200 Mhz with 256 Mb Ram (again yuck) running three instances, about 40M cache per instance, client sqlplus 3.3.2

Regards

--

Sybrand Bakker, Oracle DBA

All standard disclaimers apply

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 18 2000 - 13:06:44 CDT