RE: Data Warehouse on Windows -more
Adar, >From what I understand and have seen it's not just at 4GB - it's EVERY 4GB. So for example if your database extends from 3.8GB - 4.2GB it fail just as it will extending from 7.8GB-8.2GB or 11.8GB - 12.2GB (for example). It certainly DOESN'T mean that you can't use files larger than 4GB! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 19 August 2002 19:19 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello Aleem This is not a boundary. It is a problem if you use autoextend and the file grows from less then 4Gb to more then 4GB. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, August 19, 2002 1:48 PM > Where can I find the more information on this boundary? Is there any such > limit for Oracle/Linux? > TIA! > > Aleem > > -Original Message- > Sent: Thursday, August 15, 2002 7:44 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Data Warehouse on Windows > > Don't forget the Oracle/Windows 4GB boundary corruption problem! > > Lewis Bishop > --- > Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant > Phone - 020 8298 3418 > Mobile - 07950 380857 > Email - [EMAIL PROTECTED] > > > -Original Message- > Sent: 15 August 2002 14:58 > To: Multiple recipients of list ORACLE-L > > This header confirms that this email message has been swept for the > presence of computer viruses. > > Corporate IT > THE WOOLWICH > -- > > Hi, > I was asked to give some hint for the hardware for a data warheouse running > on Win 2k and holding about 20-40 GB data. > Project will have about 40 small and 7-8 large tables. Users <20. Probably > long running queries. > Which hardware would you use? How many processors? Which disks? > The os-system is set and cannot be Unix/Linux according to management > decision. > Any tips/recommendations appreciated > Antje Sackwitz > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sackwitz, Antje > 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). > > > The information, attachments and opinions contained in this message are > those of its author only and do not necessarily represent those of The > Woolwich and or any other members of the Barclays Group and are intended > solely for the use of the individual or entity to whom they are addressed. > The sender may not be authorised to give financial advice, and nothing in > this message should be construed as offering such advice. > > The message may contain privileged and confidential information and you may > not copy, distribute or take any action in reliance on it. If you have > received this email in error please notify the Information Security Manager > at [EMAIL PROTECTED] > > Replies to this email may be monitored for operational or business reasons. > > Woolwich plc. Registered in England Number : 3295699. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bishop Lewis > 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: Abdul Aleem > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538
Re: WG: Re: Data Warehouse on Windows
Hi, Sure that Sybase has not all the nice features Oracle has but I'm a bit surprised that you find it way too slow, do you have Sybase 12.5 ? 12.5 has interesting new features compare to 11.9 version. "20 users doing ad hoc queries ..." I supposed you have a tool like Business Objects or Cognos and you're hiding the tables behind a user layer. "Some typical queries involve joining 2 tables each holding 2 Million rows." Are you using dimensionnal modeling ? You can have a dimension with a million lines but it's very rare. Have you built aggregates ? The only good way to speed up queries in a DW is to pre-calculate the data. Have you investigate to see what is the bottleneck in your application ? Depending on it you may or may not solve it by using Oracle DW features : partitionnning, star join, ,... HTH --- "Sackwitz, Antje" <[EMAIL PROTECTED]> a écrit : > > Hi, Stephane, > > actually we have the database running on Sybase > but there it is way too > > slow ( as I > > told everyone here before). The application has > about 25 small and about > > 10 large > > tables. Data comes in every night about 100-250MB. > We have just about 20 > > users > > doing 'ad hoc' queries to the database via a > commercial tool. At the > > moment we > > have a test installation running on an IBM > computer having 2 processors a > > 2Ghz, 2 > > Gig RAM. Some typical queries involove joing 2 > tables each holding > > 2Million rows. > > Test situation will represent data warehouse after > being 3 years in > > production. > > Well, now the query takes about 15-20 Mintues > which is too slow for our > > sales > > people. I calculated, the machine scans about > 80-1Mio rows per second. > > I thought, there are a lot of tuning possibilites > in Oracle that are not > > available in > > Sybase. Our system can run on both RDBMS. So as we > are buying a new > > machine > > for our database test environment I thought I > better find out which is > > best equipment > > for Oracle as I expect people to learn that Sybase > is not your number one > > when you > > go for a fdata warehouse. Overall we calculated, > that we add new muodules > > over > > next couple of years so finally DW will hold 20 > Gig data. > > Windows is chosen as sales folk here says Windows > machines are a lot > > cheaper > > than UNIX and the commercial tool needs some > server processes available > > not for > > Linux > > Any further recommendations? > > Regards, > > Antje > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Sackwitz, Antje > 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Data Warehouse on Windows -more
Hello Aleem This is not a boundary. It is a problem if you use autoextend and the file grows from less then 4Gb to more then 4GB. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, August 19, 2002 1:48 PM > Where can I find the more information on this boundary? Is there any such > limit for Oracle/Linux? > TIA! > > Aleem > > -Original Message- > Sent: Thursday, August 15, 2002 7:44 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Data Warehouse on Windows > > Don't forget the Oracle/Windows 4GB boundary corruption problem! > > Lewis Bishop > --- > Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant > Phone - 020 8298 3418 > Mobile - 07950 380857 > Email - [EMAIL PROTECTED] > > > -Original Message- > Sent: 15 August 2002 14:58 > To: Multiple recipients of list ORACLE-L > > This header confirms that this email message has been swept for the > presence of computer viruses. > > Corporate IT > THE WOOLWICH > -- > > Hi, > I was asked to give some hint for the hardware for a data warheouse running > on Win 2k and holding about 20-40 GB data. > Project will have about 40 small and 7-8 large tables. Users <20. Probably > long running queries. > Which hardware would you use? How many processors? Which disks? > The os-system is set and cannot be Unix/Linux according to management > decision. > Any tips/recommendations appreciated > Antje Sackwitz > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sackwitz, Antje > 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). > > > The information, attachments and opinions contained in this message are > those of its author only and do not necessarily represent those of The > Woolwich and or any other members of the Barclays Group and are intended > solely for the use of the individual or entity to whom they are addressed. > The sender may not be authorised to give financial advice, and nothing in > this message should be construed as offering such advice. > > The message may contain privileged and confidential information and you may > not copy, distribute or take any action in reliance on it. If you have > received this email in error please notify the Information Security Manager > at [EMAIL PROTECTED] > > Replies to this email may be monitored for operational or business reasons. > > Woolwich plc. Registered in England Number : 3295699. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bishop Lewis > 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: Abdul Aleem > 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
RE: Data Warehouse on Windows
Oracle licenses are generally sold per CPU or per user, and cover only the machine on which the license was purchased for. We have a licensing arrangement that is per user and covers that user on any system we wish to put a database on. I don't know if Oracle still sells licensing that way. I don't think so, but you'd have to ask your sales critter to find out. There are some companies that have purchased site licenses also. Again, I don't know if Oracle still does that. Jared Abdul Aleem <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/19/2002 04:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Data Warehouse on Windows Jard, "If you're not already under some kind of license that covers existing users on a new system, Oracle will likely tell you that you need to license per CPU." As we are on licensing with Oracle, I would appreciate if you could elaborate what you mean by "covering on new system". TIA! Aleem -Original Message- Sent:Friday, August 16, 2002 3:52 AM To: Multiple recipients of list ORACLE-L Antje, Before you determine the number CPU's, you need to talk to your Oracle rep about your proposed DW and determine how they will make you license it. If you're not already under some kind of license that covers existing users on a new system, Oracle will likely tell you that you need to license per CPU. If that's the case, you might consider going with the fastest CPU's you can get, and limiting it to 2 CPU's. With that number of users and a fairly small DW, you would most likely be fine. Of course, I don't know anything about your requirements, but I do know that an EE license is $40k U.S. per CPU, which can really eat into the budget for a small project. HTH Jared "Sackwitz, Antje" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2002 06:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Data Warehouse on Windows Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem 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 li
RE: Data Warehouse on Windows -more
You can search metalink for "4gb boundary" or "windows 4gb corruption" - both of these should raise various notes which refer to it. But, as already mentioned if you ensure AUTOEXTEND is OFF you'll have nothing to worry about. AFAIK this is only a WINDOWS problem. Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 19 August 2002 12:49 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Where can I find the more information on this boundary? Is there any such limit for Oracle/Linux? TIA! Aleem -Original Message- Sent: Thursday, August 15, 2002 7:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: Data Warehouse on Windows Don't forget the Oracle/Windows 4GB boundary corruption problem! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 15 August 2002 14:58 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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: Abdul Aleem 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). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individu
RE: Data Warehouse on Windows -more
-- Abdul Aleem <[EMAIL PROTECTED]> > Where can I find the more information on this boundary? Is there any such > limit for Oracle/Linux? Corruption, not that I've seen. Unless you compile the kernel w/ extended memory translation turned on. The default looks something like: CONFIG_NOHIGHMEM=y # CONFIG_HIGHMEM4G is not set # CONFIG_HIGHMEM64G is not set -- 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: Data Warehouse on Windows -more
Where can I find the more information on this boundary? Is there any such limit for Oracle/Linux? TIA! Aleem -Original Message- Sent: Thursday, August 15, 2002 7:44 PM To: Multiple recipients of list ORACLE-L Subject:RE: Data Warehouse on Windows Don't forget the Oracle/Windows 4GB boundary corruption problem! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 15 August 2002 14:58 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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: Abdul Aleem 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: Data Warehouse on Windows
Jard, "If you're not already under some kind of license that covers existing users on a new system, Oracle will likely tell you that you need to license per CPU." As we are on licensing with Oracle, I would appreciate if you could elaborate what you mean by "covering on new system". TIA! Aleem -Original Message- Sent: Friday, August 16, 2002 3:52 AM To: Multiple recipients of list ORACLE-L Subject: Re: Data Warehouse on Windows Antje, Before you determine the number CPU's, you need to talk to your Oracle rep about your proposed DW and determine how they will make you license it. If you're not already under some kind of license that covers existing users on a new system, Oracle will likely tell you that you need to license per CPU. If that's the case, you might consider going with the fastest CPU's you can get, and limiting it to 2 CPU's. With that number of users and a fairly small DW, you would most likely be fine. Of course, I don't know anything about your requirements, but I do know that an EE license is $40k U.S. per CPU, which can really eat into the budget for a small project. HTH Jared "Sackwitz, Antje" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2002 06:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Data Warehouse on Windows Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem 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: Data Warehouse on Windows
Hello Antje Pay close attention to the type of windows version they install on the server. I got into a situation where I wanted to use 3GB for Oracle and it turns out that we have the standard NT edition instead of Enterprise edition and a single process is limited to use 2GB memory. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 3:58 PM > Hi, > I was asked to give some hint for the hardware for a data warheouse running > on Win 2k and holding about 20-40 GB data. > Project will have about 40 small and 7-8 large tables. Users <20. Probably > long running queries. > Which hardware would you use? How many processors? Which disks? > The os-system is set and cannot be Unix/Linux according to management > decision. > Any tips/recommendations appreciated > Antje Sackwitz > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sackwitz, Antje > 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: Yechiel Adar 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: Data Warehouse on Windows
It is a problem with Oracle DataFiles on the 4GB boundary. Doc ID: Note:148894.1 Subject: ALERT: Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on NT/2000 Platforms Type: ALERT Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date:07-JUN-2001 Last Revision Date:25-JUL-2002 Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on NT/2000 Platforms ~ Change Record ~~ 27-Dec-01: The fix release in the Patches section of this alert was modified from 8.1.7.2 to 8.1.7.3. Versions Affected ~ The problems described here can affect releases 8.1.6 and 8.1.7. Platforms Affected ~~ The problems affect Oracle8i releases on Windows NT and Windows 2000. Description ~~~ Releases of Oracle8i on Windows NT and Windows 2000 platforms can exhibit serious problems when a datafile autoextends or is resized onto a 4GB boundary (e.g. 4GB, 8GB). When a datafile has been configured such that it will autoextend onto a 4GB boundary, any attempt to autoextend: a. when in noarchive log mode it causes the database to crash b. when in archive log mode the file is marked offline in V$RECOVER_FILE When not in archive log mode, it is safe to restart the database and continue, altering datafiles to autoextend onto different boundaries asap. NOTE: It may be necessary to stop and restart the OracleService itself. The only way to recover this file when in archive log mode is to restore the whole database and roll forward to a point before the file autoextended. Likelihood of Occurrence It is highly likely that problems will be encountered if an attempt is made to autoextend or resize a datafile onto a 4Gb boundary. Possible Symptoms ~ The possible symptoms from this problem are: a. The database crashes (when in noarchive log mode) and the alert file and database writer (DBW0) trace file report: KCF: write/open error block=0xX online=Y file=N '..' error=27069 txt: 'OSD-4026: Invalid parameter passed. (OS-204802)' b. The file is marked offline in V$RECOVER_FILE and access to the database continues. The following error appears in the alert.log: KCF: write/open error block=0xX online=Y file=N '..' error=27069 txt: 'OSD-4026: Invalid parameter passed. (OS-204802)' Automatic datafile offline due to write error on file N: '..' Workaround ~~ The only safe workaround at present is to ensure that no file is resized or created to autoextend onto a 4Gb boundary. This is best achieved by making sure all datafiles have AUTOEXTEND disabled. It is advisable to read the article below which describes potential issues using files of 2Gb or larger in size as this may influence the maximum datafile size you choose to use. Patches ~~~ A fix is now available in 8.1.7.1.4 and will be included in 8.1.7.3 References ~~ 2Gb or not 2Gb - File limits in Oracle[NOTE:62427.1] Base bug reporting this problem [BUG:1668488] At 09:53 AM 15-08-02 -0800, you wrote: >Was that corruption problem in Oracle or in the windows OS? > >I asked a Microsoft person here and he says that the file size limit for >windows2000 is in exabytes. (2^64 bytes) > >Regards, >Patrice Boivin >Systems Analyst (Oracle Certified DBA) > >Systems Admin & Operations | Admin. et Exploit. des systèmes >Technology Services| Services technologiques >Informatics Branch | Direction de l'informatique >Maritimes Region, DFO | Région des Maritimes, MPO > >E-Mail: [EMAIL PROTECTED] > > > -Original Message- >Sent: Thursday, August 15, 2002 11:44 AM >To: Multiple recipients of list ORACLE-L >Subject:RE: Data Warehouse on Windows > >Don't forget the Oracle/Windows 4GB boundary corruption problem! > >Lewis Bishop >--- >Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant >Phone - 020 8298 3418 >Mobile - 07950 380857 >Email - [EMAIL PROTECTED] > > >-Original Message- >Sent: 15 August 2002 14:58 >To: Multiple recipients of list ORACLE-L > >This header confirms that this email message has been swept for the >presence of computer viruses. > >Corporate IT >THE WOOLWICH >-- > >Hi, >I was asked to give some hint for the hardware for a data warheouse running >on Win 2k and holding about 20-40 GB data. >Projec
RE: Data Warehouse on Windows
It is an Oracle on Windows problem. Basically it's not that you can't have files over 4GB - just don't have autoextend on (something I always avoid anyway). You CAN manually extend past the 4GB boundaries (ie 4, 8, 12...). Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 15 August 2002 18:54 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Was that corruption problem in Oracle or in the windows OS? I asked a Microsoft person here and he says that the file size limit for windows2000 is in exabytes. (2^64 bytes) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 15, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Subject: RE: Data Warehouse on Windows Don't forget the Oracle/Windows 4GB boundary corruption problem! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 15 August 2002 14:58 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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: Boivin, Patrice J 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 b
WG: Re: Data Warehouse on Windows
> Hi, Stephane, > actually we have the database running on Sybase but there it is way too > slow ( as I > told everyone here before). The application has about 25 small and about > 10 large > tables. Data comes in every night about 100-250MB. We have just about 20 > users > doing 'ad hoc' queries to the database via a commercial tool. At the > moment we > have a test installation running on an IBM computer having 2 processors a > 2Ghz, 2 > Gig RAM. Some typical queries involove joing 2 tables each holding > 2Million rows. > Test situation will represent data warehouse after being 3 years in > production. > Well, now the query takes about 15-20 Mintues which is too slow for our > sales > people. I calculated, the machine scans about 80-1Mio rows per second. > I thought, there are a lot of tuning possibilites in Oracle that are not > available in > Sybase. Our system can run on both RDBMS. So as we are buying a new > machine > for our database test environment I thought I better find out which is > best equipment > for Oracle as I expect people to learn that Sybase is not your number one > when you > go for a fdata warehouse. Overall we calculated, that we add new muodules > over > next couple of years so finally DW will hold 20 Gig data. > Windows is chosen as sales folk here says Windows machines are a lot > cheaper > than UNIX and the commercial tool needs some server processes available > not for > Linux > Any further recommendations? > Regards, > Antje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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: Data Warehouse on Windows
DW are memory hungry... It really depends on the application needs, there will be less than 20 users, if the design is good they won't be hitting raw ultra-detailed data with query using only one dimension ... Depending on the kind of data loads, 4G of ram can be quite enough for a small DW. Before buying the hardware, is there any capacity planning that will be done ? --- [EMAIL PROTECTED] a écrit : > Antje, > > Forgot to mention: The mgrs do know the memory > limitations > on Windows don't they, as DW are very memory hungry? > > Jared > > > > > > > "Sackwitz, Antje" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 08/15/2002 06:58 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Data Warehouse on Windows > > > Hi, > I was asked to give some hint for the hardware for a > data warheouse > running > on Win 2k and holding about 20-40 GB data. > Project will have about 40 small and 7-8 large > tables. Users <20. > Probably > long running queries. > Which hardware would you use? How many processors? > Which disks? > The os-system is set and cannot be Unix/Linux > according to management > decision. > Any tips/recommendations appreciated > Antje Sackwitz > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Sackwitz, Antje > 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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[2]: Data Warehouse on Windows
Well, there are options Jared. If your using a system that has 4 or fewer CPU's you could license standard edition which does not have all of the bells and whistles of Enterprise. That though would constrain a datawarehouse somewhat, but at $15K per processor it is cheaper. Now if you can absolutely tell Oracle who the users are and don't have a web server or other transaction processor in between the users and the data then you can go for a user based license. BUT you've got to license 5 users per processor minimum which as was said with < 20 users that's a good 4 CPU box. User licenses are $300 per on Standard and $800 per on Enterprise. Breaking out the old calculator yields a price tag of $16K for a 4 processor box with 20 users on Enterprise edition. Not too bad. But watch out for the maintenance too, that adds $3,520 to the purchase price & is an annual bill. Just make sure that whoever buys the server buys it with all of the memory(ram) it will hold. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 8/15/2002 2:51 PM Antje, Before you determine the number CPU's, you need to talk to your Oracle rep about your proposed DW and determine how they will make you license it. If you're not already under some kind of license that covers existing users on a new system, Oracle will likely tell you that you need to license per CPU. If that's the case, you might consider going with the fastest CPU's you can get, and limiting it to 2 CPU's. With that number of users and a fairly small DW, you would most likely be fine. Of course, I don't know anything about your requirements, but I do know that an EE license is $40k U.S. per CPU, which can really eat into the budget for a small project. HTH Jared "Sackwitz, Antje" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2002 06:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Data Warehouse on Windows Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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). -- 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: Data Warehouse on Windows
Unisys. Quoting [EMAIL PROTECTED]: > Antje, > > Forgot to mention: The mgrs do know the memory limitations > on Windows don't they, as DW are very memory hungry? > > Jared > > > > > > > "Sackwitz, Antje" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 08/15/2002 06:58 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Data Warehouse on Windows > > > Hi, > I was asked to give some hint for the hardware for a data warheouse > running > on Win 2k and holding about 20-40 GB data. > Project will have about 40 small and 7-8 large tables. Users <20. > Probably > long running queries. > Which hardware would you use? How many processors? Which disks? > The os-system is set and cannot be Unix/Linux according to management > decision. > Any tips/recommendations appreciated > Antje Sackwitz > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sackwitz, Antje > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: Data Warehouse on Windows
Antje, Before you determine the number CPU's, you need to talk to your Oracle rep about your proposed DW and determine how they will make you license it. If you're not already under some kind of license that covers existing users on a new system, Oracle will likely tell you that you need to license per CPU. If that's the case, you might consider going with the fastest CPU's you can get, and limiting it to 2 CPU's. With that number of users and a fairly small DW, you would most likely be fine. Of course, I don't know anything about your requirements, but I do know that an EE license is $40k U.S. per CPU, which can really eat into the budget for a small project. HTH Jared "Sackwitz, Antje" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2002 06:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Data Warehouse on Windows Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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).
Re: Data Warehouse on Windows
Antje, Forgot to mention: The mgrs do know the memory limitations on Windows don't they, as DW are very memory hungry? Jared "Sackwitz, Antje" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2002 06:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Data Warehouse on Windows Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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).
RE: Data Warehouse on Windows
Was that corruption problem in Oracle or in the windows OS? I asked a Microsoft person here and he says that the file size limit for windows2000 is in exabytes. (2^64 bytes) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 15, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Subject: RE: Data Warehouse on Windows Don't forget the Oracle/Windows 4GB boundary corruption problem! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 15 August 2002 14:58 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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: Boivin, Patrice J 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: Data Warehouse on Windows
RAID 0+1. Hardware mirroring. Pentium III, two CPUs and 1G of RAM. And a sysadmin who can set up the RAID (the contracting officer will break my hands if I touch hardware other than the keyboard). Get dual controllers if you can so you can do some worthwhile separating of redo logs and rollback segments. Probably it will be a Dell or a Gateway. Don't bother with a monitor bigger than 15". For some reason management figures that a high price computer needs a large monitor (probably some sort of Freudian envy at work there) but this is going to be a server that will sit off in a quiet corner with no one sitting at the keyboard. No sound board, no speakers, no fancy video board. "Sackwitz, Antje" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: root 08/15/2002 09:58 AM Please respond to ORACLE-L Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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: Thomas Day 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: Data Warehouse on Windows
Don't forget the Oracle/Windows 4GB boundary corruption problem! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 15 August 2002 14:58 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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: Data Warehouse on Windows
In a datawarehouse you want to exploit parallelism as much as possible. So you'd better with many processors and independant mount points. As raid 5 is very popular because it's cheaper, you will probably put your data on raid5 but fight to put your redo on non raid 5 disk. Do you have a good idea of the architecture ? Will you load the data daoly, weekly, monthly ? You may end up with a design where the database is non archivelog and allmost all the loads are done in direct path with nologging , then putting the redo on raid5 is less important. --- "Sackwitz, Antje" <[EMAIL PROTECTED]> a écrit : > Hi, > I was asked to give some hint for the hardware for a > data warheouse running > on Win 2k and holding about 20-40 GB data. > Project will have about 40 small and 7-8 large > tables. Users <20. Probably > long running queries. > Which hardware would you use? How many processors? > Which disks? > The os-system is set and cannot be Unix/Linux > according to management > decision. > Any tips/recommendations appreciated > Antje Sackwitz > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Sackwitz, Antje > 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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).
Data Warehouse on Windows
Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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).