RE: Lets load test

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Wed, 14 Dec 2005 08:35:47 -0800
Message-ID: <B9782AD410794F4687F2B5B4A6FF3501021D54C2@ex1.ms.polyserve.com>

SAN, DAS or NAS ?

---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ethan Post

	Sent: Wednesday, December 14, 2005 8:13 AM
	To: kutrovsky.oracle_at_gmail.com
	Cc: oracle-l
	Subject: Re: Lets load test
	
	
	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
		
		
		

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 14 2005 - 10:35:59 CST