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