Good Afternoon,
I'm getting pinged for some rather specific analysis by my Business Systems team, supporting Operations.
They're trying to identify when a specific change happened to a table and by whom. The Vendor's self auditing doesn't catch this particular event, so in come the DBAs after the fact. The Workload Analysis tool is very helpful in this regard.
However, the results are rather difficult to sort through when your qualifier is the actual SQL run. I can eye-ball it. But that's so inefficient.
Is there any way to query the Spotlight databases to retrieve the SQL Text from the sessions, the same way the WA tool does? I figure if it can pull it, I might be able to, too. All the Export does is give me the table data displayed. I need the SQL to complete my R&A.
Thanks so much for any advice you can offer.
-Bill