dba_hsot_acls
shows access control lists assigned to restrict access to network hosts through PL/SQL network utility packages. select hcl.host, hcl.lower_port, hcl.upper_port, hcl.acl_owner, xce.ace_order, xce.start_date, xce.end_date, xce.grant_type, xce.inverted_principal, xce.principal, xce.principal_type, xce.privilege, xce.security_class, xce.security_class_owner, hcl.acl, hcl.aclid from dba_host_acls hcl left join dba_xs_aces xce on hcl.acl = xce.acl;