Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> redo log on veritas filesystem

redo log on veritas filesystem

From: <dominica_at_gmail.com>
Date: 1 Mar 2005 15:42:07 -0800
Message-ID: <1109720526.968682.36580@z14g2000cwz.googlegroups.com>


Hi All,

   I am just wondering what other companies do with your redo logs if you are using Veritas filesystem. Shouldn't the redo logs be put on regular SCSI disk or on the Veritas filesystem? I mean for database performance aspect, will oracle writing the redo logs slower if it is on Veritas filesystem.

Let me tell you my configuration.
Currently, my work's database is 8.1.7.4 (32 bit) running on SUN's hardware. Database is around 340 Gig. (I inherit this database, I am NEW to this company).

OS version:
5.9 Generic_117171-02 sun4u sparc SUNW,Sun-Fire-V440

Every 5 or 10 minutes is switch to another redo log. Redo log is 200 Meg. Archive log mode on.

Currently redo logs are on VERITAS FILESYSTEM:

/dev/vx/dsk/INSTANCE_NAME/U01
/dev/vx/dsk/INSTANCE_NAME/U03

And this veritas filesystem is actually make up of multiple disks. The name is U01 or U03, but it is actually configure through Veritas filesystem from a bunch of disks.

My question is: shouldn't redo logs be on a regular unix file system, like on a dedicate SCSI disk. And make that SCSI disk 0+1.

P.S. I am planning to upgrade this database to 9.2 or 10g soon.

Thanks in advance,

Dominica Received on Tue Mar 01 2005 - 17:42:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US