Table of Contents

About

The ttXactAdmin utility shows:

  • all active transactions,
  • the locks they are holding
  • and anyone waiting on those locks.

Example

[oracle@Exalytics-01 ~]$ ttXactAdmin MY_DSN;
2012-07-01 13:05:17.286
/u01/app/oracle/product/cache_store/tt_cache_store/di_tt_cache_store
TimesTen Release 11.2.2.2.0

Outstanding locks

PID     Context            TransID     TransStatus Resource  ResourceID           Mode  SqlCmdID             Name

Program File Name: ttcserver
  Client: HI-LAPTOP-NGD.HotITem.local (192.168.71.18) PID: 9560

1458    0x1427880             3.5      Active      Database  0x01312d0001312d00   IX    0

Program File Name: ttcserver
  Client: HI-LAPTOP-NGD.HotITem.local (192.168.71.18) PID: 9560

2985    0x1ba1880             5.27     Active      Database  0x01312d0001312d00   IX    0
                                                   Command   50889616             S     50889616
                                                   Command   50202664             S     50202664