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

From DBArtisan
Jump to: navigation, search

Go Up to Using Space Analyst

The Database Overview tab lets you view the global storage picture of your database.

The table below describes the options and functionality on the Database Overview tab of Space Analyst for Oracle:

Option Description

Database Overview

Shows how much space in KB is taken up in the database by various object types (tables, indexes, etc.) along with a pie chart that represents the percentage of each object type. You can switch between the default graphical view and a grid view. NOTE: Objects owned by SYS and SYSTEM are not included in this breakdown.

Tablespace Space Overview

When in graphical mode, this section contains a bar chart graph that displays all tablespaces and how much total space each has allocated. When in grid mode, Space Analyst displays detailed information about all tablespaces (status, total, used, free, percent free, etc.) ORACLE ONLY: When in grid mode, Space Analyst displays tablespace status. You can switch between the default graphical view and a grid view.

Tablespace Fragmentation Overview

Contains fragmentation information for all tablespaces and displays how badly fragmented a tablespace or datafile is. Higher scores for the tablespace's fragmentation index indicate little or no fragmentation, while lower scores indicate fragmentation. You can switch between graphical and grid views of tablespace fragmentation. If fragmentation is present, you can view detailed object and fragmentation information for the tablespace in the tablespace map. You can correct fragmentation problems via Space Analyst's Reorganization Wizard. You can switch between the default graphical view and a grid view.

Tablespace Objects Overview

Contains a grid that displays how much space in each tablespace is assigned to tables, indexes, clusters, and rollback segments. ORACLE ONLY: When in grid mode, Space Analyst displays tablespace LOB data values.

The table below describes the options and functionality on the Database Overview tab of Space Analyst for IBM DB2 for Linux, Unix, and Windows:

Option Description

Database Overview

Shows how much space in KB is taken up in the database by various object types (tables, indexes, etc.) along with a pie chart that represents the percentage of each object type. You can switch between the default graphical view and a grid view.

Log Space Overview

Displays all of the log options for the database: Total Used Total Free Block Log When Disk Full Log File Size User Exit Primary Logs Secondary Logs Maximum Secondary Log Space Used Maximum Total Log Space Used

Tablespace Space Overview

When in graphical mode, this section contains a bar chart graph that displays all tablespaces and how much total space each has allocated. When in grid mode, displays detailed information about all tablespaces: Name Type State Used Space (MB) Free Space (MB) Content Type (Any, Long, Temp, System temp) Number of containers NOTE: You can switch between the default graphical view and a grid view.

Tablespace Objects Overview

Contains a grid that displays how much space in each tablespace is assigned to each object. Also displays tablespace LOB data values. Displays detailed information about all tablespace objects: Tablespace Name Table - total space used by tables Index - total space used by indexes Extent Size - tablespace extent size Page size - Tablespace page size

Available Functionality

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

Note: Functionality differ by platform.

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

Topics