## Request Information

Your Workspace : Admin Home : Monitoring : Request Information

### Parameters

> Request Start Time: | Thu Jun 01 10:49:16 2000 (959870956)
> Request Completion Time: | Thu Jun 01 10:49:20 2000 (959870960)
> Request Duration: | 4077 ms
> Method: | GET
> URL: | /intranet/ad-index
> Query: | (empty)

### Headers

> Connection: | Keep-Alive
> User-Agent: | Mozilla/4.61 [en] (X11; U; Linux 2.2.12-20 i686)
> Host: | dev.arsdigita.com
> Accept: | image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, image/png, */*
> Accept-Encoding: | gzip
> Accept-Language: | en
> Accept-Charset: | iso-8859-1,*,utf-8
> Cookie: | last_visit=959374634; ad_browser_id=4608; second_to_last_visit=959269200; ad_user_login=1472%2cISotUu64GyYZUPdBdNVRWMsdVnRaFzwG; ad_session_id=198622%2c1472%2cjbJ4dmbI8QQd5nSSobE%2e9c5H%2fQyOVs1v%2c959870956

### Output Headers

> Set-Cookie: | last_visit=959870956; path=/; expires=Fri, 01-Jan-2010 01:00:00 GMT
> Set-Cookie: | second_to_last_visit=959374634; path=/; expires=Fri, 01-Jan-2010 01:00:00 GMT
> MIME-Version: | 1.0
> Date: | Thu, 01 Jun 2000 14:49:20 GMT
> Server: | AOLserver/3.0+ad2
> Content-Type: | text/html
> Content-Length: | 10715
> Connection: | close

### Database Requests

> Duration | Command
> --- | ---
> 1 ms | gethandle -timeout -1 (returned nsdb0)

> 13 ms

> dml nsdb0 (main pool)

> >     update session_statistics
> >     set session_count = session_count + 1,
> >     repeat_count = repeat_count + 1
> >     where entry_date = trunc(sysdate)

> 124 ms

> dml nsdb0 (main pool)

> >     update users
> >     set last_visit = sysdate,
> >         second_to_last_visit = last_visit,
> >         n_sessions = n_sessions + 1
> >     where user_id = 1472

> 1 ms | releasehandle nsdb0 (main pool)
> 1 ms | gethandle (returned nsdb1)

> 6 ms

> 1row nsdb1 (main pool)

> >     select decode(count(1),0,0,1)
> >                    from user_group_map
> >                   where user_id=1472
> >                     and (group_id=6
> >                          or group_id=1181)

> 1 ms | releasehandle nsdb1 (main pool)
> 1 ms | gethandle (returned nsdb2)

> 10 ms

> 0or1row nsdb2 (main pool)

> >     select group_id
> >     from administration_info
> >     where module = 'intranet'
> >     and submodule is null

> 13 ms

> 1row nsdb2 (main pool)

> >     select count(*) from user_group_map where user_id =1472 and group_id = 2

> 9 ms

> 0or1row nsdb2 (main pool)

> >     select group_id
> >     from administration_info
> >     where module = 'site_wide'
> >     and submodule is null

> 12 ms

> 1row nsdb2 (main pool)

> >     select multi_role_p from user_groups where group_id = 1

> 17 ms

> 1row nsdb2 (main pool)

> >     select decode(count(*), 0, 0, 1) from user_group_map where user_id = 1472 and group_id = 1 and role in ('administrator', 'all')

> 18 ms

> 0or1row nsdb2 (main pool)

> >     select first_names || ' ' || last_name as full_name,
> >                     decode(portrait_upload_date,NULL,0,1) as portrait_exists_p
> >                from users
> >               where user_id=1472

> 1225 ms

> select nsdb2 (main pool)

> >     select ug.group_name, ug.group_id
> >                from user_groups ug, im_projects p
> >               where ad_group_member_p ( 1472, ug.group_id ) = 't'
> >                 and ug.group_id=p.group_id
> >                 and p.project_status_id in (select project_status_id
> >                                               from im_project_status
> >                                              where project_status='Open'
> >                                                 or project_status='Future' )
> >               order by lower(group_name)

> 1 ms | getrow nsdb2 t39 (main pool)
> 2 ms | getrow nsdb2 t39 (main pool)
> 1 ms | getrow nsdb2 t39 (main pool)
> 1 ms | getrow nsdb2 t39 (main pool)
> 1 ms | getrow nsdb2 t39 (main pool)
> 2 ms | getrow nsdb2 t39 (main pool)

> 1578 ms

> select nsdb2 (main pool)

> >     select ug.group_name, ug.group_id
> >                from user_groups ug, im_customers c
> >               where ad_group_member_p ( 1472, ug.group_id ) = 't'
> >                 and ug.group_id=c.group_id
> >                 and c.customer_status_id in (select customer_status_id
> >                                               from im_customer_status
> >                                              where customer_status in ('Current','Inquiries','Creating Bid','Bid out'))
> >               order by lower(group_name)

> 2 ms | getrow nsdb2 t54 (main pool)

> 30 ms

> 1row nsdb2 (main pool)

> >     select sum(hours) from im_hours where user_id=1472
> >         and on_which_table='im_projects'
> >         and day >= sysdate - 7

> 14 ms

> 1row nsdb2 (main pool)

> >     select decode(count(1),0,0,1)
> >                from user_groups ug
> >               where ad_group_member_p ( 1472, ug.group_id ) = 't'
> >                 and ug.short_name='Business'

> 15 ms

> 1row nsdb2 (main pool)

> >     select decode(count(1),0,0,1)
> >                from user_groups ug
> >               where ad_group_member_p ( 1472, ug.group_id ) = 't'
> >                 and ug.short_name='Finance'

> 5 ms

> 1row nsdb2 (main pool)

> >     select sysdate - 30 from dual

> 4 ms

> select nsdb2 (main pool)

> >     select newsgroup_id from newsgroups where scope = 'all_users' or scope = 'registered_users' or (scope = 'group' and group_id = 6)

> 1 ms | getrow nsdb2 t71 (main pool)
> 1 ms | getrow nsdb2 t71 (main pool)
> 1 ms | getrow nsdb2 t71 (main pool)
> 2 ms | getrow nsdb2 t71 (main pool)

> 16 ms

> select nsdb2 (main pool)

> >     select news.title, news.news_item_id, news.approval_state,
> >      expired_p(news.expiration_date) as expired_p,
> >      to_char(news.release_date,'Mon DD, YYYY') as release_date_pretty
> >     from news_items news, users ut
> >     where creation_date > '2000-05-02'
> >     and (newsgroup_id = 1 or newsgroup_id = 2 or newsgroup_id = 4)
> >     and news.approval_state = 'approved'
> >     and release_date < sysdate
> >     and news.creation_user = ut.user_id
> >     order by release_date desc, creation_date desc

> 1 ms | getrow nsdb2 t82 (main pool)
> 2 ms | getrow nsdb2 t82 (main pool)
> 1 ms | getrow nsdb2 t82 (main pool)
> 2 ms | getrow nsdb2 t82 (main pool)
> 2 ms | getrow nsdb2 t82 (main pool)

> 137 ms

> select nsdb2 (main pool)

> >     select g.group_name, g.group_id
> >                    from user_groups g, im_projects p, im_employees_active u, im_project_types
> >                   where p.project_lead_id = u.user_id
> >                     and p.project_type_id = im_project_types.project_type_id
> >                     and p.group_id=g.group_id
> >                     and p.requires_report_p='t'
> >              and u.user_id='1472'
> >              and p.project_status_id = (select project_status_id
> >                                                    from im_project_status
> >                                                   where project_status='Open')
> >              and ( (lower(project_type) not in ('client - full service')
> >                    and not exists  (select 1
> >                                       from general_comments gc
> >                                      where gc.comment_date > sysdate - 7
> >                                        and on_which_table = 'user_groups'
> >                                        and on_what_id = p.group_id)) or (lower(project_type) in ('client - full service')
> >                    and exists (select 1
> >                                  from survsimp_surveys
> >                                 where short_name in ('project_report'))
> >                    and not exists (select 1
> >                                      from survsimp_responses
> >                                     where survey_id=(select survey_id
> >                                                        from survsimp_surveys
> >                                                       where short_name in ('project_report'))
> >                                       and submission_date > sysdate - 7
> >                                       and group_id=p.group_id)) )

> 1 ms | getrow nsdb2 t96 (main pool)
> 2 ms | getrow nsdb2 t96 (main pool)

> 20 ms

> select nsdb2 (main pool)

> >     select distinct u.user_id
> >                from users_active u, user_group_map ugm
> >               where u.user_id = ugm.user_id
> >                 and ugm.group_id = 6
> >                 and u.portrait is not null

> 1 ms | getrow nsdb2 t103 (main pool)
> 3 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 52 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 4 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 3 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 4 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 8 ms | getrow nsdb2 t103 (main pool)
> 16 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 1 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)
> 2 ms | getrow nsdb2 t103 (main pool)

> 33 ms

> 0or1row nsdb2 (main pool)

> >     select u.first_names || ' ' || u.last_name as name, u.bio, u.skills,
> >                         ug.group_name as office, ug.group_id as office_id
> >                    from im_employees_active u, user_groups ug, user_group_map ugm
> >                   where u.user_id = ugm.user_id(+)
> >                     and ug.group_id = ugm.group_id
> >                     and ug.parent_group_id = 5
> >                     and u.user_id = 1678
> >                     and rownum < 2

> 12 ms

> select nsdb2 (main pool)

> >     select ug.group_id, ug.group_name, ai.url as ai_url
> >     from  user_groups ug, administration_info ai
> >     where ug.group_id = ai.group_id
> >     and ad_group_member_p ( 1472, ug.group_id ) = 't'

> 1 ms | getrow nsdb2 t207 (main pool)
> 119 ms | getrow nsdb2 t207 (main pool)
> 1 ms | releasehandle nsdb2 (main pool)
> 1 ms | gethandle log (returned nsdb3)

> 11 ms

> 1row nsdb3 (log pool)

> >     select ad_group_member_p(1472, system_administrator_group_id) from dual

> 1 ms | releasehandle nsdb3 (log pool)
> 3678 ms | (total)

Last Modified: $Id: developer-support-example.html,v 1.1.1.1 2001/04/20 20:51:09 donb Exp $