Is there a way to see what the bind values are in Foglight or Performance Analysis for Sql Server, Oracle, DB2, and Sybase?
In general we do not trace the statements but only shows what exists in the database cache. In order to find the bind variables we will need to trace the statement with sufficient trace level, we sample statements that exists in the shared pool, therefore this data is unavailable to us.
Performance Analysis cannot show the values of what passes through bind variables and there are no settings to change that there.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center