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" <[EMAIL PROTECTED]>
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>
<P><FONT SIZE=2 FACE="Arial">Hello all -</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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. </FONT></P>
<P><FONT SIZE=2 FACE="Arial">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.) </FONT></P>
<P><FONT SIZE=2 FACE="Arial">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). </FONT></P>
<P><FONT SIZE=2 FACE="Arial">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. </FONT></P>
<P><B><FONT SIZE=1 FACE="Arial">Lisa Rutland Koivu</FONT></B>
<BR><FONT SIZE=1 FACE="Arial">Oracle Database Administrator</FONT>
<BR><FONT SIZE=1 FACE="Arial">Qode.com</FONT>
<BR><FONT SIZE=1 FACE="Arial">4850 North State Road 7</FONT>
<BR><FONT SIZE=1 FACE="Arial">Suite G104</FONT>
<BR><FONT SIZE=1 FACE="Arial">Fort Lauderdale, FL 33319</FONT>
</P>
<P><FONT SIZE=1 FACE="Arial">V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=1 FACE="Arial">F: 954.484.2933 </FONT>
<BR><FONT SIZE=1 FACE="Arial">C: 954.658.5849</FONT>
<BR><FONT SIZE=1 FACE="Arial"><A HREF="http://www.qode.com"
TARGET="_blank">http://www.qode.com</A></FONT>
</P>
<P><I><FONT COLOR="#000000" SIZE=1 FACE="Arial">"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."</FONT></I></P>
</BODY>
</HTML>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [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).
