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: ODS

RE: ODS

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Wed, 28 Feb 2001 09:25:43 -0800
Message-ID: <F001.002BF96A.20010228075056@fatcity.com>

Dick,

100gb allocated or actually used?

thx

Ross

-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com] Sent: Wednesday, February 28, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Re:ODS

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). Received on Wed Feb 28 2001 - 11:25:43 CST

Original text of this message

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