rheggs
Member
Hi List
First time posting, please treat me gently.
We are running R04701 (AP to GL by Original Document) nightly for integrity checking. The report now takes several hours to run, and The Powers That Be are asking if anything can be done to make the run shorter.
Does anyone have any experience of tuning the database (Oracle 8.1.6) to speed things up, or any other suggestions? I'm quite comfortable with Oracle, but I've only had 2 months of exposure to OneWorld so far, and I'm still feeling a bit shell shocked!
Some figures that may or may not be useful...
F0911 contains about 820,000 rows
F0101 contains about 50,000 rows
F0411 contains 83,000 rows
Richard
OneWorld Xe SP15.1
Enterprise: Oracle 8.1.6, AIX 4.3.3
Webserver: (HTML) SP 15.1_0012, AIX 4.3.3
First time posting, please treat me gently.
We are running R04701 (AP to GL by Original Document) nightly for integrity checking. The report now takes several hours to run, and The Powers That Be are asking if anything can be done to make the run shorter.
Does anyone have any experience of tuning the database (Oracle 8.1.6) to speed things up, or any other suggestions? I'm quite comfortable with Oracle, but I've only had 2 months of exposure to OneWorld so far, and I'm still feeling a bit shell shocked!
Some figures that may or may not be useful...
F0911 contains about 820,000 rows
F0101 contains about 50,000 rows
F0411 contains 83,000 rows
Richard
OneWorld Xe SP15.1
Enterprise: Oracle 8.1.6, AIX 4.3.3
Webserver: (HTML) SP 15.1_0012, AIX 4.3.3