Re: Lets load test

From: Christo Kutrovsky <kutrovsky.oracle_at_gmail.com>
Date: Wed, 14 Dec 2005 12:56:32 -0500
Message-ID: <52a152eb0512140956l4a16f59dv4e208695549b11bf@mail.gmail.com>

Ethan,

Test results with 5 million / 10k commit of your scripts:

Wed Dec 14 12:38:02 EST 2005 Benchmark Results v_rows=5000000 | v_parse=1000 | v_commit=10000

INSERT APPEND INTO BENCHMARK                       : 00:00:19.63
GATHER TABLES STATS                                : 00:00:01.90
CREATE TABLE LOGGING                               : 00:00:09.71
UPDATE COLUMN                                      : 00:02:34.21
DELETE ALL FROM TABLE                              : 00:01:04.98
DROP TABLE                                         : 00:00:17.55
CREATE TABLE NOLOGGING                             : 00:00:07.85
INSERT/COMMIT LOOP                                 : 00:00:00.01
BULK UPDATE                                        : 00:02:08.65
TRUNCATE TABLE                                     : 00:00:00.18
ADD COLUMN NUMERIC DEFAULT                         : 00:02:20.82
ADD COLUMN CHARACTER DEFAULT                       : 00:03:16.27
DROP NUMERIC COLUMN                                : 00:01:38.53
DROP CHARACTER COLUMN                              : 00:01:42.84
HARD PARSE                                         : 00:00:00.23

Starting with 50 m. I will work on gething Mark's test suite after that.

On 12/14/05, Ethan Post <post.ethan_at_gmail.com> wrote:
> 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

Received on Wed Dec 14 2005 - 11:56:44 CST