Online Documentation for SQL Manager for Oracle

Tablespace

The Tablespace tab consists of two basic areas: Tablespaces and Segments for <tablespace_name>.

Tablespaces

The list displays Oracle tablespaces as a grid with the following columns: Tablespace, Alloc Size (Mb), Free Size (Mb), Used Size (Mb), Pct Used, Max(Mb), Free Space Fragmentation Index. If more convenient, you can change the order of the columns by dragging their headers horizontally.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

Right-click an item within the list to call the context menu allowing you to refresh the list, coalesce the tablespace and set SQL trace to the trace log on the server.

Tablespace management tools are also available through the Navigation bar of the Database Statistics window.

Segments for <tablespace_name>

The list displays the selected tablespace segments as a grid with the following columns: Owner, Segment name, Segment type, Size (b), Initial Extent, Next Extent, Pct Increase, Extents, Max Extents, Extent Efficacy, Frag Count. If more convenient, you can change the order of the columns by dragging their headers horizontally.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

If necessary, you can also filter the rows in the Segments for <tablespace_name> list by minimum extents and segment type. Use the corresponding controls in the upper area.