How to check whether Oracle Management Pack access is available or not?


Following are the two ways to check Management Pack access is available or not:-

1. By using v$parameter

column name format a35;
column value format a35;
SELECT name,value FROM v$parameter WHERE name LIKE '%pack%';

Sample output:-



2. By using CONTROL_MANAGEMENT_PACK_ACCESS parameter

show parameter CONTROL_MANAGEMENT_PACK_ACCESS;

Sample output:-

No comments :
Write comments