Oracle 9i very slow on certain queries

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. Received on Thu Feb 08 2007 - 16:21:16 CST