Re:One Database, Multiple Apps

From: <dgoulet_at_vicr.com>
Date: Mon, 12 Mar 2001 10:16:09 -0800
Message-ID: <F001.002C9D4A.20010312094717@fatcity.com>

Lisa,

If this is a purchased application, which it does not sound like, you may not have an option since many a third party vendor loves to run rough shod over the database. I've got a message in work to the list on a third party product we recently installed which is a "bad actor" in this regards. Anyway, if you are developing the application then having it in the same instance will be a performance booster. When ever you deal with two or more instances you end up with SQL*Net, Net8, or whatever else Oracle likes to call it, in between & that is a performance bottleneck.

Dick Goulet

____________________Reply Separator____________________
Author: "Koivu; Lisa" <lkoivu_at_qode.com>
Date:       3/12/2001 8:26 AM

Hello all -

I have one medium-large production database here. Our system is hybrid but more similar to OLTP. As far as I know quick inserts are not a problem. I need to implement tracking software, where all I'd have to do from the database side is just collect records very quickly without impacting the speed of page views. This tracking software connects via JDBC and really does not care about dbms versions. I am thinking of just implementing a schema in my current database for this purpose and making the table as quick for inserts as possible (no primary key, minimal indexing, PCTUSED set appropriately, etc.)

Honestly I can't think of a good reason for creating a separate database other than I'd be creating a bunch of configuration work for myself as well as modifying our backup and recovery strategy (which I am comfortable with doing). Any reporting off this raw data will be done in a "reporting" database, or off Cognos cubes. I thought about any advantages to having one database available when the other is down, and really there are none (if one is down, the entire application will not be available).

Has anyone had to configure databases in this manner and if so, what other ideas came into play when deciding whether or not to have one database serve more than one application? Thanks for any comments you may have.

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>One Database, Multiple Apps</TITLE>
</HEAD>
<BODY>

Hello all -


I have one medium-large production database here.
Our system is hybrid but more similar to OLTP.  As far as I know quick inserts are not a problem.

I need to implement tracking software, where all
I'd have to do from the database side is just collect records very quickly without impacting the speed of page views.  This tracking software connects via JDBC and really does not care about dbms versions.  I am thinking of just implementing a schema in my current database for this purpose and making the table as quick for inserts as possible (no primary key, minimal indexing, PCTUSED set appropriately, etc.)

Honestly I can't think of a good reason for
creating a separate database other than I'd be creating a bunch of configuration work for myself as well as modifying our backup and recovery strategy (which I am comfortable with doing).  Any reporting off this raw data will be done in a "reporting" database, or off Cognos cubes.    I thought about any advantages to having one database available when the other is down, and really there are none (if one is down, the entire application will not be available).

Has anyone had to configure databases in this
manner and if so, what other ideas came into play when deciding whether or not to have one database serve more than one application?  Thanks for any comments you may have.

Lisa Rutland Koivu
 Oracle Database Administrator
 Qode.com
 4850 North State Road 7
 Suite G104
 Fort Lauderdale, FL  33319


V: 954.484.3191, x174
 F: 954.484.2933 
 C: 954.658.5849
 <A HREF="http://www.qode.com"
TARGET="_blank">http://www.qode.com</A>


"The information contained
herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

</BODY>
</HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

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: 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 Mon Mar 12 2001 - 12:16:09 CST