Is there a less expensive view to call than V_USER_EXPLICIT_ENTITLEMENTS?
This select is taking over 15 minutes in my environment:
SELECT Entitled_ID,
Entitlement_ID
FROM AVUSER.V_USER_EXPLICIT_ENTITLEMENTS
WHERE ENTITLEMENT_TYPE='ApplicationRole'
Thanks,
Bill
7.0.2 P07