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_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