What is a dictionary-managed tablespace?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a dictionary-managed tablespace?
Rating:
A tablespace that stores metadata regarding free/used extents and extent allocation in the data dictionary is called a dictionary-managed tablespace. Oracle uses the data dictionary to track allocated and free extents for dictionary-managed tablespaces. Data regarding free extents is recorded in the FET$ data dictionary table, whereas data regarding used extents is recorded in the UET$ data dictionary table. Oracle automatically updates these tables whenever an extent is allocated or freed for reuse in a dictionary-managed tablespace.
Rating:
Was this information helpful?
Other articles
- What is data dictionary cache?
- What is SYSDBA?
- Things to practice for Oracle test 1Z0-031.
- What is SHUTDOWN command?
- What is operating system authentication?