Check Tablespace Size in PL/SQL: Quick Guide

In PL/SQL, you can use the following statement to view the size of a tablespace:

SELECT tablespace_name, ROUND(SUM(bytes) / 1024 / 1024, 2) AS "Size (MB)"
FROM dba_data_files
GROUP BY tablespace_name;

This statement will return the name and size (in MB) of each tablespace. You can replace it with a query that fits your needs.