RE: How many of you use S.A.M.E?

And on the same thread:

http://kevinclosson.wordpress.com/2006/12/15/the-60-allocation-rule-orac
le-tpc-h-proves-hard-drives-are-still-round/





-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Christian Antognini
Sent: Friday, February 02, 2007 3:01 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: How many of you use S.A.M.E?

> By the way have you tried by chance what Loaiza suggested,
> putting data in specfic physical sectors of a hard drive?
> I am really curious how can that be achieved. S.A.M.E is
> simple but putting data as he says makes life impossible
> dont you think so?

Hi

I'm just formatting a new SAS disk, therefore here an example...

With fdisk I divided the disk in 4 partitions which have the same size.
Basically for each of them I simply specify the start/end cylinders.

At the end I have the following situation:

[root@helicon .vnc]# fdisk -l /dev/sda

Disk /dev/sda: 73.4 GB, 73407820800 bytes
255 heads, 63 sectors/track, 8924 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1               1        2231    17920476   83  Linux
/dev/sda2            2232        4463    17928540   83  Linux
/dev/sda3            4464        6695    17928540   83  Linux
/dev/sda4            6696        8924    17904442+  83  Linux

And here a quick performance test with hdparm:

[root@helicon .vnc]# hdparm -t /dev/sda?

/dev/sda1:
 Timing buffered disk reads:  252 MB in  3.01 seconds =  83.73 MB/sec

/dev/sda2:
 Timing buffered disk reads:  234 MB in  3.01 seconds =  77.62 MB/sec

/dev/sda3:
 Timing buffered disk reads:  214 MB in  3.00 seconds =  71.27 MB/sec

/dev/sda4:
 Timing buffered disk reads:  190 MB in  3.01 seconds =  63.22 MB/sec


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


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

Other related posts: