HOWTO : Use TimesTen Built-ins ttBlockInfo And ttSize To View Or Monitor Database And Table Size (Doc ID 956830.1)

Last updated on MARCH 02, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 7.0.0.0.0 and later
Information in this document applies to any platform.
TimesTen Built-in ttSize ttBlockInfo SYS.MONITOR PERM_IN_USE_SIZE

***Checked for relevance on 16-May-2014***

***Checked for relevance on 23-Oct-2015***

Goal

Demonstrate how to use the SYS.MONITOR table, ttBlockInfo and ttSize to view database and table size
changes resulting from some simple SQL INSERT and DELETE operations.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms