Database Administration (MOSC)

MOSC Banner

RDBMS 12.1.0.2 audit

edited Apr 18, 2017 5:04AM in Database Administration (MOSC) 1 commentAnswered

Hi,

One of our 12.1.0.2 databases  on Windows create lots of this audits in the Windows System event viewer:

Audit trail: LENGTH: '276' ACTION :[121] 'SELECT * FROM gv$sql_plan where sql_id = '54ajrzr9kdrfa' and inst_id = 1 and child_address = hextoraw('0000000E24DB9158')' DATABASE USER:[1] '/' PRIVILEGE :[4] 'NONE' CLIENT USER:[0] ''

CLIENT TERMINAL:[10] 'GOBMDOP013' STATUS:[1] '0' DBID:[10] '2149967057' .

Is this related to Metalink document 2020881.1 (Dynamic SQL statements parsed or executed using DBMS_SQL package are still being audited in the conventional *.aud type OS files. )?

Auditing is not enabled (audit_sys_operations is TRUE).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center