why 11g2 AUD$ generate faster than 10g2
I do not found found the answer here:
http://www.oracle.com/technetwork/articles/sql/11g-security-100258.html
but I also realize my aud$ log increase lots after migration to 11g. no transaction change.
I compare Mar/25/2010 and /AUG/12/2010 (Thursday)
and found the
select count(*) from sys.aud$ where userhost like '%021' and userid ='STAGING' and obj$name='OPERATIONS_LOG' and to_char(NTIMESTAMP# ,'MM/DD/YYYY')='03/26/2010';
=21
select count(*) from sys.aud$ where userhost like '%021' and userid ='STAGING' and obj$name='OPERATIONS_LOG' and to_char(NTIMESTAMP# ,'MM/DD/YYYY')='08/13/2010';
=1521
the only diff I can found in the AUD$ log is, every second, more record generate for the same statement. Can anyone give me the hint?
but I also realize my aud$ log increase lots after migration to 11g. no transaction change.
I compare Mar/25/2010 and /AUG/12/2010 (Thursday)
and found the
select count(*) from sys.aud$ where userhost like '%021' and userid ='STAGING' and obj$name='OPERATIONS_LOG' and to_char(NTIMESTAMP# ,'MM/DD/YYYY')='03/26/2010';
=21
select count(*) from sys.aud$ where userhost like '%021' and userid ='STAGING' and obj$name='OPERATIONS_LOG' and to_char(NTIMESTAMP# ,'MM/DD/YYYY')='08/13/2010';
=1521
the only diff I can found in the AUD$ log is, every second, more record generate for the same statement. Can anyone give me the hint?
0