开发者

Three basic requirements that determine AWR snapshot usability

开发者 https://www.devze.com 2023-02-21 09:18 出处:网络
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 dete开发者_StackOverflow社区rmine whether an AWR snapshot is usabl

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 dete开发者_StackOverflow社区rmine 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.


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消