googers
Member
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 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.