Session 2: Obtaining a Global Vew of Storage Using Space Analyst for Oracle
Go Up to Space Analyst for Oracle tutorial
When it opens, Space Analyst shows a complete overview of the storage situation of a particular database or database server. The first tab of Space Analyst displays all pertinent global statistics regarding storage structure usage throughout a database.
There are four distinct sections displayed on the first Database Overview tab of Space Analyst:
- Database Overview
- Tablespace Space Overview
- Tablespace Fragmentation Overview
- Tablespace Objects Overview
Space Analyst for Oracle - Database Overview
The Database Overview displays:
- The total count of all tablespaces, datafiles and temporary files.
- The percentage breakdown of the various object types in a database. Positioning the mouse pointer over the graph causes it to display the actual percentage amounts for each object type.
- The amount of space in kilobytes that each object type consumes is also shown. This section helps you get a clear picture of exactly how much space the various object types in your database are taking up.
- Tip: If you want to see a grid-style display of the information shown in the graph, position your mouse over the graph, click the right mouse button and select the ‘toggle display’ option.
Space Analyst for Oracle - Tablespace Space Overview
The Tablespace Space Overview section displays summary information regarding every tablespace in the database. When invoked in graph form, this section shows how much total space is currently allocated to each tablespace. When shown in grid form, this section shows not only the total space allocated for each tablespace, but also includes the used, free, and percent free amounts, along with an indicator that shows whether any of the tablespace’s underlying data or temp files can automatically grow if necessary.
- Tip: To see a grid-style display of the information shown in the graph, position your mouse over the graph, click the right mouse button and select the ‘toggle display’ option. To return to the graph, just perform the same actions over the grid.
When this section is in grid form, you can also perform a number of actions on a tablespace like open it in a DBArtisan editor, extract it’s DDL, convert it to either local or dictionary-managed, and more. For example, to open a tablespace in one of DBArtisan’s object editors, do the following:
- In the grid, select a tablespace.
- Right-click and select Open.
- Select a tablespace and click the Open toolbar button.
- DBArtisan opens a Tablespaces Editor.
Space Analyst for Oracle - Fragmentation Overview
The fragmentation overview provides a quick glance into how badly fragmented a tablespace is. Space Analyst computes a fragmentation index for every tablespace that can be used to quickly tell if fragmentation problems are plaguing a tablespace. A 100 percent reading indicates no fragmentation, while lower scores indicate the presence of fragmentation.
To see the percentage of fragmentation for each tablespace in the graph, do the following:
- Position the pointer over each bar in the chart.
To see a grid-style display of the information shown in the graph, do the following:
- Position the pointer over the graph.
- Right-click and select Toggle Display.
Space Analyst for Oracle - Tablespace Objects Overview
The tablespace objects overview provides a window into the types of objects that each tablespace contains. This view is useful because it helps you quickly understand if undesired objects are present in a tablespace.
- Note: There is no graphical view available for this section.