I'm still using 2G files, even though I've got big files enabled. You never know when you're going to come across something (e.g. /usr/bin/tar) that doesn't like files larger than 2G.. I have a relatively small (< 0.5TB) database though.. Rich -- Rich Holland (913) 645-1950 SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`"); _____ From: Prem Khanna J [mailto:premj@xxxxxxxxxxxxxx] Sent: Sunday, July 11, 2004 11:19 PM To: oracle-l@xxxxxxxxxxxxx Cc: Rich Holland Subject: Re[1]:AIX and Largefiles Performance Rich , we have a similar env (oracle 9.2.0.4/AIX5.2). what would be your suggestion max datafile size in case of JFS ? Thanks and Regards, Prem. On Sat, 10 Jul 2004 Rich Holland wrote : >Byron, > >Any chance you can forward the tuning paper along? I'm interested in reading a >copy. I'm currently running half a dozen ERP systems on Oracle 9204, AIX >51-003 and having no problems with the bf option on native JFS. From the tiny >bit of reading I've done about JFS2, I'd worry more about performance there >than via JFS -- I made the decision early on to stick with JFS, and haven't >been disappointed. We've survived multiple power outage crashes, fibre channel >disconnections, etc. It's been solid, and performed well -- we're using a pair >of FCS adapters to SAN disk on an EMC via FC switches, and to be honest I don't >think the client can generate enough workload to really stress the I/O >configuration here... :-) > >Rich <http://clients.rediff.com/signature/track_sig.asp> ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------