Skip to Content
Mar 15, 2013 at 09:24 AM

Table Splitting question / system copy



we are migrating from Oracle DB on AIX to Exadata. The database is ~5 TB, the biggest table is CE10200 with 550 GB.

Report UMG_R3LOAD_RUNTIME_PREDICTION recommends a split factor 6 for this table.

I think this factor is too small. Does anyone have a reference for splitting tables? 90 GB for one package seems too large for me. I think 10 - 15 GB is a better value but i can't estimate the impact to the db performance / export performance when splitting the table to 50 packages.

I can't find a best practise for this topic. Maybe we can document a reference here 😊

Thanks for your help.