Re: Lets load test

From: Christo Kutrovsky <kutrovsky.oracle_at_gmail.com>
Date: Thu, 15 Dec 2005 13:23:53 -0500
Message-ID: <52a152eb0512151023h17d18e8bu859ba159654d9a99@mail.gmail.com>

Here's my results with ORABM:

Created with:

orabmload.10g.linux Warehouses 20

Followed by the rest of the loading procedures.

Then running:

/app/oracle/working/orabm/bin/linux> ./orabm.10g.linux 1,2,3,4 200000
---begin sess=1 txn=200000 ORACLE_SID=test64 Thu Dec 15 12:55:04 2005
test64 txn(all)=200000 xn(sam)=159999 t(sam)=170 tps=941 sl=80026(50%) on=48069(30%) oi=31904(19.9%) end=151205-12:58:37
---end - Thu Dec 15 12:58:37 2005
---begin sess=2 txn=200000 ORACLE_SID=test64 Thu Dec 15 12:58:37 2005

test64 txn(all)=200000 xn(sam)=159999 t(sam)=184 tps=870
sl=80247(50.2%) on=47811(29.9%) oi=31941(20%) end=151205-13:02:27
test64 txn(all)=200000 xn(sam)=159999 t(sam)=185 tps=865
sl=80227(50.1%) on=47981(30%) oi=31791(19.9%) end=151205-13:02:28

---end - Thu Dec 15 13:02:28 2005
---begin sess=3 txn=200000 ORACLE_SID=test64 Thu Dec 15 13:02:28 2005

test64 txn(all)=200000 xn(sam)=159999 t(sam)=197 tps=812
sl=79775(49.9%) on=48028(30%) oi=32196(20.1%) end=151205-13:06:33
test64 txn(all)=200000 xn(sam)=159999 t(sam)=197 tps=812
sl=80176(50.1%) on=48000(30%) oi=31823(19.9%) end=151205-13:06:34
test64 txn(all)=200000 xn(sam)=159999 t(sam)=197 tps=812
sl=80316(50.2%) on=47801(29.9%) oi=31882(19.9%) end=151205-13:06:35

---end - Thu Dec 15 13:06:35 2005
---begin sess=4 txn=200000 ORACLE_SID=test64 Thu Dec 15 13:06:35 2005

test64 txn(all)=200000 xn(sam)=159999 t(sam)=209 tps=766
sl=80171(50.1%) on=47908(29.9%) oi=31920(20%) end=151205-13:10:56
test64 txn(all)=200000 xn(sam)=159999 t(sam)=210 tps=762
sl=79416(49.6%) on=48453(30.3%) oi=32130(20.1%) end=151205-13:10:57
test64 txn(all)=200000 xn(sam)=159999 t(sam)=211 tps=758
sl=79817(49.9%) on=48072(30%) oi=32110(20.1%) end=151205-13:10:58
test64 txn(all)=200000 xn(sam)=159999 t(sam)=212 tps=755
sl=80433(50.3%) on=47922(30%) oi=31644(19.8%) end=151205-13:10:59

---end - Thu Dec 15 13:10:59 2005

Again, this is:

Oracle 10gR2
4x XEON 3.6 1 mb cache (8 virtual CPUs)
16 G RAM
12 Gb SGA
64 bit Linux RedHat 4 - 64 bit Oracle

--

Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group
--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 15 2005 - 12:25:36 CST