Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

UNIFIED_AUDIT_SGA_QUEUE_SIZE

Property Description
Parameter type Integer
Default value 1 MB
Modifiable No
Range of values 1 MB to 30 MB
Basic No
Oracle RAC Multiple instances can have different values

UNIFIED_AUDIT_SGA_QUEUE_SIZE specifies the size of SGA queue for unified auditing. The parameter can be useful when queued-write mode is used for unified auditing. In queued-write mode, audit records are first written to the SGA queue. When the SGA queue reaches a particular threshold, the audit records are flushed to the AUDSYS schema table. The SGA queue size should be tuned according to the audit data generation. If large numbers of audit records are generated very frequently, you can increase the size of SGA queue, so that frequent flushes of queue data can be prevented. Similarly, if fewer audit records are generated, a smaller size can be used for the SGA queue.

See Also:

Oracle Database Security Guide for more information about writing unified audit trail records to the AUDSYS schema.