I'm running an 8i as interface between different systems to carry out a dataexchange. Each of these systems has its own schema with its own exporttable (in fact view), from where the data are transmitted to the importtable of the destinationsystem via "instead of"-triggers. The destinationsystem reads his importtable and deletes the data afterwards (deletion=confirmation).
In normal operation there are about 50000 inserts per 15" whereof 30000 belong to the same destinationsystem.
I have now the problem, that after a while operation, the performance on the a.m. importtable is slowing down. Therefore i have created cyclic jobs to perform an indexrebuild and tablereorganisation (alter table move) once per day, but still the performance is decreasing (it happened twice that this table was filled up with about 6 Mio entries).
Has anybody some further suggestions what I could look at ?
In normal operation there are about 50000 inserts per 15" whereof 30000 belong to the same destinationsystem.
I have now the problem, that after a while operation, the performance on the a.m. importtable is slowing down. Therefore i have created cyclic jobs to perform an indexrebuild and tablereorganisation (alter table move) once per day, but still the performance is decreasing (it happened twice that this table was filled up with about 6 Mio entries).
Has anybody some further suggestions what I could look at ?