How to determine the true available space in the UNIFI database - WKB32608

OBJECTIVE or GOAL

Determine the true available space in the UNIFI database after archiving data manually or via OSM.

ENVIRONMENT

• UNIFI 1.8.x
• UNIFI 1.9.x

PROCEDURE

Method 1

1. Log in to Windows using a user who is local admin and a member of the ora_dba group.
2. Copy the attached diskusage.bat file to the workstation or network server.
3. Double-click the batch file.

Method 2

1. Log in to Windows using a user who is local admin and a member of the ora_dba group.
2. Open command line using "Run as Administrator".
3. Change directory to C:\Program Files\Waters\UNIFI\Server\Bin.
4. Run command: Waters.Deployment.InstallUtil.exe database DisplayDiskUsage.

Output (from either method)

 

The output shows:

1. The red value shows the total size of the database disk or ASM disk group.

2. The orange value is the current maximum size set for the database. It will not grow greater than this value. Note: Workstations are set with a limit of 200 data files This limits them to about 3.5 TB.

3. The pink value is the current allocated size used by Oracle data files. The database has expanded this much so far.

4. The green value is the high water mark (i.e., the highest point occupied by data). Normally this is close to the pink value.

5. The blue value shows the current free space in the existing data files (cleared by exports of data).

This database has lots of free space. In total, it has 199 GB without expanding and another 700 GB free before it expands to the quota.

The quota can be increased in WDM if necessary, but space should always be left for the other tablespaces.

ADDITIONAL INFORMATION

The attached batch file helps run the above script more easily. Just double-click.