Re: Oracle 9i very slow on certain queries

From: <frank.van.bortel_at_gmail.com>
Date: 9 Feb 2007 05:02:56 -0800
Message-ID: <1171026176.734235.209570@h3g2000cwc.googlegroups.com>

On 8 feb, 23:21, paultre..._at_gmail.com wrote:
> Hi,
> my company has the following setup for 2 years:
> - NT Server 4 with oracle 9i server
> - Forms and Reports 6i connecting to the server from client
> - these are XP clients connected to an NT domain
>
> All queries etc were running fine for the last 2 years until today
> when suddenly some of the queries to the database started to perform
> very slowly.
>
> Queries that took seconds now are taking minutes and some of the
> reports are bombing out as a result.... I was wonder if there are any
> checks that I can run to specifcally isolate the problem/s
>
> Indexes are the only thing that comes to mind as an explaintion to the
> problem but how can I isolate with indexes to look at?
>
> If I do isolate an index as the problem is a rebuild the correct
> option
>
> Thanks in advance.

Very obvious answer:
What happened today with your infrastructure? Someone installed a service pack? RAID array in degraded mode? Someone all of a sudden decided statistics might be a good idea?

Anyway: you get the picture: now fill in the blanks. Received on Fri Feb 09 2007 - 07:02:56 CST