12c Database Metric - User Block , User Block Chain , User Locks
Testing rules/incidents to be alerted for blocking sessions.
Looking at the OEM 12c reference doc - it has the following metrics
User Block
User Block - says disabled when I look at database metrics webpage.
User Block Chain - returns the following error.
ORA-00904: "BR"."TYPE": invalid identifier
oracle.sysman.emSDK.emd.comm.MetricGetException: ORA-00904: "BR"."TYPE": invalid identifier
User Locks seem to work. - but have not yet tested.
Has anyone was able to get the User Block and User Block Chain to work?
Looking at the OEM 12c reference doc - it has the following metrics
User Block
Blocking Session CountUser Block Chain
Blocking Session CountUser Locks
Blocking Session DB Time
Maximum Blocked DB Time (seconds)
Maximum Blocked Session Count
User Block - says disabled when I look at database metrics webpage.
User Block Chain - returns the following error.
ORA-00904: "BR"."TYPE": invalid identifier
oracle.sysman.emSDK.emd.comm.MetricGetException: ORA-00904: "BR"."TYPE": invalid identifier
User Locks seem to work. - but have not yet tested.
Has anyone was able to get the User Block and User Block Chain to work?
0