摘要：
http://t.askmaclean.com/thread-1484-1-1.html10.2.0.5.0+RACElapsed: 60.32 (mins) DB Time: 582.45 (mins) AAS非常高，说明负载很高gc buffer busy 12,815,419 22,761 2 65.1 ClusterCPU time 7,283 20.8 gc cr multi bloc... 阅读全文
该文被密码保护。 阅读全文
摘要：
GLOBAL BUFFER BUSY WAIT是RAC平台经常出现的一种等待事件，这种等待如果比较严重的话，会对系统的性能产生十分重大的影响。甚至导致数据库被短暂的HANG住。今天做awr报告发现gc buffer busy等待时间gc buffer busy This wait event, also known as global cache buffer busy prior to Oracle 10g, specifies the time the remote instance locally spends accessing the requested data block. T. 阅读全文
摘要：
http://yangtingkun.itpub.net/post/468/526943客户产品数据库上午出现了严重的性能问题，简单记录一下问题的诊断和解决过程。可以看到，数据库的DB TIME已经涨到了非常高的地步，这说明系统正经受着非常严重的性能问题：Snap IdSnap TimeSessionsCursors/SessionBegin Snap:717031-3月-12 08:00:5039510.5End Snap:717231-3月-12 09:00:2768911.7Elapsed:59.61 (mins)DB Time:17,270.93 (mins)从TOP 5看，等待事件中 阅读全文
摘要：
http://blog.csdn.net/robinson1988/article/details/6077944AWR中有 DB time这个术语，那么什么是DB time呢？Oracle10gR2 官方文档 给出了详细解释(Oracle10gPerformance Tuning Guide 5.1.1.2 Time Model Statistics)The most important of the time model statistics is DB time. This statistics represents the total time spent indatabase cal 阅读全文
摘要：
http://www.eygle.com/digest/2009/02/awr_db_time.html在Oracle Database 10g中引入了DB time指标，其实这并不算是新概念。先摘录一些官方的说明（Oracle Database Performance Tuning Guide 10g Release 2 (10.2) B14211-01）DB TimeAmount of elapsed time (in microseconds) spent performing Database user-level calls. This does not include the ti 阅读全文