AW: Distinct, Active user count
From: Petr Novak <Petr.Novak_at_trivadis.com>
Date: Tue, 12 Feb 2013 12:22:37 +0000
Message-ID: <09011014EB621E4CBC2536B62A1B64075AD6CFAB_at_smxc002.trivadis.com>
Hallo Denise,
Von: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org]" im Auftrag von "Sayan Sergeevich Malakshinov [malakshinovss_at_psbank.ru] Gesendet: Dienstag, 12. Februar 2013 13:02 An: denise_at_mail.wvnet.edu
Cc: oracle-l_at_freelists.org
Betreff: RE: Distinct, Active user count
Date: Tue, 12 Feb 2013 12:22:37 +0000
Message-ID: <09011014EB621E4CBC2536B62A1B64075AD6CFAB_at_smxc002.trivadis.com>
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_at_freelists.org [oracle-l-bounce_at_freelists.org]" im Auftrag von "Sayan Sergeevich Malakshinov [malakshinovss_at_psbank.ru] Gesendet: Dienstag, 12. Februar 2013 13:02 An: denise_at_mail.wvnet.edu
Cc: oracle-l_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-l-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 12 2013 - 13:22:37 CET