| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Mixing OLTP with DSS
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.
dwilliams_at_lifetouch.com
-----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.
rick_stephenson_at_ovid.com
-----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.
dwilliams_at_lifetouch.com
-----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: DWILLIAMS_at_LIFETOUCH.COM
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Wed Oct 30 2002 - 22:23:32 CST
 |
 |