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 1 SQL declare 2 i number; 3 sqlstr varchar2(200); 4 begin 5 i:=2; 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 2 select * from test1 where a=:x 2 SQL * * Database Control and ADDM Findings By looking at the Database Control home page for your database, you can see the Diagnostic Summary section, which gives you the number of ADDM findings from the previous automatic run. By clicking the Performance Findings link, you are directed to the Automatic Database Diagnostic Monitor (ADDM) page, where you can access the details of the latest ADDM run. * ADDM Analysis Results On the Automatic Database Diagnostic Monitor (ADDM) page, you can see the detailed findings for the latest ADDM run. The Database Time represents the sum of the non-idle time spent by sessions in the database for t