catch.saravana
Member
Hi All,
The existing DB (Size 2 TB) on 9.1E version has got all variable extents (963 tables split across 55 data and 55 index area) where the segregation of tables are based on functionality which doesn't seem to be a good design. We are migrating to 11.6 version; as part of our migration we have segregated the tables based on the # of rows, mean record size and transaction load. I have to make a decision to either go with either variable or fixed extent; based on what parameters should I take my decision (what all I should take into consideration)?
I have hand picked some 20+ tables out of the 963 tables put it in a separate excel sheet and have attached to this thread for your reference (replaced the table/db names with dummy names - sorry for that).
Overall there are,
23 Large Size Tables (separate area)
10 Medium Size Tables (separate area)
88 Small Size Tables (segregated to 3 different areas)
842 Very Small Size Tables (segregated to 3 different areas)
If in case you suggest fixed extents and 1 variable extent for each area, what could be the size of each extent? How do I decide the size of each extent?
Regards,
Saravanakumar B
The existing DB (Size 2 TB) on 9.1E version has got all variable extents (963 tables split across 55 data and 55 index area) where the segregation of tables are based on functionality which doesn't seem to be a good design. We are migrating to 11.6 version; as part of our migration we have segregated the tables based on the # of rows, mean record size and transaction load. I have to make a decision to either go with either variable or fixed extent; based on what parameters should I take my decision (what all I should take into consideration)?
I have hand picked some 20+ tables out of the 963 tables put it in a separate excel sheet and have attached to this thread for your reference (replaced the table/db names with dummy names - sorry for that).
Overall there are,
23 Large Size Tables (separate area)
10 Medium Size Tables (separate area)
88 Small Size Tables (segregated to 3 different areas)
842 Very Small Size Tables (segregated to 3 different areas)
If in case you suggest fixed extents and 1 variable extent for each area, what could be the size of each extent? How do I decide the size of each extent?
Regards,
Saravanakumar B