Tuesday, April 8, 2014

What Management Packs are enabled?

SELECT DISTINCT d.pack_display_label pack_name, NVL2(l.pack_name,'YES','NO') license FROM mgmt_admin_licenses l, mgmt_license_definitions d 
WHERE d.pack_label = l.pack_name(+) 
ORDER BY d.pack_display_label; 

References: 
========== 
How to Find What Management Packs are Enabled for a Database? (Doc ID 1308552.1) 

No comments:

Post a Comment