moin,

mach mal

select* from APEX_WORKSPACE_ACTIVITY_LOG

mit den infos solltest du alles bauen können...


gruss/c

edit

z.b. sowas:
........................................
select
application_id,
page_id,
count(*) as hits,
min(elapsed_time) as min,
avg(elapsed_time) as avg,
max(elapsed_time) as max
from
apex_workspace_activity_log
group by
application_id, page_id

........................................

oder sowas:

select
application_id app_id,
to_char(view_date,'YYYY.MM.DD HH24') hour,
count(*) page_views,
sum(rows_queried) report_rows,
count(distinct(application_id||'.'||page_id)) pages,
sum(elapsed_time) elapsed_time,
avg(elapsed_time) avg_elapsed_time,
count(distinct apex_session_id) sessions,
count(distinct apex_user) distinct_users,
sum(decode(page_view_mode,'R',1,0)) pages_from_cache,
sum(regions_from_cache) regions_from_cache,
count(distinct to_char(view_date,'YYYYMMDDHH24MI')) distinct_minutes
from
apex_workspace_activity_log
group by
application_id, to_char(view_date, 'YYYY.MM.DD HH24')





2 mal bearbeitet. Zuletzt am .