RE: DB on NT
Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -Original Message- Antje Sent: 05 July 2001 10:51 To: Multiple recipients of list ORACLE-L Hi, I' hav to build up foolowing matrix DB Size <.. Operating system NT Sun Solaris AIX ... Has anyone a similar matrix to share? Especially I'm interested in the size for NT. I know there was a saying - put no database larger than 1 GB on a NT machine. Is this still true with 8.1.7 or is it stable with larger databases also? Regards, Antje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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: DB on NT
Me neither. I've had database 50-70G in size on NT. (Which, in the grand scale of things isn't terribly large, but it's my personal experience and sufficient for this example). Compaq ProLiant servers, Compaq RAID controllers and storage arrays. Very nice equipment, rock solid and very fast. So long as you stick to the OEM'd drivers, you won't go wrong. I am a huge fan of Compaq servers, they must have learnt a great deal about system engineering from their acquisition of DEC. Nothing personal to anyone reading this, but there are a whole bunch of people on this list who have very strong anti-NT sentiments, which aren't always justified, IMHO. YMMV. Don't even get me started on Unix, which sucks. Rebooting if you need more file descriptors?! Or shared memory? All operating systems suck. Apart from maybe VMS. g -Original Message- Sent: Thursday, July 05, 2001 12:02 PM To: Multiple recipients of list ORACLE-L Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: DB on NT
Antje "I know there was a saying - put no database larger than 1 GB on a NT machine." The above is nonsense. I have a database that is 200G on NT. I know of no limit regarding database size on NT. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 05, 2001 7:02 AM To: Multiple recipients of list ORACLE-L Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -Original Message- Antje Sent: 05 July 2001 10:51 To: Multiple recipients of list ORACLE-L Hi, I' hav to build up foolowing matrix DB Size <.. Operating system NT Sun Solaris AIX ... Has anyone a similar matrix to share? Especially I'm interested in the size for NT. I know there was a saying - put no database larger than 1 GB on a NT machine. Is this still true with 8.1.7 or is it stable with larger databases also? Regards, Antje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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: Mercadante, Thomas F 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: DB on NT
Guy, "Don't even get me started on Unix, which sucks. Rebooting if you need more file descriptors?! Or shared memory? All operating systems suck. Apart from maybe VMS." Isn't saying "all operating systems suck" a bit harsh? :) Personally, I think they all have their challenges, but they can be managed. I agree with you on two points - the anti-NT brigade on this list are a bit phobic, and that the VMS operating system is/was one of the best every designed! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 05, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Me neither. I've had database 50-70G in size on NT. (Which, in the grand scale of things isn't terribly large, but it's my personal experience and sufficient for this example). Compaq ProLiant servers, Compaq RAID controllers and storage arrays. Very nice equipment, rock solid and very fast. So long as you stick to the OEM'd drivers, you won't go wrong. I am a huge fan of Compaq servers, they must have learnt a great deal about system engineering from their acquisition of DEC. Nothing personal to anyone reading this, but there are a whole bunch of people on this list who have very strong anti-NT sentiments, which aren't always justified, IMHO. YMMV. Don't even get me started on Unix, which sucks. Rebooting if you need more file descriptors?! Or shared memory? All operating systems suck. Apart from maybe VMS. g -Original Message- Sent: Thursday, July 05, 2001 12:02 PM To: Multiple recipients of list ORACLE-L Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: Mercadante, Thomas F 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: DB on NT
Perhaps it is confusion with filesize and then it is a whole different ball game and not only for NT but some older unixes and other OS's as well. and then we can start the arguments for using raw or not using raw for files under unix. Peter At 10:45 PM 5/07/2001, you wrote: >Antje > >"I know there was a saying - put no database larger than 1 GB on a NT >machine." > >The above is nonsense. I have a database that is 200G on NT. I know of no >limit regarding database size on NT. > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >Sent: Thursday, July 05, 2001 7:02 AM >To: Multiple recipients of list ORACLE-L > > >Hi, > >Regarding the issue of databases larger than 1GB on NT, could someone please >explain this to me, as I was not aware of this 'saying'. > >Thanks in advance, > >Steven H. > >-Original Message- >Antje >Sent: 05 July 2001 10:51 >To: Multiple recipients of list ORACLE-L > > >Hi, >I' hav to build up foolowing matrix > > DB Size <.. >Operating system >NT >Sun Solaris >AIX >... >Has anyone a similar matrix to share? >Especially I'm interested in the size for NT. >I know there was a saying - put no database larger than 1 GB on a NT >machine. >Is this still true with 8.1.7 or is it stable with larger databases also? > >Regards, >Antje > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Steven Hovington > 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: Mercadante, Thomas F > 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: Peter McLarty 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: DB on NT
ALso, what does "1GB" actually mean? That much data, if you dumped it all out into a CSV file? A 1GB tablespace to hold all the data (and how is that tablespace organized)? 1GB being the sum of the sizes of all the datafiles? So, even if there were such a saying, it would be meaningless. What I like to do, and perhaps this is just me, is to have all the datafiles within a tablespace the same size. So, if I calculated that I needed a 2G tablespace, I might create 4 500M datafiles, and when I needed more I would add more 500M datafiles. I just think this makes things easier to manage, from a physical storage perspective. And contrary to the letter (rather than the spirit) of OFA, I name datafiles: //__.dbf Anyone else do something like this? guy -Original Message- Sent: Thursday, July 05, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Perhaps it is confusion with filesize and then it is a whole different ball game and not only for NT but some older unixes and other OS's as well. and then we can start the arguments for using raw or not using raw for files under unix. Peter At 10:45 PM 5/07/2001, you wrote: >Antje > >"I know there was a saying - put no database larger than 1 GB on a NT >machine." > >The above is nonsense. I have a database that is 200G on NT. I know of no >limit regarding database size on NT. > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >Sent: Thursday, July 05, 2001 7:02 AM >To: Multiple recipients of list ORACLE-L > > >Hi, > >Regarding the issue of databases larger than 1GB on NT, could someone please >explain this to me, as I was not aware of this 'saying'. > >Thanks in advance, > >Steven H. > >-Original Message- >Antje >Sent: 05 July 2001 10:51 >To: Multiple recipients of list ORACLE-L > > >Hi, >I' hav to build up foolowing matrix > > DB Size <.. >Operating system >NT >Sun Solaris >AIX >... >Has anyone a similar matrix to share? >Especially I'm interested in the size for NT. >I know there was a saying - put no database larger than 1 GB on a NT >machine. >Is this still true with 8.1.7 or is it stable with larger databases also? > >Regards, >Antje > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Steven Hovington > 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: Mercadante, Thomas F > 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: Peter McLarty 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: Guy Hammond 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: DB on NT
I tend to leave out the sid in a datafile name, saves me from having to rename it, if i'm doing the transportable tablespace ordeal. joe >>> [EMAIL PROTECTED] 07/05/01 12:03PM >>>ALso, what does "1GB" actually mean? That much data, if you dumped itall out into a CSV file? A 1GB tablespace to hold all the data (and howis that tablespace organized)? 1GB being the sum of the sizes of all thedatafiles? So, even if there were such a saying, it would bemeaningless.What I like to do, and perhaps this is just me, is to have all thedatafiles within a tablespace the same size. So, if I calculated that Ineeded a 2G tablespace, I might create 4 500M datafiles, and when Ineeded more I would add more 500M datafiles. I just think this makesthings easier to manage, from a physical storage perspective. Andcontrary to the letter (rather than the spirit) of OFA, I namedatafiles://__.dbfAnyone else do something like this?guy-Original Message-Sent: Thursday, July 05, 2001 2:56 PMTo: Multiple recipients of list ORACLE-LPerhaps it is confusion with filesize and then it is a whole differentball game and not only for NT but some older unixes and other OS's as well.and then we can start the arguments for using raw or not using raw for filesunder unix.PeterAt 10:45 PM 5/07/2001, you wrote:>Antje>>"I know there was a saying - put no database larger than 1 GB on a NT>machine.">>The above is nonsense. I have a database that is 200G on NT. I knowof no>limit regarding database size on NT.>>Tom Mercadante>Oracle Certified Professional>>>-Original Message->Sent: Thursday, July 05, 2001 7:02 AM>To: Multiple recipients of list ORACLE-L>>>Hi,>>Regarding the issue of databases larger than 1GB on NT, could someoneplease>explain this to me, as I was not aware of this 'saying'.>>Thanks in advance,>>Steven H.>>-Original Message->Antje>Sent: 05 July 2001 10:51>To: Multiple recipients of list ORACLE-L>>>Hi,>I' hav to build up foolowing matrix>> DB Size <..>Operating system>NT>Sun Solaris>AIX>...>Has anyone a similar matrix to share?>Especially I'm interested in the size for NT.>I know there was a saying - put no database larger than 1 GB on a NT>machine.>Is this still true with 8.1.7 or is it stable with larger databasesalso?>>Regards,>Antje>>>-->Please see the official ORACLE-L FAQ: http://www.orafaq.com>-->Author: Steven Hovington> 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: Mercadante, Thomas F> 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: Peter McLarty INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Guy Hammond INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).