samarchon
Active Member
Hi,
We are running R09705 integrity report and it takes forever to finish. Please see below for E1 configuration. After some research we figured out that the Oracle is using the wrong index. So the DBA group rebuilt the indices (on F0911) and analyzed the tablespace. After this we were good for 4 days, the report finished in 2-3 hrs and it was using the correct index. Now the database is back to using the wrong index. Have anybody faced this problem and how have you solved it? It seems ridiculuos to me to rebuild indices every few days. We were on 9i before and we did not have this problem. But this is the only UBE having this problem.
Thanks for your help.
--Sam
Apps Rel: 8.9, Tools Rel: 8.96_H1, Oracle 10G on Unix, WinTel logic/application servers, Citrix Clients
We are running R09705 integrity report and it takes forever to finish. Please see below for E1 configuration. After some research we figured out that the Oracle is using the wrong index. So the DBA group rebuilt the indices (on F0911) and analyzed the tablespace. After this we were good for 4 days, the report finished in 2-3 hrs and it was using the correct index. Now the database is back to using the wrong index. Have anybody faced this problem and how have you solved it? It seems ridiculuos to me to rebuild indices every few days. We were on 9i before and we did not have this problem. But this is the only UBE having this problem.
Thanks for your help.
--Sam
Apps Rel: 8.9, Tools Rel: 8.96_H1, Oracle 10G on Unix, WinTel logic/application servers, Citrix Clients
