RE: Distinct, Active user count

From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
Date: Tue, 12 Feb 2013 16:02:18 +0400
Message-ID: <OF14D0B284.B81AF5E1-ON44257B10.0041F2F4-44257B10.00424B11_at_psbank.ru>

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

Received on Tue Feb 12 2013 - 13:02:18 CET