
You can access the Tables screen by calling the DBA Cockpit and choosing in the navigation frame of the DBA Cockpit.
The Tables screen displays information on all tables of the database, such as the used, unused or reserved space, the number of rows, the number of rows deleted, forwarded, and so on.
In the Selection area, you can specify the time frame and other criteria for which you want the tables to be displayed.
To analyze table data, you proceed as follows:
You specify the time frame and other criteria for which you want the tables to be displayed.
To refresh table data, you choose the Apply Selection push button. The following information is displayed:
|
Column: |
Description: |
|---|---|
|
Database |
Name of the database |
|
Table Owner |
Name of the table owner |
|
Table Name |
Name of the table |
|
Reserved Total (KB) |
Space reserved for future inserts |
|
Used Total |
Total amount of space used in KB |
|
Unused Total |
Total amount of unused space in KB |
|
Data Total (KB) |
Amount of data for this table in KB |
|
Data Utilized Total |
Amount of utilized data for this table in KB |
|
Number of Rows |
Table rows |
|
Data Change |
Percentage of data change since the last statistics update was performed on the object |
|
Data Cluster Ratio |
Data cluster ratio in % |
|
Large IO Efficiency |
Information about I/O efficiency |
|
Deleted Rows |
Number of data records that were deleted |
|
Forwarded Rows |
Rows that grow in length with subsequent updates |
To display further details of the selected table, you select a line in the overview table and choose Table Details . By analyzing and maintaining single tables, you can optimize tables and indexes to:
Save disk space by releasing unused space
Improve access to a table by keeping statistics up-to-date or by reorganizing fragmented tables or indexes
The Single Table Analysis screen consists of the following areas:
A selection area, where you specify the schema and name of the table to be analyzed
Tab pages with detail information that is relevant for tables and indexes