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.
Received on Mon Jun 12 2000 - 15:02:14 CDT
