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
New to Oracle E-Business Suite? Start with the Oracle E-Business Suite guide and toolkit, or plan with Oracle EBS Roadmap Planner, Training Path Builder, ERP Certification Study Planner.
Keep exploring
Free tools
- Oracle EBS Tablespace Growth Forecast CalculatorProject compound growth of an EBS tablespace or database, find when it crosses an alert threshold and how much storage to add.
- IBM i Disk Growth and Capacity Forecast CalculatorForecast how many months until IBM i auxiliary storage reaches your threshold, using current use, capacity and monthly growth.
- AS/400 Disk Storage Growth Forecast CalculatorEstimate how many years of disk you have left on IBM i given data growth, journal receivers and your safe utilisation threshold.
ERP fixes and how-tos
- How to purge concurrent requests and manager data in Oracle EBSHow to schedule Purge Concurrent Request and/or Manager Data in Oracle EBS: the parameters, what is deleted, what else to purge, and mistakes that slow the system.
- How to Create an Item in Oracle EBSCreate an inventory item in Oracle EBS: Master Items form, master organization, templates, attributes, organization assignment, categories and common errors.
- How to Add a Private AI Layer to Oracle EBS 12.2 On-PremReference architecture for a private AI layer on Oracle EBS 12.2: Active Data Guard replica, ISG REST, MO and responsibility security, local GPUs and audit.
Runs with your ERP
- Esker Order Management and Oracle E-Business SuiteHow Esker captures customer POs from email, fax and PDF and creates sales orders in Oracle EBS: integration, data flows, setup, pitfalls and a private AI layer.
- Cloud Inventory (DSI) with Oracle E-Business Suite: Mobile Barcode InventoryCloud Inventory, formerly DSI, adds offline mobile barcode inventory to Oracle E-Business Suite and JD Edwards. Data flows, setup steps, pitfalls and AI notes.
- BarTender and Oracle E-Business Suite: Label Printing from OracleHow BarTender prints labels from Oracle EBS using Oracle XML print requests and Integration Builder: methods, data flows, setup steps, pitfalls and AI help.
AI on your ERP
- AI for Oracle EBS in Aerospace and Defense ManufacturingAI on Oracle EBS for aerospace and defense manufacturers: project manufacturing, serial control, and ITAR segregation handled without a cloud dependency.
- AI for Oracle E-Business Suite, Without Leaving On-PremHosting Oracle EBS 12.2 on-prem or in a private cloud? Add a private LLM over concurrent programs, interface tables and AP/PO data without moving to Fusion.
Integrations
- How to use ChatGPT with Oracle E-Business SuiteUsing ChatGPT with Oracle E-Business Suite: export vs live access, custom GPT actions over ISG REST, enterprise data controls and when to keep data on-prem.
- How to connect Claude to Oracle E-Business SuiteConnect Claude to Oracle E-Business Suite via MCP, the Anthropic API, AWS Bedrock or Vertex, and know when an on-prem open-weight model is the better fit.