Re: Lets load test

IBM FastT 900 (new name DS 4500)
SAN Fibrechannel, 2 gbit (tested max 200 Mb/sec)

2 arrays in mirror with 36 gb drives for REDO (not multiplexed) 1 array 8x 73 gb (15k rpm) in raid 5 256Kb stripe

Controller has 1 gb cache, 2 controllers.

All ASM (except archived redo log destinations)

Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group

On 12/14/05, Kevin Closson <kevinc_at_polyserve.com> wrote:
> SAN, DAS or NAS ?
>
> ________________________________
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Ethan Post
> Sent: Wednesday, December 14, 2005 8:13 AM
> To: kutrovsky.oracle_at_gmail.com
> Cc: oracle-l
> Subject: Re: Lets load test
>
>
> I have a benchmark script I would like you to try, will send you the
> attachment in a seperate email. Be interested in seeing the numbers, it is
> very easy to run. I will post the script on the web when I get a chance for
> everyone.
>
> -Ethan
>
>
> On 12/14/05, Christo Kutrovsky <kutrovsky.oracle_at_gmail.com> wrote:
> > I have a relativelly fast machine for testing.
> >
> > It's a 4 cpu XEON 3.6 ghz with 1 mb of cache
> > 16 gb of ram
> >
> > and a lot of fast storage.
> >
> > It's running RedHat linux 4 64 bit with 64 bit Oracle 10g and ASM.
> >
> > Throw your ideas if you would like to see something tested, it's
> > sitting idle right now.
> >
> > I just finished setting it up, so i am running some very raw tests.
> >
> > For example, I created a 3.68 gb table with ~40m rows from
> > dba_objects. Exact size is:
> >
> > 3'959'422'976 bytes
> > 38'653'952 rows
> >
> > It's gething full scanned for 5.05 cpuseconds. (482008 logical reads,
> > no physical).
> >
> > If anyone wants to see something let me know. There's 500 gb of
> > storage available.
> >
> > --
> > Christo Kutrovsky
> > Senior Database/System Administrator
> > The Pythian Group
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>

--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l