statistics stat

exec dbms_stats.gather_schema_stats( ownname => 'HMA_TM_STAGE') ;

exec dbms_stats.gather_schema_stats( ownname => 'HMA_TM_STAGE',degree => 6) ;

EXEC DBMS_STATS.gather_table_stats(ownname => 'HMA_TM_PROD_GEN2_MONITOR', tabname => 'zzt_service_log', degree => 8);

EXEC DBMS_STATS.gather_index_stats(ownname => 'HMA_TM_PROD_GEN2_MONITOR', indname => 'SYS_IL0001313574C00015$$', degree => 8);


exec dbms_stats.lock_table_stats('HMA_TM_PROD_GEN2_MONITOR', 'ZZT_SERVICE_LOG');