ToolPlan capacity
Tablespace runway and datafiles
How long a tablespace lasts at its current growth rate, and ready-to-run statements that add enough space for the period you choose, keeping it under 85% full.
The tool runs entirely in your browser. Nothing you type into it is sent anywhere.
Related scripts
- Tablespace usageUsed and free space in GB against the maximum each tablespace can autoextend to, with its type (permanent, temporary or undo), fullest first.
- Datafiles with size and autoextend limitsEvery datafile, its current size, whether it can grow, and how far. Files with AUTOEXTEND NO in a busy tablespace are the ones that page you at night.
- Add space: resize or add a datafileTemplates for the three usual fixes. The resize runs as written; the other two are commented out. Change names and sizes, and uncomment the one you…
- Top 20 largest segmentsThe biggest tables, indexes, LOBs and partitions in the database.