How can i change the pctincrease of tablespaces to 1
Printable View
How can i change the pctincrease of tablespaces to 1
There is no need to have a tablespace with pctincrease 1. Are you after SMON coalesing free space every 5th minute?
which consumes resources
but if you are happy with it then
alter tablespace system default storage(pctincrease 1)
yes i want smon to coalesce the tablespace. As tablespaces get fragmented so i want the smon to coalesce it. Is that a bad idea? what is the alternative to get fragmented space back?
Cheers
UKDBA
alter tablespace static_idx default storage(pctincrease 1);
seems like i was a bit late . :)
well coalesce uses quite a lot of resources that is why