My Oracle Support Banner

Unload Cache Group taking a long time to complete if it contained many rows (Doc ID 1126638.1)

Last updated on APRIL 13, 2020

Applies to:

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


User performed UNLOAD CACHEGROUP and observed it was taking a long time to complete by checking output
in ttIsql, call ttLogHolds():

< 291, 255620424, Long-Running Transaction , 45.3135152 >

Then user ran ttXactAdmin and found that its still busy doing the

Outstanding locks

PID      Context         TransId       TransStatus Resource ResourceId                Mode Name
799622 0x1100c98d0 45.3135152 Committing  Database 0x01312d0001312d00 IX
                                                                    Row       0x000000008eb736e8 Sn SYS.CACHE_GROUP
                                                                    Table      737448                      W MY.BIG_CG

User in this case ended up deciding to stop the long running transaction by
kill -9 799622

pid 799622 was doing the UNLOAD CACHEGROUP MY.BIG_CG.

Then the User decided they had to destroy and rebuild the data store as a result. 

This could have been avoided, see solution recommended below.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.