Re: database layout question

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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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.
--





----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------



text/x-vcard attachment: Card for Don Jerman