Backend query for Active session history from Enterprise Manager Cloud Control 13c
Hi,
I am looking for a query which gives the active session history data what we see in the Enterprise manager cloud control 13c.
I am guessing it would be one of the views from "Cloud Control Management Repository"
Views
I am aware of v$active_session_history, dba_active_sess_history but i don't need data from it.
Query should look something like .
SELECT
target_name,
COLLECTION_TIMESTAMP,
metric_column,
"VALUE"
FROM
<view_name>
WHERE
metric_name = 'Average Active Sessions'
AND target_name = '<myDB>'
AND COLLECTION_TIMESTAMP BETWEEN SYSDATE - INTERVAL '1' HOUR AND SYSDATE
Here is the view of the current graph for which i need the backend query.