?
oracle基线与优化（三）(三)
ype => 'COMPARE PERFORMANCE',
execution_params => dbms_advisor.arglist('COMPARISON_METRIC',
'CPU_TIME',
'EXECUTION_NAME1',
'11g_trail',
'EXECUTION_NAME2',
'11g_trail2'),
execution_desc => 'Compare 10g SQL Trace Performance to 11g Test-Execute for CPU_TIME');
end;
/
--比较BUFFER_GETS
begin
dbms_sqlpa.execute_analysis_task(task_name => '11gsps2',
execution_name => 'comparbuffergets',
execution_type => 'COMPARE PERFORMANCE',
execution_params => dbms_advisor.arglist('COMPARISON_METRIC',
'BUFFER_GETS',
'EXECUTION_NAME1',
'11g_trail',
'EXECUTION_NAME2',
'11g_trail2'),
execution_desc => 'Compare 10g SQL Trace Performance to 11g Test-Execute for BUFFER_GETS');
end;
--比较实际执行时长
begin
DBMS_SQLPA.EXECUTE_ANALYSIS_TASK(task_name => '11gsps2',
execution_type => 'COMPARE PERFORMANCE',
execution_name =>
'Compare_elapsed_time',
execution_params => dbms_advisor.arglist('execution_name1',
'11g_trail',
'execution_name2',
'11g_trail2',
'comparison_metric',
'elapsed_time'));
end;
/
--比较物理读
begin
DBMS_SQLPA.EXECUTE_ANALYSIS_TASK(task_name => '11gsps2',
execution_type => 'COMPARE PERFORMANCE',
execution_name => 'Compare_physical_reads0',
execution_params => dbms_advisor.arglist('execution_name1',
'11g_trail',
'execution_name2',
'11g_trail2',
'comparison_metric',
'disk_reads'));
end;
/
set long 100000 longchunksize 100000 linesize 200 head off feedback off echo off
spool spa_report_elapsed_time.html
SELECT dbms_sqlpa.report_analysis_task('SPA_TEST', 'HTML', 'ALL','ALL', execution_name=>'Compare_elapsed_time') FROM dual;
spool off