Database Space Management menu options

You can use the Database Space Management option to perform the following functions:

To report on database space utilization
To reorganize fragmented database objects

Table: Database Space and Memory Management options

Option	Description
Report on Database Space	The report contains the tablespaces and the physical pathnames of the databases. For each tablespace, the report displays the name, the amount of free space in KBytes, and the file size in KBytes. The report also displays the amount of free space that remains on each of the file systems being used for the database.
Database Reorganize	Select this option to reorganize fragmented database tablespaces. These actions are performed from the Database Reorganize menu as follows: 1) Defragment All This option automatically determines the tablespaces that are fragmented. 2) Table Level Defragmentation This option generates a fragmentation report for each database table. For each table, the report includes the TABLE_NAME, number of ROWS, number of ROW_SEGMENTS, and SEGS_PER_ROW. In addition, a * displays in the ! column for an individual table if it will be automatically selected for reorganization by the Defragment All option. A row segment is all or part of one row that is contained on one page. A row may have one or more row segments. The ROW_SEGMENTS value indicates total number of row segments for the table. The SEGS_PER_ROW value shows the average number of segments per row, and indicates whether or not a table is fragmented. A SEGS_PER_ROW value of 1 is ideal, and any value more than 1 indicates a high degree of fragmentation. For example, a value of 1.5 means that half of the rows are partitioned. See About fragmentation.

Option

Description

Report on Database Space

The report contains the tablespaces and the physical pathnames of the databases.

For each tablespace, the report displays the name, the amount of free space in KBytes, and the file size in KBytes. The report also displays the amount of free space that remains on each of the file systems being used for the database.

Database Reorganize

Select this option to reorganize fragmented database tablespaces.

These actions are performed from the Database Reorganize menu as follows:

1) Defragment All
This option automatically determines the tablespaces that are fragmented.
2) Table Level Defragmentation
This option generates a fragmentation report for each database table. For each table, the report includes the TABLE_NAME, number of ROWS, number of ROW_SEGMENTS, and SEGS_PER_ROW.
In addition, a * displays in the ! column for an individual table if it will be automatically selected for reorganization by the Defragment All option.
A row segment is all or part of one row that is contained on one page. A row may have one or more row segments. The ROW_SEGMENTS value indicates total number of row segments for the table. The SEGS_PER_ROW value shows the average number of segments per row, and indicates whether or not a table is fragmented.
A SEGS_PER_ROW value of 1 is ideal, and any value more than 1 indicates a high degree of fragmentation. For example, a value of 1.5 means that half of the rows are partitioned.
See About fragmentation.

Database Space Management menu options

Feedback

Feedback