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