We have had some issues with long running SQL queries. We think that some bind variables may be effecting the performance. We have been capturing the bind variables and exporting to save sessions. We then perform a manual task of aligning purepaths with the matching bind values(from SQL statement) found by drilling down from purepath into database dashlet. Then enable the "show bind value" column. We take the pp information and the bind values and paste them into excel for analysis.
Is there anyway to correlate purepaths with the associated bindings with a dashboard/report/automation?. This is for 100's of purepaths.
Answer by Andreas G. ·
Hi
I would use the opposite approache - meaning:
#1 open the database dashlet and turn on bind values
#2: focus on those SQL executions that take very long with those particular bind values
#3: drill to the PurePaths from that particular SQL Execution -> this will give you all PPs that made a call to this particular SQL with these bind values
#4: instead of copying these PPs into an Excel sheet I would EXPORT these PurePaths and give that to the engineers that need to look at it.
#5: Engineers import that exported session and see exactly those PurePaths with the call to that SQL Query.
Andi
JANUARY 15, 3:00 PM GMT / 10:00 AM ET