Re: Oracle stalls when loading/saving from DB

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CD93E31.4F92B6F9_at_exesolutions.com...
> Ulf Elsing wrote:
>
> > Hi,
> >
> > just a week ago we have installed oracle 8.1.7. Enterprise Edition on a
new
> > server (1xPentium 4 2000A, 1024MB Ram, SCSI-Raid, Windows 2000 Advanced
> > Server). We have a MFC-Application connecting to oracle via ADO. When
> > working with the Application connected to the new server, the
Application
> > does periodically stall when loading from or writing to the database.
The
> > Application does not react for about 1 minute. After that, it works
normal
> > again.
> >
> > On the old Server (2xPentium 3 733, NT4 Server) we never encountered
these
> > problems.
> >
> > Does anybody have an idea???
> >
> > Best Regards
> > Ulf
>
> Go to http://metalink.oracle.com and search for information about Pentium
4
> issues and the workarounds.

IIRC these all relate to installation and database creation. Its obviously very difficult to tell what is going on from the information provided but my suspicion would be that the redo logs are incorrectly sized and that the db is in archive log mode.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************