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:
|
Note:
This view is available starting with Oracle Database 12c Release 1 (12.1.0.2).