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: need your help in physical design

Re: need your help in physical design

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 05 Dec 2005 09:22:26 -0800
Message-ID: <1133803327.886184@jetspin.drizzle.com>


zvika wrote:
> hello,
> my currently database is 50 gb (win nt) and the file location is :
> dbf in drive g and f
> (indexes seperate from tables and i know it's not contribute to
> performance.
> redo logs in drive g
> muliplex redo logs on g drive
> control file on f,g,h drives.
> archive logs on h drive
> oracle software on f drive
>
> drive f,g,h are mirrored
>
> i need to plan the physical structure of the new computer which has:
> c drive 36 GB mirror (system drive)
> 146GB disk mirror
> 3 X 72GB disk mirror
>
> my plan is:
> 146 GB disk for archive and backup
> 2 X 72GB disks for dbf
> 1 X 72 GB disk for online redo logs
> oracle software on system drive
> control files multiplexed across 3 drives
>
> i'm not sure if it's the best plan so i'm asking you .
>
> thanks
> zvika

Does the machine have a RAID controller? Look into SAME (Stripe And Mirror Everything).

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Dec 05 2005 - 11:22:26 CST

Original text of this message

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