ttComputeTabSizesbuilt-in procedure refreshes table size statistics stored in TimesTen system tables. After calling this built-in procedure, you can review the statistics updates by querying the
This procedure computes the different types of storage allocated for the specified table, such as the amount of storage allocated for inline row storage, dictionary tables, out-of-line buffers and system usage. If no table is specified, the procedure computes the sizes for all tables on which the user has
SELECT privileges. The implementation of this built-in behaves like a DDL statement: the transaction commits just before the procedure begins and commits again upon its successful termination.
This procedure requires the
SELECT privilege on the specified table.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic.
TimesTen Scaleout applications can call this built-in procedure.
In TimesTen Scaleout, this procedure runs on all elements in the grid.
This procedure has no related views.
ttComputeTabSizes (['tblName'], [includeOutOfLine])
ttComputeTabSizes has the parameters:
Name of an application table. Can include the table owner. If a value of
The type of tables that can be estimated are:
If value is
Avoiding the computation of out-of-line values significantly decreases the latency of this procedure.
ttComputeTabSizes returns no results.
To compute the size of
my_table without including out-of-line columns, use:
CALL ttComputeTabSizes ('my_table', 0);
The built-in procedure allows concurrent insertions while
ttComputeTabSizesis running. For this reason, the size computed by
ttComputeTabSizesfor each table is any value between the minimum size of the table during the computation and the maximum size of the table during the computation. For example, if the size of a table is 250 MB when
ttComputeTabSizesis performed, and a transaction running concurrently raises the size of the table to 300 MB,
ttComputeTabSizesestimates a value between 250 and 300 MB.
The computed size of tables includes the size of dictionaries.