How to query the SA 2.0 MPDS databases for the current tablespace size

[TCC_2]

Resolution

To query both Master Provisioning Data Store (MPDS) databases for the current tablespace size, perform these steps:

1. Login to the Oracle databases through SQLPlus (enter sqlplus to do this) as the "system" user.
   
   
2. Run the select bytes/1024 from dba_data_files where tablespace_name = 'name_of_the_tablespace'; command.
   
   This is an example:
   
   SQL> select bytes/1024 from dba_data_files where tablespace_name = 'USERS';