![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Performance and Tuning
文章平均质量分 83
Honcho
Love Life Love Oracle !
展开
-
Restoring Optimizer Statistics
In some cases we may find that gathering fresh statistics has led to the optimizer executing sub-optimal execution plans and we would like t原创 2011-10-15 00:07:45 · 772 阅读 · 0 评论 -
Using the AWR History Tables to compare performance
Using the DBA_HIST AWR history tables, we can compare the top wait events between different days or different time periods. Let us assume that we find that batch jobs which are executed at night part原创 2011-10-20 13:59:34 · 316 阅读 · 0 评论 -
How to identify blocks which cause latch contention on the 'cache buffers chains' latch
Possible hot blocks in the buffer cache normally can be identified by a high or rapid increasing wait count on the CACHE BUFFERS CHAINS latch.This latch is acquired when searching for data blocks cach原创 2012-01-16 00:03:42 · 514 阅读 · 0 评论