Oracle 视图 DBA_HIST_SNAPSHOT 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图DBA_HIST_SNAPSHOT是一个系统建模视图,存储了在周期性数据库快照中所收集的概要信息以及执行任务的详细信息。该视图用于捕获、汇总和跟踪时间段内数据库活动的历史信息,主要用于性能分析和故障排除。DBA_HIST_SNAPSHOT中维护了概要信息:俯视图会记录所有与排它状态 (exclusive mode) 不相关的事务。 使用DBA_HIST_SNAPSHOT视图可以:
1、确定数据库运行时发生的事件;
2、查看数据库快照信息,包括等待事件,活动会话,SQL语句等;
3、监控系统活动,以查看特定的SQL语句的性能,以及CPU和等待时间;
4、为性能调优和故障排除提供资料,提供数据库发展趋势的分析。
官方英文解释
DBA_HIST_SNAPSHOT
displays information about the snapshots in the Workload Repository.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Startup time of the instance |
|
|
|
Time at the beginning of the snapshot interval |
|
|
|
Time at the end of the snapshot interval; the actual time the snapshot was taken |
|
|
Amount of time to perform the snapshot |
|
|
|
Snapshot level |
|
|
|
Number of errors occurring in the tables for the particular snapshot |
|
|
|
Condition under which the snapshot was inserted. Possible values are:
|
|
|
|
Snapshot time zone expressed as offset from UTC (Coordinated Universal Time) time zone |
|
|
|
Time at the beginning of the snapshot interval, with timezone |
|
|
|
Time at the end of the snapshot interval; the actual time the snapshot was taken, with timezone |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
Table F-1 for more information about the MMON
process