I need info on large databases. In Oracle or SQL Server.
Specifically, how big is big?
... need a repository of detail transactions for a client

they do 2 Billion transactions anually ... @ 500 bytes each (real gross) after a little performance-based data modeling, we're looking at a terrabyte. I can split it into 20 "clumps" -- nearly all work is done within a clump, but would need some management reporting across the whole set.

we need to add 8-10million transactions each day.

Can you help give me some perspective on this? If not, can you tell me who can?