Re: Advice needed on move to Sun 15K (losing spindles)

Jay,

You will hit performance problems because of not having I/O bandwidth. Databases don't need storage, they need IO operations. Two important pieces of info that are missing from your post:

• How many databases in total are going to run on this Sun 15K ?
• How many concurrent users on all databases at the same time ?

Anjo.

"Miller, Jay" wrote:
>
> Our CIO has suggested that we get a Sun 15K to house all of our
> databases. This has some advantages (communication between the various
> boxes would be much faster) but I have some performance concerns.
>
> Specifically, our main OLTP database would go down from 18 spindles to 8
> spindles. Mirroring will take away 4 of those leaving 4 spindles. The
> vendor (Sun) was recommending striping across all 4 spindles. He said we
> don't need to worry about i/o issues because there will be a large cache.
>
> I'm skeptical and argued for cutting them in half (striping 2 and 2). We
> could then at least seperate the redo logs from the datafiles (probably
> putting them with the oracle executables and some other files).
>
> The Sun rep kept talking up how much more powerful the CPUs were and I kept
> saying, "but we're not CPU bound, we don't need any more CPU".
>
> If anyone can either
>
> a) tell me I'm worrying for nothing
> b) recommend a better way to stripe/distribute my files
> c) provide references or experience to show this is a bad idea
>
> I'd really appreciate it.
>
>
> Thanks,
> Jay Miller
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Miller, Jay
> INET: JayMiller_at_TDWaterhouse.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).