Hi,

I am running SAP R/3 46B Oracle 816 on NT.

Today on checking free space of tablespaces, i found that lot of free space is shown. And on checking deeply I found that space is left free in the form of few contiguous blocks.

What should I need to do to reorganize this and I fel that this is affecting performance also. Am I right.

eg of free space details


File Block-ID Kbyte free Blocks free

2 392 1,040 130
2 652 1,040 130
2 912 1,040 130
2 1,172 1,040 130
2 1,432 1,040 130
2 1,692 1,040 130
2 1,952 1,040 130
2 2,212 1,040 130
2 10,662 16,640 2,080
92 36,430 1,708,560 213,570


After this again , my tool says that tablespace is 81% full. and i need to add datafile almost every 2 weeks. What would be better to do, keep on adding files or reorganize this.