How come the system tablespace is so big ?
I had a 80G warehouse and the system tablespace was
not that big.
- Janardhana Babu <jbdonga_at_ucdavis.edu> a écrit : >
SYSTEM ... 1GB
> TEMP ... 3GB
> RBS ... 3GB
> SORT_AREA_SIZE 512K
> SGA ... not more than 50% of the total available
> RAM
>
> The above sizes are working excellent for 140GB
> datawarehouse database.
> I set these values when the DB was 50GB. Leave 1GB
> free space in RBS when
> creating rollback segments.
>
> -- Janardhana Babu
> At 06:47 AM 6/7/00 -0800, Gopal , Umesh wrote:
>
> >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).
>
> --
> Author: Janardhana Babu
> INET: jbdonga_at_ucdavis.edu
>
> 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 - 14:11:44 CDT
