Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!nx01.iad01.newshosting.com!newshosting.com!news.alt.net!newsfeed.east.grouptelecom.net!news.east.grouptelecom.net!not-for-mail From: "Sam" Newsgroups: comp.databases.oracle.server Subject: Are you good on Performance, Raid and configuration Date: Thu, 15 Mar 2007 15:41:43 -0700 Organization: Group Telecom - a 360networks Company Lines: 29 Message-ID: NNTP-Posting-Host: h216-18-8-180.gtcust.grouptelecom.net X-Trace: utornnr1pp.grouptelecom.net 1173998376 16700 216.18.8.180 (15 Mar 2007 22:39:36 GMT) X-Complaints-To: abuse@gt.ca NNTP-Posting-Date: Thu, 15 Mar 2007 22:39:36 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-RFC2646: Format=Flowed; Original Xref: usenetserver.com comp.databases.oracle.server:424254 X-Received-Date: Thu, 15 Mar 2007 17:42:04 EST (text.usenetserver.com) Hi everybody, I need your opinion for a few basic performance and configuration questions, I have a database with a mix amount of read and write and I have a new computer that support Raid with SCSI hard disk, the environment is a development/test environment and redundancy is not important right now,(Just performance is important right now) I just have 2 hard disk available right now, which one give me better performance: 1. Mirroring 2. No Mirror and install OS on first hard disk and Oracle on second hard disk Second questions , How do you place different oracle files: Data Files, Index Files, Log Files? For example if you select number 2 (No Mirror) on witch hard disk you put Data files, index files and so on to get a better performance? Thanks you in advance - Sam