Re: slow Oracle9i-server

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Sun, 18 Apr 2004 00:17:54 GMT
Message-ID: <SOjgc.42855$dg7.41145@edtnps84>

Christoph Waglechner wrote:

> Hello!
>
> I'm running an Oracle9i server on Win2000. After restarting the server,
> the Oracle server application is about five times slower than before. A
> virus- infection is nearly impossible, and other processes are working
> normally.
>
> Former restarts didn't have any effects on the Oracle9i's performance.
>
> greetz Christoph

If nothing at all has changed, there will be no impact in performance. You may not have implemented the change, or may simply not remember implementing the change.

Therefore .... what has changed on the server? (Absolutely nothing is highly unlikely) Any system/memory/hardware changed? Any new software added or existing software patched?

What has changed around the database startup parameters?

Remember one consistent reason for an instance running slower than before is that the disk subsystem is more heavily used - are you perhaps paging or swapping?

Finally - why do you believe that it's running slower? Some measurements perhaps? or just a feeling?

/Hans Received on Sat Apr 17 2004 - 19:17:54 CDT