RE: Large Redo Logs

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