Database Administrator (DBA) Question:

Download Job Interview Questions and Answers PDF

What does coalescing a tablespace do?

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

Answer:

Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents.

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
What are the different Parameter types?What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?