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 -> Re: Reorganizing a database that has raw partions

Re: Reorganizing a database that has raw partions

From: BBurtensha <bburtensha_at_aol.com>
Date: 1997/11/29
Message-ID: <19971129210901.QAA06220@ladder02.news.aol.com>#1/1

Why do you want to move away from raw? We get significantly better performance using raw logical volumes vs. jfs. If your raw devices are raw logical volumes you can easily move those around, to different physical drives within the volume group, using migratepv in order to balance i/o. This can be done while the system is up and in use.

We use one volume group, oravg, and individual raw logical volumes for each tablespace. We don't os-stripe our lv's because we mirror them, however we have used Oracle striping. By keeping everything in one vg we have all of our disks assigned and available so that we have the option of spreading those mirrored lv's across the maximum number of physical devices.

It may still be wise to export and import your database to clean it up and restructure your tablespaces. We do this on a regular basis.

Our main systems is an eight node SP2 running 4.1.4 with 80 4.5GB SSA disks. I've got about 14 instances on 5 of those nodes.

Good luck,
Barry Received on Sat Nov 29 1997 - 00:00:00 CST

Original text of this message

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