cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
815
Views
0
Helpful
0
Comments
TCC_2
Advocate
Advocate

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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Quick Links