Re: OFA Question
No reason - Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 12:50 PM Hi All Running Oracle 817 on Red Hat Linux. File layout is as follows. oradata3/prod: control01.ctl indx01.dbf redo01.log system01.dbf tools01.dbf oradata4/prod: control02.ctl redo02.log temp01.dbf oradata6/prod: control03.ctl rbs01.dbf redo03.log oradata7/prod: redo01b.log users01.dbf oradata8/prod: archives redo02b.log oradata9/prod: archives redo03b.log Where archives is a dir containing online dbf backups and archived redo logs. Is there ANY reason at all not to use spare space on oradata 3,4,6,7 to store other files ? They won't be read or written during times when the database is under load. Cheers GS -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Solomon 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: Sam Roberts 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).
OFA Question
Hi All Running Oracle 817 on Red Hat Linux. File layout is as follows. oradata3/prod: control01.ctl indx01.dbf redo01.log system01.dbf tools01.dbf oradata4/prod: control02.ctl redo02.log temp01.dbf oradata6/prod: control03.ctl rbs01.dbf redo03.log oradata7/prod: redo01b.log users01.dbf oradata8/prod: archives redo02b.log oradata9/prod: archives redo03b.log Where archives is a dir containing online dbf backups and archived redo logs. Is there ANY reason at all not to use spare space on oradata 3,4,6,7 to store other files ? They won't be read or written during times when the database is under load. Cheers GS -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Solomon 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: OFA Question
Is there ANY reason at all not to use spare space on oradata 3,4,6,7 to store other files ? They won't be read or written during times when the database is under load. Cheers GS Can't see any. Regards Stephane Faroult Oriole Corporation -- Diese E-Mail wurde mit http://de.mail-inspector.de verschickt Mail Inspector ist ein kostenloser Service von http://www.is-fun.net Der Absender dieser E-Mail hatte die IP: 195.25.229.12 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: OFA Question
In performance terms it won't really make a difference but from an admin point of view it's not a great idea. It's way too easy to accidentally move or remove a file during a routine operation and it can can confuse backup and restore operations. If I ever have to do this I create a subdirectory so that at least they're logically separate and risk is minimised. regards, Mike Hately Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: OFA Question
Since Greg originally asked Is there ANY reason..., I'll add another element to the consideration. I agree with what Mike says, but if you are really, really picky, putting other files on the filesystem with Oracle datafiles can cause file fragmentation when a datafile is extended in size (auto or otherwise). Also, the filesystem can become fragmented as new (other) files are added and deleted - resulting in a lot of odd sized chunks of contiguous free space in the filesystem. Is this critical? Probably not, but I don't like doing it on critical production servers. OFA allows, even encourages, this in its normal incarnation. I often use the VLDB OFA model for significant production databases specifically to prevent this. It looks like you have adopted the VLDB OFA model - I didn't see a / in front of oradata1/prod, but if these mount points are actually /oradata1/prod, etc., then that is the VLDB model. (see trailing note). This model is for sites where there is no intention of putting other stuff in these filesystems. /u01/oradata/dbname/... and /u01/junk/other.file(s) are OK in the normal OFA model, but /oradata1/junk/other.file(s) is at least misleading in the VLDB model since other.file(s) are not oradata. (A picky point to be sure.) Also, my experience is that the noble intention of not accessing other files on the data filesystems during critical periods will most likely be abandoned at some point. I have received calls reporting database performance problems only to find someone doing something like uncompressing and expanding very large (1 GB+) .tar.Z files on a performance critical filesystem. (Your mileage may certainly vary!) Note: The OFA documentation in the Oracle manuals and at technet.oracle.com is not really complete - it is sort of the Reader's Digest version. For the full blown OFA documentation, see either: http://www.hotsos.com/dnloads/0.Millsap1995.09.24-OFA.pdf . That is Cary Millsap's company site and it may require a (free) registration. You could also use: http://www.vampired.net/articles/php/standards.php and download it from there. (See 6. Mount Points for VLDB sites - OFA 11. I allow at least one exception to it though - for multiple databases. For example, /oradata1/prod1/... /oradata1/prod2/... ). -Don Granaman [Certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 6:01 AM In performance terms it won't really make a difference but from an admin point of view it's not a great idea. It's way too easy to accidentally move or remove a file during a routine operation and it can can confuse backup and restore operations. If I ever have to do this I create a subdirectory so that at least they're logically separate and risk is minimised. regards, Mike Hately Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 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).