sizing and performance

Hello we are running JDE OneWorld SP20 on Solaris 8 and Oracle 8.1.6.3.
We are growing our F0911 (General Ledger) table at about 1,000,000 records a month. We have been up on production for about 18 months. This is starting to cause performance issues with integrity runs and other processing.
Has anyone found a way to provide help with this or similar datasizing issues? How about the following activities to help this problem?
1) Oracle table partitions of the F0911 table or others?
2) Archiving of data
3) Summarizing of data?
4) tuning JDE queries for faster summary data?

Thank you for any and all responses.

We ran into performance issues on the AS/400 at about 18 months as well. One issue was OLD SQL Paackages. They had never been deleted so all our optimized access paths were based on much smaller files with a lot fewer records. Delete all the "JDE" (no sql packs that start with "Q") SQL packages and see if it doesn't help performance. It won't be the whole answer but it should contribute a noticeable return. Besides, you want to do these things one at a time anyway and this is a relatively easy task to accomplish.

Systems Programmer
AS/400 V4R5 9406-730 8-Way / OneWorld B7332 SP11.3

Thank you for your reply