I have to create a table. The average length of a record is 100 bytes and the average growth of that table is 12.000.000 records each day.
All old records are deleted every 2 days then the table must keep 24.000.000 online.
The DB Block Size is 8192.
I know that the pctincrease should be zero, the initial and next extent shoul have the same size which is ??
What are the best values for the storage clause (initial, next, pctfree, pctused) ?
I don't know the answers to your specific questions, but this sounds like a prime candidate for using partitions if ever I saw one! Then you won't be deleting 24 million records every other day, you will just drop the oldest partition and add a new one. Each partition will need to be sized for 24 million records (2.4GB if my maths is correct).