AW: Distinct, Active user count
- From: Petr Novak <Petr.Novak@xxxxxxxxxxxx>
- To: "malakshinovss@xxxxxxxxx" <malakshinovss@xxxxxxxxx>, "denise@xxxxxxxxxxxxxx" <denise@xxxxxxxxxxxxxx>
- Date: Tue, 12 Feb 2013 12:22:37 +0000
Hallo Denise,
I am not sure, what you mean with 'active user count'. If you need to look on
DB load (number of active sessions), then Sayans statement will help you. If
you need to check, how many users were logged in , you can check
DBA_HIST_SYSSTAT, statistics 'logons current' , which includes also background
processes (equals select count(*) from v$session).
Best Regards,
Petr
________________________________________
Von: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx]" im
Auftrag von "Sayan Sergeevich Malakshinov [malakshinovss@xxxxxxxxx]
Gesendet: Dienstag, 12. Februar 2013 13:02
An: denise@xxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Betreff: RE: Distinct, Active user count
You can try to get it from AWR, but i'm not sure that you have all snaps
from Jan 1:
select *
from dba_hist_sysmetric_history
where upper(metric_name) like '%ACTIV%SESS%';
select *
from dba_hist_sysmetric_summary
where upper(metric_name) like '%ACTIV%SESS%';
Best regards,
Sayan Malakshinov
http://orasql.org
--
//www.freelists.org/webpage/oracle-l--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » AW: Distinct, Active user count - Petr Novak
