Although it would be difficult to prove, you could
always (once the volumes and file systems are created)
try creating your high usage stuff first (redos etc
etc) and "hopefully" it will land where you want it to
go.
You could then try the reverse (add the high use stuff
last) and see which is faster. You could then make
some deductions about whats going on
hth
connor
- KC <kchan_at_speednet.com.au> wrote: > 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).
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).
Received on Wed Jun 20 2001 - 11:08:02 CDT
