From a list of business transactions with snapshots, choose a long-running
business transaction that accesses the database, one that takes a few seconds or
more.
These are more likely to have captured database details.
Double-click Drill Down above the database icon.
The correlated database details window appears.
Click the Queries, Clients, Sessions, and Schema tabs to view details of
database activity that occurred around the time when the snapshot was
captured.
For relational databases, these details reflect the database activity from the
transaction snapshot. For non-relational databases, these details reflect the
database activity that occurred around the time of the transaction
snapshot.
Note: For Oracle backends only: If you want to list only the queries executed by the Transaction Snapshot in the Transaction Snapshot window, you can enable the jdbc-dbcam-integration-enabled node property for the Java Agent.