• Arun Kumar

Tablespace Coalesce

DBA Weekly Task

  • For each datafile in the tablespace, it combines all contiguous free extents into larger contiguous extents.

  • It is a command to take any free extents that are right next to some other free extent and make one bigger free extent.

  • SMON will perform this coalescing in the background but if you need it to happen right now, coalesce will do it.

ALTER TABLESPACE USERS COALESCE;


Recent Posts

See All

SQL Data-Type conversion functions

SQL conversion functions are single row functions designed to alter the nature of the data type of a column value, expression, or literal. TO_CHAR, TO_NUMBER, and TO_DATE are the three most widely use

Automatic SQL Tuning in Oracle

Database optimizer runs very fast and must select the best execution plan for a query within fraction of seconds. Due to time constraint (under normal query execution), sometimes optimizer will choose

Top resource intensive SQL

Database performance is a major concern for a DBA. SQLs are the ones which needs proper DB management in order to execute well. At times the application team might tell you that the database is runnin

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback