Hash_area_size is used when doing hash joins which you
do more than nested loops in a datawarehouse
environment.
Large_pool_size can be used if you do parallel
processing or using MTS.
Oracle can tune it automatically if you set
parallel_automatic_tuning is set to true.
Any suggestions on this ?
- "Gopal , Umesh" <ugopal_at_proxicom.com> a écrit : >
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 ??
>
> I also require some guideline regarding setting the
> value of
> LARGE_POOL_SIZE, is this parameter set per server
> process like
> sort_area_size
>
> Thanks
> Umesh
>
> -----Original Message-----
> Sent: Wednesday, June 07, 2000 2:18 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos -- now, 100 FREE prints!
> http://photos.yahoo.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.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).
> --
> 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
Received on Thu Jun 08 2000 - 02:38:11 CDT
