RE: Lets load test

SAN, DAS or NAS ? 


________________________________

        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ethan Post
        Sent: Wednesday, December 14, 2005 8:13 AM
        To: kutrovsky.oracle@xxxxxxxxx
        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@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
                --
                http://www.freelists.org/webpage/oracle-l

Other related posts: