About that large data store:
- Do updates/inserts/deletes come all day? How time-critical are they? Are they independent of each other or come in large transactions?
- How many indices do queries use? Can table be effectivelly partitioned on all of them? Some of them?
- Does particular version of Oracle support read-only replicas?