Hi,

As it is said that Many Extents of a segment doesn't degrade the performance. Then for what reasons reorganization is done. Just to recollect the waste space....

I have a table of size 17 GB, with 41973583 Rows, 247 extents.

Earlier its Storage parameters were set as Intial 16 KB, Next 16 KB PCT increase 0. SAP calculates the next extent and its current next extent is 1310720 KB.

Monthly growth of the table is approx 1400000 KB. Generally only inserts are happening in this table. Therefore I don't expect much waste space.

Shall I reorganize this table with Initial 1310720, next 1310720. In this way its extents will be reduced, what other gains I'll have.

Since I m running on 8i, therefore no limitations of extents is there.

Do I need to Reorganize this table.

Vijay