Re: Lets load test
- From: Ethan Post <post.ethan@xxxxxxxxx>
- To: kutrovsky.oracle@xxxxxxxxx
- Date: Wed, 14 Dec 2005 10:13:15 -0600
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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
