Space Manager with LiveReorg 9.0 - User Guide

Generate DML Profile Reports

To generate a DML Profile report

1. In the Explorer, right-click an object or segment and select DML Profile | DML Profile Report.

2. Select a From and To date at the bottom of the report, if needed.
3. Select each of the tabs to view report details.

Tips:

• To create a DML Profile, right-click an object or segment and select DML Profile | Create/Modify Collection. See Smart Start for DML Profiler for more information.
• To open the DML Profile Collections window for an owner in the selected database, expand the DML Profile Collection node in the database tree-list and select the owner.

Export a report

You can export a report to one of a number of different file formats, such as PDF or Excel. See Preview and Export Reports for more information.

Related Topics  

Smart Start for DML Profiler

Manage Storage

Monitor Storage from the Explorer

Monitor Storage from the Explorer

The Explorer provides a comprehensive overview of space use throughout a database—at the database, tablespace, datafile, object, and segment levels. You can drill down from the database level to the tablespace and object levels.

Pie-chart-style graphs let you see at-a-glance how much space is allocated and how much space is free at the database and tablespace levels. The Properties and the Statistics panels, as well as columns in the Segments (objects) grid, provide numeric information on space usage, various counts, and object sizes.

Note: The Explorer displays automatically when you launch Space Manager. If you have multiple connection profiles, each connection is displayed in the Explorer tree-list (left pane).

In databases that are Oracle 11 or higher, Recycle Bin information is displayed. At the database and tablespace levels, the Explorer reveals how much space is being used by dropped objects. This lets you see how much can be reclaimed for use by other objects.

What You Can Do From the Explorer

Use the Explorer to view storage information. In addition, the Explorer serves as the central launch point for Space Manager functionality. Many functions are available from the right-click menu when you select a database, tablespace, or segment in the Explorer.

From the Explorer window you can perform the following tasks:

• Display information—Display storage and space use information for a database, a tablespace, a datafile, or a segment.
  • See Monitor Database Storage for more information about displaying database information.
  • See Monitor Tablespace and Object Storage for more information about displaying tablespace and object/segment information.
  • See Monitor Datafile Storage to learn how to view the Datafile Map, segments and reorg need information.
  • See View Recycle Bin and Free Space for more information about managing the Recycle Bin and free space.
• Search for segments/objects—Use simple or advanced search to find objects.
  • Use the Search box to search for objects, segments, and partitions by name in the Explorer. See To use the Search field.
  • Use the Advanced search feature to use multiple search criteria to find objects. See Advanced Search.
• View and Identify reorg need—Use the Reorg Need column in the Segments/Objects grid and the Datafile Map to identify objects in need of reorganization. See View Reorg Need from the Explorer.
• Launch Reorganization Wizards—Launch the Reorg Manager or the Partitioning Wizard by right-clicking one or more selected objects in the grid. See Launch Reorg Manager and Launch Partitioning Wizard.

In addition, you can launch other Space Manager tools from the Main menu. Actions you perform are applied to the currently-selected database in the Explorer.

• Generate a report—Use the Main menu to open the Reports window and generate a report for the selected database.
• Open the Script/Job Monitor—Use the Main menu to open the Script/Job Monitor for the selected database.
• Open the Options dialog—Use the Main menu to open the Options dialog and specify options for the selected database.

Tip: You can drag and drop databases in the Explorer tree-list to rearrange the list.