Database Autonomy Service (DAS) storage analysis shows how much storage a database instance is consuming, how fast it is growing, and how many days of storage remain. Use it to catch space issues early and identify the tables or databases driving growth.
Limitations
-
Storage analysis supports up to 20,000 tables per instance.
-
The postgres, template0, and template1 system databases are excluded from analysis.
View storage analysis
Prerequisites
Before you begin, ensure that you have:
-
Access to the DAS console
-
A database instance registered in DAS
Steps
-
Log on to the DAS console.
-
In the left-side navigation pane, click Instance Monitoring.
-
Find the database instance you want to check and click its instance ID.
-
In the left-side navigation pane, click Storage Analysis.
-
On the Storage Overview and Data Space tabs, review the storage information described in the following table.
| Tab | Section | What it shows |
|---|---|---|
| Storage Overview | Storage | Current space usage, average daily growth over the past seven days, estimated days of storage remaining, and total used space. Hover over the  icon next to each item for details. |
| Exceptions | Tables or collections in the instance that have detected anomalies. | |
| Storage Trend | Space usage over a time range of up to seven days. | |
| Tablespaces | Storage usage broken down by table. Click a table name to view its fields and indexes. | |
| Data Space | Storage usage broken down by database, including tablespace details. Click a table name to view its fields and indexes. | |