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@Son
ymusic.com To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] 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:
1) does anyone have any experience with a product called "SAS
Datawarehousing
Administrator" (or SAS)?
2) 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: [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).
