http://www.bitscn.com/pdb/oracle/200809/151545.html
RESOLVE METHOD:
CHECK EXECUTE PLAN:
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
1, CHECK IF THERE IS CARTESIAN .
2，CHECK TABLE STATISTICS.
3, IF USE PREDICT FILTER ON TABLE, THEN CHECK COLUMN STATISTICS .
4, UPDATE TABLE STATISTICS.
SQL> EXEC DBMS_STATS.DELETE_TABLE_STATS(USER, 'ORD_HIT_COMM')
PL/SQL procedure successfully completed.
SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS(USER, 'ORD_HIT_COMM')
PL/SQL procedure successfully completed.
5, CHECK STATISTICS.
SELECT COLUMN_NAME, NUM_DISTINCT, NUM_NULLS, DENSITY, NUM_BUCKETS
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'ORD_HIT_COMM'
AND COLUMN_NAME = 'ENABLE_FLAG';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/350519/viewspace-1039814/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- aix, linux 解决特殊符号文件名:
- 在AIX,LINUX系统中访问含特殊符号的文件
- SSH Host key verification failed
- 让一个普通用户看到另一个用户的包体
- dbms_scheduler package body INVALID 解决方案
- db_recovery_file_dest_size, v$flashback_database_logfile,v$restore_point引发的血案.
- impdp 遇到 ORA-07445 错误。重新EXPDP，IMPDP解决了。
- drop user 死锁（物化视图，JOB）
- expdp, impdp ORA-39213 Metadata processing not available
- aix login shell permission error trouble shooting.
