Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: System TS size

RE: System TS size

From: Gopal , Umesh <>
Date: Wed, 7 Jun 2000 15:22:10 -0400
Message-Id: <>

I will be running oracle 8i enterprise on Sun sparc machine 2 gb ram 100 Gb RAW data on 700 Gb available storage

Please tell me how hash_area_size is used ??=20

I also require some guideline regarding setting the value of LARGE_POOL_SIZE, is this parameter set per server process like sort_area_size


-----Original Message-----
From: paquette stephane [] Sent: Wednesday, June 07, 2000 2:18 PM
To: Multiple recipients of list ORACLE-L Subject: Re: System TS size

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.


Stephane Paquette
DBA Oracle
(33) 01 53 93 06 50

Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D   INET:
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: (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 Received on Wed Jun 07 2000 - 14:22:10 CDT

Original text of this message