Let me see! hehe. Awwwwww, yes! What about Oracle Database 10G Release 2 and "BIGFOOT"! hehe.

I mean "bigfile"! hehe.








Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Rhoades Mark A SPL Contractor
[mailto:oracledba-ezmlmshield-x86410554.[Email address protected]
Sent: Wednesday, May 31, 2006 1:12 PM
To: LazyDBA Discussion
Subject: Oracle and SAN


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




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page