Oracle-L: Mixing OLTP with DSS

From: Rick Stephenson <RStephenson_at_Ovid.com>
Date: Tue, 29 Oct 2002 10:19:46 -0800
Message-ID: <F001.004F6966.20021029101946@fatcity.com>

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: Rick Stephenson
INET: RStephenson_at_Ovid.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 - 12:19:46 CST