ORACLE_SQL性能优化要素.ppt

* 首页面 SQL declare 2 i number; 3 sqlstr varchar2(200); 4 begin 5 i:=1; 6 sqlstr:=select * from test1 where a=:x; 7 execute immediate sqlstr using i; 8 end; 9 / PL/SQL procedure successfully completed. SQL select name,executions from v$db_object_cache where name like select * from test1 where a%; NAME EXECUTIONS select * from test1 where a=:x 1 select * from test1 where a=:x