How to view the usage of database table spaces?

To view the usage of database table spaces, you can use one of the following methods:

1. Utilize system tables: Retrieve information on tablespace usage by querying the dba_data_files view and the dba_free_space view with the following SQL statement.
2. Retrieve the tablespace name, file name, and size in MB from the data files table. Also, retrieve the tablespace name and free space in MB from the free space table.
3. This will display the file name and size of each tablespace, as well as the available space size of each tablespace.
4. Generate a report on tablespace usage: In SQL*Plus or SQL Developer, you can run the following command to create a tablespace usage report.
5. Display 1000 rows per page and set the line size to 200 characters. Format the tablespace name to 20 characters, and the used, free, and total space to show with comma separators. Retrieve the tablespace name, used space, free space, and total space from the database table dba_tablespace_usage_metrics.
6. This will display the used space, available space, and total space of each table space.
7. You can check the table space usage by accessing Oracle Enterprise Manager (OEM), logging in, and navigating to “Database” > “Tablespaces”. From here, you can view the usage of each table space along with other related metrics.

Please note that these methods may require you to have appropriate permissions to access database-related views and tools.