The ps_thread_trx_info function returns a JSON object detailing the current transaction and executed statements for a specific thread.
sys.ps_thread_trx_info(thread_id)ps_thread_trx_info is a available with the .
It returns a JSON object with information about the thread specified by the given thread_id. This information includes:
the current transaction;
executed statements (derived from the and the (full data will only returned if the consumers for those tables are enabled).
The maximum length of the returned JSON object is determined by the value of the (by default 65535). If the returned value exceeds this length, a JSON object error is returned.
This page is licensed: CC BY-SA / Gnu FDL