View unified audit report - Oracle Database Script.
- 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;