Re: How to calculate number of sessions per ID
Date: Wed, 22 Oct 2008 17:05:22 -0500
Message-ID: <OFD455CE89.C8D86A2A-ON862574EA.0079407A-862574EA.00795908@discover.com>
Thought I would add to my initial post:
Would the following query give me correct number of sessions opened by ID 74 over the course of Oct 20th?
select count(distinct session_id) from DBA_HIST_ACTIVE_SESS_HISTORY
where user_id = 74 and sample_time >= to_date('10-20-2008','mm-dd-yyyy') and sample_time < to_date('10-21-2008','mm-dd-yyyy')
thank you
Gene Gurevich
<genegurevich_at_dis cover.com> Sent by: To oracle-l-bounce_at_f oracle-l_at_freelists.org reelists.org cc Subject 10/22/2008 04:41 How to calculate number of sessions PM per ID Please respond to genegurevich_at_disc over.com
Hi everybody:
I am running oracle 10.2.0.3 and I need to calculate the number of sessions
opened by a specific ID
per day. Is DBA_HIST_ACTIVE_SESS_HISTORY view appropriate for that task?
If not, what would
be a better source?
thank you
Gene Gurevich
Please consider the environment before printing this email.
--
http://www.freelists.org/webpage/oracle-l
Please consider the environment before printing this email.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 22 2008 - 17:05:22 CDT