Skip to main content

Posts

Showing posts from June, 2018

Locked Stats queries

Locked Stats queries  Commands we used to lock execute DBMS_STATS.UNLOCK_TABLE_STATS('SAPP10','FAGLFLEXA'); Command we used to unlock execute DBMS_STATS.LOCK_TABLE_STATS('SAPP10','FAGLFLEXA'); Check locked statst of tables;- SELECT TABLE_NAME FROM DBA_TAB_STATISTICS WHERE STATTYPE_LOCKED = 'ALL';

For Group Target availability report. (OEM 12 C)

for Group Target availability report.  select TARGET_NAME,TARGET_TYPE,START_TIMESTAMP,AVAILABILITY_STATUS,AVAILABILITY_STATUS_CODE,TYPE_DISPLAY_NAME from mgmt$availability_current where AVAILABILITY_STATUS not like '%Up%'  and target_name  in ( select MEMBER_TARGET_NAME from mgmt$target_flat_members  where AGGREGATE_TARGET_GUID='2D063F91D5E72C284CA8F36604402DA7')   select TARGET_TYPE, count(TARGET_NAME) from sysman.mgmt$availability_current where target_name  in ( select MEMBER_TARGET_NAME from sysman.mgmt$target_flat_members   where AGGREGATE_TARGET_GUID='xxxxxxxxxx') group by TARGET_TYPE; select TARGET_TYPE, count(TARGET_NAME) from sysman.mgmt$availability_current where AVAILABILITY_STATUS not like '%Up%'  and target_name  in ( select MEMBER_TARGET_NAME from sysman.mgmt$target_flat_members   where AGGREGATE_TARGET_GUID='xxxxxxxxx') group by TARGET_TYPE;  select TARGET_TYPE,AVAILABILITY_STATUS,count(TARGET_NAM...