EXPort/Import can be Very Slow with OPTIMIZER_MODE = FIRST_ROWS http://metalink.Oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=181072.1
3。修改初始化參數(shù)OPTIMIZER_MODE = CHOOSE， 創(chuàng)建登錄觸發(fā)器，只有當(dāng)應(yīng)用用戶登錄的時候才設(shè)置優(yōu)化模式 CREATE OR REPLACE TRIGGER LoginTrigger AFTER LOGON ON ETFDB.SCHEMA BEGIN execute immediate 'alter session set OPTIMIZER_GOAL=FIRST_ROWS'; END; /
4。exp使用專門的用戶EXPIMPADMIN，該用戶具有EXP_FULL_DATABASE和IMP_FULL_DATABASE 角色。然后創(chuàng)建觸發(fā)器 CREATE OR REPLACE TRIGGER LoginTrigger AFTER LOGON ON EXPIMPADMIN.SCHEMA BEGIN execute immediate 'alter session set OPTIMIZER_GOAL=CHOOSE'; END; /
