Viewing the Segment Activity Details of Any Object

To view segment activity details of any object, follow these steps:

  1. From the Administration menu, choose Storage, then select Information Lifecycle Management.

    Enterprise Manager displays the Information Lifecycle Management page.

  2. Move the cursor over any of the boxes within the Database level heat map where each box represents a tablespace. Click the Tablespace to which the object you want to view belongs.

    Enterprise Manager displays the Tablespace level heat map for the 100 largest objects belonging to the tablespace. The Segment Activity tables displays the Segment Activity details for the 100 largest objects.

  3. On the Information Lifecycle Management page, click the Show Additional button.

    Enterprise Manager displays a dialog box that you can use to search for the segment activity details of any object belonging to the tablespace.

  4. On the dialog box, enter the Schema Name and Object Name and click Search.

    Enterprise Manager displays the Segment Activity details for the object.

  5. Click the Edit Object Policy button to display the Edit Object page with the ADO tab selected. You can create a policy for the object that allows it to be compressed or moved.