| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: UFS logging
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 wbuchan_at_uk.intasys.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: wbuchan_at_uk.intasys.com
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Wed Sep 18 2002 - 06:08:34 CDT
 |
 |