| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Large Redo Logs
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).
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).
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 Thu Apr 19 2001 - 16:08:43 CDT
 |
 |