We have about 50 Oracle databases we are wanting to combine into one large
database. This new database all the data files will reside on a SAN.

My question is, when your data files are stored on a SAN and you have a large
table with about 1 billion records would you get any performance improvements
by partitioning it?
Or should you just leave it as one very large data file?

Any insight on this would be appreciated.

Thanks,
Mark



Oracle LazyDBA home page