Hi folks,
Does SMON coaleses the free extents or the free blocks.
and one more thing, which view gives me the information about the free extents, so that i can decide whether i should coalesce the tablespace manaually.
Regards
sonia
Printable View
Hi folks,
Does SMON coaleses the free extents or the free blocks.
and one more thing, which view gives me the information about the free extents, so that i can decide whether i should coalesce the tablespace manaually.
Regards
sonia
extents of coz
dba_free_space
dba_free_space_coalesced