Re: database layout question
- From: Don Jerman <djerman@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 04 Mar 2004 10:47:18 -0500
What you suggest sounds reasonable if the performance is what you expect.
I assume swap is on the 18G 15k disks.
We're gearing up on SAN-connected IA-32 boxes. We find that the SAN is
significantly faster than internal drives, so I would (if I were you) plan
to check on that in your setup before committing on the
internal-vs-external allocation of the 144G devices. Entry-level vs.
enterprise is significant, but our mini-SAN is still faster than our
internal storage.
Ron Rogers wrote:
> List,
> I am privileged today and will be receiving a new server to replace
> the old production server. I do not have a choice on the disk
> environment provided. I only have a recommendation on the OS and I
> recommended that we use RedHat AS.
> The server will have a tape autoloader connected for tape archival of
> the daily database backups.
> The server will have 4 sets of mirrored drives in the following
> configuration;
> 2 - 18 GIG internal 15K rpm
> 2 - 72 GIG internal 10K rpm
> 2 - 144 GIG internal 10K rpm
> 2 - 144 GIG SAN 10K rpm
> currently the database creates about
> 100 Meg of archivelog data each morning with the daily data load
> loads approx 200,000 rows of data each morning
> has 4 GIG temp space assigned
> has 4 GIG redo space assigned
> has 45 GIG data space assigned
> has 45 GIG index space assigned
> The server is basically a warehouse but has 6 applications that are
> OLTP generating a small amount of activity.
> The database uses LMT with autoextend for the data and index files.
> My question is.. with the listed configuration where would you suggest
> I install the Oracle and the datafiles?
> I think that ;
> OS should reside on the 18 GIG drive
> Oracle binaries, redo, system, temp reside on the 72 GIG drives
> data and index reside on the internal 144 GIG drives
> archivelogs and the backups reside on the 144 GIG SAN drives.
> would perform best as the Oracle will not need to use the SAN for it's
> daily activities and this is an ENTRY level SAN not an ENTERPRISE SAN
>
> I woud like to use Oacle 10g if I can get it loaded and familiar with
> it on my play box, otherwise I will use 9.2.0.4
>
> Any suggestions appreciated
> Ron
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
--
E-mail correspondence to and from this address may be subject to
the North Carolina Public Records Law "NCGS.Ch.132" and may be
disclosed to third parties by an authorized state official.
--
begin:vcard
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:djerman@xxxxxxxxxxxxxxx
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information
Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard
Other related posts:
