Last updated on NOVEMBER 02, 2015
Applies to:Oracle Server - Enterprise Edition - Version 10.2.0.4 to 188.8.131.52 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 25-Aug-2011
Starting with 10.2.0.4, when the number of XML audit files exceeds a certain number (+30000), the queries on v$xml_audit_trail or dba_common_audit_trail start to error out with errors like:
Removing the files from the audit_file_dest directory solves the problem for the moment. In time, however, if the files are not removed, the problem will to reoccur.
This problem is rarely seen on 32k bits systems, where the maxpid parameter is generally hardcoded to 32k.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms