ttPageLevelTableInfo

As aging deletes rows, TimesTen frees empty pages and reuses empty slots on non-full pages. The ttPageLevelTableInfo built-in procedure shows the page allocation for each table to determine when TimesTen is reusing empty slots and freeing empty pages or if new pages are allocated to store new rows.

Required Privilege

This procedure requires SELECT privilege to see the current values.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Related Views

This procedure has no related views.

Syntax

ttPageLevelTableInfo( [ tblOwner tt_char(31) ], [ tblName tt_char(31)])

Parameters

ttPageLevelTableInfo has these optional parameters:

Parameter	Type	Description
`tblOwner`	`TT_CHAR (31)`	TimesTen table owner. If not specified, uses the current user.
`tblName`	`TT_CHAR (31)`	Name of an application table. Only user tables can be specified. No global temporary tables can be specified.

Result Set

ttPageLevelTableInfo returns these results:

Parameter	Type	Description
`tblOwner`	`TT_CHAR (31) NOT NULL`	TimesTen table or cache group owner.
`tblName`	`TT_CHAR (31) NOT NULL`	Name of an application table. Provide the cache root table for a cache group.
`card`	`TT_BIGINT NOT NULL`	Table tuple count
`logical_pgcnt`	`TT_BIGINT NOT NULL`	Count of logical pages
`logical_nonFullPages`	`TT_BIGINT NOT NULL`	Count of logical pages with empty slots
`logical_freeSlots`	`TT_BIGINT NOT NULL`	Total count of empty slots in logical pages
`physical_pgcnt`	`TT_BIGINT NOT NULL`	Count of physical pages
`physical_nonFullPages0`	`TT_BIGINT NOT NULL`	Count of physical pages with empty slots in directory list 0
`physical_nonFullPages1`	`TT_BIGINT NOT NULL`	Count of physical pages with empty slots in directory list 1
`physical_nonFullPages2`	`TT_BIGINT NOT NULL`	Count of physical pages with empty slots in directory list 2
`physical_nonFullPages3`	`TT_BIGINT NOT NULL`	Count of physical pages with empty slots in directory list 3
`physical_freeSlots0`	`TT_BIGINT NOT NULL`	Count of empty physical slots in directory list 0
`physical_freeSlots1`	`TT_BIGINT NOT NULL`	Count of empty physical slots in directory list 1
`physical_freeSlots2`	`TT_BIGINT NOT NULL`	Count of empty physical slots in directory list 2
`physical_freeSlots3`	`TT_BIGINT NOT NULL`	Count of empty physical slots in directory list 3

Examples

The following demonstrates the output received for table1 and table2 using the ttPageLevelTableInfo built-in procedure:

Command> vertical 1; 
Command> call ttPageLevelTableInfo;

  TBLOWNER:                 USER1
  TBLNAME:                  TABLE1
  CARD:                     6
  LOGICAL_PGCNT:            1
  LOGICAL_NONFULLPAGES:     1
  LOGICAL_FREESLOTS:        250
  PHYSICAL_PGCNT:           2
  PHYSICAL_NONFULLPAGES0:   0
  PHYSICAL_NONFULLPAGES1:   0
  PHYSICAL_NONFULLPAGES2:   1
  PHYSICAL_NONFULLPAGES3:   1
  PHYSICAL_FREESLOTS0:      0
  PHYSICAL_FREESLOTS1:      0
  PHYSICAL_FREESLOTS2:      253
  PHYSICAL_FREESLOTS3:      253


  TBLOWNER:                 USER1
  TBLNAME:                  TABLE2
  CARD:                     3
  LOGICAL_PGCNT:            1
  LOGICAL_NONFULLPAGES:     1
  LOGICAL_FREESLOTS:        253
  PHYSICAL_PGCNT:           1
  PHYSICAL_NONFULLPAGES0:   0
  PHYSICAL_NONFULLPAGES1:   1
  PHYSICAL_NONFULLPAGES2:   0
  PHYSICAL_NONFULLPAGES3:   0
  PHYSICAL_FREESLOTS0:      0
  PHYSICAL_FREESLOTS1:      253
  PHYSICAL_FREESLOTS2:      0
  PHYSICAL_FREESLOTS3:      0

2 rows found.

The following demonstrates the output received for table1 using the ttPageLevelTableInfo built-in procedure. The output uses vertical 0 (which is the default).

Command> call ttPageLevelTableInfo(user1, table1);
< USER1, TABLE1, 6, 1, 1, 250, 2, 0, 0, 1, 1, 0, 0, 253, 253 >

Notes