I require your assistance. I work on Oracle 22.214.171.124 on Solaris. There is a particular issue with a table. User complains that every time he tries to access the table (select only), it takes more than one to two hours to get the results. There are no DML operations performed on the table. If I run statistics, then the select works fine for one or two days. Then it again reverts to the old stage. There is no locking involved, since there is no DML operations on the table (only select is performed). It is a long running query. Please help. Give me ideas as to what other reasons can be listed out and how it can be sorted. It is a huge table. Thanks in advance.
This was first published in June 2007