optimizer modes:rule-based,cost-based
optimizer :throughput,response time
optimizer_features_enable=8.1.5
package:dbms_spm(sql plan management)
v$sql_plan
plan_table :explain plan for select * from t; select * from table(dbms_xplan.display);
tkprof 1.trc output.txt
Oracle sql statement tuning
最新推荐文章于 2025-03-18 21:22:37 发布