Go up

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, 393 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, 392 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, 392 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, 392 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, 392 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