Chat now with support
Chat with Support

Space Manager with LiveReorg 9.0 - User Guide

Smart Start for Space Manager Collect Statistics Profile DML Activity Manage Storage Reorganize Objects with Reorg Manager Partition Tables with the Partitioning Wizard Run and Monitor Scripts Run Reports Options Troubleshooting Administration Functions Appendix About Us

Manage Storage with Object Properties

Use Object Properties to view comprehensive information for an object and its related objects.

To open Object Properties, right-click an object in the Explorer and select Object Properties. See Open Object Properties for more information.


What Is Supported for Object Properties


  • Non-partitioned tables and indexes
  • Partitioned tables and indexes (range, hash, list)
  • Tables with LOBs, LOB partitions, and LOB subpartitions
  • IOTs and partitioned IOTs
  • IOT overflows
  • Clusters, clustered tables, cluster indexes, indexes on clustered tables
  • Tables with user-defined datatypes
  • Tables with ROWID and UROWID datatypes

Not Supported

  • Nested tables
  • Object tables
  • Temporary tables
  • Materialized views
  • Replication tables; objects that are part of  a replication group

    Note: In most cases, Object Properties cannot be opened for objects it does not support.


Open Object Properties

To open Object Properties

  1. Right-click an object in the Explorer or in a Predicted Reorganization Benefit report and select Object Properties.
  2. The object and its related objects are listed in a hierarchical tree view in the left pane. Related objects descend from the top-level object. The objects can include partitions, subpartitions, indexes, LOBs, and IOT overflows. (Object types are represented with various symbols.)

    Note: In most cases, a table is shown at the top of the object tree. However, a cluster is shown at the top when the launching object is a cluster, a clustered table, a cluster index, or an index on a clustered table.

  3. View properties for the selected object by selecting the various Object Properties tabs. The tabs available change according to the type of object selected.
  4. View properties for a related object by selecting it in the object tree.

Note: Information at the top of the Object Properties window identifies the object selected in the object tree. The information includes object name, owner, object type, and object ID. Identifying information is displayed for all tabs.


View Object Properties

View the Properties tab in Object Properties to see various attributes for the selected object.

Note: The panels and fields displayed in the Properties tab change according to the type of object selected. If an attribute is not used for an object, N/A is displayed in the attribute field.



Storage Attributes

The Storage panel displays the attributes set with Oracle’s storage clause. These include INITIAL, NEXT, PCTINCREASE, MINEXTENTS, and MAXEXTENTS. They determine how extents are allocated for objects.

If an object resides in a locally managed tablespace, the values displayed may be different from the values specified when the object was created or reorganized:

  • MINEXTENTS—The value shown for MINEXTENTS is always 1, no matter which allocation type is used for a locally managed tablespace.

The Storage panel also displays attributes set with Oracle’s physical attributes clause, such as PCTFREE and PCTUSED. INITRANS and MAXTRANS are displayed below the Storage panel. These attributes determine how space is used inside object data blocks.

Additional Attributes

Additional attributes are displayed when they are available for an object. These attributes include logging and caching information.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating