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
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?
alter tablespace static_idx default storage(pctincrease 1);
Vinit
seems like i was a bit late .
Vinit
well coalesce uses quite a lot of resources that is why
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width
Reply With Quote
Bookmarks