My Oracle Support Banner

OEM Agent Process is Filling up the adump Directory on 12.1 CDB Physical Standby Server (Doc ID 2420459.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.4.0 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

OEM Agent is filling up the adump directory rapidly with auddata on 12.1.0.2.0 CDB Physical Standby server.

Below is the sample extract from one of the audfiles :-


System name: Linux
Node name: xyz.com
Release: 3.10.0-514.el7.x86_64
Version: #1 SMP Wed Oct 19 11:24:13 EDT 2016
Machine: x86_64
Instance name: XYZ1
Redo thread mounted by this instance: 1
Oracle process number: 59
Unix process pid: 7511, image: oracle@xyz.com

Fri Jun 29 03:48:56 2018 +02:00
LENGTH : '346'
ACTION :[187] 'select user_id, con_id, username from cdb_users where (user_id, con_id) in ((:1 ,:2 ),(:3 ,:4 ),(:5 ,:6 ),(:7 ,:8 ),(:9 ,:10 ),(:11 ,:12 ),(:13 ,:14 ),(:15 ,:16 ),(:17 ,:18 ),(:19 ,:20 ))'
DATABASE USER:[3] 'SYS'
PRIVILEGE :[6] 'SYSDBA'
CLIENT USER:[6] 'oracle'
CLIENT TERMINAL:[7] 'unknown'
STATUS:[1] '0'
DBID:[10] '1796242711'

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.