How to Check LAST_ARCHIVE_TIME

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 23 Nov, 2023
  • 0 Comments
  • 15 Secs Read

How to Check LAST_ARCHIVE_TIME

we can get LAST_ARCHIVE_TIME From DBA_AUDIT_MGMT_LAST_ARCH_TS. It is a dictionary view which contains information about the last archive timestamps set for purging unified audit trail.
SQL> select LAST_ARCHIVE_TS from DBA_AUDIT_MGMT_LAST_ARCH_TS;

Hope it Helps!