Re: Oracle 10g Auditing

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Tue, 2 Aug 2011 07:00:39 -0700 (PDT)
Message-ID: <7112aab0-ca40-46aa-99ff-3b2f737da17f_at_f17g2000prf.googlegroups.com>

On Aug 1, 10: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? The command below does not work with 10g but it works
> fine with 11g.
>
> -- 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

Having always kept my audit trail in the database I am unaware of any way to limit the OS file size on 10g. What effect does purging the audit trail have on the OS file?

HTH -- Mark D Powell -- Received on Tue Aug 02 2011 - 09:00:39 CDT