相比与10gR1而言,10gR2在performance tuning方面更注重人机交互,不仅statpack得到了很大的增强,还提供了很多新的report机制,dba借助这些报表,可以更快地监控系统性能.

10gR2中performance tuning
.active session history reports
.automatic PGA memory management
.automatic shared memory menagement
.automatic tuning mulitblock read count
.automatic workload repository reports(awrrpt/awrrpti/awrsqrpt/awrsqrpti)
.configure automatic workload repository SQL collection
.enhanced end2end application tracing
.improved system statistics
.SQL access advisor
.SQL profiles
.SQL tuning advisor
.SQL tuning sets
.v$SQLSTATS