RE: TEMP tablespace size in a Data Warehouse

Charlie,

the rule of thumb must be 1.5 times the size of your largest table.

Regards, Richard Klavers

Tel.: 00 31 (0)79 371 2543
Fax: 00 31 (0)79 371 2529
E-mail: r.klavers_at_arbeidsbureau.nl

> ----------
> Van: Charlie Mengler[SMTP:charliem_at_mwh.com]
> Antwoord naar: ORACLE-L_at_fatcity.com
> Verzonden: maandag 12 juni 2000 23:12
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: TEMP tablespace size in a Data Warehouse
>
> Is there any "rule of thumb" that can be used to guesstimate the
> appropriate size
> of the TEMP tablespace in a data warehouse instance? For example
> XXX% of total size or
> TEMP should be 1.YY * the size of the largest table or
> TEMP should be 1.ZZ * the size of the largest index or
> ??????
>
> Along these lines what can be done to minimize or reduce the amount of
> TEMP
> that is needed & what are the trade-offs involved. (This is beside the
> "obvious"
> response WRT to sorts & Sort Area Size.)
>
> --
> Charlie Mengler Maintenance Warehouse
> charliem_at_mwh.com 5505 Morehouse Drive
> 858-552-6229 San Diego, CA 92121
> Always be sincere about your enthusiasm, whether you mean it or not.
> --
> Author: Charlie Mengler
> INET: charliem_at_mwh.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).
Received on Tue Jun 13 2000 - 00:48:28 CDT