Re: Disk configuration

Connor,

It would be easy if I am the SysAdmin, our Mr. Unix here doesn't like raw just because he can't see the files in the file system. I am just exploring different ways to stripe the disk, I noticed that we made one subdisk for each disk and stripe the volume on them. This is quite different to the places I worked before, people create subdisks on the outer and inner tracks of the disk and stripe one volume on the outer tracks subdisk and another for the inner tracks, I assumed people do that for performance reason, any ideal on issue you will have for having one subdisk per disk? I agreed that raw is the best in term of performance.

KC

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Wednesday, June 20, 2001 6:04 PM

>If you are going to that level for performance
>reasons, I would seriously consider using raw
>partitions to avoid the issue.
>
>hth
>connor
>
>--- KC <kchan_at_speednet.com.au> wrote: > Kevin,
>>
>> Thanks for your input. I was trying to put certain
>> datafiles on contiguous disk space, tell me if I am
>> wrong, I try to avoid the situation where you want
>> to create a 2G file, but the file system don't have
>> a 2G contiguous space, so your flle is broken into
>> multiple pieces, can that happen??
>>
>> KC
>> -----Original Message-----
>> From: Kevin Lange <kgel_at_ppoone.com>
>> To: Multiple recipients of list ORACLE-L
>> <ORACLE-L_at_fatcity.com>
>> Date: Wednesday, June 20, 2001 1:22 AM
>> Subject: RE: Disk configuration
>>
>>
>> It all depends on what kind of os/filesystem/and
>> disks you have. I know that under AIX, using SSA
>> drives we could actually tell where on the disk we
>> wanted the filesystem to go. This way we could
>> position certain things in the faster location.
>>
>> But personally, I would not go thru the trouble.
>>
>> I have never had a DB slowdown so far because of
>> placement on the drive. Admittadly, I have had
>> probelms based on putting conflicting tables/indexes
>> on the same drive .... you want to keep things that
>> could be access simultaneously on different media.
>> But other than that .... no other conflicts.
>> -----Original Message-----
>> From: KC [mailto:kchan_at_speednet.com.au]
>> Sent: Tuesday, June 19, 2001 9:36 AM
>> To: Multiple recipients of list ORACLE-L
>> Subject: Disk configuration
>>
>>
>> Dear List,
>>
>> Someone told me when a disk receive a write
>> request, it write to the nearest free space on disk
>> where the disk read/write head is currently
>> positioning, is this information correct?? If this
>> is true, is this a bad thing for database
>> application?? That mean we can't really control
>> where the file go, for performance purpose we may
>> want to put certain files on the outer tracks of a
>> disk, if the write location is depending on where
>> the read/write head is, how can we avoid that, can
>> we create subdisks from the outer track of a disk
>> and create a logical volume from it??
>>
>> KC
>>
>
>
>=====
>Connor McDonald
>http://www.oracledba.co.uk (mirrored at
>http://www.oradba.freeserve.co.uk)
>
>"Some days you're the pigeon, some days you're the statue"
>
>____________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
>or your free @yahoo.ie address at http://mail.yahoo.ie
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: =?iso-8859-1?q?Connor=20McDonald?=
> INET: hamcdc_at_yahoo.co.uk
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: KC
  INET: kchan_at_speednet.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).