Oracle Get table Space file size

Oracle obtains tablespace file information through query dba_segments table, including table space name, size, etc.
?

1	Select Tablespace_name,sum (max_size), sum (bytes) from dba_segments Group by Tablespace_name;

The units of max_size and bytes are bytes. The above SQL statement is executed in a stored procedure, and sometimes a dba_segments "table or view does not exist" error occurs. This is because the Dba_segments table's query permissions are not assigned to the current user. The following statement needs to be executed for authorization.

?

1	Grant SELECT on dba_segments to User

User is the username to authorize. If additional permissions are required, you can use the following statement to assign all permissions to user

?

1	Grant all on dba_segments to user;