To generate a DML Profile report
In the Explorer, right-click an object or segment and select DML Profile | DML Profile Report.
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.
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.
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:
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.
Tip: You can drag and drop databases in the Explorer tree-list to rearrange the list.