Ross,
There's 100GB in use. I'm in the process, along with our SA of adding
another 20GB of additional available disk space. Yeah this a pretty big ODS,
but the end users want a minimum of 90 days back data & with a build plan that
approaches the vertical over the next 6 months!!!
Dick Goulet
____________________Reply Separator____________________
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date: 2/28/2001 7:50 AM
Dick,
100gb allocated or actually used?
thx
Ross
-----Original Message-----
Sent: Wednesday, February 28, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Murali,
Since we use what I really believe is an Operational Data Store or ODS,
I'll
provide the insight from here, others may have their own opinion.
We are a manufacturer of power components, little modules that fit into
larger power supplies, like the one in your PC. As a result we have a
number of
manufacturing lines each building different or the same product at the same
time. Each of these lines has a number of automatic testers that test the
product. These testers need data on the specifications that they are to
test
the modules to at each point in the process and they also need a location
where
they send the results of those tests. On top of all that we also collect
statistical process control data and failure analysis data when a
technicians
repair a defective module, at least before it gets filled with epoxy. All
of
this data is flowing through the factory all day, 24x7. On top of that
engineers are looking at the results data looking for trends in both tester
performance from lost of angles, and module behavior. Yes this ODS does
feed
into our Data Warehouse on a daily basis, but of more importance is the
real-time monitoring that occurs to keep yields in line with company
expectations.
What size is this monster, 100GB and growing at about 20% per year (who
said
anything about a recession). We use EMC disk with mirroring, a HP9000 K570
as
the processor with redundant processors and power supplies, and the box will
be
getting EMC's PowerPath software in a month or so. The block size is 8K and
the
SGA is running around 500MB, believe it or not the biggest performance boost
we
gave the instance was to raise the shared pool to 150M. We use 4 DBWR
slaves
and 10M logfiles to keep the recovery granularity fairly fine, although we
haven't had to recover this db in over 4 years. This system is running
24x7,
gets quarterly cold backup with weekly hot backups, runs in archivelog mode,
and
dedicated server. One note, the predecessor to the current computer set the
company record for uptime on a HP-UX box at 18 months, including the
database.
On an average day I'd estimate that this system takes in half to 1GB of data
and
sends out better than 10GB in answer to user requests. We also "retire" to
tape
approximately 100MB of data a day and dump 300MB of redundant data each day
too.
Dick Goulet
____________________Reply Separator____________________
Author: "Murali Vallath" <[EMAIL PROTECTED]>
Date: 2/27/2001 12:39 PM
Hello Everyone,
This new term Operational Data Store(ODS) has many definitions, like staging
area to the data warehouse, data mart, A data warehouse or reporting
database, a archive area etc etc. updated almost real time.
>From your experience, is this being used in the Oracle world. What size are
these databases? What configuration is this on? What is the uptime?
I have a requirement that this should be a 24*7 database. Anyone would like
to share their experiences.
Regards,
Murali Vallath
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Murali Vallath
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).
--
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).
<!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>RE: ODS</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Dick, </FONT>
</P>
<P><FONT SIZE=2>100gb allocated or actually used?</FONT>
</P>
<P><FONT SIZE=2>thx</FONT>
</P>
<P><FONT SIZE=2>Ross</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: [EMAIL PROTECTED] [<A
HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, February 28, 2001 10:05 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Re:ODS</FONT>
</P>
<BR>
<P><FONT SIZE=2>Murali,</FONT>
</P>
<P><FONT SIZE=2> Since we use what I really believe is an
Operational Data Store or ODS, I'll</FONT>
<BR><FONT SIZE=2>provide the insight from here, others may have their own
opinion.</FONT>
</P>
<P><FONT SIZE=2> We are a manufacturer of power components,
little modules that fit into</FONT>
<BR><FONT SIZE=2>larger power supplies, like the one in your PC. As a
result we have a number of</FONT>
<BR><FONT SIZE=2>manufacturing lines each building different or the same product
at the same</FONT>
<BR><FONT SIZE=2>time. Each of these lines has a number of automatic
testers that test the</FONT>
<BR><FONT SIZE=2>product. These testers need data on the specifications
that they are to test</FONT>
<BR><FONT SIZE=2>the modules to at each point in the process and they also need
a location where</FONT>
<BR><FONT SIZE=2>they send the results of those tests. On top of all that
we also collect</FONT>
<BR><FONT SIZE=2>statistical process control data and failure analysis data when
a technicians</FONT>
<BR><FONT SIZE=2>repair a defective module, at least before it gets filled with
epoxy. All of</FONT>
<BR><FONT SIZE=2>this data is flowing through the factory all day, 24x7.
On top of that</FONT>
<BR><FONT SIZE=2>engineers are looking at the results data looking for trends in
both tester</FONT>
<BR><FONT SIZE=2>performance from lost of angles, and module behavior. Yes
this ODS does feed</FONT>
<BR><FONT SIZE=2>into our Data Warehouse on a daily basis, but of more
importance is the</FONT>
<BR><FONT SIZE=2>real-time monitoring that occurs to keep yields in line with
company</FONT>
<BR><FONT SIZE=2>expectations.</FONT>
</P>
<P><FONT SIZE=2> What size is this monster, 100GB and growing
at about 20% per year (who said</FONT>
<BR><FONT SIZE=2>anything about a recession). We use EMC disk with
mirroring, a HP9000 K570 as</FONT>
<BR><FONT SIZE=2>the processor with redundant processors and power supplies, and
the box will be</FONT>
<BR><FONT SIZE=2>getting EMC's PowerPath software in a month or so. The
block size is 8K and the</FONT>
<BR><FONT SIZE=2>SGA is running around 500MB, believe it or not the biggest
performance boost we</FONT>
<BR><FONT SIZE=2>gave the instance was to raise the shared pool to 150M.
We use 4 DBWR slaves</FONT>
<BR><FONT SIZE=2>and 10M logfiles to keep the recovery granularity fairly fine,
although we</FONT>
<BR><FONT SIZE=2>haven't had to recover this db in over 4 years. This
system is running 24x7,</FONT>
<BR><FONT SIZE=2>gets quarterly cold backup with weekly hot backups, runs in
archivelog mode, and</FONT>
<BR><FONT SIZE=2>dedicated server. One note, the predecessor to the
current computer set the</FONT>
<BR><FONT SIZE=2>company record for uptime on a HP-UX box at 18 months,
including the database. </FONT>
<BR><FONT SIZE=2>On an average day I'd estimate that this system takes in half
to 1GB of data and</FONT>
<BR><FONT SIZE=2>sends out better than 10GB in answer to user requests. We also
"retire" to tape</FONT>
<BR><FONT SIZE=2>approximately 100MB of data a day and dump 300MB of redundant
data each day too.</FONT>
</P>
<P><FONT SIZE=2>Dick Goulet</FONT>
</P>
<P><FONT SIZE=2>____________________Reply Separator____________________</FONT>
<BR><FONT SIZE=2>Author: "Murali Vallath"
<[EMAIL PROTECTED]></FONT>
<BR><FONT SIZE=2>Date: 2/27/2001 12:39
PM</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hello Everyone,</FONT>
</P>
<P><FONT SIZE=2>This new term Operational Data Store(ODS) has many definitions,
like staging </FONT>
<BR><FONT SIZE=2>area to the data warehouse, data mart, A data warehouse or
reporting </FONT>
<BR><FONT SIZE=2>database, a archive area etc etc. updated almost real
time.</FONT>
</P>
<P><FONT SIZE=2>From your experience, is this being used in the Oracle world.
What size are </FONT>
<BR><FONT SIZE=2>these databases? What configuration is this on? What is the
uptime?</FONT>
</P>
<P><FONT SIZE=2>I have a requirement that this should be a 24*7 database. Anyone
would like </FONT>
<BR><FONT SIZE=2>to share their experiences.</FONT>
</P>
<P><FONT SIZE=2>Regards,</FONT>
</P>
<P><FONT SIZE=2>Murali Vallath</FONT>
</P>
<P><FONT
SIZE=2>_________________________________________________________________</FONT>
<BR><FONT SIZE=2>Get your FREE download of MSN Explorer at <A
HREF="http://explorer.msn.com"
TARGET="_blank">http://explorer.msn.com</A></FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: <A
HREF="http://www.orafaq.com" TARGET="_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Murali Vallath</FONT>
<BR><FONT SIZE=2> INET: [EMAIL PROTECTED]</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>--------------------------------------------------------------------</FON
T>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT>
<BR><FONT SIZE=2>to: [EMAIL PROTECTED] (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 send the HELP command for other information (like
subscribing).</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: <A
HREF="http://www.orafaq.com" TARGET="_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: </FONT>
<BR><FONT SIZE=2> INET: [EMAIL PROTECTED]</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>--------------------------------------------------------------------</FON
T>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT>
<BR><FONT SIZE=2>to: [EMAIL PROTECTED] (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 send the HELP command for other information (like
subscribing).</FONT>
</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).
