Space Analyst for Oracle and IBM DB2 for Linux, Unix, and Windows - Database Overview Tab
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.