How can I coalesce free space?

santosh
Posts: 1311
Joined: Wed Sep 07, 2016 4:43 pm

How can I coalesce free space?

Postby santosh » Sat Nov 12, 2016 2:46 pm

How can I coalesce free space?

raoneel2016
Posts: 824
Joined: Wed Oct 05, 2016 2:40 pm

Re: How can I coalesce free space?

Postby raoneel2016 » Sat Nov 12, 2016 2:47 pm

SMON coalesces free space (extents) into larger, contiguous extents every 2 hours and even then only for a short period of time.

SMON will not coalesce free space if a tablespace's default storage parameter "pctincrease" is set to 0. One can manually coalesce a tablespace using the ALTER TABLESPACE ... COALESCE; command.


Return to “Oracle”

Who is online

Users browsing this forum: No registered users and 3 guests