Re: System TS size

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Wed, 7 Jun 2000 10:06:21 -0700 (PDT)
Message-Id: <10521.108073@fatcity.com>

100 GB data warehouse, is that the raw data or the total disk space you think you will have ?

The system tablespace is never a big one, in fact its size depend a lot on the version of Oracle you're using. Between 200 and 300 megs.

In the other hands the temp tablespace in a datawarehouse is a big one.
Will your fact tables be partitionned ?
Do you have a lot of aggregates ?
Will you grind a lot of data ?
Around 1.5 time the largest table is a good start.

For the rollback segment, it depends on how much data you will load .

In your case, the sort_area_size will be less important than hash_area_size. I increased the hash_area_size to a very large value (that was 2 years ago, around 300-400 M I think) in the sql scripts doing the aggegates.

The SGA size will vary according to your needs. Will there be a lot of users querying the warehouse or will the data be loaded in desktop olap tool,.... there are a lot of configurations. It depens on what you do.

I recommend the Oracle 8 and 8i books on datawarehousing by Gary Dodge and Tim Gorman.

HTH

• "Gopal , Umesh" <ugopal_at_proxicom.com> a écrit : >
  > I am planning a 100 Gb data warehouse, with largest
  > talble about 25 Gb on
  > machine with 2 Gb memory,
  > Can anyone please provide a me with a guideline as
  > to what a
  > good size for the following would be :
  >
  > SYSTEM tablespace,
  > TEMPORARY tablespace
  > ROLLBACK segment Tablespace
  > SORT_AREA_SIZE parameter
  > SGA size
  >
  > All help appreciated
  >
  > Umesh
  > --
  > Author: Gopal , Umesh
  > INET: ugopal_at_proxicom.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).
  

  ---

Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50

---

Received on Wed Jun 07 2000 - 12:06:21 CDT