Spotlight on Oracle 10.6

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Spotlight on Oracle 10.6 - Release Notes

New Features Resolved Issues and Enhancements Deprecated Features Known Issues System Requirements Product Licensing Getting Started Globalization About us Copyright

Top Sessions Page

Top Sessions lists all users connected to the MySQL database in logical I/O request order. Clicking a column heading changes the sort order of the table.

To open the Top Sessions page

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

Actions on the Top Sessions grid

Column	Description
Select (Highlight) a session	View detailed information on the session. See: Transaction Page Explain Plan Page
Kill a session	Right-click the session and select Kill Session. A message appears with the serial number of the session to be killed. Click Yes to kill the session or click No to leave it running. Note: Not all users may have permission to kill sessions. This permission is granted by the Database Administrator.
End a MySQL query	Right-click the session and select Kill Query. A confirmation message appears. Click Yes to kill the query or click No to leave the query running. Note: Not all users may have permission to kill sessions. This permission is granted by the Database Administrator.

Column

Description

Select (Highlight) a session

View detailed information on the session. See:

Kill a session

Right-click the session and select Kill Session.

A message appears with the serial number of the session to be killed. Click Yes to kill the session or click No to leave it running.

Note: Not all users may have permission to kill sessions. This permission is granted by the Database Administrator.

End a MySQL query

Right-click the session and select Kill Query.

A confirmation message appears. Click Yes to kill the query or click No to leave the query running.

Note: Not all users may have permission to kill sessions. This permission is granted by the Database Administrator.

The Top Sessions Grid

Notes:

Not all columns are visible by default. Use the Column Organizer to view hidden columns. Show, Hide & Order Columns

The values in this table are obtained from the output of the SHOW FULL PROCESSLIST or SHOW INNODB STATUS commands.

Column	Description
ID	The unique identifier for the user session.
Host	The name of the host from which the user has established a connection.
User	The MySQL account under which the user has connected to the database.
Database	The name of the MySQL database to which the user is currently connected.
State	The current state of the session. If the session is idle, this will be sleeping. Otherwise, the State column shows the current activity undertaken by the user.
Time	The amount of time – in seconds – for which the current query has been running.
Command	The type of command currently running for the session.
Info	More information; usually the text of the SQL statement being 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.
Queue State	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.
No. Lock Structs.	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.
Undo Log Entries	Obtained from the output of the MySQL SHOW INNODB STATUS command.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Spotlight on Oracle 10.6 - Release Notes

Top Sessions Page