cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Community Helping Community

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

783
Views
0
Helpful
0
Comments

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';

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here