OraFAQ Forum: Security » v$xml_audit

Home » RDBMS Server » Security » v$xml_audit_trail return no rows (Oracle 10.2, windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

v$xml_audit_trail return no rows [message #472804]

Tue, 24 August 2010 00:55

oracleraj
Messages: 13
Registered: November 2009

Junior Member

We had enabled auditing for erp user

-AUDIT UPDATE TABLE, INSERT TABLE, DELETE TABLE BY erp BY ACCESS;
-audit_trail 'XML, EXTENDED'
SQL> show parameter audit

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string D:\ORACLE\PRODUCT\10.2.0\ADMIN
\ICPORA\ADUMP
audit_sys_operations boolean TRUE
audit_trail string XML, EXTENDED
SQL>

when we check at this path D:\ORACLE\PRODUCT\10.2.0\ADMIN\ICPORA\ADUMP there are xml files creating.. but when we excute below query, it return no rows..

select db_user, os_user, os_host, TO_CHAR(EXTENDED_TIMESTAMP,'fmDd-MM-YYYY HH:MI:SS AM'), sql_text, sql_bind
from v$xml_audit_trail
where db_user in ('erp', 'ERP')
and to_char(extended_timestamp, 'fmDd-MM-YYYY') = to_char(SYSDATE, 'fmDd-MM-YYYY')
order by 4 asc;

NOTE: The query was runing properly and returning rows, but it's been one week query returns no rows.

[Updated on: Tue, 24 August 2010 01:02]

Report message to a moderator