Re: Simple Oracle Query Taking Too Long

> Now, I'll be darned if I could remember what cunning process
> only ran with pct_increase != 0, but you should know, Daniel.

If the tablespace had a default PCTINCREASE <> 0 then SMON would coalesce free extents. If set to 0, then SMON would not coalesce free extents. This had nothing to do with the PCTINCREASE on the table, but the tablespace's default value. You could set PCTINCREASE=0 on the segment and still have SMON coalesce free space in the tablespace.

And for the record, I sure do not miss those days!! Use LMT's and start living!!!!

;)

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown