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

How to query the SA 2.0 MPDS databases for the current percentage utilized for each data file

353
Views
0
Helpful
0
Comments

Core Issue

To avoid running out of space, it is important to track the utilized size for each data file on each Oracle database.

Resolution

To query the Service Agent (SA) 2.0 Master Provisioning Data Store (MPDS) for the percentage of each data file utilized in Oracle databases, perform these steps:

  1. Login to both Oracle databases through SQLPlus (enter sqlplus) as the "system" user.

  2. Run this command:

    select t.file_name, sum(f.bytes), t.bytes, (sum(f.bytes)/t.bytes)*100 from dba_free_space f, dba_data_files t where t.file_id = f.file_id group by t.file_name, f.file_id, t.bytes;

    This is an e
    xample of the command output:

    FILE_NAME
    --------------------------------------------------------------------------------
    SUM(F.BYTES)  BYTES (SUM(F.BYTES)/T.BYTES)*100
    ------------ ---------- --------------------------
    /db002/oradata/database1/tools01.dbf
      10420224  10485760  99.375
    /db002/oradata/database1/undotbs.dbf
      384499712  419430400  91.671875
    /db002/oradata/database1/users01.dbf
      104726528  104857600  99.875

Note: This output represents the current free space for each data file.

Create
Recognize Your Peers
Content for Community-Ad