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).