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 7.0.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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
UNLOAD CACHEGROUP MY.BIG_CG:

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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