Skip to main content
Delphix

How to Determine the Database Runtime Size and the Dataset Storage Size (KBA7949)

 

KBA

KBA# 7949

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

How to identify the database runtime size and its storage consumption on Delphix

runtime.databaseSize

The database runtime size is the size consumed by the database at the physical level. This is equivalent to the size shown under the configuration tab of the dataset in the GUI.

 

You can obtain this same information from the cli using the following steps:

1. Login to the cli as a delphix admin user.

2. Navigate to source.

3. Run the command list display=name,virtual,runtime.databaseSize.

 

runtime.databaseSize is the parameter that shows the size of the files loaded into the database at the physical level and not the size of the database after Delphix has compressed it. 

From a dSource perspective, the Manage > Datasets > Configuration tab shows the quantity of data the toolkit has sync'd to the Delphix Engine during ingestion.

During the initial provision of a VDB, the size of the VDB would be the same as that of the dSource from which it is provisioned. The size of the VDB will increase only when data has been loaded to it after the initial provision and then differs from the size of the dsource.

You can also view this by logging into the target host, initiating a sqlplus connection, and running the following command:

SQL> select db_unique_name,database_role,open_mode from v$database;


DB_UNIQUE_NAME         DATABASE_ROLE    OPEN_MODE
------------------------------ ---------------- --------------------
Vnewman_NFQ               PRIMARY  READ WRITE


SQL> select round(sum(bytes)/1024/1024/1024,2) as GB from v$datafile;


 GB
----------
      1.87

Dataset Storage

The dataset storage shown on the right side of the GUI when selecting a dataset is exactly the same as the storage consumption for that dataset set shown under the Resources > Storage Capacity screen.

This information can be obtained from the cli by navigating to capacity> consumer.

The data shown in the storage capacity screen corresponds to the size of the dataset after it is compressed and shows the storage utilized by the dataset on the Delphix end.

delphixengine capacity consumer> ls
Objects
CONTAINER         BREAKDOWN.ACTUALSPACE
Vnew_NFQ          1.56GB