RE: How to organize oracle directories in Unix ?
As long as your mount points are not sharing disks from the same volume group you are correct. However, its expensive to write to RAID 5 which is why you will usually see raid 0+1 instead. -Original Message- Sent: Sunday, September 09, 2001 7:55 AM To: Multiple recipients of list ORACLE-L Hi Joe, What's your configuration ? Raid 1 ? How do U organize the oracle directories ? Correct me if I am wrong. I thought though I use Raid 5 but with different mount points, I will not have contention problems For example One mount point for data files Another mount point for index files. Please advise. Thanks. Regds, New Bee -Original Message- To: Multiple recipients of list ORACLE-L Sent: 09/09/2001 8:30 PM if u dont know the underlying striping and someone else built the filesystes, then the point is moot, you might as well have one logical disk, since you cant reallt guarantee where something is going to end up anyways. with all of the raid5 stuff(that evryone likes so much anymore), we as DBAs dont have control over where stuff is, so a good backup/recovery plan is a must, at least in the old days when a physical device was mapped to a filesystem(pre-logical volume days), we could handle making sure of duplexing redo logs, etc. joe "CHAN Chor Ling Catherine (CSC)" wrote: > > Hi Guru, > > How do you organize your oracle directories in Unix ? > > I am thinking of using the configurations below. We are using Raid 5 with > various mount points. > > \dg1\oracle => contains Oracle Human Resources software applications and > oracle home .eg. sidappl, sidcomn, sidora > > \dg2\oracle => contains redo log file and control file eg. sidredo & sidctrl > > \dg3\oracle => contains redo log file and control file eg. sidredo & sidctrl > > \dg4\oracle => contains redo log file and control file eg. sidredo & sidctrl > > \dg5\oracle => system tablespace file and temp tablespace data file .eg. > siddata > \dg6\oracle => data file and rollback segment data file .eg. siddata > \dg7\oracle => index file eg. sididx > \dg8\oracle => archive log file .eg. sidarc > > Is there any disadvantage if I put the redo log file and control file in > different directories but in the same mount point ? > > Is there any disadvantage if I put the rollback segment data file together > with my data file in the same directory ? > > Is there any disadvantage if I put the tablespace data file together with my > temp tablespace data file in the same directory ? > > TIA > > Regds, > New Bee -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Kimberly Smith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: How to organize oracle directories in Unix ?
-- Don Granaman <[EMAIL PROTECTED]> > It isn't mount points that matter for I/O contention, it is spindles and > channels - the physical disk layout. If this is one set of disks used in > one large RAID-5 setup, then creating multiple mount points for logical > volumes created on top of it will do nothing to reduce I/O contention. > To balance out I/O, you MUST know the physical layout underneath the > logical volumes and balance the I/O against that. Actually, you can help balance things a bit with careful LVM management. There is caching and I/O optimization going on at that level also. For example, you may have two RAID5 stripes (PV's) combined into the same volume (VG). By specifying which of the PV's your LV's are created/ extended onto you can at least partially balance the load. There is obviously no benefit to multiple mounts for a single LV, but you can get some improvement by creating multiple LV's within the VG (which then do require separate mount points unless you're using raw I/O). You can do some of this without even knowing the physical layout of the spindles -- though that obviously helps. Knowing which PV's (e.g., RAID5 groupings or mirror sets) are aviailable goes a long way to balancing the load. Main problem I've found is the absolute lack of shell tools for looking at how the I/O load maps at the spindle level. At that point all you have are the PV's reported by iostat & friends. Unless you know how the LV's were laid out it leaves you with little idea as to how the filesystem maps onto the load. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: How to organize oracle directories in Unix ?
Steven, i'm with you on the "nothing works concept", since i'm a consultant, i end end up throwing my hands in the air(after tuning all that i can from the db side, sql, etc) and leaving it up to the "disk nazis". They do as they please with no input and and can sometimes be the killer of performance on the db. joe Steven Lembark wrote: > > -- Joe Testa <[EMAIL PROTECTED]> > > > It all depends on the underlying striping of the physical disks. I'm > > unfortunately constrained by raid 5 also, so my hands are tied when it > > comes to disk contention fixes, so i leave it to the unix SA to deal > > with it, i just end up with one huge logical filesystem and throw the > > datafiles wherever. > > There is no reason that RAID5 has to cause you pain if the stripe > size makes sense for your O/S (e.g., RAID stripe == disk I/O page). > > Remember also that there are three layers to it: disks, RAID and > LVM. Your RAID system probably exports each RAID group as a single > physical volume (PV). You can specify which PV's each logical volume > (LV) is assigned to -- if beer doesn't work try a cattle prod. This > gives you the ability to manage contention pretty well. > > Main problem I've seen is that EMC and friends sell 150GB drives, > which get grouped into PV's at the raid level. This leaves you > with a single "device" and no ability to plan the I/O at all (and, > unfortunately neither booze nor prod's have worked with any managlement > I've tried them on). > > Even with striped LV's you can manage the I/O by choosing the LV > stripe size sanely and perhaps striping across multiple devices. > > -- > Steven Lembark 2930 W. Palmer > Workhorse Computing Chicago, IL 60647 > +1 800 762 1582 -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: How to organize oracle directories in Unix ?
-- Joe Testa <[EMAIL PROTECTED]> > It all depends on the underlying striping of the physical disks. I'm > unfortunately constrained by raid 5 also, so my hands are tied when it > comes to disk contention fixes, so i leave it to the unix SA to deal > with it, i just end up with one huge logical filesystem and throw the > datafiles wherever. There is no reason that RAID5 has to cause you pain if the stripe size makes sense for your O/S (e.g., RAID stripe == disk I/O page). Remember also that there are three layers to it: disks, RAID and LVM. Your RAID system probably exports each RAID group as a single physical volume (PV). You can specify which PV's each logical volume (LV) is assigned to -- if beer doesn't work try a cattle prod. This gives you the ability to manage contention pretty well. Main problem I've seen is that EMC and friends sell 150GB drives, which get grouped into PV's at the raid level. This leaves you with a single "device" and no ability to plan the I/O at all (and, unfortunately neither booze nor prod's have worked with any managlement I've tried them on). Even with striped LV's you can manage the I/O by choosing the LV stripe size sanely and perhaps striping across multiple devices. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: How to organize oracle directories in Unix ?
It isn't mount points that matter for I/O contention, it is spindles and channels - the physical disk layout. If this is one set of disks used in one large RAID-5 setup, then creating multiple mount points for logical volumes created on top of it will do nothing to reduce I/O contention. To balance out I/O, you MUST know the physical layout underneath the logical volumes and balance the I/O against that. -Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, September 09, 2001 9:55 AM > Hi Joe, > > What's your configuration ? Raid 1 ? > How do U organize the oracle directories ? > > Correct me if I am wrong. I thought though I use Raid 5 but with different > mount points, I will not have contention problems > For example > One mount point for data files > Another mount point for index files. > > Please advise. Thanks. > > Regds, > New Bee > -Original Message- > To: Multiple recipients of list ORACLE-L > Sent: 09/09/2001 8:30 PM > > if u dont know the underlying striping and someone else built the > filesystes, then the point is moot, you might as well have one logical > disk, since you cant reallt guarantee where something is going to end up > anyways. > > with all of the raid5 stuff(that evryone likes so much anymore), we as > DBAs dont have control over where stuff is, so a good backup/recovery > plan is a must, at least in the old days when a physical device was > mapped to a filesystem(pre-logical volume days), we could handle making > sure of duplexing redo logs, etc. > > joe > "CHAN Chor Ling Catherine (CSC)" wrote: > > > > Hi Guru, > > > > How do you organize your oracle directories in Unix ? > > > > I am thinking of using the configurations below. We are using Raid 5 > with > > various mount points. > > > > \dg1\oracle => contains Oracle Human Resources software applications > and > > oracle home .eg. sidappl, sidcomn, sidora > > > > \dg2\oracle => contains redo log file and control file eg. sidredo & > sidctrl > > > > \dg3\oracle => contains redo log file and control file eg. sidredo & > sidctrl > > > > \dg4\oracle => contains redo log file and control file eg. sidredo & > sidctrl > > > > \dg5\oracle => system tablespace file and temp tablespace data file > .eg. > > siddata > > \dg6\oracle => data file and rollback segment data file .eg. siddata > > \dg7\oracle => index file eg. sididx > > \dg8\oracle => archive log file .eg. sidarc > > > > Is there any disadvantage if I put the redo log file and control file > in > > different directories but in the same mount point ? > > > > Is there any disadvantage if I put the rollback segment data file > together > > with my data file in the same directory ? > > > > Is there any disadvantage if I put the tablespace data file together > with my > > temp tablespace data file in the same directory ? > > > > TIA > > > > Regds, > > New Bee > > -- > Joe Testa > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask :) > IM: n8xcthome or joen8xct > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: CHAN Chor Ling Catherine (CSC) > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Don Granaman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containin
RE: How to organize oracle directories in Unix ?
-- "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]> > Correct me if I am wrong. I thought though I use Raid 5 but with different > mount points, I will not have contention problems > For example > One mount point for data files > Another mount point for index files. Makes sense. Also helpful to keep rollback and log files on a separate phyiscal path for speed. Main problem is Oracle's flakey file layout. Either you get the supported method w/ several layers of meaningless direcrories or you get something that people can read... If your RAID5 systems are striped sanly (read: in O/S page size) then they will look and act pretty much like disk drives. You can push the whole issue onto the storage system by striping the logical volumes across multiple RAID5 devices. This leaves you with multiple mount points that all use all of the disks all of the time. If the database is fairly active this can be usable since it spreads the I/O out pretty thoroughly. The issue of being inable to isolate the I/O to speicfic devices means less with high-end RAID systems than it used to with disks. The RAID toys (e.g., Storage Works, EMC) and disks have enough cache and brains to sort, burst and pre-fetch I/O in a workable fashion. More people screw themselves with single-backplane computers or single- controller RAID systems than by grouping disks from what I've seen cleaning the things up. Best way to start is watch the I/O to things you'd like to group together (e.g., rollback, logs, index, data) and see which ones on your system get what kinds of load. OLTP usually looks more like the death 1000 cuts from inserts w/a broadsword to the next during bulk extracts; OLAP is the reverse, with a daily belch of data from the nightly load and a constant stream of queries. You have to decide which one needs to have the best performance and layout the file system to manage that kind of I/O most effectively. Things with serious peaks probably belong on their own data paths to whatever extent possible (e.g., rollbacks); nice, steady flows with a mix of input and output can likely be grouped onto devices that can gracefully handle the average flow. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: How to organize oracle directories in Unix ?
It all depends on the underlying striping of the physical disks. I'm unfortunately constrained by raid 5 also, so my hands are tied when it comes to disk contention fixes, so i leave it to the unix SA to deal with it, i just end up with one huge logical filesystem and throw the datafiles wherever. joe "CHAN Chor Ling Catherine (CSC)" wrote: > > Hi Joe, > > What's your configuration ? Raid 1 ? > How do U organize the oracle directories ? > > Correct me if I am wrong. I thought though I use Raid 5 but with different > mount points, I will not have contention problems > For example > One mount point for data files > Another mount point for index files. > > Please advise. Thanks. > > Regds, > New Bee > -Original Message- > From: Joe Testa > To: Multiple recipients of list ORACLE-L > Sent: 09/09/2001 8:30 PM > Subject: Re: How to organize oracle directories in Unix ? > > if u dont know the underlying striping and someone else built the > filesystes, then the point is moot, you might as well have one logical > disk, since you cant reallt guarantee where something is going to end up > anyways. > > with all of the raid5 stuff(that evryone likes so much anymore), we as > DBAs dont have control over where stuff is, so a good backup/recovery > plan is a must, at least in the old days when a physical device was > mapped to a filesystem(pre-logical volume days), we could handle making > sure of duplexing redo logs, etc. > > joe > "CHAN Chor Ling Catherine (CSC)" wrote: > > > > Hi Guru, > > > > How do you organize your oracle directories in Unix ? > > > > I am thinking of using the configurations below. We are using Raid 5 > with > > various mount points. > > > > \dg1\oracle => contains Oracle Human Resources software applications > and > > oracle home .eg. sidappl, sidcomn, sidora > > > > \dg2\oracle => contains redo log file and control file eg. sidredo & > sidctrl > > > > \dg3\oracle => contains redo log file and control file eg. sidredo & > sidctrl > > > > \dg4\oracle => contains redo log file and control file eg. sidredo & > sidctrl > > > > \dg5\oracle => system tablespace file and temp tablespace data file > .eg. > > siddata > > \dg6\oracle => data file and rollback segment data file .eg. siddata > > \dg7\oracle => index file eg. sididx > > \dg8\oracle => archive log file .eg. sidarc > > > > Is there any disadvantage if I put the redo log file and control file > in > > different directories but in the same mount point ? > > > > Is there any disadvantage if I put the rollback segment data file > together > > with my data file in the same directory ? > > > > Is there any disadvantage if I put the tablespace data file together > with my > > temp tablespace data file in the same directory ? > > > > TIA > > > > Regds, > > New Bee > -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: How to organize oracle directories in Unix ?
Hi Joe, What's your configuration ? Raid 1 ? How do U organize the oracle directories ? Correct me if I am wrong. I thought though I use Raid 5 but with different mount points, I will not have contention problems For example One mount point for data files Another mount point for index files. Please advise. Thanks. Regds, New Bee -Original Message- To: Multiple recipients of list ORACLE-L Sent: 09/09/2001 8:30 PM if u dont know the underlying striping and someone else built the filesystes, then the point is moot, you might as well have one logical disk, since you cant reallt guarantee where something is going to end up anyways. with all of the raid5 stuff(that evryone likes so much anymore), we as DBAs dont have control over where stuff is, so a good backup/recovery plan is a must, at least in the old days when a physical device was mapped to a filesystem(pre-logical volume days), we could handle making sure of duplexing redo logs, etc. joe "CHAN Chor Ling Catherine (CSC)" wrote: > > Hi Guru, > > How do you organize your oracle directories in Unix ? > > I am thinking of using the configurations below. We are using Raid 5 with > various mount points. > > \dg1\oracle => contains Oracle Human Resources software applications and > oracle home .eg. sidappl, sidcomn, sidora > > \dg2\oracle => contains redo log file and control file eg. sidredo & sidctrl > > \dg3\oracle => contains redo log file and control file eg. sidredo & sidctrl > > \dg4\oracle => contains redo log file and control file eg. sidredo & sidctrl > > \dg5\oracle => system tablespace file and temp tablespace data file .eg. > siddata > \dg6\oracle => data file and rollback segment data file .eg. siddata > \dg7\oracle => index file eg. sididx > \dg8\oracle => archive log file .eg. sidarc > > Is there any disadvantage if I put the redo log file and control file in > different directories but in the same mount point ? > > Is there any disadvantage if I put the rollback segment data file together > with my data file in the same directory ? > > Is there any disadvantage if I put the tablespace data file together with my > temp tablespace data file in the same directory ? > > TIA > > Regds, > New Bee -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: How to organize oracle directories in Unix ?
CHAN: If I'm wrong, please correct me, but if you're talking about where to put things for performance reasons and you're using a RAID 5 configuration, then it doesn't make any difference. With a RAID 5 configuration, as I remember, is striped with parity and all the disks are seen as one big volume. Assuming all this is true, it doesn't matter where you put the files in which case I would suggest putting them all under the same directory structure for easy management. If, however, we are talking about separate disks/controllers, here are few file placement perf tuning tips I've come to learn with regard to your questions: > Is there any disadvantage if I put the redo log file and control file in different > directories but in the same mount point ? Yes, redo logs are essential to recovery. The speed at which redo logs can be written to in many ways determines has a direct impact on the overall performance of the database. Therefore, redo logs should put redo logs on their own devices. > Is there any disadvantage if I put the rollback segment data file together with my > data file in the same directory ? For the same reasoning above, rollback segments should be on their own devices since inserts, updates and deletes will normally require writing to rollback as well. > Is there any disadvantage if I put the tablespace data file together with my temp > tablespace data file in the same directory ? Again, the issue here is contention. If you are selecting a large amount of data from a particular table in a particular tablespace and the data must be sorted and that sort must use the sort segment in the temporary tablespace, you don't want that sorting to be utilizing the same controller/disk(s) as the selecting does. Otherwise, you could end up with a I/O performance bottleneck. List, if I'm wrong here, please correct me. Jon Walthour -Original Message- Sent: Sunday, September 09, 2001 7:05 AM To: Multiple recipients of list ORACLE-L Hi Guru, How do you organize your oracle directories in Unix ? I am thinking of using the configurations below. We are using Raid 5 with various mount points. \dg1\oracle => contains Oracle Human Resources software applications and oracle home .eg. sidappl, sidcomn, sidora \dg2\oracle => contains redo log file and control file eg. sidredo & sidctrl \dg3\oracle => contains redo log file and control file eg. sidredo & sidctrl \dg4\oracle => contains redo log file and control file eg. sidredo & sidctrl \dg5\oracle => system tablespace file and temp tablespace data file .eg. siddata \dg6\oracle => data file and rollback segment data file .eg. siddata \dg7\oracle => index file eg. sididx \dg8\oracle => archive log file .eg. sidarc Is there any disadvantage if I put the redo log file and control file in different directories but in the same mount point ? Is there any disadvantage if I put the rollback segment data file together with my data file in the same directory ? Is there any disadvantage if I put the tablespace data file together with my temp tablespace data file in the same directory ? TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: How to organize oracle directories in Unix ?
if u dont know the underlying striping and someone else built the filesystes, then the point is moot, you might as well have one logical disk, since you cant reallt guarantee where something is going to end up anyways. with all of the raid5 stuff(that evryone likes so much anymore), we as DBAs dont have control over where stuff is, so a good backup/recovery plan is a must, at least in the old days when a physical device was mapped to a filesystem(pre-logical volume days), we could handle making sure of duplexing redo logs, etc. joe "CHAN Chor Ling Catherine (CSC)" wrote: > > Hi Guru, > > How do you organize your oracle directories in Unix ? > > I am thinking of using the configurations below. We are using Raid 5 with > various mount points. > > \dg1\oracle => contains Oracle Human Resources software applications and > oracle home .eg. sidappl, sidcomn, sidora > > \dg2\oracle => contains redo log file and control file eg. sidredo & sidctrl > > \dg3\oracle => contains redo log file and control file eg. sidredo & sidctrl > > \dg4\oracle => contains redo log file and control file eg. sidredo & sidctrl > > \dg5\oracle => system tablespace file and temp tablespace data file .eg. > siddata > \dg6\oracle => data file and rollback segment data file .eg. siddata > \dg7\oracle => index file eg. sididx > \dg8\oracle => archive log file .eg. sidarc > > Is there any disadvantage if I put the redo log file and control file in > different directories but in the same mount point ? > > Is there any disadvantage if I put the rollback segment data file together > with my data file in the same directory ? > > Is there any disadvantage if I put the tablespace data file together with my > temp tablespace data file in the same directory ? > > TIA > > Regds, > New Bee -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
How to organize oracle directories in Unix ?
Hi Guru, How do you organize your oracle directories in Unix ? I am thinking of using the configurations below. We are using Raid 5 with various mount points. \dg1\oracle => contains Oracle Human Resources software applications and oracle home .eg. sidappl, sidcomn, sidora \dg2\oracle => contains redo log file and control file eg. sidredo & sidctrl \dg3\oracle => contains redo log file and control file eg. sidredo & sidctrl \dg4\oracle => contains redo log file and control file eg. sidredo & sidctrl \dg5\oracle => system tablespace file and temp tablespace data file .eg. siddata \dg6\oracle => data file and rollback segment data file .eg. siddata \dg7\oracle => index file eg. sididx \dg8\oracle => archive log file .eg. sidarc Is there any disadvantage if I put the redo log file and control file in different directories but in the same mount point ? Is there any disadvantage if I put the rollback segment data file together with my data file in the same directory ? Is there any disadvantage if I put the tablespace data file together with my temp tablespace data file in the same directory ? TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
