My Oracle Support Banner

How To Get Detailed Information About the Activities of a Current Connection Using the Sys Schema? (Doc ID 2212417.1)

Last updated on MARCH 08, 2017

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Goal

Get details of what a connection is doing using the sys schema.

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
 sys.ps_trace_thread
 Automatic Enable Consumers and Instruments
 Manual Enable Consumers and Instruments
 sys.ps_thread_stack
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.