Space Analyst for Oracle and IBM DB2 for Linux, Unix, and Windows - Datafiles Tab

From DBArtisan
Jump to: navigation, search

Go Up to Using Space Analyst

The Data Files tab lets you view fragmentation and object placement information for data files.

The table below describes the options and functionality on the Datafiles tab of the Space Analyst:

Option Description

Datafile Fragmentation

Displays fragmentation about datafiles. Higher scores for a datafile's fragmentation index indicate little or no fragmentation, while lower scores indicate fragmentation. If fragmentation is present, you can view detailed object and fragmentation information for the datafile's tablespace in the tablespace map. You can correct fragmentation problems via Space Analyst's Reorganization Wizard. NOTE: Datafiles for temporary tablespaces are not included in the Datafile Fragmentation grid.

Datafile Objects Overview

Contains a grid that displays how much space in each datafile is assigned to tables, indexes, clusters, and rollback segments.

Tip: To open a Tablespace Editor, right-click a datafile in any grid, and then select Open. To extract the tablespace DDL in an ISQL editor, right-click a datafile in any grid, and then select Extract.

Available Functionality

The following functionality is available in the Command menu, shortcut menu, and toolbar:

Note: Functionalists differ by platform.

Open Editor. For information on modifying database objects, see Modifying objects using editors.