"AUDIT BY SESSION" = "AUDIT BY ACCESS" in 11g
For the recent change in 11g about the "audit by session" = "audit by access":
http://download.oracle.com/docs/cd/B28359_01/network.111/b28531/whatsnew.htm#CJABBIGH
We have great concern on this as our SYS.AUD$ table was increased from 20Mb to 2Gb a day. It seemed impossible to admin such change. Do anyone get a workaround on this if "audit <object> by session;" is a must? Thanks!
In fact, just the following script will product 10000 records in audit table
audit all on test.abc by session;
declare
n_nbr number;
begin
for i in 1.10000 loop
select count(*) into n_nbr from test.abc where col1 = i;
http://download.oracle.com/docs/cd/B28359_01/network.111/b28531/whatsnew.htm#CJABBIGH
We have great concern on this as our SYS.AUD$ table was increased from 20Mb to 2Gb a day. It seemed impossible to admin such change. Do anyone get a workaround on this if "audit <object> by session;" is a must? Thanks!
In fact, just the following script will product 10000 records in audit table
audit all on test.abc by session;
declare
n_nbr number;
begin
for i in 1.10000 loop
select count(*) into n_nbr from test.abc where col1 = i;
0