| 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
yes,
as UNIX sysadmin, I can say this
The logging parameters is insteresting when you put it as parameter inside /etc/vfstab
What says the manual (RTFM :-;)
" logging | nologging
If logging is specified, then logging is
enabled for the duration of the mounted
file system. Logging is the process of
storing transactions (changes that make up
a complete UFS operation) in a log before
the transactions are applied to the file
system. Once a transaction is stored, the
transaction can be applied to the file sys-
tem later. This prevents file systems from
becoming inconsistent, therefore eliminat-
ing the need to run fsck. And, because
fsck can be bypassed, logging reduces the
time required to reboot a system if it
crashes, or after an unclean halt. The
default behavior is nologging.
The log is allocated from free blocks on
the file system, and is sized approximately
1 Mbyte per 1 Gbyte of file system, up to a
maximum of 64 Mbytes. Logging can be
enabled on any UFS, including root (/).
The log created by UFS logging is continu-
ally flushed as it fills up. The log is
totally flushed when the file system is
unmounted or as a result of the lockfs -f
command. "
So, the fsck phase is bypassed
Yes, you can use forcedirectio with the logging option as I did. If I remember exactly, I put also the following option "onerror=umount", that makes me sleeping very well at night.
cheers
Cordialement,
Jean-yves Torres - UNIX system administrateur
) 59 80 91 Direct : 04 72 66 40 91 Mobile : 0613 477 747 -
DSIT/XM/USR
25C quai P.Semard - 69350 La Mulatiere - France
% ext.steria.torres_at_sncf.fr <mailto:ext.steria.torres_at_sncf.fr>
"Contrary to popular opinion, Unix is user friendly, It just happens to be very selective about who it makes friends with."
-----Message d'origine-----
De : Bill Buchan [mailto:wbuchan_at_uk.intasys.com]
Envoye : mercredi 18 septembre 2002 12:43
A : Multiple recipients of list ORACLE-L
Objet : UFS logging
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:13:26 CDT
 |
 |