Skip to Content
avatar image
Former Member

Cross-system SQL trace

I am looking for a method to trace all SQL statements, running in the SAP system and updating the database (INSERT, UPDATE, DELETE). Like SQL trace in ST05, but not user-dependent. The purpose is to catch all updates from all users and store these updates in a database within the same SAP instance. I think it would be similar to Oracle ReDo logs techniques, but on SAP transactional level of details.

Are there any SAP standard tools for doing that?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 04, 2013 at 03:39 AM

    I remember ST05 has a filter on user , i think you can remove it , then it will be for all the applications in that instance ? Can you please check that once... no access to SAP system right now.... you can also check ST01 ( i think that can also be set for all the users)...
    forgive if i am wrong... 😊

    Add comment
    10|10000 characters needed characters exceeded

    • sorry but m not sure which would have higher performance , in ST12 you can have a trace just for SQL(sql trace)... may be some one who have worked with both can help in this regard....

      However can you get in touch with your db team .... because there should be a way for server side trace  for all the DB operations ,rather than running a trace in SAP.... that would surely have good performance.... just a thought.

  • May 08, 2013 at 12:26 PM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I've been looking into DB replication in the way Oracle ReDo logs are working, btu unfortunately plenty of details are lost by that stage. For example, it works with kind of generic user ID-s, doesn't have any idea about SAP transaction, which triggered the action and the worst of all - nobody knows how to decipher it in order to bring it back to the tables/fields/values, discplayed in the SQL trace.

      Or are you talking about something different?

      Thank you!