Separate instances -- good idea, it'll be easier to move the warehouse to its new server once you find what it does to your OLTP users. I hope things work out for you and you figure a way to insulate the two instances from each other. We run a lot of OLTP instances on the same server, but boy that DW was a new experience! In my case, I've never seen management get out the checkbook so eagerly. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED]
-----Original Message----- Sent: Wednesday, October 30, 2002 9:49 AM To: Multiple recipients of list ORACLE-L I have been leaning toward bringing up another instance, and I think I will go that route. The new data that will hold 100's of GB will not tie into any of the data currently in our OLTP database. I will also have more flexibility to tune each instance separately for their specific needs. Thanks for the insight. Rick Stephenson Oracle Database Administrator Ovid Technologies, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, October 29, 2002 10:04 PM To: Multiple recipients of list ORACLE-L Rick - See the other message titled: Adhoc queries and limiting the amount of records returned". We thought we would start our DW economically and store it with an existing OLTP system. Bought a separate server real quick. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, October 29, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Am I looking for trouble by mixing an OLTP type database with a DSS type database? I currently have a relatively small database that is used for quick lookup type actions. The company wants to add a much bigger and constantly growing application for historical reporting on the same machine. Should I create another instance or keep it in the same instance? Keeping it in the same instance would seem to defeat having anything cached seeing that the large reports will flush out the cache each and every time. I am running Oracle 8.1.7, on Solaris 2.8. Any suggestions would be helpful. Thanks, Rick Stephenson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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: Rick Stephenson INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
