We’re trying to get to details of DB queries, optimize the slowest, etc. This would be very useful for our team.
We’re running .NET Agent 220.127.116.11 and the application uses Oracle via Oracle Managed Client. Most of queries are native Oracle SQL, SP execution, etc. rather than EF-generated.
App configuration has been moved to New Relic servers and Show advanced settings > Record SQL? = Raw.
We’re having two issues
SQL is nowhere to be seen in transaction traces. Queries show up in Database, Slow Queries. Oracle operations are in traces, but they are not hyperlinked and I could not find SQL anywhere there.
In Slow Queries I see original query with bind variables, but no bind values to be found:
SELECT COUNT(1) FROM era_internal_users WHERE login_id = :login_id