Performance is definitely something that requires a lot of attention. We leveraged the Oracle SQL Tuning Advisor and Oracle's Enterprise Manager Grid Control to tune queries and add some indexes before we went into production. That was a big benefit for us. |
Since we're using partitioning, it allows us to easily purge data by simply removing partitions from the table as data ages, as opposed to trying to do massive data deletes or creating new tables. |