If you are using Audit Trail, can you share your experience?

We've received a request to deliver metrics on all Oracle updates made by a specific group in our organization (about 6 users). On a monthly basis, they want to know who made the change, when the change was made, and what the data was before/after the change. We are considering enabling Audit Trail just for the People and Assignment tables, but we are concerned that we will introduce system performance issues, especially as other groups within the organization hear that Audit Trail is available and request it be enabled for more data tables.

If you are a large organization and are using Audit Trail for a similar need, I'd love to connect with you and hear about your experience with Audit Trail. Have you experienced any performance issues? Were there unforeseen consequences that you've had challenges with?