Oracle-L: RE: Mixing OLTP with DSS

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 29 Oct 2002 21:03:50 -0800
Message-ID: <F001.004F7085.20021029210350@fatcity.com>

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). Received on Tue Oct 29 2002 - 23:03:50 CST