Re: Oracle 9i very slow on certain queries

On Feb 9, 1:02 pm, "frank.van.bor..._at_gmail.com" <frank.van.bor..._at_gmail.com> wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -

very simple answer - nothing happened with my infrastructure: I restored last night's dump to a new 10g Oracle database on a different box to see in this would throw up my problem as I was having no joy finding the route on to problem using Mark's suggested method above(thank you Mark) ...

however to my horror I am still getting the same response times with the new server running 10g (10.2.0.1.0 - Production) database with the 9i(Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production) dump imported.

the new oracle 10g database is installed on a clean OS......so now I am back to the same problem of narrowing the problem.....

Thanks Received on Fri Feb 09 2007 - 12:37:34 CST