On 0, "Michael D. Schleif" <[EMAIL PROTECTED]> wrote: > > Now that we have several filesystem types (ext2/3, reiserfs, &c.), where > can I go to find out pros and cons of each? Is there some > filesystem-selection-HOWTO? > > For instance, what is the best filesystem type on which to install a > database, specifically oracle? > > Also, setup and configuration hints are valuable (e.g., block size) . . > . > > What do you think?
I'm not a filesystem expert, but I'd say that a journaling filesystem like ext3 or reiserfs is wasted on Oracle, since it does far more journalling than the filesystem will ever do. Make sure you have your Oracle controlfiles backed up, logfiles replicated on more than one partition (preferrably more than one device), datafiles backed up regularly, and logfiles archived somewhere safe. As for the best FS for general use, I think you will get more conflicting opinions than is worth your while. Tom -- Tom Cook Information Technology Services, The University of Adelaide "Other people's priorities are endlessly odd." - Kingsley Amis Get my GPG public key: https://pinky.its.adelaide.edu.au/~tkcook/tom.cook-at-adelaide.edu.au
msg03888/pgp00000.pgp
Description: PGP signature