How to set audit trail in oracle database

[Former Member]

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

[JPReyes]

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

[Former Member]

Hi Juan,

Thanks for your reply,

As you mention that the SQL Performance trace, I am not looking for this.

I want to know if we on audit trail in oracle database,what will be the impact on system.

Audit point of view I have to set the audit trail in oracle database, so that I want to know the whether we have set audit trail to user or Table in database.what is standard recommendation.

for e.g :-

How many user has access the table, from which terminal and what changes they have did.etc

what will be Impact on database and performance If we turn on audit trail in oracle.

How much more disk space will need

Thanks

Dinesh M

[Former Member]

Hi Dinesh

Turning the audit trail on, would result in increase in the disk space usage as it keeps on creating audit log files either at OS level or audit entries in the database table.

Setting audit trail for a user or a Database table completely depends upon your audit requirement.

And how much more disk space you need?? It again depend up on the period you keep your audit trail on.

Have sneak preview of this link:

http://www.oracle-base.com/articles/10g/Auditing_10gR2.php

Rahul.

[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