Estimating Tablespace Size

About Estimating Tablespace Size

The Estimate Tablespace Size generates a report with the details of recommended tablespaces sizes for the CISDBA and CISINDEX tablespaces.

This task explains how to estimate the tablespace size:

  1. In the navigation pad, select Tools > Explore Object Management > Estimate Tablespace Size.

    OR

    From the menu bar, select Tools > Explore Object Management > Estimate Tablespace Size. The Estimate Tablespace Size window appears.

  2. Click Generate to generate the report. The table details appear.

After generating the report, a confirmatory message appears, and the recommended minimum tablespace sizes are also displayed.

  1. Click OK. The Save to File is enabled.

  2. To save the report on to the file, click Save to File. The file is saved, and the file location and name are displayed.