Timesten - ttxactadmin utility

> Database > (TimesTen|TT) (In-Memory Database|IMDB)

1 - About

The ttXactAdmin utility shows:

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

3 - Example

[[email protected] ~]$ 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