Oracle Report run slow and take 100% CPU [message #55395] |
Wed, 22 January 2003 10:15 |
tan tran
Messages: 2 Registered: January 2003
|
Junior Member |
|
|
I have a database 8.1.6 and the front end developed on Oracle Forms and Reports. The application was implemented for couple years. Now, once a while, when users run report, it take forever and take 100% CPU. Everytime this happen, I issues command from SQL Plus ALTER TABLE .. MOVE TABLESPACE and ALTER INDEX... REBUILD on all objects in that schema. After that, the same report run in less than a minute. I need a solution to fix this problem permanence so that it will not happen again. I Check the fragmentation but the tablespace are not fragmented.
Anyone know what causing this problem, any lead would be appreciated. Thanks in advance.
|
|
|
|
Re: Oracle Report run slow and take 100% CPU [message #55399 is a reply to message #55395] |
Wed, 22 January 2003 11:17 |
tan tran
Messages: 2 Registered: January 2003
|
Junior Member |
|
|
Rebuild the indexes by themself do not solve problem. I have to move all table to different tablespace and move back then rebuild indexes. If I just rebuild indexes, it do not solve this problem. I don't know the reason why!!! Thanks for your reply, howerver, I already did that and it was not a solution.
|
|
|