HOWTO Use ttXactAdmin To Observe Transactions For SELECT, INSERT, UPDATE and DELETE Statements (Doc ID 842481.1)

Last updated on MARCH 02, 2016

Applies to:

TimesTen Data Server - Version 6.0.0 and later
Information in this document applies to any platform.
ttXactAdmin, transaction, ttIsql

***Checked for relevance on 19-06-2013***

Goal

Demonstrate how to use ttXactAdmin to observe 'uncommitted' transactions for SELECT, INSERT, UPDATE and DELETE statements.  We will do this by turning autocommit off, executing a statement and then running ttXactAdmin and committing after each statement.

Addendum as of August, 2011: The original Support Note referenced ttXactAdmin as it existed for TimesTen V6 and V7. While the basic locking protocol for V11 is unchanged from the earlier releases, the output of ttXactAdmin is somewhat different. Look for additional ttXactAdmin examples taken from V11.2.1.8 at the end of this Note.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms