How to get schema/database/table names associated with rows in STL_UTILITYTEXT

0

Is there a table that maps xid/pid to table id/schema name/database name? I found SVV_TRANSACTIONS, but that only has data on currently running transactions/locks and I want something that preferably covers 2-5 days of history like the STL tables.

asked a year ago196 views
1 Answer
0
AWS
EXPERT
Ziad
answered a year ago
  • Hi, is it guaranteed that all processes/transactions will be in STL_TR_CONFLICT? I thought that wasn't the case since not all transactions will conflict with others.

  • Hi, It contains all the transactions that faced conflicts. Are you looking also for transactions without conflicts?

  • Yes, is that possible?

  • Not that I'm aware of.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions