决定 AWR 快照可用性的三个基本要求
我是Oracle的新手，我知道Oracle使用两个AWR快照来创建AWR报告。决定AWR快照是否可用的三个基本要求是什么？或者换句话说，快照可用于生成 AWR 报告。
我还有另一个问题。 AWR 表（不是 DBA_HIST 视图）中的主快照表。我想知道哪个是快照最重要的AWR表。
任何帮助将不胜感激。
I am a newbie to Oracle and I know that oracle uses two AWR snapshots to create an AWR report. What are three basic requirements that determine whether an AWR snapshot is usable? Or in other words a snapshot can be used for generating an AWR report.
I also have another question. Out of the AWR tables (not the DBA_HIST views) which is the main snapshot table. I want to know which is the most important AWR table for snapshots.
Any help will be greatly appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
确保快照涵盖有代表性的工作负载。
在办公时间对繁忙的报告数据库进行故障排除时，夜间空闲数据库的快照几乎没有什么用处。
Make sure the snapshots cover a representative work load.
A snapshot of an idle database during the night is of little use when troubleshooting a busy reporting database during office hours.
我能想到的要求之一是快照间隔不能太小。如果是这样，您将无法清楚地了解数据库活动。
One of the requirements that I can think of is that the snapshot interval should not be too small. If it is you won't get a clear picture of database activity.