Oracle EBS Database Growth Forecast Calculator
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.
Your numbers
Allocated or used size, be consistent with the capacity figure below.
Compound monthly growth, measured from at least six months of history.
Space you expect to reclaim from purges such as Purge Concurrent Request and/or Manager Data.
Usable capacity of the volume or ASM disk group.
Your results
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.
Projected database size (GB) over time
Sweeps Forecast horizon from 1 to 60, holding your other inputs fixed.
Growth driver review
Optionally share table size summaries and we will help identify which modules and logs drive your growth.
Optional. The tool and every export work without this. No spam.
How to use it
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.
- 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
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
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.
- 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.
Frequently Asked Questions
Is compound growth right for EBS?
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?
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?
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?
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.
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.
Related Tools
Oracle EBS Maintenance Window and Backup Time Calculator
Work out how long the outage needs to be, including a backup, the work itself, validation and a contingency buffer, and how long a rollback restore would take.
OracleOracle EBS Concurrent Manager Queue Wait Calculator
Model average queue wait and utilization for a concurrent manager queue as you change the number of target processes.
OracleOracle EBS Concurrent Program Load Planner Worksheet
List your scheduled concurrent programs with runtime and frequency, then see total busy minutes and the processes needed to carry the load.
OracleOracle EBS AP Invoices on Hold SQL Generator
Fill in operating unit, lookback days and optional hold code to get ready-to-run SQL for unreleased holds in Oracle Payables.
More Oracle tools
See all- Oracle EBS Inventory Tables Reference
- Oracle EBS WIP Tables Reference
- Oracle EBS Cycle Count Workload Calculator
- Oracle EBS Discrete Manufacturing Go-Live Checklist
- Oracle EBS Inventory Accuracy Readiness Assessment
- Oracle EBS Concurrent Request Phase and Status Reference
- Oracle EBS Responsibility Design Worksheet
- Oracle EBS GL Period Close Checklist
- Oracle EBS AP Invoice Interface Template