| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Lets load test
I show you are about 10 times faster than
OS = SUN SOLARIS 8 (64 bit)/Oracle 9.2.0.4 (64 bit)
CPU = 6 x 900 MHz
Mem = 12 GB
My SGA was about 1GB and I ran with 500,000 rows ~35MB table. The disk is direct attached and I have not optimized the file layout. This is a test box.
My laptop, Dell Latitude D600 1.4 Ghz faired a little better than the Sun box.
I am not using any type of parellelism in my tests so the benchmark is only making use of 1 CPU in my tests.
Sun Box Results with 500,000 rows.
INSERT APPEND INTO BENCHMARK : 00:00:31.97 GATHER TABLES STATS : 00:00:14.69 CREATE TABLE LOGGING : 00:00:01.98 UPDATE COLUMN : 00:01:10.21 DELETE ALL FROM TABLE : 00:01:42.20 DROP TABLE : 00:00:05.54 CREATE TABLE NOLOGGING : 00:00:01.97 INSERT/COMMIT LOOP : 00:00:04.36 BULK UPDATE : 00:01:40.70 TRUNCATE TABLE : 00:00:01.46 ADD COLUMN NUMERIC DEFAULT : 00:01:19.84 ADD COLUMN CHARACTER DEFAULT : 00:03:17.52 DROP NUMERIC COLUMN : 00:02:16.66 DROP CHARACTER COLUMN : 00:02:02.07 HARD PARSE : 00:00:04.76
On 12/14/05, Christo Kutrovsky <kutrovsky.oracle_at_gmail.com> wrote:
> 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-lReceived on Wed Dec 14 2005 - 14:29:40 CST
 |
 |