extents question 1

[watergrinder]

we have a table with 10.4 million records.

segment_type = table
header_file=9
header_block = 671737
bytes= 482918400
blocks = 58950
extents = 343
initial_extent = 14909440
next_extent = 4194304
min_extents = 1
max_extents = 800
pct_increase = 0

Tablespace: Dictionary managed

About 8-900,000 new records are created per month, about 25k daily.

How is this table growing? How many times MAXEXTENTS could be done on this table? Is there a limit? And how does this influence tablespace? Any suggestions/explanations will be very useful.

 

[watergrinder]

Forgot to tell, D/B version is 8.1.7.0.0. Thanks

 

[watergrinder]

Any answers? At the rate at which the table is currently increasing do you see any problems?

 

[alexhu]

You have used 343 extents

You have 800 - 343 = 457 left if you do not change MAXEXTENTS

So you have 457 * 4194304 bytes left to extend

Which is 1828MB

25k daily gives you 4 days per MB = 7312 days (20 years +) left before you run out of extents

Alex