DBA Hub

📋Steps in this guide1/1

View unified audit report

- Unified report for last 1 hour: set lines 299 col SQL_TEXT for a23 col action_name for a18 col UNIFIED_AUDIT_POLICIES for a23 select action_name,SQL_TEXT,UNIFIED_AUDIT_POLICIES ,EVENT_TIMESTAMP from unified_AUDIT_trail where EVENT_TIMESTAMP > sysdate -1/24;

oracle configurationintermediate
by OracleDba
13 views
1

View unified audit report

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
- Unified report for last 1 hour:
set lines 299
col SQL_TEXT for a23
col action_name for a18
col UNIFIED_AUDIT_POLICIES for a23
select action_name,SQL_TEXT,UNIFIED_AUDIT_POLICIES ,EVENT_TIMESTAMP from unified_AUDIT_trail
where EVENT_TIMESTAMP > sysdate -1/24;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!