How about the partition affect the INSERT performance?
We have an application which need great insert performance: we need to keep the most current 90 days data, there are about 60M records a day and We must insert 200000 records within 5 minutes successfully. Please give me suggestion how to do the partition properly or other solutions:
My plan is use both partition and sub partition: The first level partition is based on day of 365 (that's 365 partitions, so that I can move stale records easily), the second level function I want to use hash function based on customer name.
Best
Subject
Views
Written By
Posted
How about the partition affect the INSERT performance?
4844
January 10, 2008 10:30AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.