ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEF079D2E0530100007F1FF2 DBA Session Type Y select 'Foreground' value, 'User sessions only' description from dual union all select 'Background' value, 'DB internal processes only' description from dual US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 3F659DDC36E034E9E0630100007F3D9B select 100*gash.seconds/xxen_util.zero_to_null(sum(gash.seconds) over (partition by &gash_inst_id 1)) percentage, gash.seconds/gash.total_seconds active_sessions, xxen_util.time(gash.seconds) time, &gash_inst_id gash.seconds, gash.wait_class, &gash_event xxen_util.time(gash.total_seconds) time_window from ( select distinct &gash_inst_id count(*) over (partition by &gash_inst_id gash.wait_class,&gash_event 1) seconds, nvl(gash.wait_class,'ON CPU') wait_class, &gash_event (max(cast(gash.sample_time as date)) over (partition by &gash_inst_id 1)-min(cast(gash.sample_time as date)) over (partition by &gash_inst_id 1))*86400 total_seconds from gv$active_session_history gash where 1=1 ) gash order by &gash_inst_id seconds desc Y US DBA SGA Wait Event Summary (active session history) Wait event and CPU usage summary from the SGA active session history. Enginatics &gash_event &gash_inst_id 1=1 1 10 1=1 gash.sample_time>=:from_time DateTime select xxen_util.client_time(gash.sample_time) from ( select min(gash.sample_time) sample_time from gv$active_session_history gash where gash.session_type='FOREGROUND' and :$flex$.request_id is null and :$flex$.sid_serial is null ) gash US From Time 2 20 1=1 gash.sample_time<:to_time+1/86400 DateTime select xxen_util.client_time(sysdate) from dual where :$flex$.request_id is null and :$flex$.sid_serial is null US To Time 3 30 &gash_inst_id gash.inst_id, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US By Instance 4 40 &gash_event gash.event, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US By Event 5 50 1=1 gash.session_type=upper(:session_type) LOV DBA Session Type 8E2FF36EDEF079D2E0530100007F1FF2 Y select 'Foreground' value, 'User sessions only' description from dual union all select 'Background' value, 'DB internal processes only' description from dual Foreground US Session Type