To check existing audit policies in Oracle, you can query the following both view: AUDIT_UNIFIED_POLICIES and AUDIT_UNIFIED_ENABLED_POLICIES view

List the Policies present in Oracle

SELECT * FROM AUDIT_UNIFIED_POLICIES; 

Enabled policies present in Oracle

SELECT * FROM AUDIT_UNIFIED_ENABLED_POLICIES;