Hi,
I would like to extract the insert, delete and update queries that are performed against a single table of an Oracle database monitored via DPA.
I would like to schedule this to receive it once a day, and I want it to be dynamic. For this reason, the TopSQL report is not suitable because it uses hashes and would not record new queries performed during the day.
Could someone help me create a query to get this information directly from the MySQL repository so I can bypass DPA and program it in another way?
Thank you very much,
froana