HOWTO Use ttXactAdmin To Observe Transactions For SELECT, INSERT, UPDATE and DELETE Statements
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***
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 V220.127.116.11 at the end of this Note.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms