Useful SQL Queries for TableSpace Management
(Doc ID 1380813.1)
Last updated on FEBRUARY 02, 2022
Applies to:Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
This article provides a few SQL queries that a Database Administrator may find useful to manage Tablespaces with a focus on their usage. The queries are formatted to create neat reports and can serve as a base to be customized.
It also provides very short description on each column, but does not explain in detail the concepts of Tablespaces, Segments, Extents and their management, which is out of this document's scope.
The scripts are meant for database administrators and support engineers. A basic understanding of the concepts of TableSpace, DataFile, Segments, Extents as well as basic knowledge of SQL statement nomenclature are welcome.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|List tablespaces, their data files properties and usage|
|List tablespaces, their status and usage|
|List segments of a tablespace, their properties and sizes|