Space Analyst Functionality

From DBArtisan
Jump to: navigation, search

Go Up to Using Space Analyst

Space Analyst offers functionality that help you analyze space. The Space Analyst support the following functionality:

Note: Functionality differ by platform.

Space Analyst - Analysis Report

The Analysis Report dialog lets you build an HTML analysis report for the selected tablespace. You can run reports on a recurring basis and dynamically alter any saved thresholds that flag space problems in the tablespace being analyzed.

For Oracle, the report includes sections for particular reorganization needs, including:

  • Fragmentation index for the tablespace
  • Tables with high block inefficiencies
  • Tables or indexes with next extent space deficit problems
  • Tables or indexes with maximum extent limit problems
  • Tables or indexes with percent increase greater than zero
  • Tables with chained/migrated row problems
  • Indexes with B-tree depth problems

For Microsoft, the report contains different sections that highlight particular reorganization needs, including:

  • Free space levels for the database and log
  • Tables with forwarded record problems
  • Indexes with average fragmentation problems
  • Tables or indexes with extent fragmentation problems
  • Tables or indexes with logical fragmentation problems
  • Tables or indexes with scan density problems
  • Tables or indexes with average page density problems

For Sybase ASE, the report contains different sections that highlight particular reorganization needs, including:

  • Free space levels for the database and log
  • Tables with forwarded row problems
  • Tables with empty page problems
  • Tables with deleted row problems
  • Tables with low fragmentation scores
  • Indexes with unused space problems
  • Indexes with empty leaf problems
  • Indexes with height/level problems
  • Indexes with low fragmentation scores

For IBM DB2 for Linux, Unix, and Windows, the report contains different sections that highlight particular reorganization needs, including:

  • Tables with overflow problems
  • Tables with space utilization problems
  • Tables with page utilization problems
  • Tables with index space contention
  • Indexes with cluster ratio problems
  • Indexes with used space% problems
  • Indexes with balance problems
  • Indexes with deleted RID problems
  • Indexes with empty leaf problems
  • Indexes with low uniqueness
  • Free levels of tablespace and log space

To open the Analysis Report dialog box:

  1. Open the Space Analyst.
  2. On the Command menu, click the Analysis Report.

For all platforms, browse to or type a report title and make your desired selections from the drop-down lists. After the report executes, you can print it or save it.

To print the report:

  1. Click Print from the Analysis Report toolbar.

To save the report:

  1. Select Save from the File menu on the main toolbar.

Space Analyst - Convert to Locally-managed

The Convert to Locally-Managed dialog lets you convert a dictionary-managed tablespace to locally-managed. Objects in locally-managed tablespaces have unlimited extents; they will never fail to extend due to an imposed maximum extent limit.

Important Notes

There are a few restrictions on these conversion procedures (for example, Oracle9i UNDO tablespaces currently can't be converted, etc.), so you should check the Oracle documentation for the specifics on performing a conversion.

The Convert to Locally-Managed option is only available if the selected tablespace(s) are:

  • ONLINE
  • In Read/Write mode
  • Dictionary managed
  • Not UNDO tablespaces
  • Not Temporary tablespaces
  • Not the SYSTEM tablespace

The table below describes the options and functionality on the Convert to Locally-Managed dialog

Option Description

Tablespaces to be Converted

Displays the tablespaces to be converted to locally-managed.

Conversion Options

OPTIONAL: Lets you type allocation unit and relative file number information.

Completing the Convert to Locally-Managed Dialog Box for Space Analyst

To complete this dialog box, do the following:

  1. Select Convert to Locally-Managed.
    OR
  2. Right-click the target object, and then select Convert to Locally-Managed.
    The Space Analyst opens the dialog box.
  3. Do one of the following:
Button Description

bs154a21.jpg

Opens the Preview dialog.

bs154a28.jpg

Opens a scheduling application.

bs154a2f.jpg

Executes the task.

Space Analyst - Convert to Dictionary-Managed

Note: The Convert to Dictionary-Managed functionality is for Oracle 9i only.

The Convert to Dictionary-Managed dialog lets you convert a locally-managed tablespace to dictionary.

Important Notes

The Convert to Dictionary-Managed dialog is only available if the selected tablespace(s) are:

  • ONLINE
  • In Read/Write mode
  • Locally managed
  • Not UNDO tablespaces
  • Not Temporary tablespaces
  • Not the SYSTEM tablespace

The table below describes the options and functionality on the Convert to Dictionary-Managed dialog:

Option Description

Tablespaces to be Converted

Displays the tablespaces to be converted to dictionary-managed.

Completing the Dictionary-Managed Dialog Box for Space Analyst

To complete this dialog box, do the following:

  1. Select Convert to Dictionary-Managed.
    OR
  2. Right-click the target object, and then select Convert to Dictionary-Managed.
    The Space Analyst opens the dialog box.
  3. Do one of the following:
Button Description

bs154a62.jpg

Opens the Preview dialog.

bs154a69.jpg

Opens a scheduling application.

bs154a70.jpg

Executes the task.

Space Analyst - Extract

The Extract functionality lets you extract the database DDL in an ISQL editor.

To extract the database DDL in an ISQL editor, do the following:

  1. Click the Extract DDL button.
    OR
  2. Select Extract.
    OR
  3. Right-click the target object, and then select Extract.
    Space Analyst extract the database DDL in an ISQL editor.

Space Analyst - Map

The Map functionality opens the Tablespace Map tab or Map tabof the Space Analyst for the selected index.

Important Notes

None

Opening the Tablespace Map Tab for Space Analyst

To open the Tablespace Map or Map tab, do the following:

  1. Select Map.
    OR
  2. Right-click the target object, and then select Map.
    Space Analyst open the Tablespace Map tab or Map tab.

Space Analyst - Open Editor

The Open functionality lets you modify objects in the object editors.

To open the object editor, do the following:

  1. In any grid, select an object.
  2. Click the Open Editor button.
    OR
  3. Select Open.
    OR
  4. Right-click the target object, and then select Open.
    Space Analyst opens the object editor.