Oracle-L: Re: Datawarehousing help

From: <Cherie_Machler_at_gelco.com>
Date: Mon, 06 May 2002 04:43:22 -0800
Message-ID: <F001.00458A2D.20020506044322@fatcity.com>

Rachel,

Are you licensed for Oracle Designer?

We put the estimated row counts for each table into Designer and it produces a nice report showing sizing estimates per table or index, tablespace, and database. Pretty painless. You still need to add on extra space for archives, exports, backups, etc. but at least you can get a sizing estimate for the tables, themselves.

I'm not familiar with SAS.

Cherie Machler
Oracle DBA
Gelco Information Network

                                                                                                                        
                    Rachel_Carmichael_at_Son                                                                               
                    ymusic.com                  To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>     
                    Sent by:                    cc:                                                                     
                    root_at_fatcity.com            Subject:     Datawarehousing help                                       
                                                                                                                        
                                                                                                                        
                    05/03/02 05:08 PM                                                                                   
                    Please respond to                                                                                   
                    ORACLE-L

Okay, my background is OLTP, but we are looking at a data warehousing project
here....

any and all help appreciated! Specifically:

does anyone have any experience with a product called "SAS Datawarehousing Administrator" (or SAS)?
how do I go about doing rough estimates of sizing needs, assuming I will get rough numbers of information being collected, growth rates, length of history to keep, etc.

help?

Rachel

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Rachel_Carmichael_at_Sonymusic.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: Cherie_Machler_at_gelco.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 Mon May 06 2002 - 07:43:22 CDT