Re: Lets load test
- From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
- To: Ethan Post <post.ethan@xxxxxxxxx>
- Date: Wed, 14 Dec 2005 12:56:32 -0500
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@xxxxxxxxx> 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@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
> >
> >
> >
>
>
--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group
--
//www.freelists.org/webpage/oracle-l
Other related posts:
