摘要:
删除统计信息并锁定 exec dbms_stats.delete_table_stats(ownname => 'scott',tabname =>'a'); exec dbms_stats.lock_table_stats(ownname => 'scott',tabname =>'a');exe 阅读全文
摘要:
set heading off;set feedback off;set echo off;Set lines 999;Spool rollback.sqlselect 'ROLLBACK FORCE '''|| LOCAL_TRAN_ID ||''';' from DBA_2PC_PENDING 阅读全文
摘要:
修改为5%(范围从1-100): exec dbms_stats.set_table_prefs(null,'table_name','STALE_PERCENT',5); 恢复为10%: exec dbms_stats.set_table_prefs(null,'table_name','STAL 阅读全文