Oracle Tablespace File Sizes: How to View

1 year ago
Isabella Edwards
1 minute

To view the size of tablespace files, you can use the following SQL statement:

SELECT tablespace_name, file_name, bytes / 1024 / 1024 AS "Size (MB)" 
FROM dba_data_files;

This SQL statement will display the names and sizes (in MB) of all tablespace files. You can execute this SQL statement to view the sizes of tablespace files.

bannerAds