Database Administrator (DBA) Question:
Download Questions PDF

What does coalescing a tablespace do?

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?