Resolve TimesTen ttStats Issue Where TT_STATS Package/Tables Are Not Created When Upgrading To 11.2.2.5.0 (Doc ID 1569242.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.2.0 and later
Information in this document applies to any platform.

Symptoms

The TimesTen ttStats peformance monitoring utility is enabled in TimesTen release 11.2.2.5.0 and all later releases. The utility requires an operating environment consisting of a "TT_STATS" package and several supporting tables to exist in the data store SYS schema. In any data store created in the 11.2.2.5.0 instance, these objects will be built automatically. 

However, if a customer has data stores which were created in earlier releases of 11.2.2 and if the customer upgrades his TimesTen instance to 11.2.2.5.0, the upgraded data stores will not contain the package and tables necessary to run ttStats. While the scripts necessary to create both the TT_STATS package and the various tables are included in the 11.2.2.5.0 distribution, these cannot be run by users as users are not able to manually create objects in the SYS schema. Any attempt to access the TT_STATS package will return the following error:

 

Cause

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