Bill: In theory I don;t see any reason for not using UFS logging in file systems. But as far as the performance goes, you will see a slight decrease since the system has to do more work than the normal logging. But your recovery will be very fast after the crash since 'fsck' will be completed in seconds (bypassed??) in UFS logged systems.
On the other hand Oracle Transactions are already logged in the redo logs and you will not see any benefit/performance from the rdbms with UFS logged file systems. But this will definitely help you in speeding up the media recovery, startup-shutdown operations and any type of file transfers. KG -----Original Message----- Sent: Wednesday, September 18, 2002 3:43 AM To: Multiple recipients of list ORACLE-L Hi all, Can anyone share any experience of the "logging" option on Solaris 8 filesystems with regard to Oracle and performance. I've just inhereted a second hand Sun box to use as a test machine and the filesystems are already set up with this option for both redo log disks and datafile disks. The disks are also set up for buffered i/o which I'm tempted to change to forcedirectio, but I'd prefer to just change one thing at a time and see what happens! Any info much appreciated. - Bill. -- Intasys Billing Technologies Ltd. www.intasysbilling.com 74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
