Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Transaction Page

The Transaction page of the Top Sessions drilldown displays the details of the current transaction for the selected session.

To open the Transaction page

  1. Select the Spotlight on MySQL connection in the Spotlight Browser.
  2. Click Top Sessions Page.

  3. Select a row in the Top Sessions grid.
  4. Click Transaction.

Data on the Transaction page

Within the InnoDB storage engine, all user activity occurs inside a transaction.

Control Description

MySQL Thread ID

The Thread ID of the current MySQL connection.

Query ID

The ID of the query executed.

Transaction State

The current state of the transaction (for example, NOT STARTED or ACTIVE).

Obtained from the output of the MySQL SHOW INNODB STATUS command.

No. Tables in Use

Obtained from the output of the MySQL SHOW INNODB STATUS command.

No. Tables Locked

Obtained from the output of the MySQL SHOW INNODB STATUS command.

Queue State

Obtained from the output of the MySQL SHOW INNODB STATUS command.

No. Locked Struct(s)

Obtained from the output of the MySQL SHOW INNODB STATUS command.

Lock Heap Size

Obtained from the output of the MySQL SHOW INNODB STATUS command.

Undo Log Entries

Obtained from the output of the MySQL SHOW INNODB STATUS command.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating