Re: Lets load test

From: Ethan Post <post.ethan_at_gmail.com>
Date: Wed, 14 Dec 2005 10:13:15 -0600
Message-ID: <357b48a90512140813l64166d2dg7703df0727379193@mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 14 2005 - 10:14:13 CST