Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

764
Views
0
Helpful
0
Comments