No question at this time
DBA Top 10
1 M. Cadot 90700
2 B. Vroman 39400
3 T. Boles 38500
4 A. Kavsek 36300
5 P. Wisse 24600
6 Y. Naguib 16800
6 J. PĂ©ran 16800
8 A. Hudspith 15150
8 A. Khan 15150
10 F. Pachot 14300
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 54 now available

Feb 04, 2014
(recommended update: build 1403)
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered46992
Total active users29528
Act. users last 24h31
Act. users last hour0
Hits last week1855
Hits last month7395
Go up

Auditing at table level in 11g
Next thread: Row chaining and migration in 10g and 11g
Prev thread: Strategy for gathering statistics with RDBMS 10g and 11g

Message Score Author Date
Hello All, We have recently upgraded our DR env...... raghavendra rao yella Apr 27, 2012
These are the settings we currently have in 9i a...... raghavendra rao yella Apr 27, 2012
I hope you have already gone through below doc. ...... Tarun Biswas Apr 27, 2012
Same question at: http://www.orafaq.com/forum/t...... Michel Cadot Apr 28, 2012
Thanks for an update on this Tarun. Appreciate it....... raghavendra rao yella Apr 28, 2012

Follow up by mail Click here


Subject: Auditing at table level in 11g
Author: raghavendra rao yella, United States
Date: Apr 27, 2012, 871 days ago
Os info: Solaris Sparc 64bit
Oracle info: 11.2.0.3
Message: Hello All,

We have recently upgraded our DR environment from 9i to 11g. We have auditing turned on for 3 tables.

On 9i, AUD$ table size is 11G for 12 months and the upgraded 11g environment has 9G in 2 days....

Below is the sql statement we used to turn on auditing on these tables.

audit select,update,delete on audit_Test2 by session;

Opened SR with Oracle, but no proper response from them...

Can you please advice what changes we need to do in order to reduce the amount of audit data on these tables in 11g?


Thanks,
Raghu Yella.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Auditing at table level in 11g
Author: raghavendra rao yella, United States
Date: Apr 27, 2012, 871 days ago
Message:
These are the settings we currently have in 9i and 11g. But in 11g the amount of data is more.

Here is what we came across.
"On 9i - when a session is opened and performing inserts/updates/select/deletes in a loop of for eg., 100.. it will generate one entry in AUD$ table. But in 11g, the same loop of 100 is generating 100 entries in AUD$ table" HOW TO RESTRICT THIS?

OWNER OBJECT_NAME OBJECT_TYPE ALT AUD COM DEL GRA IND INS LOC REN SEL UPD REF EXE CRE REA WRI
LOYALTY_OWNER ACCOUNT_REDEMPTIONS TABLE -/- -/- -/- S/S -/- -/- -/- -/- -/- S/S S/S -/- -/- -/- -/- -/-
e
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Auditing at table level in 11g
Author: Tarun Biswas, United Arab Emirates
Date: Apr 27, 2012, 871 days ago
Message: I hope you have already gone through below doc.

AUD$ Growing After Upgrade to 11g or ATC patch installed [ID 852815.1]

#######11.1.0.7

This was an intentional change with the new auditing architecture introduced in 11g. From 11.1.0.7 the auditing system uses "write once" audit records, this means that once a record has been written it can't be updated. This change improves performance of the auditing system (because there is less contention and it removes the need for indexes on aud$). This also means that the db audit trail works in the same way as the XML and OS audit trails. This change is architectural, there is no way to go back to the old BY SESSION auditing behavior.

Thanks

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Auditing at table level in 11g
Author: Michel Cadot, France
Date: Apr 28, 2012, 870 days ago
Message:
Same question at:
http://www.orafaq.com/forum/t/180881/102589/

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Auditing at table level in 11g
Author: raghavendra rao yella, United States
Date: Apr 28, 2012, 870 days ago
Message: Thanks for an update on this Tarun. Appreciate it....

We dealt with Oracle support for the past 5 days and haven't heard any response.

So based on the notes.. it seems like we need to go with implementing FGA .

Thanks,
Raghu Yella.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here