Timesten Dynamic AWT: Perm Space increasing during Dynamic loading for a empty Oracle table

(Doc ID 2089462.1)

Last updated on AUGUST 29, 2017

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.8.7 to 11.2.2.8.10 [Release 11.2]
Information in this document applies to any platform.

Symptoms

 After creating a DYNAMIC AWT cache group and trying to do a dynamic loading for a empty oracle table, the permsize increased. Even though no rows being loaded.

 

dssize is showing increase in perm in use value and dsmap -blk showing increase in heappage usage.

Before
< Free 17 242959360
< HpDir(Temp) 49 179728
< HpPg(Perm) 849 54056208

After
> Free 17 239718960
> HpDir(Temp) 49 180528
> HpPg(Perm) 899 57295808

The same issue did not happen for normal table and when there is no dynamic loading.

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