Hi,

We reorganized all "medium tables" (about 150 tables) two weeks ago with:
- bdbpre6.1 ...
- drop table (oracle level)
- bdbpost6.1 -f
Some of them were not reorganized since december 2002.
All are in the same two tablespaces (one for data, one for index).

Since this date, our EDI process has no more performance problems.
I wonder if the problem is really linked to this action.

How often do you reorganize your tables ?

Regards

The EDI problem came maybe from table ttaad512 which had a lot of records with cjob = ' ' which were written by the EDI process. This table was never reorganized.

Regards

Your reorg did 2 things:
- it recreated the tables. If the settings in the ora_storage where the same as before you probably got the same amount of extents as before.
- As you used the -f option, it did an analyze table afterwards.

So:
- when reorganizing tables make sure that:
* you only reorganize tables that suffer on performance e.g. because they are really fragmented (#extents > 500).
* change the ora_storage according the new situation
- Make sure you analyze your tables on frequent basis. Use dbms_utility.analyze_schema in Baan 8 and use dbms_stats.gather_schema_stats for Oracle 9 and 10.

Hope this helps,
Dick

you can spool the output of the following commanad to a file and run the output of the file again in SQL.

select 'ANALYZE TABLE BAANDB.' || TABLE_NAME || ' ESTIMATE STATISTICS SAMPLE 40 PERCENT ; '
from dba_tables
where table_name like '_________123' ; -- 123 is company nr.

We have created a script/task that automatically analyzes all the tables in the company in one week and then the process repeats again.

-Jalandhar