oralce db time

最新推荐文章于 2021-04-02 21:14:42 发布

bjchangxiao

最新推荐文章于 2021-04-02 21:14:42 发布

阅读量193

点赞数

本文探讨了Oracle数据库中DBTime可能超过实际运行时间的原因。DBTime是从实例启动开始累计测量的时间，通过合并所有非空闲用户会话的时间来计算。因此，即使实例仅运行了30分钟，如果有四个活跃用户会话，其累积DBTime可能达到120分钟。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

上次看awr就纳闷db time怎么比60分钟长，明明awr是默认一小时一次

https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF94163

DB time is measured cumulatively from the time of instance startup. Because DB time it is calculated by combining the times from all non-idle user sessions, it is possible that the DB time can exceed the actual time elapsed after the instance started. For example, an instance that has been running for 30 minutes could have four active user sessions whose cumulative DB time is approximately 120 minutes.