| 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: 34 databases to 1 database
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0296A.751C3930
Content-Type: text/plain;
charset="iso-8859-1"
The biggest problem you will have is maintainence concerns. What happens when half of the apps need to upgrade to the next version of the database, and the other half can't yet?
-----Original Message-----
From: Webber Valerie H [mailto:Valerie.H.Webber_at_irs.gov]
Sent: Thursday, September 28, 2000 8:20 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 34 databases to 1 database
What about the 34 schemas under one instance? Is that the best method to manage these databases? It will eventually be one database but much work has to be done in the application first.
Thanks for the quick response!
Val
-----Original Message-----
From: Khedr, Waleed [ mailto:Waleed.Khedr_at_FMR.COM
<mailto:Waleed.Khedr_at_FMR.COM> ]
Sent: Wednesday, September 27, 2000 5:22 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: 34 databases to 1 database
Four disks is not bad as long you end up with four spindles dedicated to your database. If not , then raid-5 will be better choice than raid 0+1 since you will end up having three spindles rather than two. You got plenty of memory to allocate to the SGA to avoid going to the disks.
Regards
Waleed
-----Original Message-----
Sent: Wednesday, September 27, 2000 4:26 PM
To: Multiple recipients of list ORACLE-L
I am working on a new project to take 34 Informix (approx. 5G each;1 is 13G)
that currently run on 5 UNIX Pyramids and convert to 1 Oracle database (8.1.6) on a SUN E10K.
Does anyone know of any issues to watch out for or any potential problem of having 1 database instance on Oracle and 34 schemas to reflect the current system. Does anyone know of a better solution? References to MetaLink/TechNet, etc welcomed.
The SUN E10K will have 8G of memory, 8 CPUs but only 4 18G disks (I know its
a nightmare with only 4 disks. Obviously a ridiculous decision made before I
joined the team...)
Thanks in advance!
Val
Valerie H. Webber
Management Systems Designers, Inc
Database Administrator
Valerie.H.Webber_at_irs.gov
704-569-1002 x107
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Khedr, Waleed INET: Waleed.Khedr_at_FMR.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). ------_=_NextPart_001_01C0296A.751C3930 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>RE: 34 databases to 1 database</TITLE> <META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD> <BODY> <DIV><SPAN class=281553316-28092000><FONT face=Arial color=#0000ff size=2>The biggest problem you will have is maintainence concerns. What happens when half of the apps need to upgrade to the next version of the database, and the other half can't yet? </FONT></SPAN></DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">Received on Thu Sep 28 2000 - 11:37:57 CDT
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Webber Valerie H [mailto:Valerie.H.Webber_at_irs.gov]<BR><B>Sent:</B> Thursday, September 28, 2000 8:20 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: 34 databases to 1 database<BR><BR></FONT></DIV>
<P><FONT size=2>What about the 34 schemas under one instance? Is that the best
method to manage these databases? It will eventually be one database but much work has to be done in the application first.</FONT></P>
<P><FONT size=2>Thanks for the quick response!</FONT> <BR><FONT
size=2>Val</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
Khedr, Waleed [<A href="mailto:Waleed.Khedr_at_FMR.COM">mailto:Waleed.Khedr_at_FMR.COM</A>]</FONT>
<BR><FONT size=2>Sent: Wednesday, September 27, 2000 5:22 PM</FONT> <BR><FONT
size=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT size=2>Subject: RE: 34 databases to 1 database</FONT> </P><BR>
<P><FONT size=2>Four disks is not bad as long you end up with four spindles
dedicated to</FONT> <BR><FONT size=2>your database. If not , then raid-5 will be better choice than raid 0+1</FONT> <BR><FONT size=2>since you will end up having three spindles rather than two. You got plenty</FONT> <BR><FONT size=2>of memory to allocate to the SGA to avoid going to the disks.</FONT>
<BR><FONT size=2> </FONT> <BR><FONT size=2>Regards</FONT> <BR><FONT
size=2> </FONT> <BR><FONT size=2>Waleed</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>Sent:
Wednesday, September 27, 2000 4:26 PM</FONT> <BR><FONT size=2>To: Multiple recipients of list ORACLE-L</FONT> </P><BR><BR>
<P><FONT size=2>I am working on a new project to take 34 Informix (approx. 5G
each;1 is 13G)</FONT> <BR><FONT size=2>that currently run on 5 UNIX Pyramids and convert to 1 Oracle database</FONT> <BR><FONT size=2>(8.1.6) on a SUN E10K. </FONT></P>
<P><FONT size=2>Does anyone know of any issues to watch out for or any
potential problem of</FONT> <BR><FONT size=2>having 1 database instance on Oracle and 34 schemas to reflect the current</FONT> <BR><FONT size=2>system. Does anyone know of a better solution? References to</FONT>
<BR><FONT size=2>MetaLink/TechNet, etc welcomed.</FONT> </P>
<P><FONT size=2>The SUN E10K will have 8G of memory, 8 CPUs but only 4 18G
disks (I know its</FONT> <BR><FONT size=2>a nightmare with only 4 disks. Obviously a ridiculous decision made before I</FONT> <BR><FONT size=2>joined the team...)</FONT> </P>
<P><FONT size=2>Thanks in advance! </FONT><BR><FONT size=2>Val
</FONT><BR><FONT size=2>Valerie H. Webber</FONT> <BR><FONT size=2>Management
Systems Designers, Inc </FONT><BR><FONT size=2>Database Administrator</FONT>
<BR><FONT size=2>Valerie.H.Webber_at_irs.gov</FONT> <BR><FONT size=2>704-569-1002
x107 </FONT></P><BR>
<P><FONT size=2>-- </FONT><BR><FONT size=2>Please see the official ORACLE-L
FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com</A></FONT> <BR><FONT size=2>-- </FONT><BR><FONT size=2>Author: Khedr, Waleed</FONT> <BR><FONT size=2> INET: Waleed.Khedr_at_FMR.COM</FONT> </P>
<P><FONT size=2>Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT size=2>--------------------------------------------------------------------</FONT>
<BR><FONT size=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT> <BR><FONT size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT size=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT size=2>also
 |
 |