解決問題：存儲過程運(yùn)行特別慢問題處理
1翎承，查看存儲過程用到的表（DBA_dependencies）：
SELECT T.REFERENCED_OWER |'.'| T.REFERENCED_NAME
? ?FROM DBA_DEPENDENCIES T
?WHERE T.OWNER ='SCOTT'
? ? ? ?AND NAME = 'P_...'
? ? ? ?AND T.REFERENCED_TYPE = "TABLE';
2误证，對表進(jìn)行表分析:
ANALYZE TABLE TABLENAME COMPUTE STATISTICS;
