# Oracle EBS Tablespace Growth Forecast Calculator

> Source: https://netray.co/tools/oracle-ebs-tablespace-growth-forecast-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Project compound growth of an EBS tablespace or database, find when it crosses an alert threshold and how much storage to add.

## Category

oracle

## Erp

Oracle E-Business Suite

## Audience

- EBS DBA
- Infrastructure manager

## Tool

**Kind:** calculator

**Inputs:**

#### Current used space

**Key:** used_gb

**Type:** number

**Default:** 850

**Min:** 1

**Step:** 10

**Unit:** GB

**Help:** Used size from DBA_SEGMENTS or DBA_DATA_FILES minus free space.

#### Current allocated space

**Key:** alloc_gb

**Type:** number

**Default:** 1200

**Min:** 1

**Step:** 10

**Unit:** GB

**Help:** Total data file size for the tablespace or database.

#### Monthly growth rate

**Key:** growth_pct

**Type:** number

**Default:** 2.5

**Min:** 0.1

**Max:** 30

**Step:** 0.1

**Unit:** % per month

**Help:** Measure from AWR or monthly size snapshots.

#### Planning horizon

**Key:** horizon

**Type:** slider

**Default:** 12

**Min:** 1

**Max:** 60

**Step:** 1

**Unit:** months

#### Alert threshold

**Key:** threshold_pct

**Type:** slider

**Default:** 85

**Min:** 50

**Max:** 95

**Step:** 1

**Unit:** % of allocated

#### Space freed by planned purge

**Key:** purge_gb

**Type:** number

**Default:** 0

**Min:** 0

**Step:** 10

**Unit:** GB

**Help:** For example Purge Concurrent Request and Manager Data, workflow purge, archived history.

**Outputs:**

#### Current utilisation

**Key:** util

**Expr:** used_gb / alloc_gb * 100

**Format:** percent

#### Projected used space at horizon

**Key:** proj

**Expr:** used_gb * pow(1 + growth_pct / 100, horizon)

**Format:** number

**Description:** Compound growth with no purge.

#### Projected space after purge

**Key:** proj_net

**Expr:** max(0, proj - purge_gb)

**Format:** number

#### Months until threshold is crossed

**Key:** months_thr

**Expr:** if(gt(used_gb, alloc_gb * threshold_pct / 100), 0, ln(alloc_gb * threshold_pct / 100 / used_gb) / ln(1 + growth_pct / 100))

**Format:** months

**Primary:** true

**Description:** Zero means the threshold is already exceeded.

#### Allocation needed at horizon

**Key:** needed

**Expr:** proj_net / (threshold_pct / 100)

**Format:** number

**Description:** Space to allocate so utilisation stays at or below the threshold.

#### Additional storage to add

**Key:** add_gb

**Expr:** max(0, needed - alloc_gb)

**Format:** number

**Primary:** true

**Chart:**

#### Projected used space (GB) by planning horizon

**Type:** line

**X:** horizon

**From:** 1

**To:** 60

**Steps:** 30

**Series:**

- proj

**Disclaimer:** Growth is rarely perfectly compound. Use your own measured history, and add headroom for month end, upgrades and temporary data.

## Content

**Intro:** EBS databases grow in steps: transaction history, attachments, workflow and request logs. This calculator turns a measured monthly growth rate into a clear answer: when you cross your alert threshold and how much storage to add.

**Sections:**

#### How to use the calculator

**Body:** Enter current used and allocated space, then your measured monthly growth rate. Take growth from monthly snapshots of segment size over at least six months, not from a single busy month. Choose a planning horizon and an alert threshold, such as 85 percent. If you plan a purge, enter the space it frees. The outputs show months until the threshold, projected size and the extra storage required.

#### The formula

**Body:** Projected size equals current used space times one plus the monthly growth rate, raised to the number of months. Months to threshold equals the natural log of threshold space divided by used space, divided by the natural log of one plus the growth rate. Allocation needed is projected size after purge divided by the threshold fraction. This assumes steady percentage growth, which is a planning approximation.

**Bullets:**

- Use segment level history, not file size, to measure growth
- Check large objects, such as AQ, attachments and workflow tables
- Run the standard purge programs before buying storage
- Recalculate after major go-lives and acquisitions

#### Reading the result and common mistakes

**Body:** If the months to threshold is under your procurement lead time, act now. A common error is projecting from a month with a one time load, which overstates growth. Another is forgetting that backups, standby copies and clones multiply the real storage cost. Purges free space inside data files, so allocated space only drops after a reorganisation or shrink.

**Cta:** If capacity questions keep landing on your DBA, tell us what data you collect. We can discuss natural-language access to those figures on your own infrastructure.

**Faq:**

#### How do I measure EBS database growth?

**Answer:** Record the total size of segments by tablespace or schema at the same point each month, for example from DBA_SEGMENTS, and compare. Six to twelve months of history gives a more reliable rate than any single month.

#### Which EBS tables usually grow fastest?

**Answer:** Common heavy hitters include workflow and notification tables, concurrent request history, general ledger and subledger accounting tables, and attachment storage. Your own top segments query will show the real list.

#### Will purging free space for the operating system?

**Answer:** Not immediately. A purge frees space within the tablespace for reuse. To return space to storage you typically need to move objects or resize data files, which should be planned with your DBA.

#### Is compound growth the right model?

**Answer:** It is a reasonable first approximation when growth scales with activity. If growth is steady in gigabytes rather than percent, or driven by one off projects, adjust the rate or run scenarios with different values.

## Search terms

oracle ebs tablespace growth calculator, oracle database growth forecast, ebs database size projection, oracle tablespace capacity planning, ebs storage planning calculator, months until tablespace full

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json