7 Working with the Transaction Monitor

Viewing the transaction monitor page

Before using the transaction monitor, ensure that preferred credentials are set for your TimesTen database target. For more information about setting preferred credentials, see "Setting preferred credentials for a target".

To view the transaction monitor page, ensure that you are on the TimesTen database target page. For information on navigating to the TimesTen database target page, see "Navigating to the TimesTen target page".

From the TimesTen Database Home menu, select Monitoring, then select Transaction Monitor.

Analyzing information on the transaction monitor page

The transaction monitor displays a snapshot of the current transactions in your TimesTen database and describes details about your transactions. Use the transaction monitor to review how your transactions are processed. If your application is running slow, there may be an issue with how the transactions in the application are acquiring locks. If a lock is not released or is taking too long to be released, application responsiveness is degraded. The transaction monitor can help you identify transactions that are taking too long to be processed.

The transaction monitor page is divided into two tabs:

• Outstanding locks

• Awaiting locks

Outstanding locks

The outstanding locks tab enables you to view information about outstanding locks in your database. It is divided into two regions:

• Transaction information

• Lock detail for transaction

Transaction information

Figure 7-1 Transaction Information region

Description of "Figure 7-1 Transaction Information region"

The transaction information region displays the current transactions that are holding locks in your database in a table format. You can click the column header to sort the table based on the column.

Click a transaction to review detailed information about the transaction and the locks associated with the transaction.

Figure 7-2 Select a transaction

Description of "Figure 7-2 Select a transaction"

The lock information for your selected transaction displays in the lock detail for transaction region. For more information on the lock detail for transaction region, see "Lock detail for transaction".

To rollback a transaction, select the transaction and click the Rollback button that is located above the transaction information table.

Figure 7-3 Rollback a transaction

Description of "Figure 7-3 Rollback a transaction"

A confirmation dialog appears where you need to confirm the rollback operation.

Lock detail for transaction

Figure 7-4 Lock details

Description of "Figure 7-4 Lock details"

The lock details region displays information about the locks of a selected transaction.

The number of locks in the lock details region should be low. If you see many locks, review the way your application is acquiring locks.

For more information about locks and transactions, see "ttXactAdmin" in the Oracle TimesTen In-Memory Database Reference.

Awaiting locks

Figure 7-5 Awaiting locks

Description of "Figure 7-5 Awaiting locks"

The awaiting locks region displays transactions that are competing for the same lock resources.

The number of locks in the awaiting locks region should be low. Locks that are awaiting events such as user input do not show in the table. If you see a transaction that does not clear after running the transaction monitor multiple times, review the lock. You may need to force a commit or a rollback on the transaction.

For more information about locks and transactions, see "ttXactAdmin" in the Oracle TimesTen In-Memory Database Reference.