Datfiles/logfiles layout

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Fri, 2 Jul 2004 10:23:31 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C5187D9248@ex2003.metratech.com>

Hi,

We are setting up the oracle database machine and layout the files as following.=20
Env 10g on Win2k
2 cpu xeon processor box
2 raid array (raid 0, since this is testing) of 14 36G each and controller for each
Current layout:
Oracle software, control file, Rollback tablespace, temp tablespace, index tablespace(100GB file with extent sixe of 512MB) on 1 raid array
(H:)

Table tablespace (100GB file with extent size of 1GB), redo logs on another array (I:)

We are testing insert performance where we are selecting from IOT table
(on H:) and inserting into another table (on (I:) and its indexes on
(H:)

Is this configuration looks ok or what are the changes that we can try?

Thanks
--Harvinder

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
-----------------------------------------------------------------

Received on Fri Jul 02 2004 - 09:20:26 CDT