Resolve TimesTen ttStats Issue Where TT_STATS Package/Tables Are Not Created When Upgrading To 18.104.22.168.0
Last updated on SEPTEMBER 23, 2016
Applies to:Oracle TimesTen In-Memory Database - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
The TimesTen ttStats peformance monitoring utility is enabled in TimesTen release 126.96.36.199.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 188.8.131.52.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 184.108.40.206.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 220.127.116.11.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:
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