| SQL Id | SQL Text |
|---|
| 089dbukv1aanh | SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL |
| 0v3dvmc22qnam | insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time) |
| 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') |
| 104rt8usunwtx | SELECT SUM(DECODE(CACHE_NAME, 'DEFAULT', CACHE_SIZE, 0)) DEFAULT_CACHE, SUM(DECODE(CACHE_NAME, 'KEEP', CACHE_SIZE, 0)) KEEP_CACHE, SUM(DECODE(CACHE_NAME, 'RECYCLE', CACHE_SIZE, 0)) RECYCLE_CACHE FROM( SELECT DECODE(S.CACHEHINT, 0, 'DEFAULT', 1, 'KEEP', 2, 'RECYCLE', NULL) CACHE_NAME, COUNT(*) * BUF.BLOCK_SIZE / 1048576 CACHE_SIZE FROM SYS.SYS_OBJECTS SO, SYS.SEG$ S, V$BH BH, V$BUFFER_POOL BUF, SYS.TS$ TS WHERE S.FILE# = SO.HEADER_FILE AND S.BLOCK# = SO.HEADER_BLOCK AND S.TYPE# = SO.SEGMENT_TYPE_ID AND SO.OBJECT_ID = BH.OBJD AND BUF.NAME = DECODE(S.CACHEHINT, 0, 'DEFAULT', 1, 'KEEP', 2, 'RECYCLE', NULL) AND S.TS# = TS.TS# AND TS.BLOCKSIZE = BUF.BLOCK_SIZE GROUP BY S.CACHEHINT, BUF.BLOCK_SIZE) |
| 1ytruncyx2kdb | BEGIN MGMT_HTTP_SESSION.session_expired(:1); END; |
| 2b064ybzkwf1y | BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END; |
| 39m4sx9k63ba2 | select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece# |
| 3jn6gkhvmjnhy | SELECT NVL("A1"."FST_PAX", 0), NVL("A1"."BUS_PAX", 0), NVL("A1"."ECN_PAX", 0) FROM "V_YUNNAN_FLIGHT_RES_STATUS" "A1" WHERE "A1"."LEG_ID"=:B1 |
| 3ktacv9r56b51 | select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# |
| 43c5ykm1mcp2a | begin dbms_application_info.set_module(:1, :2); dbms_application_info.set_client_info(:3); dbms_session.set_identifier(:4); end; |
| 44mwxbkuxcrsa | SELECT /*+rule*/ S.TABLE_OWNER, S.TABLE_NAME FROM ALL_SYNONYMS S WHERE S.SYNONYM_NAME = :B1 AND S.OWNER = 'PUBLIC' AND ROWNUM = 1 |
| 459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
| 4vs91dcv7u1p6 | insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36) |
| 53saa2zkr6wc3 | select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1 |
| 546bvn1xa05td |
DECLARE Bytez Number; ArchStr CHAR(7); CURSOR TempVLogCursor IS SELECT GROUP# FROM v$log WHERE status = 'CURRENT'; CURSOR GVDBArchLogCursor IS SELECT DECODE(log_mode, 'NOARCHIVELOG', 0, 1) FROM V$DATABASE; BEGIN SELECT COUNT(*) INTO :RedoLogGroupCount FROM V$LOG; OPEN TempVLogCursor; FETCH TempVLogCursor INTO :RedoLogGroupCurrent; CLOSE TempVLogCursor; SELECT ROUND(SUM(BYTES)/1048576) INTO :RedoLogGroupMegs FROM V$LOG; SELECT ROUND(SUM(BYTES)/1048576) INTO Bytez FROM V$LOG WHERE status ='CURRENT'; :RedoLogGroupPercentActive := (Bytez / :RedoLogGroupMegs) * 100; SELECT COUNT(*) INTO :ArchCnt FROM V$ARCHIVE_PROCESSES WHERE status = 'ACTIVE'; OPEN GVDBArchLogCursor; FETCH GVDBArchLogCursor INTO :LogMode; CLOSE GVDBArchLogCursor; SELECT COUNT(*) INTO :LogSwitchesPastHour FROM V$LOG_HISTORY WHERE sysdate-first_time <= 1/24; SELECT COUNT(*) INTO :LogSwitchesPastDay FROM V$LOG_HISTORY WHERE sysdate-first_time <= 1.0; SELECT COUNT(*) INTO :Data_FilesTablespaces FROM DBA_TABLESPACES; SELECT COUNT(*) INTO :DBA_Data_Files FROM DBA_DATA_FILES; SELECT COUNT(*) INTO :DBA_TempFiles FROM DBA_TEMP_FILES; SELECT ROUND(SUM(BYTES)/1048576) INTO :DBA_Data_Files_Megs FROM DBA_DATA_FILES; SELECT ROUND(SUM(BYTES)/1048576) INTO :DBA_Tmp_Data_Files_Megs FROM DBA_TEMP_FILES; SELECT ROUND(SUM(BYTES)/1048576) INTO :DBA_Segments FROM DBA_SEGMENTS; SELECT SUM(DECODE(VALUE, 'TRUE', 1, 0)) INTO :AsyncIO FROM V$PARAMETER WHERE name = 'disk_asynch_io'; END;
|
| 5sgs7q9pjnzg5 | SELECT table_name, table_owner FROM ALL_SYNONYMS WHERE owner = 'PUBLIC' AND synonym_name = 'QUEST_COM_TEAM_CODING' |
| 5ur69atw3vfhj | select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1 |
| 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 70j0hkngbx2gb |
select t.LEG_ID, t.TAIL_NO, t.AC_TYPE, t.FLIGHT_NO, t.FLIGHT_NO_DISP, to_char(t.EST_ARR_TIME, 'yyyy-mm-dd hh24:mi') as EST_ARR_TIME, to_char(t.EST_dept_TIME, 'yyyy-mm-dd hh24:mi') as EST_dept_TIME, to_char(t.plan_dept_time, 'yyyy-mm-dd hh24:mi') as plan_dept_time, to_char(t.plan_arr_time, 'yyyy-mm-dd hh24:mi') as plan_arr_time, to_char(t.real_dept_time, 'yyyy-mm-dd hh24:mi') as real_dept_time, to_char(t.real_arr_time, 'yyyy-mm-dd hh24:mi') as real_arr_time, tt.apt_2_zhs as deptairportdisp, ttt.apt_2_zhs as arrairportdisp, t.DEPT_AC_LOC, t.ARR_AC_LOC, t.ARR_AIRPORT, t.DEPT_AIRPORT, to_char(t.PDATE, 'yyyy-mm-dd') as pdate, tttt.agent from foisiw.v_fids_flightleg t, foisiw.v_info_airport_if tt, foisiw.v_info_airport_if ttt, foisiw.v_info_aircraft_if tttt where 1=1 and (t.DEPT_AIRPORT = :1 OR T.ARR_AIRPORT = :2) and to_char(t.EST_DEPT_TIME, 'yyyy-MM-dd') = :3 and to_char(t.EST_DEPT_TIME, 'yyyy-MM-dd') = :4 AND ttt.apt_3_code = t.ARR_AIRPORT AND tt.apt_3_code = t.DEPT_AIRPORT and tttt.TAIL_NO=t.TAIL_NO order by t.TAIL_NO, t.EST_DEPT_TIME
|
| 70v1yfdpypg7p | select * from foisiw.v_yunnan_flight_log where 1 = 1 |
| 7w4y6z1ma4qs0 | select * from t_flightleg_info where CARRIER = 'FM' OR CARRIER = 'MU' OR CARRIER = 'KN' OR CARRIER = 'CK' |
| 9phw0qs6w9rpz |
select this_.LEG_ID as LEG1_7_0_, this_.AC_TYPE as AC2_7_0_, this_.ARR_AC_LOC as ARR3_7_0_, this_.ARR_AGT as ARR4_7_0_, this_.ARR_AIRPORT as ARR5_7_0_, this_.ARR_GATE as ARR6_7_0_, this_.ARR_INF_TIME as ARR7_7_0_, this_.ARR_ROOM as ARR8_7_0_, this_.BGG_UNIT as BGG9_7_0_, this_.BGG_WAIT as BGG10_7_0_, this_.BGG_WEIGHT as BGG11_7_0_, this_.BLOCK_OFF_TIME as BLOCK12_7_0_, this_.BLOCK_ON_TIME as BLOCK13_7_0_, this_.BOARD_BEGIN_TIME as BOARD14_7_0_, this_.BOARD_END_TIME as BOARD15_7_0_, this_.BOARD_PAX as BOARD16_7_0_, this_.CAB_CLOSE_TIME as CAB17_7_0_, this_.CAB_OPEN_TIME as CAB18_7_0_, this_.CAPT_NAME as CAPT19_7_0_, this_.CARGO_LOAD_TIME as CARGO20_7_0_, this_.CARRIER as CARRIER7_0_, this_.CAT_AIRPORT as CAT22_7_0_, this_.CAT_BNS_CLASS as CAT23_7_0_, this_.CAT_ECN_CLASS as CAT24_7_0_, this_.CAT_FLAG as CAT25_7_0_, this_.CAT_FST_CLASS as CAT26_7_0_, this_.CAT_READY_TIME as CAT27_7_0_, this_.CGO_WEIGHT as CGO28_7_0_, this_.CHECK_IN as CHECK29_7_0_, this_.DCS_BNS_ADULT_PAX as DCS30_7_0_, this_.DCS_BNS_CHILD_PAX as DCS31_7_0_, this_.DCS_BNS_INFANT_PAX as DCS32_7_0_, this_.DCS_BNS_PAX as DCS33_7_0_, this_.DCS_CLOSE_TIME as DCS34_7_0_, this_.DCS_ECN_ADULT_PAX as DCS35_7_0_, this_.DCS_ECN_CHILD_PAX as DCS36_7_0_, this_.DCS_ECN_INFANT_PAX as DCS37_7_0_, this_.DCS_ECN_PAX as DCS38_7_0_, this_.DCS_FST_ADULT_PAX as DCS39_7_0_, this_.DCS_FST_CHILD_PAX as DCS40_7_0_, this_.DCS_FST_INFANT_PAX as DCS41_7_0_, this_.DCS_FST_PAX as DCS42_7_0_, this_.DCS
_PAX as DCS43_7_0_, this_.DELETE_FLAG as DELETE44_7_0_, this_.DEPT_AC_LOC as DEPT45_7_0_, this_.DEPT_AGT as DEPT46_7_0_, this_.DEPT_AIRPORT as DEPT47_7_0_, this_.DEPT_GATE as DEPT48_7_0_, this_.DEPT_INF_TIME as DEPT49_7_0_, this_.EST_ARR_TIME as EST50_7_0_, this_.EST_DEPT_TIME as EST51_7_0_, this_.FLIGHT_NO as FLIGHT52_7_0_, this_.FLIGHT_NO_DISP as FLIGHT53_7_0_, this_.FLT_PROP as FLT54_7_0_, this_.FPL_FLIGHT_TIME as FPL55_7_0_, this_.INF_TIME as INF56_7_0_, this_.INT_OR_DOM as INT57_7_0_, this_.MAIL_WEIGHT as MAIL58_7_0_, this_.OIL_FILL_TIME as OIL59_7_0_, this_.PDATE as PDATE7_0_, this_.PASSBY_PAX as PASSBY61_7_0_, this_.PLAN_ARR_TIME as PLAN62_7_0_, this_.PLAN_DEPT_TIME as PLAN63_7_0_, this_.PUSER as PUSER7_0_, this_.REAL_ARR_TIME as REAL65_7_0_, this_.REAL_DEPT_TIME as REAL66_7_0_, this_.REMARK as REMARK7_0_, this_.REMARK_TIME as REMARK68_7_0_, this_.RES_BNS_ADULT_PAX as RES69_7_0_, this_.RES_BNS_CHILD_PAX as RES70_7_0_, this_.RES_BNS_INFANT_PAX as RES71_7_0_, this_.RES_BNS_PAX as RES72_7_0_, this_.RES_ECN_ADULT_PAX as RES73_7_0_, this_.RES_ECN_CHILD_PAX as RES74_7_0_, this_.RES_ECN_INFANT_PAX as RES75_7_0_, this_.RES_ECN_PAX as RES76_7_0_, this_.RES_FST_ADULT_PAX as RES77_7_0_, this_.RES_FST_CHILD_PAX as RES78_7_0_, this_.RES_FST_INFANT_PAX as RES79_7_0_, this_.RES_FST_PAX as RES80_7_0_, this_.RES_PAX as RES81_7_0_, this_.SPCCAT_FLAG as SPCCAT82_7_0_, this_.SPCSVC_FLAG as SPCSVC83_7_0_, this_.SPCSVC_TIME as SPCSVC84_7_0_, this_.T
AIL_NO as TAIL85_7_0_, this_.TIME_STAMP as TIME86_7_0_, this_.TOTAL_WEIGHT as TOTAL87_7_0_, this_.VIPSVC_FLAG as VIPSVC88_7_0_, this_.VIPSVC_TIME as VIPSVC89_7_0_, this_.WAIT_ROOM as WAIT90_7_0_, this_.WEEKDAY as WEEKDAY7_0_ from foisiw.v_fids_flightleg this_ where this_.PLAN_DEPT_TIME>=:1 and this_.PLAN_DEPT_TIME<:2 and ((this_.CARRIER=:3 or this_.CARRIER=:4) or this_.CARRIER=:5) and this_.DELETE_FLAG=:6 |
| 9tgj4g8y4rwy8 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
| a4ct9tx8f9d4a | begin execute immediate 'alter session set NLS_NUMERIC_CHARACTERS = ''., '''; end; |
| asvzxj61dc5vs | select timestamp, flags from fixed_obj$ where obj#=:1 |
| awt5yyntr9hcd |
DECLARE CURSOR VParamCur IS SELECT name, value FROM V$PARAMETER WHERE name IN ('sessions', 'mts_max_dispatchers', 'parallel_max_servers', 'mts_max_servers', 'processes'); CURSOR SessInfoCur IS SELECT a.active, b.lockwait, c.used, d.shared, e.dedicated FROM (SELECT COUNT(*) active FROM v$session WHERE username IS NOT NULL AND type = 'USER' AND status = 'ACTIVE') a, (SELECT COUNT(*) lockwait FROM v$session WHERE username IS NOT NULL AND type = 'USER' AND lockwait IS NOT NULL) b, (SELECT COUNT(*) used FROM v$session WHERE username IS NOT NULL AND type = 'USER') c, (SELECT COUNT(*) shared FROM v$session WHERE username IS NOT NULL AND type = 'USER' AND server IN ('NONE', 'SHARED')) d, (SELECT COUNT(*) dedicated FROM v$session WHERE username IS NOT NULL AND type = 'USER' AND server = 'DEDICATED') e; SessInfoCur_rec SessInfoCur%ROWTYPE; CURSOR ProcInfoCur IS SELECT a.background, b.used, c.pgaused, c.pgaalloc, c.pgamax FROM (SELECT COUNT(*) background FROM v$process WHERE serial# != 0 AND program != 'PSEUDO' AND background = 1) a, (SELECT COUNT(*) used FROM v$process WHERE serial# != 0 AND program != 'PSEUDO') b, (SELECT ROUND(SUM(PGA_USED_MEM)/1048576) pgaused, ROUND(SUM(PGA_ALLOC_MEM)/1048576) pgaalloc, ROUND(SUM(PGA_MAX_MEM)/1048576) pgamax FROM v$process WHERE serial# != 0 AND program != 'PSEUDO') c; ProcInfoCur_rec ProcInfoCur%ROWTYPE; BEGIN FOR VParamCur_Rec IN VParamCur LOOP IF VParamCur_Rec.Name = 'sessions
' THEN :SessionsMax := VParamCur_Rec.Value; ELSIF VParamCur_Rec.Name = 'mts_max_dispatchers' THEN :ProcessesDispatchersMax := VParamCur_Rec.Value; ELSIF VParamCur_Rec.Name = 'processes' THEN :ProcessesMax := VParamCur_Rec.Value; ELSIF VParamCur_Rec.Name = 'parallel_max_servers' THEN :ProcessesParallelMax := VParamCur_Rec.Value; ELSIF VParamCur_Rec.Name = 'mts_max_servers' THEN :ProcessesSharedMax := VParamCur_Rec.Value; END IF; END LOOP; OPEN SessInfoCur; FETCH SessInfoCur INTO SessInfoCur_rec; :SessionsActive := SessInfoCur_rec.active; :SessionsLockWait := SessInfoCur_rec.lockwait; :SessionsUsed := SessInfoCur_rec.used; :ProcessesShared := SessInfoCur_rec.shared; :ProcessesDedicated := SessInfoCur_rec.dedicated; CLOSE SessInfoCur; OPEN ProcInfoCur; FETCH ProcInfoCur INTO ProcInfoCur_rec; :ProcessesUsed := ProcInfoCur_rec.Used; :ProcessesBackground := ProcInfoCur_rec.Background; :pgaused := ProcInfoCur_rec.pgaused; :pgaalloc := ProcInfoCur_rec.pgaalloc; :pgamax := ProcInfoCur_rec.pgamax; CLOSE ProcInfoCur; SELECT COUNT(*) INTO :ProcessesParallel FROM V$PQ_SLAVE; SELECT ROUND(SUM(db_block_gets)) INTO :BlockGets FROM V$BUFFER_POOL_STATISTICS; SELECT ROUND(SUM(db_block_change)) INTO :BlockMods FROM V$BUFFER_POOL_STATISTICS; SELECT ROUND(SUM(DECODE(name, 'sorts (memory)', value, 0))/(SUM(DECODE(name, 'sorts (memory)', value, 0))+SUM(DECODE(name, 'sorts (disk)', value, 0)))*100) INTO :EffP
ercentMemSorts FROM V$SYSSTAT WHERE name IN ('sorts (memory)', 'sorts (disk)'); SELECT ROUND(100-SUM(DECODE(name, 'table scans (long tables)', value, 0))/(SUM(DECODE(name, 'table scans (long tables)', value, 0))+SUM(DECODE(name, 'table scans (short tables)', value, 0)))*100) INTO :EffPercentIdxUsage FROM V$SYSSTAT WHERE (name IN ('table scans (long tables)', 'table scans (short tables)')); SELECT COUNT(*) INTO :ProcessesDispatchers FROM v$dispatcher; END; |
| b1j3urgvujytx | SELECT ROUND(SUM(BYTES)/1048576) FROM DBA_SEGMENTS |
| bc7gjv3ppdtbz | BEGIN dbms_workload_repository.create_snapshot(); END;
|
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| cvn54b7yz0s8u | select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# |
| d281b51jh0p3h | select t.leg_id, t.pdate, t.flight_no, t.flight_no_disp, t.ac_type, t.carrier, t.tail_no, t.vipsvc_flag, t.cab_close_time, t.dept_airport, t.plan_dept_time, t.est_dept_time, t.real_dept_time, t.dept_ac_loc, t.dept_agt, t.arr_airport, t.plan_arr_time, t.est_arr_time, t.real_arr_time, t.arr_ac_loc, t.arr_agt, t.flt_prop, t.int_or_dom from t_flightleg t where (t.arr_airport=:Code or t.dept_airport=:Code) and to_char(t.pdate, 'yyyyMMdd')=:Destime |
| dcstr36r0vz0d | select procedure#, procedurename, properties, itypeobj# from procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc |
| f2u44zuujgu4g | SELECT "A1"."ABN_REASON_1", "A1"."AOC_REASON", "A1"."PDESC" FROM "V_YUNNAN_FLIGHT_ABNORMAL" "A1" WHERE "A1"."LEG_ID"=:B1 |
| f711myt0q6cma | insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22) |
| fdjtrdaz8hpvg |
INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.
flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null),
decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y') |
| fqpxdvgvd96y3 | SELECT "ID", "PDATE", "CARRIER", "FLIGHT_NO", "FLIGHT_NO_FIX", "STATUS", "FLT_PROP", "INTL_FLAG", "AC_TYPE", "TAIL_NO", "AGENT_PLAN", "AGENT", "DEPT_AIRPORT", "STD", "ETD", "ATD", "BLOCKOFF", "CABIN_CLOSE", "CARGO_CLOSE", "DEPT_AC_POS", "DEPT_GATE", "DEPT_TERMINAL", "CHECKIN", "VIP_FLAG", "SERV_FLAG", "DANGER_FLAG", "FST_PAX_RES", "BUS_PAX_RES", "ECN_PAX_RES", "FST_PAX_DCS", "BUS_PAX_DCS", "ECN_PAX_DCS", "FST_PAX_LDM", "BUS_PAX_LDM", "ECN_PAX_LDM", "BAG_PC_LDM", "BAG_WT_LDM", "CGO_WT_LDM", "MAIL_WT_LDM", "ARR_AIRPORT", "STA", "ETA", "ATA", "BLOCKON", "CABIN_OPEN", "CARGO_OPEN", "ARR_AC_POS", "ARR_GATE", "ARR_TERMINAL", "BAG_CLAIM", "TIME_STAMP", "PDESC" FROM "V_HCC_FLIGHT_LEG" "B" WHERE :1="ID" |
| ga9j9xk5cy9s0 | select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece# |
| gp7z55pfh6tvs |
DECLARE CURSOR RedoLogBufferCur IS SELECT UPPER(name) name, ROUND(value) value FROM v$sysstat WHERE UPPER(name) in ('REDO BUFFER ALLOCATION RETRIES', 'REDO LOG SPACE WAIT TIME'); CURSOR VParamCur IS SELECT name, value FROM V$PARAMETER WHERE name IN ('pre_page_sga', 'cursor_space_for_time', 'session_cached_cursors'); CURSOR VSGAStatCur IS SELECT pool, ROUND(SUM(BYTES)/1048576) value FROM V$SGASTAT WHERE pool IN ('java pool', 'large pool', 'shared pool') GROUP BY pool; CURSOR BufCacheUsed IS SELECT SUM(DECODE(CACHE_NAME, 'DEFAULT', CACHE_SIZE, 0)) DEFAULT_cache, SUM(DECODE(CACHE_NAME, 'KEEP', CACHE_SIZE, 0)) keep_cache, SUM(DECODE(CACHE_NAME, 'RECYCLE', CACHE_SIZE, 0)) recycle_cache FROM( SELECT DECODE(s.cachehint, 0, 'DEFAULT', 1, 'KEEP', 2, 'RECYCLE', NULL) CACHE_name, COUNT(*) * buf.block_size / 1048576 cache_SIZE FROM sys.SYS_OBJECTS so, sys.seg$ s, V$BH bh, v$buffer_pool buf, sys.ts$ ts WHERE s.FILE# = so.header_file AND s.BLOCK# = so.header_block AND s.TYPE# = so.segment_type_id AND so.object_id = bh.objd AND buf.name = DECODE(s.cachehint, 0, 'DEFAULT', 1, 'KEEP', 2, 'RECYCLE', NULL) AND s.ts# = ts.ts# AND ts.BLOCKSIZE = buf.block_size GROUP BY s.cachehint, buf.block_size); BufCacheUsed_Rec BufCacheUsed%ROWTYPE; CURSOR CacheMaxCur IS SELECT SUM(DECODE(name, 'DEFAULT', current_size, 0)) Default_CacheMax, SUM(DECODE(name, 'KEEP', current_size, 0)) Keep_Cac
heMax, SUM(DECODE(name, 'RECYCLE', current_size, 0)) Recycle_CacheMax FROM (SELECT name, SUM(current_size) current_size FROM v$buffer_pool GROUP BY name); CacheMaxCur_Rec CacheMaxCur%ROWTYPE; CURSOR SharedPoolCur IS SELECT UPPER(name) name, round(sum(bytes)/1048576) value FROM V$SGASTAT WHERE UPPER(pool) = 'SHARED POOL' AND UPPER(name) IN ('DICTIONARY CACHE', 'FREE MEMORY', 'LIBRARY CACHE', 'SQL AREA') GROUP BY name; CURSOR BufCacheHit IS SELECT SUM(DECODE(NAME, 'DEFAULT', ratio, 0)) Default_CacheHit, SUM(DECODE(NAME, 'KEEP', ratio, 0)) Keep_CacheHit, SUM(DECODE(NAME, 'RECYCLE', ratio, 0)) Recycle_CacheHit FROM(select 'DEFAULT' name, 1 - (physical_reads / (consistent_gets + block_gets)) ratio from (select sum(consistent_gets) consistent_gets, sum(physical_reads) physical_reads, sum(block_gets) block_gets from (SELECT 0 consistent_gets, 0 physical_reads, VALUE block_gets From V$Sysstat Where Name = 'db block gets from cache' Union All Select Value, 0, 0 From V$Sysstat Where Name = 'consistent gets from cache' Union All Select 0, Value, 0 From V$Sysstat Where Name = 'physical reads cache')) UNION ALL SELECT 'KEEP' NAME, DECO
DE(DB_BLOCK_GETS + CONSISTENT_GETS, 0, 0, ROUND((1-(PHYSICAL_READS/(DB_BLOCK_GETS+CONSISTENT_GETS)))*100)) RATIO FROM V$BUFFER_POOL_STATISTICS WHERE NAME='KEEP' UNION ALL SELECT 'RECYCLE' NAME, DECODE(DB_BLOCK_GETS + CONSISTENT_GETS, 0, 0, ROUND((1-(PHYSICAL_READS/(DB_BLOCK_GETS+CONSISTENT_GETS)))*100)) RATIO FROM V$BUFFER_POOL_STATISTICS WHERE NAME='RECYCLE'); BufCacheHit_Rec BufCacheHit%ROWTYPE; BEGIN FOR VParamCur_Rec IN VParamCur LOOP IF VParamCur_Rec.Name = 'pre_page_sga' THEN IF (VParamCur_Rec.Value = 'TRUE') THEN :SGAPrePaged := 1; ELSE :SGAPrePaged := 0; END IF; ELSIF VParamCur_Rec.Name = 'cursor_space_for_time' THEN IF (VParamCur_Rec.Value = 'TRUE') THEN :SGACursorSpaceForTime := 1; ELSE :SGACursorSpaceForTime := 0; END IF; ELSIF VParamCur_Rec.Name = 'session_cached_cursors' THEN IF (VParamCur_Rec.Value <> '0') THEN :SGASessionCachedCursors := 1; ELSE :SGASessionCachedCursors := 0; END IF; END IF; END LOOP; FOR VSGAStatCur_Rec IN VSGAStatCur LOOP IF VSGAStatCur_Rec.Pool = 'java pool' THEN :JavaPoolMegs := VSGAStatCur_Rec.Value; ELSIF VSGAStatCur_Rec.Pool = 'large pool' THEN :LargePoolMegs := VSGAStatCur_Rec.Value; ELSIF VSGAStatCur_Rec.Pool = 'shared pool' THEN :SharedPoolOverallMegs := VSGAStatCur_Rec.Value; END IF; END LOOP; IF :LargePoolMegs <> 0 THEN SELECT ROUND(SUM(VALUE)/1048576) INTO :LargePoolLowUsed FROM V$SESSTAT, V$STATNAME WHERE N
AME = 'session uga memory' AND V$SESSTAT.STATISTIC# = V$STATNAME.STATISTIC#; SELECT ROUND(SUM(VALUE)/1048576) INTO :LargePoolHiUsed FROM V$SESSTAT, V$STATNAME WHERE NAME = 'session uga memory max' AND V$SESSTAT.STATISTIC# = V$STATNAME.STATISTIC#; END IF; SELECT ROUND(SUM(value)/1048576) INTO :SGATotal FROM V$SGA; SELECT SUM(DECODE(value, 'TRUE', 1, 0)) INTO :SGALocked FROM V$PARAMETER WHERE name = 'lock_sga'; OPEN BufCacheUsed; FETCH BufCacheUsed INTO BufCacheUsed_Rec; :default_cacheUsed := BufCacheUsed_Rec.DEFAULT_cache; :keep_cacheUsed := BufCacheUsed_Rec.keep_cache; :recycle_cacheUsed := BufCacheUsed_Rec.recycle_cache; CLOSE BufCacheUsed; OPEN CacheMaxCur; FETCH CacheMaxCur INTO CacheMaxCur_Rec; :Default_CacheMax := CacheMaxCur_Rec.Default_CacheMax; :Recycle_CacheMax := CacheMaxCur_Rec.Recycle_CacheMax; :Keep_CacheMax := CacheMaxCur_Rec.Keep_CacheMax; CLOSE CacheMaxCur; SELECT ROUND((1-((phy_reads-phy_direct)/(blk_gets+con_gets-phy_direct)))*100) INTO :DBBuffCacheOverallHit FROM (Select sum(decode(name, 'db block gets', value, 0)) blk_gets, sum(decode(name, 'consistent gets', value, 0)) con_gets, sum(decode(name, 'physical reads', value, 0)) phy_reads, sum(decode(name, 'db block gets', 0, 'consistent gets', 0, 'physical reads', 0, value)) phy_direct FROM v$sysstat WHERE (name in ('db block gets', 'consistent gets', 'physical reads') or name like ('physical reads direct%'))) q; OPEN B
ufCacheHit; FETCH BufCacheHit INTO BufCacheHit_Rec; :Default_CacheHit := BufCacheHit_Rec.Default_CacheHit; :Recycle_CacheHit := BufCacheHit_Rec.Recycle_CacheHit; :Keep_CacheHit := BufCacheHit_Rec.Keep_CacheHit; CLOSE BufCacheHit; FOR SharedPoolCur_Rec IN SharedPoolCur LOOP IF SharedPoolCur_Rec.Name = 'DICTIONARY CACHE' THEN :SharedPoolDictCacheMegs := SharedPoolCur_Rec.Value; ELSIF SharedPoolCur_Rec.Name = 'FREE MEMORY' THEN :SharedPoolFreeMegs := SharedPoolCur_Rec.Value; ELSIF SharedPoolCur_Rec.Name = 'LIBRARY CACHE' THEN :SharedPoolLibCacheMegs := SharedPoolCur_Rec.Value; ELSIF SharedPoolCur_Rec.Name = 'SQL AREA' THEN :SharedPoolSQLAreaMegs := SharedPoolCur_Rec.Value; END IF; END LOOP; SELECT ROUND(SUM(GETS-GETMISSES-FIXED)/SUM(GETS)*100) INTO :SharedPoolDictCacheHit FROM V$ROWCACHE; SELECT ROUND(SUM(LC_INUSE_MEMORY_SIZE)) INTO :SharedPoolLibCacheUsed FROM v$library_cache_memory; SELECT ROUND(SUM(pinhits)/SUM(pins)*100) INTO :SharedPoolLibCacheHit FROM v$librarycache; SELECT ROUND(SUM(BYTES)/1048576) INTO :SharedPoolMiscMegs FROM v$sgastat WHERE UPPER(pool) ='SHARED POOL' AND UPPER(name) NOT IN ('LIBRARY CACHE', 'DICTIONARY CACHE', 'FREE MEMORY', 'SQL AREA'); FOR RedoLogBufferCur_Rec IN RedoLogBufferCur LOOP IF RedoLogBufferCur_Rec.Name = 'REDO BUFFER ALLOCATION RETRIES' THEN :RedoLogBufferRetries := RedoLogBufferCur_Rec.Value; ELSIF RedoLogBufferCur_Rec.Name = 'REDO LOG SPACE WAIT TIME' THEN :Red
oLogBufferWaits := RedoLogBufferCur_Rec.Value; END IF; END LOOP; SELECT ROUND(SUM(BYTES)/1048576) INTO :RedoLogBufferMegs FROM v$sgastat WHERE pool IS NULL AND UPPER(name) = 'LOG_BUFFER'; END; |
| Statistic | Total | per Second | per Trans |
|---|
| Batched IO (bound) vector count | 0 | 0.00 | 0.00 |
| Batched IO (full) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 0 | 0.00 | 0.00 |
| Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
| Batched IO double miss count | 0 | 0.00 | 0.00 |
| Batched IO same unit count | 0 | 0.00 | 0.00 |
| Batched IO single block count | 0 | 0.00 | 0.00 |
| Batched IO slow jump count | 0 | 0.00 | 0.00 |
| Batched IO vector block count | 0 | 0.00 | 0.00 |
| Batched IO vector read count | 0 | 0.00 | 0.00 |
| Block Cleanout Optim referenced | 1 | 0.00 | 0.00 |
| CCursor + sql area evicted | 6 | 0.00 | 0.01 |
| CPU used by this session | 5,677,701 | 1,789.56 | 9,960.88 |
| CPU used when call started | 5,493,589 | 1,731.53 | 9,637.88 |
| CR blocks created | 88 | 0.03 | 0.15 |
| Cached Commit SCN referenced | 1,393 | 0.44 | 2.44 |
| Commit SCN cached | 2 | 0.00 | 0.00 |
| DB time | 27,864,590 | 8,782.66 | 48,885.25 |
| DBWR checkpoint buffers written | 5,611 | 1.77 | 9.84 |
| DBWR checkpoints | 0 | 0.00 | 0.00 |
| DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR transaction table writes | 1,622 | 0.51 | 2.85 |
| DBWR undo block writes | 2,269 | 0.72 | 3.98 |
| HSC Heap Segment Block Changes | 3,586 | 1.13 | 6.29 |
| Heap Segment Array Inserts | 114 | 0.04 | 0.20 |
| Heap Segment Array Updates | 133 | 0.04 | 0.23 |
| IMU CR rollbacks | 127 | 0.04 | 0.22 |
| IMU Flushes | 871 | 0.27 | 1.53 |
| IMU Redo allocation size | 248,372 | 78.28 | 435.74 |
| IMU commits | 487 | 0.15 | 0.85 |
| IMU contention | 0 | 0.00 | 0.00 |
| IMU pool not allocated | 0 | 0.00 | 0.00 |
| IMU recursive-transaction flush | 1 | 0.00 | 0.00 |
| IMU undo allocation size | 1,372,388 | 432.56 | 2,407.70 |
| IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
| LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
| Misses for writing mapping | 0 | 0.00 | 0.00 |
| Number of read IOs issued | 0 | 0.00 | 0.00 |
| RowCR - row contention | 0 | 0.00 | 0.00 |
| RowCR attempts | 55 | 0.02 | 0.10 |
| RowCR hits | 55 | 0.02 | 0.10 |
| SMON posted for undo segment recovery | 15 | 0.00 | 0.03 |
| SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 414,823 | 130.75 | 727.76 |
| SQL*Net roundtrips to/from dblink | 413,245 | 130.25 | 724.99 |
| active txn count during cleanout | 171 | 0.05 | 0.30 |
| application wait time | 78 | 0.02 | 0.14 |
| background checkpoints completed | 0 | 0.00 | 0.00 |
| background checkpoints started | 0 | 0.00 | 0.00 |
| background timeouts | 13,584 | 4.28 | 23.83 |
| branch node splits | 0 | 0.00 | 0.00 |
| buffer is not pinned count | 10,755,523 | 3,390.04 | 18,869.34 |
| buffer is pinned count | 564,395 | 177.89 | 990.17 |
| bytes received via SQL*Net from client | 35,543,678 | 11,203.04 | 62,357.33 |
| bytes received via SQL*Net from dblink | 162,442,844 | 51,200.50 | 284,987.45 |
| bytes sent via SQL*Net to client | 189,696,687 | 59,790.66 | 332,801.21 |
| bytes sent via SQL*Net to dblink | 18,549,436 | 5,846.61 | 32,542.87 |
| calls to get snapshot scn: kcmgss | 228,781 | 72.11 | 401.37 |
| calls to kcmgas | 4,591 | 1.45 | 8.05 |
| calls to kcmgcs | 23,652 | 7.45 | 41.49 |
| cell physical IO interconnect bytes | 238,846,976 | 75,282.38 | 419,029.78 |
| change write time | 32 | 0.01 | 0.06 |
| cleanout - number of ktugct calls | 215 | 0.07 | 0.38 |
| cleanouts and rollbacks - consistent read gets | 0 | 0.00 | 0.00 |
| cleanouts only - consistent read gets | 3 | 0.00 | 0.01 |
| cluster key scan block gets | 3,906,196 | 1,231.20 | 6,852.98 |
| cluster key scans | 3,556,778 | 1,121.06 | 6,239.96 |
| commit batch performed | 136 | 0.04 | 0.24 |
| commit batch requested | 136 | 0.04 | 0.24 |
| commit batch/immediate performed | 158 | 0.05 | 0.28 |
| commit batch/immediate requested | 158 | 0.05 | 0.28 |
| commit cleanout failures: callback failure | 9 | 0.00 | 0.02 |
| commit cleanout failures: cannot pin | 67 | 0.02 | 0.12 |
| commit cleanouts | 4,150 | 1.31 | 7.28 |
| commit cleanouts successfully completed | 4,074 | 1.28 | 7.15 |
| commit immediate performed | 22 | 0.01 | 0.04 |
| commit immediate requested | 22 | 0.01 | 0.04 |
| commit txn count during cleanout | 272 | 0.09 | 0.48 |
| concurrency wait time | 18,397,015 | 5,798.57 | 32,275.46 |
| consistent changes | 175 | 0.06 | 0.31 |
| consistent gets | 21,859,318 | 6,889.86 | 38,349.68 |
| consistent gets - examination | 6,295,854 | 1,984.40 | 11,045.36 |
| consistent gets direct | 1 | 0.00 | 0.00 |
| consistent gets from cache | 21,859,317 | 6,889.86 | 38,349.68 |
| consistent gets from cache (fastpath) | 15,546,658 | 4,900.16 | 27,274.84 |
| cursor authentications | 125 | 0.04 | 0.22 |
| data blocks consistent reads - undo records applied | 164 | 0.05 | 0.29 |
| db block changes | 31,185 | 9.83 | 54.71 |
| db block gets | 44,167 | 13.92 | 77.49 |
| db block gets direct | 647 | 0.20 | 1.14 |
| db block gets from cache | 43,520 | 13.72 | 76.35 |
| db block gets from cache (fastpath) | 4,800 | 1.51 | 8.42 |
| deferred (CURRENT) block cleanout applications | 2,044 | 0.64 | 3.59 |
| dirty buffers inspected | 0 | 0.00 | 0.00 |
| enqueue conversions | 1,226,111 | 386.46 | 2,151.07 |
| enqueue releases | 467,765 | 147.44 | 820.64 |
| enqueue requests | 467,825 | 147.45 | 820.75 |
| enqueue timeouts | 9 | 0.00 | 0.02 |
| enqueue waits | 1 | 0.00 | 0.00 |
| execute count | 221,932 | 69.95 | 389.35 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| file io wait time | 8,216,419 | 2,589.74 | 14,414.77 |
| free buffer inspected | 608 | 0.19 | 1.07 |
| free buffer requested | 1,356 | 0.43 | 2.38 |
| heap block compress | 48 | 0.02 | 0.08 |
| hot buffers moved to head of LRU | 211 | 0.07 | 0.37 |
| immediate (CR) block cleanout applications | 3 | 0.00 | 0.01 |
| immediate (CURRENT) block cleanout applications | 780 | 0.25 | 1.37 |
| index crx upgrade (positioned) | 4,535 | 1.43 | 7.96 |
| index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 12 | 0.00 | 0.02 |
| index fetch by key | 12,543,172 | 3,953.49 | 22,005.56 |
| index scans kdiixs1 | 420,053 | 132.40 | 736.94 |
| leaf node 90-10 splits | 106 | 0.03 | 0.19 |
| leaf node splits | 110 | 0.03 | 0.19 |
| lob reads | 0 | 0.00 | 0.00 |
| lob writes | 18 | 0.01 | 0.03 |
| lob writes unaligned | 18 | 0.01 | 0.03 |
| logons cumulative | 815 | 0.26 | 1.43 |
| max cf enq hold time | 0 | 0.00 | 0.00 |
| messages received | 8,643 | 2.72 | 15.16 |
| messages sent | 8,643 | 2.72 | 15.16 |
| min active SCN optimization applied on CR | 0 | 0.00 | 0.00 |
| no buffer to keep pinned count | 3 | 0.00 | 0.01 |
| no work - consistent read gets | 15,525,103 | 4,893.37 | 27,237.02 |
| non-idle wait count | 9,092,769 | 2,865.96 | 15,952.23 |
| non-idle wait time | 18,494,586 | 5,829.32 | 32,446.64 |
| opened cursors cumulative | 29,947 | 9.44 | 52.54 |
| parse count (describe) | 0 | 0.00 | 0.00 |
| parse count (failures) | 314 | 0.10 | 0.55 |
| parse count (hard) | 715 | 0.23 | 1.25 |
| parse count (total) | 17,836 | 5.62 | 31.29 |
| parse time cpu | 5,638,114 | 1,777.08 | 9,891.43 |
| parse time elapsed | 26,710,631 | 8,418.95 | 46,860.76 |
| physical read IO requests | 261 | 0.08 | 0.46 |
| physical read bytes | 3,334,144 | 1,050.89 | 5,849.38 |
| physical read total IO requests | 8,835 | 2.78 | 15.50 |
| physical read total bytes | 143,649,792 | 45,277.10 | 252,017.18 |
| physical read total multi block requests | 0 | 0.00 | 0.00 |
| physical reads | 407 | 0.13 | 0.71 |
| physical reads cache | 406 | 0.13 | 0.71 |
| physical reads cache prefetch | 146 | 0.05 | 0.26 |
| physical reads direct | 1 | 0.00 | 0.00 |
| physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical reads prefetch warmup | 123 | 0.04 | 0.22 |
| physical write IO requests | 4,271 | 1.35 | 7.49 |
| physical write bytes | 51,265,536 | 16,158.43 | 89,939.54 |
| physical write total IO requests | 10,820 | 3.41 | 18.98 |
| physical write total bytes | 95,197,184 | 30,005.28 | 167,012.60 |
| physical write total multi block requests | 48 | 0.02 | 0.08 |
| physical writes | 6,258 | 1.97 | 10.98 |
| physical writes direct | 647 | 0.20 | 1.14 |
| physical writes direct (lob) | 2 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical writes from cache | 5,611 | 1.77 | 9.84 |
| physical writes non checkpoint | 1,374 | 0.43 | 2.41 |
| pinned buffers inspected | 0 | 0.00 | 0.00 |
| prefetch warmup blocks aged out before use | 9 | 0.00 | 0.02 |
| process last non-idle time | 3,173 | 1.00 | 5.57 |
| recursive calls | 192,981 | 60.83 | 338.56 |
| recursive cpu usage | 5,644,941 | 1,779.23 | 9,903.41 |
| redo blocks checksummed by FG (exclusive) | 8,350 | 2.63 | 14.65 |
| redo blocks written | 20,268 | 6.39 | 35.56 |
| redo buffer allocation retries | 0 | 0.00 | 0.00 |
| redo entries | 19,500 | 6.15 | 34.21 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 631 | 0.20 | 1.11 |
| redo size | 8,631,656 | 2,720.62 | 15,143.26 |
| redo size for direct writes | 1,708 | 0.54 | 3.00 |
| redo subscn max counts | 1,896 | 0.60 | 3.33 |
| redo synch time | 12,001 | 3.78 | 21.05 |
| redo synch writes | 3,995 | 1.26 | 7.01 |
| redo wastage | 1,444,048 | 455.15 | 2,533.42 |
| redo write time | 1,204 | 0.38 | 2.11 |
| redo writes | 4,494 | 1.42 | 7.88 |
| remote Oradebug requests | 92 | 0.03 | 0.16 |
| rollback changes - undo records applied | 14 | 0.00 | 0.02 |
| rollbacks only - consistent read gets | 86 | 0.03 | 0.15 |
| rows fetched via callback | 53,618 | 16.90 | 94.07 |
| session connect time | 31 | 0.01 | 0.05 |
| session cursor cache hits | 17,403 | 5.49 | 30.53 |
| session logical reads | 21,903,485 | 6,903.78 | 38,427.17 |
| shared hash latch upgrades - no wait | 15,261 | 4.81 | 26.77 |
| sorts (memory) | 8,572 | 2.70 | 15.04 |
| sorts (rows) | 54,658 | 17.23 | 95.89 |
| sql area evicted | 301 | 0.09 | 0.53 |
| sql area purged | 2 | 0.00 | 0.00 |
| summed dirty queue length | 0 | 0.00 | 0.00 |
| switch current to new buffer | 224 | 0.07 | 0.39 |
| table fetch by rowid | 589,309 | 185.74 | 1,033.88 |
| table fetch continued row | 481 | 0.15 | 0.84 |
| table scan blocks gotten | 169,968 | 53.57 | 298.19 |
| table scan rows gotten | 1,033,089 | 325.62 | 1,812.44 |
| table scans (direct read) | 0 | 0.00 | 0.00 |
| table scans (long tables) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 3,886 | 1.22 | 6.82 |
| total cf enq hold time | 110 | 0.03 | 0.19 |
| total number of cf enq holders | 6 | 0.00 | 0.01 |
| total number of times SMON posted | 17 | 0.01 | 0.03 |
| transaction rollbacks | 158 | 0.05 | 0.28 |
| undo change vector size | 3,305,268 | 1,041.79 | 5,798.72 |
| user I/O wait time | 230 | 0.07 | 0.40 |
| user calls | 423,407 | 133.45 | 742.82 |
| user commits | 517 | 0.16 | 0.91 |
| user rollbacks | 53 | 0.02 | 0.09 |
| workarea executions - optimal | 3,883 | 1.22 | 6.81 |
| write clones created in foreground | 0 | 0.00 | 0.00 |