What is the threshold to decide whether partitioning is needed or not?
450319Feb 13 2012 — edited Feb 13 2012I have an oracle 10g enterprise edition but partitioning option is not purchased yet. I foresee the total amount of data by the end of year 2012 would be about 200 to 300 GB and by end of year 2013 will be 400 GB, year 2014 will be 500 GB. There may be four or five tables with about 2 million records (and these will be the biggest tables).
I have read that partitioning is definitely needed when the size of the database exceeds 500 GB. Are there any other criteria/threshold which suggests at what point in time the partitioning option needs to be recommended?