Re: Oracle 10g Auditing

On Aug 1, 7:28 am, indytoatl <indyto..._at_gmail.com> wrote:
> I'm running Oracle 10g with FGA to OS file. How can I limit the file
> size to 1gig?

You really don't want to do that in 10g as statements will fail when the audit file fills to capacity:

http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/auditing.htm#DBSEG525

11g offers the option to limit a single audit file to a certain size at which time a new audit log is created:

http://download.oracle.com/docs/cd/E11882_01/appdev.112/e16760/d_audit_mgmt.htm#ARPLS65396

> The command below does not work with 10g but it works
> fine with 11g.
>

That's because the DBMS_AUDIT_MGMT package does not exist in 10g.

> -- Set the Maximum size of OS audit files to 15,000Kb.
> BEGIN
>   DBMS_AUDIT_MGMT.set_audit_trail_property(
>     audit_trail_type           => DBMS_AUDIT_MGMT.AUDIT_TRAIL_OS,
>     audit_trail_property       => DBMS_AUDIT_MGMT.OS_FILE_MAX_SIZE,
>     audit_trail_property_value => 15000);
> END;
> /
>
> Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

David Fitzjarrell Received on Wed Aug 03 2011 - 17:46:13 CDT