Skip to Content
avatar image
Former Member

How to set audit trail in oracle database

Dear Expert,

Please help me to get the below information.

I need some information about oracle Audit trail set in oracle database for SAP,

How to set audit trail for specific table,

what Impact on database and performance if we turn on audit trail in production.

How much more space will I need? once I set the audit trail in database

Can I delete the audit trail after 2- 3 weeks?

How to set the audit trail in Oracle database.

Please provide me the recommendation for audit trail

Thanks

Dinesh M

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 13, 2008 at 11:38 AM

    You can activate an SQL Trace with filter at ST05 and select the tables you want to trace, impact on performance should be minimun and it should not take a lot of space (depending on the activity of the table and the amount of hits) for only a couple of tables.

    Regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Rahul,

      Thanks a lot,

      Rahul I am looking audit trail option for spacific table, I mean, If I want to set the audit trail enable for specific table. what Auditing Options can we set to specific table in oracle database

      for e.g :- LFBK (Vendor Master Bank Details) table name

      what Auditing option are recommanded or we can set ,

      Thanks

      Dinesh M