Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: ODS

Re:RE: ODS

From: <dgoulet_at_vicr.com>
Date: Wed, 28 Feb 2001 10:58:09 -0800
Message-ID: <F001.002BFBBF.20010228094141@fatcity.com>

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" <MohanR_at_STARS-SMI.com>
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" <murali_vallath_at_hotmail.com>
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: murali_vallath_at_hotmail.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).
--

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).
<!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: dgoulet_at_vicr.com [<A HREF="mailto:dgoulet_at_vicr.com">mailto:dgoulet_at_vicr.com</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>&nbsp;&nbsp;&nbsp; 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>&nbsp;&nbsp;&nbsp; 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.&nbsp; 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.&nbsp; Each of these lines has a number of automatic testers that test the</FONT>
<BR><FONT SIZE=2>product.&nbsp; 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.&nbsp; 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.&nbsp; All of</FONT>
<BR><FONT SIZE=2>this data is flowing through the factory all day, 24x7.&nbsp; 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.&nbsp; 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>&nbsp;&nbsp;&nbsp; What size is this monster, 100GB and growing at about 20% per year (who said</FONT>
<BR><FONT SIZE=2>anything about a recession).&nbsp; 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.&nbsp; 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.&nbsp; 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.&nbsp; 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.&nbsp; 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 &quot;retire&quot; 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: &quot;Murali Vallath&quot; &lt;murali_vallath_at_hotmail.com&gt;</FONT> <BR><FONT SIZE=2>Date:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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,&nbsp; 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>&nbsp; INET: murali_vallath_at_hotmail.com</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
-- 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: 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).&nbsp; 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>&nbsp; INET: dgoulet_at_vicr.com</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
-- 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: 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).&nbsp; 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: 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 Wed Feb 28 2001 - 12:58:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US