Re: How to calculate number of sessions per ID
- From: <genegurevich@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 22 Oct 2008 17:05:22 -0500
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@dis
cover.com>
Sent by: To
oracle-l-bounce@f oracle-l@xxxxxxxxxxxxx
reelists.org cc
Subject
10/22/2008 04:41 How to calculate number of sessions
PM per ID
Please respond to
genegurevich@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.
--
//www.freelists.org/webpage/oracle-l
Please consider the environment before printing this email.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
