Re: How to calculate number of sessions per ID

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.


--
http://www.freelists.org/webpage/oracle-l







Please consider the environment before printing this email.


--
http://www.freelists.org/webpage/oracle-l


Other related posts: