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

On Aug 1, 10:28*am, indytoatl <indyto... (AT) gmail (DOT) com> wrote:
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 --

On Mon, 01 Aug 2011 07:28:57 -0700, indytoatl wrote:

On Linux there is something called "logrotate" which can do just that.



--
http://mgogala.byethost5.com

Comments embedded.

On Aug 1, 7:28*am, indytoatl <indyto... (AT) gmail (DOT) com> wrote:
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/B...g.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/E...htm#ARPLS65396

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



David Fitzjarrell