Enterprise Manager Generic (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center