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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Christian Antognini Sent: Friday, February 02, 2007 3:01 AM
To: oracle-l_at_freelists.org
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_at_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_at_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