Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Coalesce temp?
I have a 24x7 database (version 7.3.2) that's been up for quite some time. I just checked dba_free_space_coalesced and noticed that my TEMP tablespace is at .5% coalesced. I'm thinking of setting its PCTFREE to 1 just so SMON will coalesce it, but I'm concerned that there may be penalties or side effects. Opinions? Received on Mon Feb 16 1998 - 00:00:00 CST