oracle解锁单个用户schema 批量解锁schema dbms_stats.unlock_schema_stats

解锁单个户

 exec DBMS_STATS.UNLOCK_schema_STATS('TT_USER');

批量解锁用户

 begin
  dbms_stats.unlock_schema_stats('ZBQ_WB');
  dbms_stats.unlock_schema_stats('ZBQ_BZ');
  dbms_stats.unlock_schema_stats('JC_BZ');
  dbms_stats.unlock_schema_stats('ZXCP');
  dbms_stats.unlock_schema_stats('ZJ');
  dbms_stats.unlock_schema_stats('YPT');
  dbms_stats.unlock_schema_stats('SZJK');
  dbms_stats.unlock_schema_stats('SSXY');
  dbms_stats.unlock_schema_stats('QY');
  dbms_stats.unlock_schema_stats('NSXY');
  dbms_stats.unlock_schema_stats('KQFX');
  dbms_stats.unlock_schema_stats('KHD');
  dbms_stats.unlock_schema_stats('JCSSJ');
  dbms_stats.unlock_schema_stats('HSQJJK');
  dbms_stats.unlock_schema_stats('GSFX');
  dbms_stats.unlock_schema_stats('FXGL');
  dbms_stats.unlock_schema_stats('BZ');
  dbms_stats.unlock_schema_stats('ST');
end;
/

供参考。