Re: Oracle 10g Auditing

From: ddf <>
Date: Wed, 3 Aug 2011 15:46:13 -0700 (PDT)
Message-ID: <>

Comments embedded.

On Aug 1, 7:28 am, indytoatl <> 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:

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

> 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.
>   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 - 64bi

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

Original text of this message