Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Oracle's enterprise manager has a metric named "User Logon Time" and will show an alert if that exceeds a certain threshold.

I would like to retrieve the numbers stored for this metrics directly using a SQL query.

However, I cannot find any view where this is stored. I can find "Logons Per Sec", "Logons Per Txn", "Current Logons Count" in the DBA_HIST_SYSMETRIC_SUMMARY view and "logons cumulative" and "logons current" in the DBA_HIST_SYSSTAT view.

The view DBA_HIST_METRIC_NAME also doesn't list any metric of that name.

So where does the Enterprise Manager get that information from?

I'm talking about this alert:

enter image description here

share|improve this question
    
I believe this is measured by the EMAgent. It measures the time difference between attempting to log on to the database and getting the "connected" message. I'm not sure where this data is stored. –  Andrew Brennan Mar 28 at 14:02
    
docs.oracle.com/cd/E11857_01/em.111/e16285/… would be handy. –  Raj Mar 28 at 18:47
    
@Raj: but that doesn't explain where it is stored and in which system view this is available. –  a_horse_with_no_name Mar 28 at 20:36
    
"Logon Per Sec" and "Logon Per Tx" can be found in OEM REPOSITORY (e.g. look in sysman.mgmt$metrics_daily view, the metric_name = 'instance_throughput' and metric_column like 'logons%'). The other metric will also be there, these are maintained in OEM REPO not in individual targets. –  Raj Mar 31 at 12:30
    
@Raj: that's it, thanks a lot. If you add that as an answer, I will accept it –  a_horse_with_no_name Mar 31 at 13:11

1 Answer 1

up vote 1 down vote accepted

"Logon Per Sec" and "Logon Per Tx" can be found in OEM REPOSITORY (e.g. look in sysman.mgmt$metrics_daily view, the metric_name = 'instance_throughput' and metric_column like 'logons%'). The other metric will also be there, these are maintained in OEM REPO not in individual targets.

share|improve this answer
    
The information I was looking for was available using select * from sysman.mgmt$metric_daily where metric_name = 'Response' and metric_column = 'userLogon' –  a_horse_with_no_name Mar 31 at 13:51

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.