1.

What Is A Locally Managed Tablespace?

Answer»

Locally Managed Tablespace is a tablespace that record extent allocation in the tablespace header.
Each tablespace manages it's own free and used SPACE within a bitmap structure stored in one of the tablespace's DATA files.

ADVANTAGES of Locally Managed Tablespaces:

  • Eliminates the need for recursive SQL OPERATIONS against the data dictionary (UET$ and FET$ tables).
  • Reduce contention on data dictionary tables (single ST enqueue).
  • Locally managed tablespaces eliminate the need to periodically coalesce free space (automatically tracks ADJACENT free space).
  • Changes to the extent bitmaps do not generate rollback information.

Locally Managed Tablespace is a tablespace that record extent allocation in the tablespace header.
Each tablespace manages it's own free and used space within a bitmap structure stored in one of the tablespace's data files.

Advantages of Locally Managed Tablespaces:


Discussion

No Comment Found

Related InterviewSolutions