Re: Large Redo Logs

Damn Haskins!! You are the man!
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, April 20, 2001 12:40 PM

> Kev,
>
> In many organizations, the System (server) Admin is not the same person
who
> is the DBA. If the DBA doesn't know any better, and plenty of DBAs don't
> know the OS level as well as they should...it is possible that the Sys.
> Admin. setup the file system in a way that he felt was appropriate
(possibly
> 1 drive as C:\ and the next 3 drives as D:\ in an extended partition, and
> the following 3 drives as E:\ in another extended partition. Why did he
or
> she do that? Because the DBA told him that he needed two partitions
> (besides the System Partition) that contained 27GB of space, each. Well,
> the System admin only had 9GB hard drives, so he created the two
partitions
> as "extended partitions" using multiple HDs until it equaled the DBAs
> requirement of 27GB. He or she didn't know an better!!
>
> I agree that the explanation was too vague, but that's my take on it.
>
> Ed Haskins
> Oracle DBA
> Verizon Wireless
>
>
> -----Original Message-----
> Sent: Friday, April 20, 2001 11:51 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Ed,
> Good example, but why would anyone ever do that in the first place? I
> think that it is just not a very well said and explained statement.
> Kev
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Thursday, April 19, 2001 6:00 PM
>
>
> > Yes, I can...I think.
> >
> > What it is saying is...it is possible to have a volume or partition
> extended
> > over multiple disks. For example; you can have 2 4GB Hard Drives, and
it
> is
> > possible to Format Drive 1 as let's say Drive D:\, then format 2GB of
> Drive
> > 2 and add it as an "Extended Partition" of D:\. If you have a 5GB
> datafile
> > (or index), the file would be on one "logical" partition, but two
physical
> > hard drives.
> >
> > You don't want to do this! Thus, "Never split index and data files to
> > different sets of disks." (UNLESS: you are using RAID...then it makes
> sense
> > that your datafiles will be spread over multiple disks).
> >
> > Hope that helps!
> >
> > Ed Haskins
> > Oracle DBA
> > Verizon Wireless
> >
> >
> > -----Original Message-----
> > Sent: Thursday, April 19, 2001 4:56 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Whoaaa, I sure hope someone can, because I have never heard that before?
> > Kev
> >
> > -----Original Message-----
> > Ghosalkar
> > Sent: Thursday, April 19, 2001 4:36 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Guys,
> >
> > i was checking my statspack report on oraperf and i came across this
> > statement.
> >
> > "Never split index and data files to different sets of disks."
> >
> > can anyone xplain the logic behind this.
> >
> > Thanks
> > Mandar
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Mandar Ghosalkar
> > INET: MandarG_at_gsr-inc.com
> >
> > 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: Kevin Kostyszyn
> > INET: kevin_at_dulcian.com
> >
> > 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:
> > INET: Ed.Haskins_at_VerizonWireless.com
> >
> > 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: Kevin Kostyszyn
> INET: kevin_at_dulcian.com
>
> 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: Haskins, Ed
> INET: Ed.Haskins_at_VerizonWireless.com
>
> 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: Kevin Kostyszyn
  INET: kevin_at_dulcian.com

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).