Home » RDBMS Server » Security » v$xml_audit_trail return no rows (Oracle 10.2, windows 2003)
v$xml_audit_trail return no rows [message #472804] Tue, 24 August 2010 00:55 Go to next message
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

Re: v$xml_audit_trail return no rows [message #472837 is a reply to message #472804] Tue, 24 August 2010 02:51 Go to previous message
oracleraj
Messages: 13
Registered: November 2009
Junior Member
simple query doesnt return any rows
SQL> select *
2 from v$xml_audit_trail;

no rows selected

SQL>

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

Report message to a moderator

Previous Topic: Oracle SIM Login Failed
Next Topic: User unable to change password with "password" command
Goto Forum:
  


Current Time: Sun Sep 19 05:30:48 CDT 2021