Finding statement leak is also very easy using EMA. Just following the following steps:
1. Select Java Basics -> Group By Value, as shown in the following image:
2. Select Object=oracle.jdbc.driver.OracleSql (or any specific class you are looking for like T4CPreparedStatement) and field=actualSql as shown below:
3. You can see distinct statements with their counts when you click Finish. You can export and run awk/sed commands as well on the output to get the desired format.
1. Select Java Basics -> Group By Value, as shown in the following image:
2. Select Object=oracle.jdbc.driver.OracleSql (or any specific class you are looking for like T4CPreparedStatement) and field=actualSql as shown below:
3. You can see distinct statements with their counts when you click Finish. You can export and run awk/sed commands as well on the output to get the desired format.
No comments:
Post a Comment