How to Estimate the Size of Tables and Indexes Before Being Created and Populated in the Database?
(Doc ID 1585326.1)
Last updated on JULY 05, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Goal
How TO Estimate The Size Of Tables and Indexes Before They Actually Gets Created And Populated In The Database , to Prepare Sufficient storage available .
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| Estimate The Size Of Tables |
| Example for using Version 1: |
| Example for using Version 2: |
| Estimate Table Size Using Enterprise Manager |
Estimate The Size Of Indexes |
| Estimate Index Size example : |
| References |