Re: Newbie - Database going down alot

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: 1996/12/03
Message-ID: <01bbe0d8$a417c6c0$e7041990@jkallman>#1/1

The first place I would take a look is in the alert file for this database. This should hopefully tell you what is corrupting your instance. If that doesn't give you any help, your next bet might be to turn tracing on via the SQL_TRACE parameter in your pfile, and then examine that output.

If you can reduce this problem to the attempted execution of a particular DML statement, this will give you less data to wade through.

Joel

-- 
Joel R. Kallman		See Oracle products in action!!  http://govt.us.oracle.com
Oracle Government
jkallman_at_us.oracle.com
----
The statements and opinions expressed here are my own 
and do not necessarily represent those of Oracle Corporation.

Kochis <djkochis_at_sgi.net> wrote in article
<01bbdc62$b09e7120$61b597ce_at_orion.sgi.net.sgi.net>...


> I have an instance using Oracle 7.1 Workgroup server running on Windows

 NT


> 3.51.  The database seems to be going down about once a day.  Apparently

> you can perform select statements but not updates? 

> 

> I am thinking REDO logs?  Need help in where to look to pin point and fix

> 

> Thanks you for you help

> 

> David

> djkochis_at_sgi.net

>

Received on Tue Dec 03 1996 - 00:00:00 CST