32: select count(*) into uniaud_linkon from v$option
33: where parameter like '%Unified Auditing%' and value = 'TRUE';
34:
35: -- Get number of Unified Audit policies created in the database
36: select count(*) into unified_policies from aud_policy$;
37:
38: -- Get number of Unified Audit policies enabled in the database
39: select count(distinct policy#) into unified_policies_enb from audit_ng$;
40:
38: -- Get number of Unified Audit policies enabled in the database
39: select count(distinct policy#) into unified_policies_enb from audit_ng$;
40:
41: -- Get number of Unified Audit policies with condition
42: select count(*) into unified_policies_cond from aud_policy$
43: where condition is NOT NULL;
44:
45: -- Get number of Unified Audit policies for each componenet
46: FOR item IN (SELECT audit_option_type, count(distinct policy_name) pol_cnt