| SQL Id | SQL Text |
|---|
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0pss01dbnfjcp | select posdev0_.DEV_ID as DEV1_37_, posdev0_.DEV_TYPE as DEV2_37_, posdev0_.MID as MID37_, posdev0_.SERIAL_NO as SERIAL4_37_, posdev0_.DEV_STATUS as DEV5_37_, posdev0_.PART_1_NO as PART6_37_, posdev0_.PART_2_NO as PART7_37_, posdev0_.PART_3_NO as PART8_37_, posdev0_.PART_4_NO as PART9_37_, posdev0_.MATCH_ID as MATCH10_37_, posdev0_.IN_DATE as IN11_37_, posdev0_.PROPERTY_INFO as PROPERTY12_37_, posdev0_.DESC_TXT as DESC13_37_, posdev0_.REG_ID as REG14_37_, posdev0_.HJ_STATUS as HJ15_37_, posdev0_.BMS_MID as BMS16_37_ from T_POS_DEV_INFO posdev0_ where posdev0_.DEV_ID='102400023234' |
| 0pt4jfmq9f1q0 | SELECT x.statistic# as stat_id, x.keh_id as keh_id, nvl(awr_time.value_diff, 0) as value_diff FROM X$KEHTIMMAP x , (SELECT startsn.stat_id as stat_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYS_TIME_MODEL startsn , WRH$_SYS_TIME_MODEL endsn WHERE endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid AND startsn.stat_id = endsn.stat_id GROUP BY startsn.stat_id ) awr_time WHERE x.statistic# <> 0 AND x.statistic# = awr_time.stat_id(+) ORDER BY x.keh_id ASC |
| 0tmxsgtshmx66 | select posdev0_.DEV_ID as DEV1_37_, posdev0_.DEV_TYPE as DEV2_37_, posdev0_.MID as MID37_, posdev0_.SERIAL_NO as SERIAL4_37_, posdev0_.DEV_STATUS as DEV5_37_, posdev0_.PART_1_NO as PART6_37_, posdev0_.PART_2_NO as PART7_37_, posdev0_.PART_3_NO as PART8_37_, posdev0_.PART_4_NO as PART9_37_, posdev0_.MATCH_ID as MATCH10_37_, posdev0_.IN_DATE as IN11_37_, posdev0_.PROPERTY_INFO as PROPERTY12_37_, posdev0_.DESC_TXT as DESC13_37_, posdev0_.REG_ID as REG14_37_, posdev0_.HJ_STATUS as HJ15_37_, posdev0_.BMS_MID as BMS16_37_ from T_POS_DEV_INFO posdev0_ where posdev0_.DEV_ID='102400023240' |
| 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') |
| 162cfuftubn16 | select count(*) as col_0_0_ from T_VPOS_INFO vpos0_ where (vpos0_.REG_ID in ('10240004' , '10240003' , '10240006' , '10240005' , '10240002' , '10240001' , '102410' , '102411' , '102412' , '102409' , '102408' , '102407' , '102406' , '102405' , '102404' , '102403' , '102402' , '102401' , '102400')) and vpos0_.STRA_ID<>'null' |
| 271qvs3am94rw | select posdev0_.DEV_ID as DEV1_37_, posdev0_.DEV_TYPE as DEV2_37_, posdev0_.MID as MID37_, posdev0_.SERIAL_NO as SERIAL4_37_, posdev0_.DEV_STATUS as DEV5_37_, posdev0_.PART_1_NO as PART6_37_, posdev0_.PART_2_NO as PART7_37_, posdev0_.PART_3_NO as PART8_37_, posdev0_.PART_4_NO as PART9_37_, posdev0_.MATCH_ID as MATCH10_37_, posdev0_.IN_DATE as IN11_37_, posdev0_.PROPERTY_INFO as PROPERTY12_37_, posdev0_.DESC_TXT as DESC13_37_, posdev0_.REG_ID as REG14_37_, posdev0_.HJ_STATUS as HJ15_37_, posdev0_.BMS_MID as BMS16_37_ from T_POS_DEV_INFO posdev0_ where posdev0_.DEV_ID='102400023246' |
| 32k6typtvh7v8 | insert into T_ONLINE_LINE (TRAN_SEQ, OCCUR_DATE, VPOS_ID, TRAN_TYPE, TRAN_RESULT, COMPLET_DATE, REG_ID, UP_DEV_INFO, UP_TRAN_INFO, UP_APP_INFO, UP_OTHER_INFO, PLUG_DLL_INFO, CALL_NO, DESC_TXT, ERROR_INFO, SERIAL_NO) values (:b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15) |
| 33a3xcupvhrmd | select posdev0_.DEV_ID as DEV1_37_, posdev0_.DEV_TYPE as DEV2_37_, posdev0_.MID as MID37_, posdev0_.SERIAL_NO as SERIAL4_37_, posdev0_.DEV_STATUS as DEV5_37_, posdev0_.PART_1_NO as PART6_37_, posdev0_.PART_2_NO as PART7_37_, posdev0_.PART_3_NO as PART8_37_, posdev0_.PART_4_NO as PART9_37_, posdev0_.MATCH_ID as MATCH10_37_, posdev0_.IN_DATE as IN11_37_, posdev0_.PROPERTY_INFO as PROPERTY12_37_, posdev0_.DESC_TXT as DESC13_37_, posdev0_.REG_ID as REG14_37_, posdev0_.HJ_STATUS as HJ15_37_, posdev0_.BMS_MID as BMS16_37_ from T_POS_DEV_INFO posdev0_ where posdev0_.DEV_ID='102400023242' |
| 3aaj0tandngrm | select posdev0_.DEV_ID as DEV1_37_, posdev0_.DEV_TYPE as DEV2_37_, posdev0_.MID as MID37_, posdev0_.SERIAL_NO as SERIAL4_37_, posdev0_.DEV_STATUS as DEV5_37_, posdev0_.PART_1_NO as PART6_37_, posdev0_.PART_2_NO as PART7_37_, posdev0_.PART_3_NO as PART8_37_, posdev0_.PART_4_NO as PART9_37_, posdev0_.MATCH_ID as MATCH10_37_, posdev0_.IN_DATE as IN11_37_, posdev0_.PROPERTY_INFO as PROPERTY12_37_, posdev0_.DESC_TXT as DESC13_37_, posdev0_.REG_ID as REG14_37_, posdev0_.HJ_STATUS as HJ15_37_, posdev0_.BMS_MID as BMS16_37_ from T_POS_DEV_INFO posdev0_ where posdev0_.DEV_ID='102400023226' |
| 3x6z9gps8xvm7 | select posdev0_.DEV_ID as DEV1_37_, posdev0_.DEV_TYPE as DEV2_37_, posdev0_.MID as MID37_, posdev0_.SERIAL_NO as SERIAL4_37_, posdev0_.DEV_STATUS as DEV5_37_, posdev0_.PART_1_NO as PART6_37_, posdev0_.PART_2_NO as PART7_37_, posdev0_.PART_3_NO as PART8_37_, posdev0_.PART_4_NO as PART9_37_, posdev0_.MATCH_ID as MATCH10_37_, posdev0_.IN_DATE as IN11_37_, posdev0_.PROPERTY_INFO as PROPERTY12_37_, posdev0_.DESC_TXT as DESC13_37_, posdev0_.REG_ID as REG14_37_, posdev0_.HJ_STATUS as HJ15_37_, posdev0_.BMS_MID as BMS16_37_ from T_POS_DEV_INFO posdev0_ where posdev0_.DEV_ID='102400023223' |
| 43j9wjssa57ds | select AD_CONTENT into :b0 from T_POS_ADVERTISING where (((REG_ID=:b1 and MERCH_ID=:b2) and APP_ID=:b3) and (END_TIME is null or TO_DATE(END_TIME, 'YYYY-MM-DD')>=TO_DATE(TO_CHAR(SYSDATE, 'YYYYMMDD'), 'YYYYMMDD'))) |
| 459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
| 4ts0kt0qnf723 | select MERCH_ID , TERM_ID into :b0, :b1 from T_APP_TERMINAL_INFO where (APP_ID=:b2 and VPOS_ID=:b3) |
| 51jjnxkp5myqh | select APP_ID into :b0 from T_RUN_POS_INFO where (VPOS_ID=:b1 and MASTER_FLAG='1') |
| 572fbaj0fdw2b | select output from table(dbms_workload_repository.awr_report_html( :dbid,
:inst_num,
:bid, :eid,
:rpt_options )) |
| 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 |
| 68287pj2gzvp9 | select VALUE_TXT into :b0 from T_SYS_CONF where NAME_TXT='udpMonitorPort' |
| 6qr70q8vv8hga | select DEV_ID , DEV_STATUS , REG_ID , HJ_STATUS , NVL(BMS_MID, ' ') into :b0, :b1, :b2, :b3, :b4 from T_POS_DEV_INFO where (MID=:b5 and SERIAL_NO=:b6) |
| 6w6r3wthy6ntg | select appmerchan0_.MERCH_ID as MERCH1_12_, appmerchan0_.ORIG_ID as ORIG2_12_, appmerchan0_.SUB_ID as SUB3_12_, appmerchan0_.MERCH_NAME as MERCH4_12_, appmerchan0_.MERCH_ATTR as MERCH5_12_, appmerchan0_.MERCH_MCC as MERCH6_12_, appmerchan0_.TRAN_CHANNEL as TRAN7_12_, appmerchan0_.CUSTOM_ID as CUSTOM8_12_, appmerchan0_.PAY_CHANNEL as PAY9_12_, appmerchan0_.TRAN_TYPE as TRAN10_12_, appmerchan0_.CONNECTER as CONNECTER12_, appmerchan0_.CALL_NO as CALL12_12_, appmerchan0_.FAX_NO as FAX13_12_, appmerchan0_.EMAIL_ADDR as EMAIL14_12_, appmerchan0_.MERCH_ADDR as MERCH15_12_, appmerchan0_.POST_CODE as POST16_12_, appmerchan0_.MERCH_STATUS as MERCH17_12_, appmerchan0_.BUSS_TIME as BUSS18_12_, appmerchan0_.DATA_ORIG as DATA19_12_, appmerchan0_.REF_1 as REF20_12_, appmerchan0_.REF_2 as REF21_12_, appmerchan0_.REF_3 as REF22_12_, appmerchan0_.REG_ID as REG23_12_, appmerchan0_.MERCHANTID as MERCHANTID12_, appmerchan0_.SUBMERCHANTNO as SUBMERC25_12_, appmerchan0_.CLOSE_TIME as CLOSE26_12_, appmerchan0_.AREACODE as AREACODE12_ from t_app_merch_info appmerchan0_ where appmerchan0_.ORIG_ID='00010000' and appmerchan0_.MERCH_ID='898211057120008' and appmerchan0_.SUB_ID='001' |
| 6wm3n4d7bnddg |
SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l ,
DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B
Y source ASC, time_secs DESC, log_id ASC |
| 78pfquvjyra0q | select MERCH_ID, TERM_ID, SUB_ID from T_APP_TERMINAL_INFO where VPOS_ID=:1 and APP_ID=:2 |
| 84ac2049ndzdv | select posdev0_.DEV_ID as DEV1_37_, posdev0_.DEV_TYPE as DEV2_37_, posdev0_.MID as MID37_, posdev0_.SERIAL_NO as SERIAL4_37_, posdev0_.DEV_STATUS as DEV5_37_, posdev0_.PART_1_NO as PART6_37_, posdev0_.PART_2_NO as PART7_37_, posdev0_.PART_3_NO as PART8_37_, posdev0_.PART_4_NO as PART9_37_, posdev0_.MATCH_ID as MATCH10_37_, posdev0_.IN_DATE as IN11_37_, posdev0_.PROPERTY_INFO as PROPERTY12_37_, posdev0_.DESC_TXT as DESC13_37_, posdev0_.REG_ID as REG14_37_, posdev0_.HJ_STATUS as HJ15_37_, posdev0_.BMS_MID as BMS16_37_ from T_POS_DEV_INFO posdev0_ where posdev0_.DEV_ID='102400023231' |
| 8nthva2ju06y5 | select APP_PATH , NVL(DECRYPT_TYPE, '-1') , NVL(SEDKEY_INDEX, '-1') , NVL(KEY_TYPE, '-1') , NVL(KEY_VALUES, ' ') , NVL(MISKEY_INDEX, '-1') into :b0, :b1, :b2, :b3, :b4, :b5 from T_BRANCH_INFO where BRANCH_ID like (:b6||'%') |
| 8yc6807gdtsmz | select distinct APP_ID from T_RUN_POS_INFO where VPOS_ID=:1 and MASTER_FLAG='1' |
| 95m2t8zvgddm0 | select posdev0_.DEV_ID as DEV1_37_, posdev0_.DEV_TYPE as DEV2_37_, posdev0_.MID as MID37_, posdev0_.SERIAL_NO as SERIAL4_37_, posdev0_.DEV_STATUS as DEV5_37_, posdev0_.PART_1_NO as PART6_37_, posdev0_.PART_2_NO as PART7_37_, posdev0_.PART_3_NO as PART8_37_, posdev0_.PART_4_NO as PART9_37_, posdev0_.MATCH_ID as MATCH10_37_, posdev0_.IN_DATE as IN11_37_, posdev0_.PROPERTY_INFO as PROPERTY12_37_, posdev0_.DESC_TXT as DESC13_37_, posdev0_.REG_ID as REG14_37_, posdev0_.HJ_STATUS as HJ15_37_, posdev0_.BMS_MID as BMS16_37_ from T_POS_DEV_INFO posdev0_ where posdev0_.DEV_ID='102400023220' |
| 99qa3zyarxvms | insert into plan_table (statement_id, timestamp, operation, options, object_node, object_owner, object_name, object_instance, object_type, search_columns, id, parent_id, position, other, optimizer, cost, cardinality, bytes, other_tag, partition_start, partition_stop, partition_id, distribution, cpu_cost, io_cost, temp_space, access_predicates, filter_predicates, projection, time, qblock_name, object_alias, plan_id, depth, remarks, other_xml ) values(:1, :2, :3, :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) |
| 9vxckr6dw96dj | update T_PLAN_SETUP set DOWN_TYPE='0' where (VPOS_ID=:b0 and PLAN_CODE=:b1) |
| 9zrays8at4zks | SELECT OBJ data_object_id, FILE#, DBABLK, CLASS, STATE, TCH
FROM X$BH
WHERE HLADDR in (select addr from (select addr from v$latch_children order by (gets+misses+sleeps) desc) where rownum<10) order by tch desc |
| a1wjhs2uwd66g | select DLL_DIR , APP_DIR , FID into :b0, :b1, :b2 from T_MODEL_INFO where MID=:b3 |
| awu9y8k2zdr9a |
select * from ( select vpos0_.VPOS_ID as VPOS1_23_, vpos0_.CUSTOM_ID as CUSTOM2_23_, vpos0_.REG_ID as REG3_23_, vpos0_.VPOS_STATUS as VPOS4_23_, vpos0_.AUTH_FLAG as AUTH5_23_, vpos0_.COMPLET_FLAG as COMPLET6_23_, vpos0_.TELE_NO as TELE7_23_, vpos0_.VPOS_ADDR as VPOS8_23_, vpos0_.MID as MID23_, vpos0_.DEV_ID as DEV10_23_, vpos0_.RELATE_FLAG as RELATE11_23_, vpos0_.INPUT_TIME as INPUT12_23_, vpos0_.FIRST_TIME as FIRST13_23_, vpos0_.LAST_SIGN_TIME as LAST14_23_, vpos0_.NEXT_SIGN_TIME as NEXT15_23_, vpos0_.APP_MODEL_ID as APP16_23_, vpos0_.DATA_ORIG as DATA17_23_, vpos0_.INIT_KEY_FLAG as INIT18_23_, vpos0_.STRA_ID as STRA19_23_, vpos0_.LAST_SIGN_END_TIME as LAST20_23_, vpos0_.INTERVAL_DAYS as INTERVAL21_23_, vpos0_.BRANCH_ID as BRANCH22_23_, vpos0_.TERMINALID as TERMINALID23_, vpos0_.AREACODE as AREACODE23_, vpos0_.TASK_ID as TASK25_23_, vpos0_.TASK_TYPE as TASK26_23_, vpos0_.FRTIMES as FRTIMES23_, vpos0_.OLD_DEV_ID as OLD28_23_, vpos0_.STOCK_FLAG as STOCK29_23_, vpos0_.BMS_MID as BMS30_23_, vpos0_.TERM_TYPE as TERM31_23_ from T_VPOS_INFO vpos0_ where vpos0_.REG_ID in ('10240004' , '10240003' , '10240006' , '10240005' , '10240002' , '10240001' , '102410' , '102411' , '102412' , '102409' , '102408' , '102407' , '102406' , '102405' , '102404' , '102403' , '102402' , '102401' , '102400') order by vpos0_.VPOS_ID desc ) where rownum <= :1
|
| ay9ff41hgp8y8 | select VALUE_TXT into :b0 from T_SYS_CONF where NAME_TXT='udpMonitorServerWebURL' |
| azjftvhrknufp | select posdev0_.DEV_ID as DEV1_37_, posdev0_.DEV_TYPE as DEV2_37_, posdev0_.MID as MID37_, posdev0_.SERIAL_NO as SERIAL4_37_, posdev0_.DEV_STATUS as DEV5_37_, posdev0_.PART_1_NO as PART6_37_, posdev0_.PART_2_NO as PART7_37_, posdev0_.PART_3_NO as PART8_37_, posdev0_.PART_4_NO as PART9_37_, posdev0_.MATCH_ID as MATCH10_37_, posdev0_.IN_DATE as IN11_37_, posdev0_.PROPERTY_INFO as PROPERTY12_37_, posdev0_.DESC_TXT as DESC13_37_, posdev0_.REG_ID as REG14_37_, posdev0_.HJ_STATUS as HJ15_37_, posdev0_.BMS_MID as BMS16_37_ from T_POS_DEV_INFO posdev0_ where posdev0_.DEV_ID='102400023238' |
| b00nc19npw9d4 | select posdev0_.DEV_ID as DEV1_37_, posdev0_.DEV_TYPE as DEV2_37_, posdev0_.MID as MID37_, posdev0_.SERIAL_NO as SERIAL4_37_, posdev0_.DEV_STATUS as DEV5_37_, posdev0_.PART_1_NO as PART6_37_, posdev0_.PART_2_NO as PART7_37_, posdev0_.PART_3_NO as PART8_37_, posdev0_.PART_4_NO as PART9_37_, posdev0_.MATCH_ID as MATCH10_37_, posdev0_.IN_DATE as IN11_37_, posdev0_.PROPERTY_INFO as PROPERTY12_37_, posdev0_.DESC_TXT as DESC13_37_, posdev0_.REG_ID as REG14_37_, posdev0_.HJ_STATUS as HJ15_37_, posdev0_.BMS_MID as BMS16_37_ from T_POS_DEV_INFO posdev0_ where posdev0_.DEV_ID='102400023239' |
| b4qw7n9wg64mh |
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#, px_flags , 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 , dbreplay_file_id, dbreplay_call_counter , 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 /*+ PARAM('_module_action_old_length', 0) */:snap_id, :dbid, :instance_number, a.sample_id, a.sample_tim
e , 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.px_flags , 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 , a.dbreplay_file_id, a.dbreplay_call_counter , 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') |
| b8j97hhjppd34 | select PARAM_ID , NVL(PARAM_VALUE, ' ') from T_POS_APP_PARAM b where ((b.VPOS_ID=:b0 and b.APP_ID=:b1) and b.PARAM_ID not in (select PARAM_ID from T_PLAN_POS_APP_PARAM c where ((c.VPOS_ID=:b0 and c.APP_ID=:b1) and PLAN_CODE in (select PLAN_CODE from T_PLAN_SETUP e where (e.VPOS_ID=:b0 and e.PLAN_STATUS='0'))))) union select PARAM_ID , NVL(PARAM_VALUE, ' ') from T_PLAN_POS_APP_PARAM a where ((a.VPOS_ID=:b0 and a.APP_ID=:b1) and PLAN_CODE in (select PLAN_CODE from T_PLAN_SETUP d where (d.VPOS_ID=:b0 and d.PLAN_STATUS='0'))) |
| bunssq950snhf | insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| cwxy8gqqm28rd |
select * from ( select vpos0_.VPOS_ID as VPOS1_23_, vpos0_.CUSTOM_ID as CUSTOM2_23_, vpos0_.REG_ID as REG3_23_, vpos0_.VPOS_STATUS as VPOS4_23_, vpos0_.AUTH_FLAG as AUTH5_23_, vpos0_.COMPLET_FLAG as COMPLET6_23_, vpos0_.TELE_NO as TELE7_23_, vpos0_.VPOS_ADDR as VPOS8_23_, vpos0_.MID as MID23_, vpos0_.DEV_ID as DEV10_23_, vpos0_.RELATE_FLAG as RELATE11_23_, vpos0_.INPUT_TIME as INPUT12_23_, vpos0_.FIRST_TIME as FIRST13_23_, vpos0_.LAST_SIGN_TIME as LAST14_23_, vpos0_.NEXT_SIGN_TIME as NEXT15_23_, vpos0_.APP_MODEL_ID as APP16_23_, vpos0_.DATA_ORIG as DATA17_23_, vpos0_.INIT_KEY_FLAG as INIT18_23_, vpos0_.STRA_ID as STRA19_23_, vpos0_.LAST_SIGN_END_TIME as LAST20_23_, vpos0_.INTERVAL_DAYS as INTERVAL21_23_, vpos0_.BRANCH_ID as BRANCH22_23_, vpos0_.TERMINALID as TERMINALID23_, vpos0_.AREACODE as AREACODE23_, vpos0_.TASK_ID as TASK25_23_, vpos0_.TASK_TYPE as TASK26_23_, vpos0_.FRTIMES as FRTIMES23_, vpos0_.OLD_DEV_ID as OLD28_23_, vpos0_.STOCK_FLAG as STOCK29_23_, vpos0_.BMS_MID as BMS30_23_, vpos0_.TERM_TYPE as TERM31_23_ from T_VPOS_INFO vpos0_ where (vpos0_.REG_ID in ('10240004' , '10240003' , '10240006' , '10240005' , '10240002' , '10240001' , '102410' , '102411' , '102412' , '102409' , '102408' , '102407' , '102406' , '102405' , '102404' , '102403' , '102402' , '102401' , '102400')) and vpos0_.STRA_ID<>'null' order by vpos0_.VPOS_ID desc ) where rownum <= :1
|
| cy6atd5qdnhru | select posdev0_.DEV_ID as DEV1_37_, posdev0_.DEV_TYPE as DEV2_37_, posdev0_.MID as MID37_, posdev0_.SERIAL_NO as SERIAL4_37_, posdev0_.DEV_STATUS as DEV5_37_, posdev0_.PART_1_NO as PART6_37_, posdev0_.PART_2_NO as PART7_37_, posdev0_.PART_3_NO as PART8_37_, posdev0_.PART_4_NO as PART9_37_, posdev0_.MATCH_ID as MATCH10_37_, posdev0_.IN_DATE as IN11_37_, posdev0_.PROPERTY_INFO as PROPERTY12_37_, posdev0_.DESC_TXT as DESC13_37_, posdev0_.REG_ID as REG14_37_, posdev0_.HJ_STATUS as HJ15_37_, posdev0_.BMS_MID as BMS16_37_ from T_POS_DEV_INFO posdev0_ where posdev0_.DEV_ID='102400023221' |
| d7h69juskn2mn | select distinct subsys0_.sysid as col_0_0_, subsys0_.sysname as col_1_0_ from subsys subsys0_, T_OPER_INFO person1_, subrole subrole2_, realsub realsub3_ where subsys0_.sysid=subrole2_.sysid and subrole2_.subroleid=realsub3_.subroleid and realsub3_.realroleid=person1_.realroleid and person1_.OPER_ID='10240000' order by subsys0_.sysid desc |
| ddb2tzcwkuqkv | select appmerchan0_.MERCH_ID as MERCH1_12_, appmerchan0_.ORIG_ID as ORIG2_12_, appmerchan0_.SUB_ID as SUB3_12_, appmerchan0_.MERCH_NAME as MERCH4_12_, appmerchan0_.MERCH_ATTR as MERCH5_12_, appmerchan0_.MERCH_MCC as MERCH6_12_, appmerchan0_.TRAN_CHANNEL as TRAN7_12_, appmerchan0_.CUSTOM_ID as CUSTOM8_12_, appmerchan0_.PAY_CHANNEL as PAY9_12_, appmerchan0_.TRAN_TYPE as TRAN10_12_, appmerchan0_.CONNECTER as CONNECTER12_, appmerchan0_.CALL_NO as CALL12_12_, appmerchan0_.FAX_NO as FAX13_12_, appmerchan0_.EMAIL_ADDR as EMAIL14_12_, appmerchan0_.MERCH_ADDR as MERCH15_12_, appmerchan0_.POST_CODE as POST16_12_, appmerchan0_.MERCH_STATUS as MERCH17_12_, appmerchan0_.BUSS_TIME as BUSS18_12_, appmerchan0_.DATA_ORIG as DATA19_12_, appmerchan0_.REF_1 as REF20_12_, appmerchan0_.REF_2 as REF21_12_, appmerchan0_.REF_3 as REF22_12_, appmerchan0_.REG_ID as REG23_12_, appmerchan0_.MERCHANTID as MERCHANTID12_, appmerchan0_.SUBMERCHANTNO as SUBMERC25_12_, appmerchan0_.CLOSE_TIME as CLOSE26_12_, appmerchan0_.AREACODE as AREACODE12_ from t_app_merch_info appmerchan0_ where appmerchan0_.ORIG_ID='00010000' and appmerchan0_.MERCH_ID='898211456910124' and appmerchan0_.SUB_ID='001' |
| dzd423pb8m08u | select posdev0_.DEV_ID as DEV1_37_, posdev0_.DEV_TYPE as DEV2_37_, posdev0_.MID as MID37_, posdev0_.SERIAL_NO as SERIAL4_37_, posdev0_.DEV_STATUS as DEV5_37_, posdev0_.PART_1_NO as PART6_37_, posdev0_.PART_2_NO as PART7_37_, posdev0_.PART_3_NO as PART8_37_, posdev0_.PART_4_NO as PART9_37_, posdev0_.MATCH_ID as MATCH10_37_, posdev0_.IN_DATE as IN11_37_, posdev0_.PROPERTY_INFO as PROPERTY12_37_, posdev0_.DESC_TXT as DESC13_37_, posdev0_.REG_ID as REG14_37_, posdev0_.HJ_STATUS as HJ15_37_, posdev0_.BMS_MID as BMS16_37_ from T_POS_DEV_INFO posdev0_ where posdev0_.DEV_ID='102400023232' |
| f314z53n7z0yg | select PLAN_CODE into :b0 from T_PLAN_SETUP where (VPOS_ID=:b1 and PLAN_STATUS='0') |
| facf7njxzfb8j | select app0_.APP_ID as APP1_32_, app0_.APP_NAME as APP2_32_, app0_.ORG_ID as ORG3_32_, app0_.APP_TYPE as APP4_32_, app0_.REG_ID as REG5_32_, app0_.APP_STATUS as APP6_32_, app0_.INPUT_DATE as INPUT7_32_, app0_.DESC_TXT as DESC8_32_, app0_.KEY_INDEX as KEY9_32_, app0_.SHARE_FLAG as SHARE10_32_ from T_APP_INFO app0_ where app0_.APP_ID='10240000' |
| fzs6tz6dq3p1a | select VPOS_ID , NVL(VPOS_ADDR, ' ') , VPOS_STATUS , NVL(TELE_NO, ' ') , REG_ID , NVL(LAST_SIGN_TIME, ' ') , NVL(NEXT_SIGN_TIME, ' ') , AUTH_FLAG , COMPLET_FLAG , NVL(LAST_SIGN_END_TIME, ' ') , NVL(BMS_MID, ' ') into :b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10 from T_VPOS_INFO where ((MID=:b11 and DEV_ID=:b12) or VPOS_ID=:b0) |
| g04jn5ms1urjr | select object_name, object_type from dba_objects where data_object_id in ( SELECT OBJ
FROM X$BH
WHERE HLADDR in (select addr from (select addr from v$latch_children order by (gets+misses+sleeps) desc) where rownum<10) )
|
| g91mzpffbgjun | select distinct organ0_.ORG_CODE as col_0_0_, organ0_.ORG_NAME as col_1_0_ from t_org_info organ0_ where (organ0_.REG_ID='10240004' or organ0_.REG_ID='10240003' or organ0_.REG_ID='10240006' or organ0_.REG_ID='10240005' or organ0_.REG_ID='10240002' or organ0_.REG_ID='10240001' or organ0_.REG_ID='102410' or organ0_.REG_ID='102411' or organ0_.REG_ID='102412' or organ0_.REG_ID='102409' or organ0_.REG_ID='102408' or organ0_.REG_ID='102407' or organ0_.REG_ID='102406' or organ0_.REG_ID='102405' or organ0_.REG_ID='102404' or organ0_.REG_ID='102403' or organ0_.REG_ID='102402' or organ0_.REG_ID='102401' or organ0_.REG_ID='102400') and (organ0_.ORG_TYPE='2' or organ0_.ORG_TYPE='0') |
| 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 vector block count | 0 | 0.00 | 0.00 |
| Batched IO vector read count | 0 | 0.00 | 0.00 |
| Block Cleanout Optim referenced | 258 | 0.07 | 0.02 |
| CCursor + sql area evicted | 7 | 0.00 | 0.00 |
| CPU used by this session | 994,160 | 275.86 | 60.19 |
| CPU used when call started | 994,032 | 275.83 | 60.18 |
| CR blocks created | 4,983 | 1.38 | 0.30 |
| Cached Commit SCN referenced | 2,182 | 0.61 | 0.13 |
| Commit SCN cached | 314 | 0.09 | 0.02 |
| DB time | 8,923,897 | 2,476.22 | 540.25 |
| DBWR checkpoint buffers written | 5,166 | 1.43 | 0.31 |
| DBWR checkpoints | 0 | 0.00 | 0.00 |
| DBWR object drop buffers written | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR transaction table writes | 106 | 0.03 | 0.01 |
| DBWR undo block writes | 1,711 | 0.47 | 0.10 |
| Effective IO time | 10,901 | 3.02 | 0.66 |
| HSC Heap Segment Block Changes | 30,932 | 8.58 | 1.87 |
| HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
| Heap Segment Array Inserts | 107 | 0.03 | 0.01 |
| Heap Segment Array Updates | 150 | 0.04 | 0.01 |
| IMU CR rollbacks | 1,030 | 0.29 | 0.06 |
| IMU Flushes | 1,978 | 0.55 | 0.12 |
| IMU Redo allocation size | 3,357,548 | 931.66 | 203.27 |
| IMU commits | 8,416 | 2.34 | 0.51 |
| IMU contention | 1,092 | 0.30 | 0.07 |
| IMU ktichg flush | 2 | 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 | 19,687,800 | 5,463.02 | 1,191.90 |
| 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 | 1 | 0.00 | 0.00 |
| RowCR - row contention | 297 | 0.08 | 0.02 |
| RowCR attempts | 314 | 0.09 | 0.02 |
| RowCR hits | 17 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 2 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 7,474,878 | 2,074.15 | 452.53 |
| active txn count during cleanout | 3,239 | 0.90 | 0.20 |
| application wait time | 765 | 0.21 | 0.05 |
| background checkpoints completed | 0 | 0.00 | 0.00 |
| background checkpoints started | 0 | 0.00 | 0.00 |
| background timeouts | 20,399 | 5.66 | 1.23 |
| branch node splits | 9 | 0.00 | 0.00 |
| buffer is not pinned count | 12,638,074 | 3,506.84 | 765.11 |
| buffer is pinned count | 40,810,852 | 11,324.29 | 2,470.69 |
| bytes received via SQL*Net from client | 610,114,926 | 169,296.07 | 36,936.37 |
| bytes sent via SQL*Net to client | 1,237,999,166 | 343,522.81 | 74,948.49 |
| calls to get snapshot scn: kcmgss | 4,066,579 | 1,128.40 | 246.19 |
| calls to kcmgas | 34,495 | 9.57 | 2.09 |
| calls to kcmgcs | 201,670 | 55.96 | 12.21 |
| cell physical IO interconnect bytes | 224,950,784 | 62,419.85 | 13,618.52 |
| change write time | 359 | 0.10 | 0.02 |
| cleanout - number of ktugct calls | 3,985 | 1.11 | 0.24 |
| cleanouts and rollbacks - consistent read gets | 807 | 0.22 | 0.05 |
| cleanouts only - consistent read gets | 291 | 0.08 | 0.02 |
| cluster key scan block gets | 325 | 0.09 | 0.02 |
| cluster key scans | 276 | 0.08 | 0.02 |
| commit batch/immediate performed | 90 | 0.02 | 0.01 |
| commit batch/immediate requested | 90 | 0.02 | 0.01 |
| commit cleanout failures: block lost | 3 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 18 | 0.00 | 0.00 |
| commit cleanout failures: cannot pin | 1,762 | 0.49 | 0.11 |
| commit cleanouts | 56,630 | 15.71 | 3.43 |
| commit cleanouts successfully completed | 54,847 | 15.22 | 3.32 |
| commit immediate performed | 90 | 0.02 | 0.01 |
| commit immediate requested | 90 | 0.02 | 0.01 |
| commit txn count during cleanout | 4,416 | 1.23 | 0.27 |
| concurrency wait time | 828,650 | 229.94 | 50.17 |
| consistent changes | 196,545 | 54.54 | 11.90 |
| consistent gets | 956,981,561 | 265,545.41 | 57,935.68 |
| consistent gets - examination | 10,975,123 | 3,045.40 | 664.43 |
| consistent gets direct | 2 | 0.00 | 0.00 |
| consistent gets from cache | 956,981,529 | 265,545.40 | 57,935.68 |
| consistent gets from cache (fastpath) | 945,885,715 | 262,466.51 | 57,263.94 |
| cursor authentications | 239 | 0.07 | 0.01 |
| data blocks consistent reads - undo records applied | 5,517 | 1.53 | 0.33 |
| db block changes | 374,079 | 103.80 | 22.65 |
| db block gets | 767,153 | 212.87 | 46.44 |
| db block gets direct | 347 | 0.10 | 0.02 |
| db block gets from cache | 766,806 | 212.78 | 46.42 |
| db block gets from cache (fastpath) | 49,192 | 13.65 | 2.98 |
| deferred (CURRENT) block cleanout applications | 28,328 | 7.86 | 1.71 |
| enqueue conversions | 61 | 0.02 | 0.00 |
| enqueue releases | 86,474 | 24.00 | 5.24 |
| enqueue requests | 86,646 | 24.04 | 5.25 |
| enqueue timeouts | 17 | 0.00 | 0.00 |
| enqueue waits | 543 | 0.15 | 0.03 |
| exchange deadlocks | 53 | 0.01 | 0.00 |
| execute count | 3,828,079 | 1,062.22 | 231.75 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| file io wait time | 15,283,656 | 4,240.94 | 925.27 |
| free buffer inspected | 5 | 0.00 | 0.00 |
| free buffer requested | 54,320 | 15.07 | 3.29 |
| heap block compress | 43 | 0.01 | 0.00 |
| hot buffers moved to head of LRU | 0 | 0.00 | 0.00 |
| immediate (CR) block cleanout applications | 1,098 | 0.30 | 0.07 |
| immediate (CURRENT) block cleanout applications | 831 | 0.23 | 0.05 |
| index crx upgrade (positioned) | 9 | 0.00 | 0.00 |
| index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 229 | 0.06 | 0.01 |
| index fetch by key | 2,192,373 | 608.34 | 132.73 |
| index scans kdiixs1 | 2,562,495 | 711.05 | 155.13 |
| leaf node 90-10 splits | 60 | 0.02 | 0.00 |
| leaf node splits | 341 | 0.09 | 0.02 |
| lob reads | 75,282 | 20.89 | 4.56 |
| lob writes | 57,562 | 15.97 | 3.48 |
| lob writes unaligned | 57,562 | 15.97 | 3.48 |
| logons cumulative | 8,393 | 2.33 | 0.51 |
| max cf enq hold time | 48 | 0.01 | 0.00 |
| messages received | 26,504 | 7.35 | 1.60 |
| messages sent | 26,504 | 7.35 | 1.60 |
| min active SCN optimization applied on CR | 6 | 0.00 | 0.00 |
| no buffer to keep pinned count | 0 | 0.00 | 0.00 |
| no work - consistent read gets | 945,648,881 | 262,400.79 | 57,249.60 |
| non-idle wait count | 7,846,763 | 2,177.34 | 475.04 |
| non-idle wait time | 872,327 | 242.06 | 52.81 |
| opened cursors cumulative | 679,795 | 188.63 | 41.15 |
| parse count (describe) | 5 | 0.00 | 0.00 |
| parse count (failures) | 7 | 0.00 | 0.00 |
| parse count (hard) | 586 | 0.16 | 0.04 |
| parse count (total) | 721,341 | 200.16 | 43.67 |
| parse time cpu | 74 | 0.02 | 0.00 |
| parse time elapsed | 4,417 | 1.23 | 0.27 |
| physical read IO requests | 1,445 | 0.40 | 0.09 |
| physical read bytes | 22,700,032 | 6,298.86 | 1,374.26 |
| physical read total IO requests | 4,240 | 1.18 | 0.26 |
| physical read total bytes | 68,403,200 | 18,980.67 | 4,141.13 |
| physical read total multi block requests | 0 | 0.00 | 0.00 |
| physical reads | 2,771 | 0.77 | 0.17 |
| physical reads cache | 2,769 | 0.77 | 0.17 |
| physical reads cache prefetch | 1,326 | 0.37 | 0.08 |
| physical reads direct | 2 | 0.00 | 0.00 |
| physical reads direct (lob) | 1 | 0.00 | 0.00 |
| physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical reads prefetch warmup | 1,318 | 0.37 | 0.08 |
| physical write IO requests | 2,097 | 0.58 | 0.13 |
| physical write bytes | 45,162,496 | 12,531.79 | 2,734.14 |
| physical write total IO requests | 30,818 | 8.55 | 1.87 |
| physical write total bytes | 156,547,584 | 43,439.18 | 9,477.39 |
| physical write total multi block requests | 121 | 0.03 | 0.01 |
| physical writes | 5,513 | 1.53 | 0.33 |
| physical writes direct | 347 | 0.10 | 0.02 |
| physical writes direct (lob) | 3 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical writes from cache | 5,166 | 1.43 | 0.31 |
| physical writes non checkpoint | 3,398 | 0.94 | 0.21 |
| pinned buffers inspected | 0 | 0.00 | 0.00 |
| prefetch clients - default | 0 | 0.00 | 0.00 |
| prefetch warmup blocks flushed out before use | 0 | 0.00 | 0.00 |
| process last non-idle time | 3,603 | 1.00 | 0.22 |
| recursive calls | 4,739,846 | 1,315.22 | 286.95 |
| recursive cpu usage | 818 | 0.23 | 0.05 |
| redo blocks checksummed by FG (exclusive) | 29,069 | 8.07 | 1.76 |
| redo blocks written | 86,317 | 23.95 | 5.23 |
| redo buffer allocation retries | 0 | 0.00 | 0.00 |
| redo entries | 61,734 | 17.13 | 3.74 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 1,439 | 0.40 | 0.09 |
| redo size | 36,836,888 | 10,221.58 | 2,230.11 |
| redo size for direct writes | 1,736 | 0.48 | 0.11 |
| redo subscn max counts | 2,538 | 0.70 | 0.15 |
| redo synch long waits | 11,190 | 3.11 | 0.68 |
| redo synch time | 16,205 | 4.50 | 0.98 |
| redo synch time (usec) | 168,660,417 | 46,800.27 | 10,210.70 |
| redo synch writes | 26,988 | 7.49 | 1.63 |
| redo wastage | 6,006,876 | 1,666.80 | 363.66 |
| redo write time | 8,749 | 2.43 | 0.53 |
| redo writes | 24,508 | 6.80 | 1.48 |
| rollback changes - undo records applied | 158 | 0.04 | 0.01 |
| rollbacks only - consistent read gets | 4,122 | 1.14 | 0.25 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 2,134,635 | 592.32 | 129.23 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 524,228 | 145.46 | 31.74 |
| session logical reads | 957,749,689 | 265,758.55 | 57,982.18 |
| shared hash latch upgrades - no wait | 56,423 | 15.66 | 3.42 |
| shared hash latch upgrades - wait | 1,560 | 0.43 | 0.09 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 153,603 | 42.62 | 9.30 |
| sorts (rows) | 1,127,999,158 | 312,999.75 | 68,289.09 |
| sql area evicted | 7 | 0.00 | 0.00 |
| sql area purged | 7 | 0.00 | 0.00 |
| switch current to new buffer | 262 | 0.07 | 0.02 |
| table fetch by rowid | 24,663,863 | 6,843.78 | 1,493.15 |
| table fetch continued row | 180 | 0.05 | 0.01 |
| table scan blocks gotten | 936,270,348 | 259,798.41 | 56,681.82 |
| table scan rows gotten | 26,923,353,019 | 7,470,752.82 | 1,629,940.25 |
| table scans (direct read) | 0 | 0.00 | 0.00 |
| table scans (long tables) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 120,669 | 33.48 | 7.31 |
| total cf enq hold time | 823 | 0.23 | 0.05 |
| total number of cf enq holders | 58 | 0.02 | 0.00 |
| total number of times SMON posted | 14 | 0.00 | 0.00 |
| transaction rollbacks | 82 | 0.02 | 0.00 |
| transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
| undo change vector size | 10,661,200 | 2,958.29 | 645.43 |
| user I/O wait time | 1,185 | 0.33 | 0.07 |
| user calls | 7,999,543 | 2,219.73 | 484.29 |
| user commits | 10,335 | 2.87 | 0.63 |
| user rollbacks | 6,183 | 1.72 | 0.37 |
| workarea executions - onepass | 0 | 0.00 | 0.00 |
| workarea executions - optimal | 120,668 | 33.48 | 7.31 |
| write clones created in background | 0 | 0.00 | 0.00 |
| write clones created in foreground | 2 | 0.00 | 0.00 |