Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Temp space vs. table size
I currently have 2 temp segments, one 40 and one 70 meg, 550 extents
at 256K each percent increase set to 0. I keep running out of temp
space while doing a non-grouping query on a very wide (72 fields),
very long table. This table comes in at just under 800 meg. Is there
some sort of desired ratio between temp space and your largest table?
Thanks in advance,
derwoud_at_bellsouth.net
Received on Thu Dec 04 1997 - 00:00:00 CST