计算数据库有多少工作是在最优状态下进行的语句

1. select optimal_count,round(optimal_count * 100/total,2) optimal_perc,
   
2. onepass_count,round(onepass_count * 100/total,2) onepass_perc,
   
3. multipass_count,round(multipass_count * 100/total,2) multipass_perc
   
4. from
   
5. (select decode(sum(total_executions),0,1,sum(total_executions)) total,
   
6. sum (optimal_executions) optimal_count,
   
7. sum(onepass_executions) onepass_count,
   
8. sum(multipasses_executions) multipass_count
   
9. from v$sql_workarea_histogram
   
10. where low_optimal_size > (64*1024));

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28878983/viewspace-2138243/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28878983/viewspace-2138243/