Re: Oracle stalls when loading/saving from DB

From: Chris Weiss <chris_at_hpdbe.com>
Date: Wed, 8 May 2002 13:16:47 -0400
Message-ID: <abbmi4$1on7$1@msunews.cl.msu.edu>

There are many things that could be causing the problems you describe. Please forgive me if you already knows these things.

*) Have you updated statistics on your new database? You should regenerate your stats on your new box.
*) Run an explain plan on the offending SQL. You might have a pathological query that the stats update might address. *) Start a session with tracing turned on and run the resulting trace file through TKPROF. This should show exactly where the app is getting hung up. *) Have you looked at the various init.ora parameters such as db block buffers and other issues that can affect caching and memory? *) Check your alert log. If you are switching your redo logs rapidly, then you know the bottleneck.
*) Run a UTLBSTAT/ESTAT and check out the readme.txt. This will highlight any hot disks.

On your system, your array could be misconfigured. Depending on your hardware, your array cache could be set incorrectly, creating an I/O bottleneck. You can test this with a couple of large file transfers with the system. However, I would look at the previous items first.

Good Luck!

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Chris Weiss
mailto:chris_at_hpdbe.com
www.hpdbe.com
High Performance Database Engineering
Available for long and short term contracts

"Ulf Elsing" <elsing_at_tms.de> wrote in message
news:abalv3$ibn$1_at_newsreader2.netcologne.de...


> 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

>

>

>

>

>

Received on Wed May 08 2002 - 12:16:47 CDT