S.A.M.E, Stripe And Mirror Everything. It's a concept that came from an individual at Oracle with a significant pile of alphabet soup after his name who has lost most of his credibility anywhere.
He was speaking though of Network Attached Storage (NAS) stuff where you really don't have to worry about the mount point/drive letter where you put the datafile(s). These neato devices do make some of the DBA's tasks of IO balancing meaningless since they do stripe data across multiple disks and run hardware mirroring in the background. In turn they retrieve your data from the most efficient place possible & buffer your writes in cache memory that 'guarantees' that it will absolutely make it to disk. What I think has happen is that some of his idea was taken out of context, though not out of quote, and made meaningless. You should still have logical database design and multiple tablespaces/datafiles. It's just that you really don't care is everything is on drive H. Dick Goulet PS: I've not implemented such an idea & have no intention thereof in the near future. Reason, NAS storage is not here. ____________________Reply Separator____________________ Author: "Michael Cupp" <[EMAIL PROTECTED]> Date: 2/27/2002 1:20 PM S.A.M.E.? -----Original Message----- Sent: Wednesday, February 27, 2002 3:48 PM To: Multiple recipients of list ORACLE-L At one of the Oracle Application group meetings it was stated that it is better to have large tables and forget normalization. Disks are getting faster and you can read a lot more data from one disk reather that getting your data from many disk locations. Also it doesn't really matter the size of the tables if you use the S.A.M.E theory. All disks are treated as one disk farm today. I haven't tried it but it sounded reasonable. ROR mª¿ªm >>> [EMAIL PROTECTED] 02/27/02 03:08PM >>> Also not uncommon when tracking medical data. Bambi. -----Original Message----- Sent: Wednesday, February 27, 2002 1:53 PM To: Multiple recipients of list ORACLE-L Some of the tables in J.D. Edwards OneWorld have over 200 columns, VARCHAR is not used, only NUMBER and CHAR. Makes for some wide tables. This product was originally some type of flat file database. Ethan -----Original Message----- Sent: Wednesday, February 27, 2002 1:28 PM To: Multiple recipients of list ORACLE-L I think the column limit is now closer to 1000, but like you, I can't imagine willingly designing a table with a column count exceeding 2 digits. More than 15 or 20 and I start to question the design. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Bellows, Bambi 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: Ron Rogers 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: Michael Cupp 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: 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).
