# Oracle EBS Database Growth Forecast Calculator

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

## Short answer

Project EBS database size from monthly growth and a one-time purge, and see how many months of storage headroom remain.

## Category

oracle

## Erp

Oracle E-Business Suite

## Audience

- EBS DBA
- Infrastructure manager
- Oracle applications administrator

## Tool

**Kind:** calculator

**Inputs:**

#### Current database size

**Key:** current_gb

**Type:** number

**Default:** 800

**Min:** 1

**Step:** 10

**Unit:** GB

**Help:** Allocated or used size, be consistent with the capacity figure below.

#### Monthly growth

**Key:** growth_pct

**Type:** number

**Default:** 2.5

**Min:** 0

**Max:** 25

**Step:** 0.1

**Unit:** % per month

**Help:** Compound monthly growth, measured from at least six months of history.

#### One-time purge or archive reclaim

**Key:** purge_pct

**Type:** number

**Default:** 10

**Min:** 0

**Max:** 80

**Step:** 1

**Unit:** % of size

**Help:** Space you expect to reclaim from purges such as Purge Concurrent Request and/or Manager Data.

#### Storage capacity

**Key:** capacity_gb

**Type:** number

**Default:** 2000

**Min:** 1

**Step:** 50

**Unit:** GB

**Help:** Usable capacity of the volume or ASM disk group.

#### Forecast horizon

**Key:** horizon

**Type:** slider

**Default:** 36

**Min:** 1

**Max:** 60

**Step:** 1

**Unit:** months

**Outputs:**

#### Size after purge

**Key:** after_purge

**Expr:** current_gb * (1 - purge_pct / 100)

**Format:** number

#### Size at horizon (GB)

**Key:** at_horizon

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

**Format:** number

**Primary:** true

#### Months until capacity is reached

**Key:** months_full

**Expr:** if(gt(growth_pct, 0), max(0, ln(capacity_gb / after_purge) / ln(1 + growth_pct / 100)), 0)

**Format:** months

**Primary:** true

**Description:** Shows 0 when growth is zero or capacity is already exceeded.

#### Headroom at horizon (GB)

**Key:** headroom

**Expr:** capacity_gb - at_horizon

**Format:** number

**Description:** Negative means you run out of space before the horizon.

**Chart:**

#### Projected database size (GB) over time

**Type:** line

**X:** horizon

**From:** 1

**To:** 60

**Steps:** 30

**Series:**

- at_horizon

**Disclaimer:** Compound growth is a simplification. Month-end close, upgrades and new modules change the slope. Re-fit the growth rate from recent history every quarter.

## Content

**Intro:** Storage requests for an EBS database need a number, not a feeling. This calculator turns your current size, growth rate and planned purge into a size forecast and a months-until-full estimate.

**Sections:**

#### How to use it

**Body:** Enter current size and capacity in the same unit and basis, either allocated or used. Estimate monthly growth from history, for example size at the start of the year and now, then solve the monthly rate as (end / start) to the power of 1/months, minus 1. Add the percentage you expect to reclaim from a purge program, then slide the horizon. The chart shows the projected size over the full 60 months so you can see when it crosses your storage line.

**Bullets:**

- Use at least six months of history to include a month-end and quarter-end cycle.
- Run the tool with and without the purge to quantify its value.
- Use growth of the database, not of backups, unless you size both together.

#### The formula

**Body:** Size after n months is S times (1 + g) to the power of n, where S is the post-purge size and g the monthly growth rate. Months until capacity C is reached is ln(C / S) divided by ln(1 + g). A purge reduces S once and moves the whole curve down, but it does not change the slope, so the effect is a fixed delay of ln(1 / (1 - p)) / ln(1 + g) months. At 2.5% monthly growth a 10% reclaim buys about 4 months.

#### Where EBS data grows and what to purge

**Body:** In most EBS systems the large consumers are FND_CONCURRENT_REQUESTS and its logs and output files, workflow tables such as WF_ITEM_ACTIVITY_STATUSES, GL and subledger accounting tables, and attachments in FND_LOBS. Standard purge programs include Purge Concurrent Request and/or Manager Data and Purge Obsolete Workflow Runtime Data. Check Oracle Support guidance for your release before running purges in production, and take a backup first.

**Bullets:**

- Output and log files on the file system do not count toward database size.
- Archiving subledger data needs functional sign-off, not just a DBA decision.
- Add growth for planned acquisitions or new modules as a step, not a slope.

**Cta:** If you want growth by tablespace and schema trended automatically from your own database and explained to your finance and infrastructure teams, we can build that on-prem.

**Faq:**

#### Is compound growth right for EBS?

**Answer:** It fits most transactional systems over a one to three year view, but real growth is lumpy around closes and upgrades. Use the result as a planning range and refit the monthly rate from the latest quarter of data.

#### Should I include archive logs and backups?

**Answer:** Only if the capacity you enter covers them. Size the database and the backup or archive destination separately, with their own growth and retention assumptions, for a clean answer.

#### How do I calculate monthly growth from history?

**Answer:** Divide the latest size by the size n months ago, raise to the power of 1 divided by n, and subtract 1. For example, 650 GB growing to 800 GB over 8 months gives about 2.6% per month.

#### Does a purge fix the growth problem?

**Answer:** A purge reclaims space once and delays the date you run out by a fixed number of months. It does not slow growth. Lasting control needs retention policies, archiving and scheduled purges.

## Search terms

oracle ebs database growth, ebs database size forecast, oracle apps storage capacity planning, purge concurrent requests oracle ebs, ebs tablespace growth calculator, oracle ebs database capacity planning, months until storage full calculator

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