Oracle 视图 DBA_ADDM_INSTANCES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_ADDM_INSTANCES可帮助用户查看启动自动处理分析（ADDM）的实例信息，其中包括report_id，实例ID，任务状态，计划开始时间和完成时间。
使用方式：
1.登录Oracle数据库，使用DBA账户或具有访问DBA_ADDM_INSTANCES视图权限的用户账户；
2.按照下列 select 语句查询单个实例的 ADDM 信息：
SELECT report_id ,instance_id, status ,plan_start_time, report_end_time FROM DBA_ADDM_INSTANCES WHERE instance_id = ‘instance_id’;
3.使用下面的 select 语句查询数据库中所有实例的 ADDM 信息：
SELECT report_id ,instance_id, status ,plan_start_time, report_end_time FROM DBA_ADDM_INSTANCES;
官方英文解释
DBA_ADDM_INSTANCES displays instance-level information for ADDM tasks that finished executing.
For each instance that was supposed to be analyzed (whether it was or not) there is one row describing information about it.
Related View
USER_ADDM_INSTANCES displays instance-level information for ADDM tasks that finished executing in all instances owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
The ID of the main ADDM task |
|
|
|
|
The number of the instance |
|
|
|
The name of the instance |
|
|
|
|
The name of the system on which the instance was running |
|
|
|
|
How information from this instance was used by the ADDM task. A value of ANALYZED means that the instance participated fully in the analysis. For the following remaining values, the instance was not used during task execution, for the stated reason: BOUNCED – the instance was shut down or started during the analysis period NO_SNAPS – there were either begin or end snapshots missing for the instance NO_STATS – there were key statistics missing for the instance NOT_FOUND – no mention of this instance could be found in AWR during the analysis period |
|
|
|
|
The database time, in microseconds, accumulated by this instance during the analysis period |
|
|
|
|
The average number of active sessions for the instance during the analysis period |
|
|
|
|
The percentage of active sessions for this instance, out of the total active sessions for the task |
|
|
|
|
Reserved for future use |
|
|
|
|
The ID of a local ADDM task that contained an analysis of the instance for the same analysis period as that of the main task. If the main task is a local ADDM, then this value is the same as the |
See Also:
“USER_ADDM_INSTANCES”
