Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: big drives (36 gig ) and Oracle performance

Re: big drives (36 gig ) and Oracle performance

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 13 Aug 1999 11:47:38 +0100
Message-ID: <7p0t3v$5q8$1@soap.pipex.net>


Sorry I'm a little late

The concern I would have concerns the number of drives. For best performance you want log files on separate disks than the datafiles. you may wish to split datafiles across disks as well. If so buying 36gig disks is a bit of waste of time as you still need (say) 5 of them.

Niall
DBA
Audit Commission UK
Steve Perry <sperry_at_sprynet.com> wrote in message news:37AC9F10.A03F0E2E_at_sprynet.com...
> I was told by our sys admins that they're starting to buy 36 gig drives
> so that they can cut costs on our sp frames. Because of our space
> requirements and the current 9 gig drives are taking up too much space,
> they're going to replace them with 36 gig drives.
> I see a couple of big issues, but I'd like to hear some other opinions.
> 1.) each drive will hold 4 times the data, but my past experience has
> taught me that I won't get 4 times the performance
> 2.) the nodes (S7A) are used for multiple instances, if a drive does go
> down, it will affect all instances using that drive
>
> Question:
> Have others gone to these sized drives?
> How are you utilizing them?
> What other concerns should I be looking at?
> What tips do you have?
>
> Thanks,
> Steve
>
Received on Fri Aug 13 1999 - 05:47:38 CDT

Original text of this message

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