tablesize Command

The tablesize command displays the detailed analysis of the amount of space used by a table.

Once you call the ttComputeTabSizes built-in procedure, which analyzes the table size of the indicated tables, the tablesize command displays the total size data for all analyzed tables.

Note:

See ttComputeTabSizes in the Oracle TimesTen In-Memory Database Reference.

Running the tablesize command with no arguments displays available sizing information for all tables that have had the ttComputeTabSizes computation run. When you provide a table as an argument, tablesize displays available sizing only for the indicated table.

The syntax for tablesize is as follows:

tablesize [[owner_name_pattern.]table_name_pattern]

The following example invokes the ttComputeTabSizes built-in procedure to calculate the table size of the employees table. Then, the tablesize command displays the sizing information gathered for the employees table.

Command>call ttComputeTabSizes('employees');
Command>tablesize employees;
 
Sizes of USER1.EMPLOYEES:
 
  INLINE_ALLOC_BYTES:   60432
  NUM_USED_ROWS:        107
  NUM_FREE_ROWS:        149
  AVG_ROW_LEN:          236
  OUT_OF_LINE_BYTES:    0
  METADATA_BYTES:       1304
  TOTAL_BYTES:          61736
  LAST_UPDATED:         2011-06-29 12:55:28.000000
 
1 table found.

These values provide insights into overhead and how the total space is used for the table.

For example:

The NUM_FREE_ROWS value describes the number of rows allocated for the table, but not currently in use. Space occupied by free rows cannot be used by the system for storing other system objects or structures.
Use the TOTAL_BYTES value to calculate how much permanent space your table occupies.
LAST_UPDATED is the time of the last size computation. If you want a more recent computation, re-run ttComputeTabSizes and display the new output.

To find a description for each calculated value, see SYS.ALL_TAB_SIZES section in the Oracle TimesTen In-Memory Database System Tables and Views Reference.