Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which command would you use to change the size of the minimum extent allocated to the USER_DATA tablespace from 2M to 3M?

April 26, 2017allocated Command extent minimum size tablespace

0

Posted

Which command would you use to change the size of the minimum extent allocated to the USER_DATA tablespace from 2M to 3M?

1 Answer

0

Posted

ALTER TABLESPACE MINIMUM EXTENT Use the ALTER TABLESPACE command to change the MINIMUM EXTENT value or the DEFAULT STORAGE parameters for a tablespace. • Evaluate this command: ALTER TABLESPACE data01 COALESCE; Which background process performs the same task? Coalescing merges neighboring free extents. This is automatically done by the SMON background process if the PCTINCREASE value for the tablespace is greater than zero. You can manually coalesce a tablespace by using this command: ALTER TABLESPACE tablespace_name COALESCE; Query DBA_FREE_SPACE_COALESCED to determine if a tablespace needs to be coalesced.