Oracle 视图 V$EMX_USAGE_STATS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$EMX_USAGE_STATS被用来报告Enterprise Manager控制台在数据库中的使用情况。它显示最后一次正常采集，而不是活动采集中的数据。
V$EMX_USAGE_STATS视图包含以下列：
– COLLECTION_ID：这是在正常采集期间运行的收集ID。
– STATS_OCCURS：此收集的记录数。
– STATS_VALUES：此收集的值。
– TARGET_TYPE：此收集的目标类型，可以是数据库，监听，容器等。
– TARGET_NAME：此收集的目标实例名称。
– METRIC_NAME：收集的度量名称。
– METRIC_UNIT：度量的单位名称。
V$EMX_USAGE_STATS视图可以帮助您更深入地了解您在Enterprise Manager控制台上完成的工作和其他统计信息，这有助于更好地优化系统性能。要使用V$EMX_USAGE_STATS视图，您需要执行以下SQL查询：
SELECT * FROM V$EMX_USAGE_STATS;
官方英文解释
V$EMX_USAGE_STATS is used to track how often each report in Oracle Enterprise Manager Database Express (EM Express) is used and how long the EM Express servlet takes to serve these reports to the client.
This view contains statistics such as the number of requests captured in the EM Express servlet for each report, total elapsed time for the EM Express servlet to render each report, as well as a detailed time breakdown including database login time, request initialization time, time to run the SQL query, and time to stream and send the query result back to the client.
All statistics are accumulated over all requests for each EM Express report since the last time the database instance was restarted.
It also includes the timestamp of the last request for each report.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Name of the EM Express report. All EM Express reports are XML reports with this format: %/orarep/component/report |
|
|
|
Number of requests captured by the EM Express servlet for this report since the last time the database instance was restarted |
|
|
|
Accumulated elapsed time for logging into the database across all requests for this report since the last time the database instance was restarted |
|
|
|
Accumulated elapsed time for initializing and preparing requests across all requests for this report since the last time the database instance was restarted |
|
|
|
Accumulated elapsed time for all requests that ran SQL queries for this report since the last time the database instance was restarted |
|
|
|
Accumulated elapsed time for streaming and sending the query result back to the client browser across all requests for this report since the last time the database instance was restarted |
|
|
|
Accumulated total elapsed time across all requests for this report since the last time the database instance was restarted |
|
|
|
Timestamp of the last request for this report since the last time the database instance was restarted |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
