ORA-03113 was not found in the alert.log, but error1092 was. About ten
minutes after I see the messages (they came up only a few seconds apart), I
got my connection back. I'm not aware of NT shutdown in the past week. I
suspect the problem have something to do with extents. Whenever I query
something about extents the query is very slow (usually takes a few seconds,
now take several minutes).
"Ron Reidy" <rereidy_at_indra.com> wrote in message
news:3C3CC9DE.D7AA3C73_at_indra.com...
> Al Liu wrote:
> >
> > We have a ORACLE 8.0.5 database on NT4 served as data source for an
> > Intergraph GIS system. The size of database is ~2gb, the drive the
database
> > residing is 4 gb. In past three days, I have had the following problems
> >
> > -some times when I try to connect database I got messages "ORA-03113:
> > end-of-file on communication channel" and " DBW0:terminating instance
due to
> > error 1092". Then after a while I can connect with either sqlplus or
> > svrmgr30. However, connection is much slower, taking 20-30 seconds.
> >
> > -queries generally runs slower than before, especially count(*) query,
maybe
> > 10 times slower.
> >
> > -When I run snap8.sql usually take less than 2 minutes. It hangs when I
run
> > it at retrieving datafile information. I checked the query, seems like
> > dba_extents was the key of slowdown. I queried dba_extents alone and
noticed
> > that it stopped at four or five segments for a long time before moving
> > forward again (total rows retrieved by the query is 2987). Query of
> > user_extents with a login of a user also run very slow.
> >
> > -The GIS system has real performance problem, some task used to take
less
> > than a minute may take more than a hour now.
> >
> > I checked V$datafile looks like all datafiles are online. I'm not sure
all
> > above symptoms were related to the same problem. Please help me to
diagnose.
> >
> > Thanks.
> >
> > Al
> Did you check the alert log when you got ora-03113? How long has it
> been since your system (NT) was rebooted?
> --
> Ron Reidy
> Oracle DBA
Received on Thu Jan 10 2002 - 07:50:58 CST
