Re: Oracle7.3 and Baan

ones is could be wrong is your index. Do you know the functionality of idexes ? they build an index-tree. and every entry in the table build a new leave in the index.
but the leaves never will be dropt or updated. So tey grow far away. so you should try to recreate the indexes. in oralce 8 it looks like alter index indexname rebuild;
i don't no in 7.3.4. it could be, that you must move them a way and build a new one.

do for example:
analyze index indexname validate structure; select * from index_stats;

in this view you see the del_lf_rows column, in this column you see the deleted rows.

do the best !

Zhenming schrieb:

> We are using Baan with Oracle 7.3.4 as the backend server. Every day we need
> to run a batch of jobs about four hours, however we notice that each day it
> produces 1.2 Gb size archive files, we set the log file size 100 MB,
> approximately it produces 12 archived files, the index spaces are about 45
> GB, and the tablespace for the tables are only about 34 GB, we wonder there
> might be something wrong with the application design, any suggestion we will
> appreciate.
>
> Zhen
Received on Fri Oct 27 2000 - 02:22:33 CDT