WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
DYFDB1	1713940724	dyfdb1	1	11-Sep-15 03:09	11.2.0.3.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
dyfdb1	Linux x86 64-bit	8	8	2	31.27

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	6733	09-Oct-15 17:44:38	462	5.7
End Snap:	6734	09-Oct-15 18:09:40	203	1.6
Elapsed:		25.02 (mins)
DB Time:		602.60 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	6,784M	7,040M	Std Block Size:	8K
Shared Pool Size:	4,864M	4,608M	Log Buffer:	30,568K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	24.1	7.6	0.17	0.03
DB CPU(s):	5.0	1.6	0.04	0.01
Redo size:	49,757.9	15,653.3
Logical reads:	644,974.5	202,901.8
Block changes:	761.9	239.7
Physical reads:	22,184.4	6,979.0
Physical writes:	6.8	2.1
User calls:	762.6	239.9
Parses:	93.3	29.3
Hard parses:	0.8	0.2
W/A MB processed:	0.8	0.3
Logons:	9.3	2.9
Executes:	142.5	44.8
Rollbacks:	0.0	0.0
Transactions:	3.2

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.32	Redo NoWait %:	99.94
Buffer Hit %:	96.77	In-memory Sort %:	100.00
Library Hit %:	96.44	Soft Parse %:	99.17
Execute to Parse %:	34.53	Latch Hit %:	98.69
Parse CPU to Parse Elapsd %:	6.76	% Non-Parse CPU:	99.72

Shared Pool Statistics

	Begin	End
Memory Usage %:	63.52	61.59
% SQL with executions>1:	96.18	99.11
% Memory for SQL w/exec>1:	92.64	93.09

Top 5 Timed Foreground Events

Host CPU (CPUs: 8 Cores: 8 Sockets: 2)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
38.43	3.11	56.2	8.7	0.2	34.8

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
63.2	96.9	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	32,019.3	32,019.3
SGA use (MB):	12,032.0	12,032.0
PGA use (MB):	914.1	679.2
% Host Mem used for SGA+PGA:	40.43	39.70

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Buffer Pool Statistics
• Advisory Statistics
• Wait Statistics
• Undo Statistics
• Latch Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Memory Statistics
• Streams Statistics
• Resource Limit Statistics
• Shared Server Statistics
• init.ora Parameters

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 36155.8s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 63.8% of Total DB time 36,155.83 (s)
• Total FG Wait Time: 15,575.16 (s) DB CPU time: 7,505.11 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 3.8% of Total DB Time (s): 36,156
• Captured PL/SQL account for 0.0% of Total DB Time (s): 36,156

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 11.8% of Total CPU Time (s): 7,505
• Captured PL/SQL account for 0.1% of Total CPU Time (s): 7,505

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 2.7% of Total User I/O Wait Time (s): 2,417
• Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 2,417

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - Buffer Gets as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 968,247,308
• Captured SQL account for 7.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 33,303,626
• Captured SQL account for 21.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 23,451,387
• Captured SQL account for 18.8% of Total
• Total UnOptimized Read Requests: 23,451,387
• Captured SQL account for 18.8% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 213,870
• Captured SQL account for 71.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 140,026
• Captured SQL account for 62.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
047jhrzwnkkbv	UPDATE "POSP"."TBL_N_TXN" SET "UPDT_DATE" = :a0, "TRANS_STATE" = :a1, "REVSAL_FLAG" = :a2, "REVSAL_SSN" = :a3, "CANCEL_FLAG" = :a4, "CANCEL_SSN" = :a5, "HOST_DATE" = :a6, "HOST_SSN" = :a7, "KEY_CANCEL" = :a9, "HEADER_BUF" = :a10, "MSG_TYPE" = :a11, "PROCESSING_CODE" = :a12, "AMT_SETTLMT" = :a13, "AMT_CDHLDR_BIL" = :a14, "TRANS_DATE_TIME" = :a15, "CONV_RATE_STLM" = :a16, "CONV_RATE_CDHLDR" = :a17, "TIME_LOCAL_TRANS" = :a18, "DATE_LOCAL_TRANS" = :a19, "DATE_EXPR" = :a20, "DATE_SETTLMT" = :a21, "DATE_CONV" = :a22, "AMT_TRANS_FEE" = :a23, "ACQ_INST_ID_CODE" = :a24, "RETRIVL_REF" = :a25, "AUTHR_ID_RESP" = :a26, "RESP_CODE" = :a27, "ADDTNL_DATA_LEN" = :a28, "ADDTNL_DATA" = :a29, "ADDTNL_AMT_LEN" = :a30, "ADDTNL_AMT" = :a31, "RSP_EMV_LEN" = :a32, "RSP_EMV_VAL" = :a33, "SWITCH_DATA_LEN" = :a34, "SWITCH_DATA" = :a35, "FINACL_DATA_LEN" = :a36, "FINACL_DATA" = :a37, "RCVG_CODE_LEN" = :a38, "RCVG_CODE" = :a39, "ACCT_ID1_LEN" = :a40, "TRANS_DESCRPT_LEN" = :a41, "TRANS_DESCRPT" = :a42, "CUP_SWRESVED_LEN" = :a43, "CUP_SWRESVED" = :a44, "ACQ_SW
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
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)
0vj5v05pdbv93	select msg_dest_id , misc_2 into :b0, :b1 from (select msg_dest_id , misc_2 from tbl_n_txn where (((((((substr(:b2, 1, 8)=substr(inst_date, 1, 8) and pan=:b3) and resp_code='00') and substr(:b2, 9, 6)>substr(inst_date, 9, 6)) and (substr(:b2, 9, 6)-substr(inst_date, 9, 6))<'10000') and msg_dest_id=:b6) and card_accp_id=:b7) and substr(misc_2, 71, 15) in (select MAP_MCHT_ID from tbl_mcht_map_ctl where ((:b8>=min_amt and :b8<=max_amt) and :b6=dest_id))) order by inst_date desc ) where rownum=1
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')
0zd925jz3p7ha	update cst_mertrans_cnt set m_count=:b0, d_count=:b1, d_total=:b2, m_total=:b3 where (((mcht_cd=:b4 and term_id=:b5) and txn_num=:b6) and card_tp=:b7)
193gpk8jzqxmm	select MPOS_IDX into :b0 from tbl_pos_key_inf where (term_id=:b1 and merch_id=:b2)
1ftbacsdpy8jp	DECLARE stmt VARCHAR2(31700); currSeq NUMBER; currUserId NUMBER; errorMessage VARCHAR2(32767); objstatus VARCHAR2(100); errorVal VARCHAR2(10); -- purpose of these is because ora_dict* is oracle implicit function and is not l-value (can't be modified) -- we want to modify these because object being changed may not be the one we're interested in (for example -- changing unique index affects table, and DDL on materialized view really affects the 'table' of it...) -- so we have our own name, owner, type ('real' ones) real_ora_dict_obj_name VARCHAR2(4000); real_ora_dict_obj_owner VARCHAR2(100); real_ora_dict_obj_type VARCHAR2(40); otype VARCHAR2(100); disallowDDL NUMBER; indexUnique VARCHAR2(40); moduleNameInfo VARCHAR2(400); oldModuleNameInfo VARCHAR2(400); oldActionInfo VARCHAR2(400); binObject NUMBER; dbRole VARCHAR2(40); dbOpenMode VARCHAR2(40); -- sequence information seqCache NUMBER; seqIncrementBy NUMBER; pieceStmt VARCHAR2(31700); outMessage VARCHAR2(32767); toIgnore VARCHAR2
1n5a4f5dspw2t	SELECT COUNT(*) FROM (select substr(UPDT_DATE, 1, 8) as inst_date, substr(UPDT_DATE, 9, 6) as inst_time, SYS_SEQ_NUM, substr(trim(PAN), 1, 6)||'****'||substr(trim(pan), -4, 4), CARD_ACCP_ID, CARD_ACCP_NAME, CARD_ACCP_TERM_ID, RETRIVL_REF, AMT_TRANS, ACQ_INST_ID_CODE, RCVG_CODE, t.txn_num||'-'||name.TXN_NAME, (SELECT CARD_TP FROM tbl_bank_bin_inf b WHERE substr(PAN, 1, length(rtrim(b.BIN_STA_NO))) = rtrim(b.BIN_STA_NO) and rownum <= 1) as CARD_TP, (substr(t.POS_ENTRY_MODE, 1, 2)||'-'||substr(t.FLD_RESERVED, 12, 2)) as transWay, RESP_CODE, tt.TERM_BATCH_NM , trim(order_no), decode(trans_State, '0', 'ʧ°Ü', '1', '³É¹¦', '2', 'ʧ°Ü', '3', 'ʧ°Ü', '4', 'ʧ°Ü', '5', 'ʧ°Ü', '6', 'ʧ°Ü', '7', 'ʧ°Ü', '8', 'ʧ°Ü', 'R', '³É¹¦', trans_State), substr(t.misc_2, 71, 15), ACCT_ID1_LEN, t.switch_data, t.CANCEL_SSN, t.REVSAL_SSN from tbl_n_txn t left outer join tbl_txn_name name on (t.txn_num = name.txn_num) left outer join tbl_term_inf tt on tt.term_id = t.CARD_ACCP_TERM_ID left outer join tbl_risk_inf r on trim(r.sa_model_kind) = trim(t.order_no) where 1=1 AND UPDT_DATE >= '20151008230000' AND UPDT_DATE <= '20151009225959' ORDER BY UPDT_DATE DESC) t
28t4znkzufuft	select ZTRK into :b0 from tbl_pos_key_inf where (term_id=:b1 and merch_id=:b2)
2q6avmcf66ju9	select * from tbl_n_txn where substr(INST_DATE, 1, 10) >= '2015100918'
31mvkjugz0pn0	SELECT D.STATUS, D.GENERATED, D.TEMPORARY, D.SECONDARY, D.OBJECT_TYPE, DECODE(BITAND(T.PROPERTY, 8192), 8192, 'YES', 'NO') FROM DBA_OBJECTS D, SYS.TAB$ T WHERE D.OBJECT_ID = :B1 AND T.OBJ# = :B1
39ax31acw29z6	WITH MET AS (SELECT DISTINCT METRIC_GUID METRIC_GUID FROM MGMT_METRICS WHERE KEYS_FROM_MULT_COLLS = 0 ), CM AS (SELECT TARGET_GUID, METRIC_GUID, MAX(COLLECTION_TIMESTAMP) MAX_TIME FROM MGMT_CURRENT_METRICS GROUP BY TARGET_GUID, METRIC_GUID HAVING MAX(COLLECTION_TIMESTAMP) != MIN(COLLECTION_TIMESTAMP)) SELECT CM.TARGET_GUID TARGET_GUID, CM.METRIC_GUID METRIC_GUID, CM. MAX_TIME MAX_TIME FROM MET, CM WHERE CM.METRIC_GUID = MET.METRIC_GUID
3ajnkuczdswnc	select * from tbl_n_txn where substr(INST_DATE, 1, 10) >= '2015100917'
3cu58w3hnufmy	select nvl(sum(m_count), 0) , nvl(sum(m_total), 0) into :b0:b1, :b2:b3 from cst_mertrans_cnt where ((mcht_cd=:b4 and month=:b5) and card_tp=:b6)
3dsgkkuspju5y	update cst_mertrans_cnt set day=:b0, d_count=:b1, d_total=:b2, m_count=:b3, m_total=:b4 where (((mcht_cd=:b5 and term_id=:b6) and txn_num=:b7) and card_tp=:b8)
3kd9cwyscc0yj	select '00000000' , ((substr(misc_2, 71, 15)||cup_ssn)||substr(inst_date, 1, 8)) , ' ' , ' ' , ' ' , case when msg_src_id='2802' then '01' when msg_src_id='2808' then '02' when msg_src_id='2807' then '03' else '00' end , '0' , substr(inst_date, 1, 8) , sys_seq_num , substr(inst_date, 9, 6) , msg_src_id , txn_num , trans_code , trans_type , trans_state , revsal_flag , revsal_ssn , cancel_flag , cancel_ssn , substr(acq_swresved, 31, 8) , substr(acq_swresved, 39, 12) , term_ssn , nvl(order_no, ' ') , nvl(inst_flag, ' ') , key_rsp , key_revsal , key_cancel , header_buf , msg_type , pan_len , pan , processing_code , amt_trans , amt_settlmt , '000000000000' , amt_cdhldr_bil , trans_date_time , conv_rate_stlm , conv_rate_cdhldr , cup_ssn , time_local_trans , date_local_trans , date_expr , date_settlmt , date_conv , mchnt_type , ' ' , pos_entry_mode , pos_cond_code , pos_pin_cap_code , amt_trans_fee , acq_inst_id_code , fwd_inst_id_code , retrivl_ref , authr_id_resp , resp_code , card_accp_term_id , card_accp_id , card_accp_name , currcy_code_trans , currcy_code
3swbq86yhcm1q	select count(*) from SYN_TBL_ACCT_TERM_DET_INF A LEFT JOIN TBL_MCHT_INF B ON A.MCHT_NO = B.MCHT_NO LEFT JOIN TBL_AGENT_INF C ON B.AGENT_NO = C.AGENT_NO LEFT JOIN SYN_TBL_ACCT_TERM_DET_INF E ON A.TXN_KEY=E.TXN_KEY AND E.TRANS_TP='T102' LEFT JOIN TBL_ACCT_TERM_DET_EXT_INF F ON A.TRANS_DATE||A.TRANS_TIME||A.MCHT_NO||A.TERM_NO||A.TRANS_TP||A.RESERVE4 = F.TBL_KEY LEFT JOIN TBL_ACCT_TERM_DET_EXT_INF G ON E.TRANS_DATE||E.TRANS_TIME||E.MCHT_NO||E.TERM_NO||E.TRANS_TP||E.RESERVE4 = G.TBL_KEY WHERE ( A.TRANS_TP in ( :1 , :2 ) )
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
45azffz4aa90t	SELECT (SELECT COUNT(*) FROM SYS.TAB$ T, SYS.SEG$ S WHERE T.OBJ# = :B1 AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND DECODE(BITAND(T.PROPERTY, 32), 32, NULL, DECODE(BITAND(S.SPARE1, 2048), 2048, 'ENABLED', 'DISABLED')) = 'ENABLED' AND ROWNUM=1) + (SELECT COUNT(*) FROM DBA_TAB_PARTITIONS WHERE TABLE_OWNER = :B3 AND TABLE_NAME = :B2 AND COMPRESSION = 'ENABLED' AND ROWNUM=1) + (SELECT COUNT(*) FROM DBA_INDEXES WHERE TABLE_OWNER = :B3 AND TABLE_NAME = :B2 AND INDEX_TYPE = 'IOT - TOP' AND COMPRESSION = 'ENABLED' AND ROWNUM=1) FROM DUAL
4cm15v3bb5jvd	UPDATE BATCH_STEP_EXECUTION set START_TIME = :1 , END_TIME = :2 , STATUS = :3 , COMMIT_COUNT = :4 , READ_COUNT = :5 , FILTER_COUNT = :6 , WRITE_COUNT = :7 , EXIT_CODE = :8 , EXIT_MESSAGE = :9 , VERSION = :10 , READ_SKIP_COUNT = :11 , PROCESS_SKIP_COUNT = :12 , WRITE_SKIP_COUNT = :13 , ROLLBACK_COUNT = :14 , LAST_UPDATED = :15 where STEP_EXECUTION_ID = :16 and VERSION = :17
4rb0qdgtaxcxs	select inst_idx into :b0 from tbl_inst_key_inf where ((merch_id=:b1 and term_id=:b2) and inst_id=:b3)
54s4r02pa00c1	update tbl_pos_key_inf set ZTRK=:b0 where (term_id=:b1 and merch_id=:b2)
572fbaj0fdw2b	select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
5md722tv748gg	select * from ( select substr(UPDT_DATE, 1, 8) as inst_date, substr(UPDT_DATE, 9, 6) as inst_time, SYS_SEQ_NUM, substr(trim(PAN), 1, 6)||'****'||substr(trim(pan), -4, 4), CARD_ACCP_ID, CARD_ACCP_NAME, CARD_ACCP_TERM_ID, RETRIVL_REF, AMT_TRANS, ACQ_INST_ID_CODE, RCVG_CODE, t.txn_num||'-'||name.TXN_NAME, (SELECT CARD_TP FROM tbl_bank_bin_inf b WHERE substr(PAN, 1, length(rtrim(b.BIN_STA_NO))) = rtrim(b.BIN_STA_NO) and rownum <= 1) as CARD_TP, (substr(t.POS_ENTRY_MODE, 1, 2)||'-'||substr(t.FLD_RESERVED, 12, 2)) as transWay, RESP_CODE, tt.TERM_BATCH_NM , trim(order_no), decode(trans_State, '0', 'ʧ°Ü', '1', '³É¹¦', '2', 'ʧ°Ü', '3', 'ʧ°Ü', '4', 'ʧ°Ü', '5', 'ʧ°Ü', '6', 'ʧ°Ü', '7', 'ʧ°Ü', '8', 'ʧ°Ü', 'R', '³É¹¦', trans_State), substr(t.misc_2, 71, 15), ACCT_ID1_LEN, t.switch_data, t.CANCEL_SSN, t.REVSAL_SSN from tbl_n_txn t left outer join tbl_txn_name name on (t.txn_num = name.txn_num) left outer join tbl_term_inf tt on tt.term_id = t.CARD_ACCP_TERM_ID left outer join tbl_risk_inf r on trim(r.sa_model_kind) = trim(t.order_no) where 1=1 AND UPDT_DATE >=
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
65yufb4ffm22q	select * from ( select row_.*, rownum rownum_ from ( select A.TRANS_DATE as A_TRANS_DATE, A.TRANS_TIME as A_TRANS_TIME, A.MCHT_NO as A_MCHT_NO, A.TERM_NO as A_TERM_NO, A.TRANS_TP as A_TRANS_TP, A.CLEAR_DATE as A_CLEAR_DATE, A.TXN_KEY as A_TXN_KEY, A.TRANS_AMT as A_TRANS_AMT, A.SETTLE_AMT as A_SETTLE_AMT, A.HAND_AMT as A_HAND_AMT, A.CARD_NO as A_CARD_NO, A.CARD_BIN as A_CARD_BIN, A.CARD_TP as A_CARD_TP, A.BANK_NAME as A_BANK_NAME, A.CHANNAL_NO as A_CHANNAL_NO, A.MCHT_NO_INST as A_MCHT_NO_INST, A.TERM_NO_INST as A_TERM_NO_INST, A.TRANS_DESC as A_TRANS_DESC, A.TRANS_ST as A_TRANS_ST, A.RESERVE1 as A_RESERVE1, A.RESERVE2 as A_RESERVE2, A.RESERVE3 as A_RESERVE3, A.RESERVE4 as A_RESERVE4, A.RESERVE5 as A_RESERVE5 , B.MCHT_NAME as A_MCHT_NAME , to_char(a.settle_amt, 'fm999999999990.00') as settleAmtEscape , to_char(to_date(a.reserve3 , 'yyyymmddhh24miss'), 'YYYY-MM-DD HH24:MI:SS') as reserve3Escape , a
6cpc4vxxb101g	update tbl_pos_key_inf set MAK=:b0 where (term_id=:b1 and merch_id=:b2)
6k79yvmjxzuzv	select * from ( select row_.*, rownum rownum_ from ( select A.TRANS_DATE as A_TRANS_DATE, A.TRANS_TIME as A_TRANS_TIME, A.MCHT_NO as A_MCHT_NO, A.TERM_NO as A_TERM_NO, A.TRANS_TP as A_TRANS_TP, A.CLEAR_DATE as A_CLEAR_DATE, A.TXN_KEY as A_TXN_KEY, A.TRANS_AMT as A_TRANS_AMT, A.SETTLE_AMT as A_SETTLE_AMT, A.HAND_AMT as A_HAND_AMT, A.CARD_NO as A_CARD_NO, A.CARD_BIN as A_CARD_BIN, A.CARD_TP as A_CARD_TP, A.BANK_NAME as A_BANK_NAME, A.CHANNAL_NO as A_CHANNAL_NO, A.MCHT_NO_INST as A_MCHT_NO_INST, A.TERM_NO_INST as A_TERM_NO_INST, A.TRANS_DESC as A_TRANS_DESC, A.TRANS_ST as A_TRANS_ST, A.RESERVE1 as A_RESERVE1, A.RESERVE2 as A_RESERVE2, A.RESERVE3 as A_RESERVE3, A.RESERVE4 as A_RESERVE4, A.RESERVE5 as A_RESERVE5 FROM SYN_TBL_ACCT_TERM_DET_INF A LEFT JOIN TBL_ACCT_TERM_DET_EXT_INF B ON A.TRANS_DATE||A.TRANS_TIME||A.MCHT_NO||A.TERM_NO||A.TRANS_TP||A.RESERVE4 = B.TBL_KEY WHERE ( B.RANK_FLAG
7302cvgcaz1mt	select * from tbl_opr_log_inf order by crt_date desc
76cckj4yysvua	select time_mp, scn, num_mappings, tim_scn_map from smon_scn_time where scn = (select max(scn) from smon_scn_time where scn <= :1)
78s4wnfyv3vqz	select MAK into :b0 from tbl_inst_key_inf where ((merch_id=:b1 and term_id=:b2) and inst_id=:b3)
7nftbczy28b2t	select usage_key , ipc_dft_index , pos_index , fld_index , fld_len , fld_val from tbl_ipc_dft where (usage_key=:b0 and ipc_dft_index=:b1) order by usage_key, ipc_dft_index, pos_index
7ryythpu0rgnh	select '00000000' , ((substr(misc_2, 71, 15)||cup_ssn)||substr(inst_date, 1, 8)) , ' ' , ' ' , ' ' , case when msg_src_id='2802' then '01' when msg_src_id='2808' then '02' when msg_src_id='2807' then '03' else '00' end , '0' , substr(inst_date, 1, 8) , sys_seq_num , substr(inst_date, 9, 6) , msg_src_id , txn_num , trans_code , trans_type , trans_state , revsal_flag , revsal_ssn , cancel_flag , cancel_ssn , substr(acq_swresved, 31, 8) , substr(acq_swresved, 39, 12) , term_ssn , nvl(order_no, ' ') , nvl(inst_flag, ' ') , key_rsp , key_revsal , key_cancel , header_buf , msg_type , pan_len , pan , processing_code , amt_trans , amt_settlmt , '000000000000' , amt_cdhldr_bil , trans_date_time , conv_rate_stlm , conv_rate_cdhldr , cup_ssn , time_local_trans , date_local_trans , date_expr , date_settlmt , date_conv , mchnt_type , ' ' , pos_entry_mode , pos_cond_code , pos_pin_cap_code , amt_trans_fee , acq_inst_id_code , fwd_inst_id_code , retrivl_ref , authr_id_resp , resp_code , card_accp_term_id , card_accp_id , card_accp_name , currcy_code_trans , currcy_code
7taaf06n846bv	select srv_name , msq_int_id , srv_num , relate_srv_id into :b0, :b1, :b2, :b3:b4 from tbl_srv_inf where (usage_key=:b5 and srv_id=:b6)
81v7xm0p6awjc	update tbl_n_txn set batch_flag='G', batch_date=substr(:b0, 1, 8) where (((((inst_date>:b1 and batch_flag='N') and revsal_flag='1') and txn_num in ('1101', '3101', '5151', '1091', '3091')) and resp_code='00') and (trans_state='1' or trans_state='R'))
88dhhc6nga1ch	update tbl_n_txn set revsal_flag=:b0, revsal_ssn=:b1 where (key_revsal=:b2 and txn_num=:b3)
8ng5tqx6dx7mr	select count(*) into :b0 from tbl_txn_sts where (((sa_txn_card=:b1 and sa_mcht_no=:b2) and sa_txn_date=:b3) and sa_ins_flag=:b4)
8vwv6hx92ymmm	UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
8zt6sk763x693	select A.EVENT_ID as A_EVENT_ID, A.EVENT_NM as A_EVENT_NM, A.EVENT_TP as A_EVENT_TP, A.EVENT_CODE as A_EVENT_CODE, A.OBJ_CLS as A_OBJ_CLS, A.PRI_KEY as A_PRI_KEY, A.SERVICE_NAME as A_SERVICE_NAME, A.METHOD_NAME as A_METHOD_NAME, A.TEMP_ID as A_TEMP_ID, A.STATUS as A_STATUS, A.RESERVE1 as A_RESERVE1, A.RESERVE2 as A_RESERVE2, A.RESERVE3 as A_RESERVE3, A.RESERVE4 as A_RESERVE4, A.RESERVE5 as A_RESERVE5, A.OPR_ID as A_OPR_ID, A.CRT_DATE as A_CRT_DATE, A.UPT_DATE as A_UPT_DATE , B.PAR_VALUE AS statusEscape, C.PAR_VALUE AS eventTpEscape, D.TEMP_NAME AS tempIdEscape from TBL_REVIEW_EVENT_INF A left join TBL_SYS_PARAM B ON A.STATUS = B.PAR_KEY AND B.GRP_CODE = 'USEABLE_STATUS' left join TBL_SYS_PARAM C ON A.EVENT_TP = C.PAR_KEY AND C.GRP_CODE = 'REVIEW_EVENT_TP' left join TBL_REVIEW_TEMP_INF D ON A.TEMP_ID = D.TEMP_ID where 1=1 and A.EVENT_ID = :1
90awxrnc3fg14	select * from tbl_n_txn where substr(inst_date, 1, 10)='2015100918' and resp_code='00'
968s2mgwa1c0w	select msq_key , msq_type into :b0, :b1 from tbl_msq_inf where msq_int_id=:b2
968zrms9m2w8h	select * from tbl_n_txn where substr(inst_date, 1, 10)='2015100917' and resp_code='00'
aac39nf3u0p3g	UPDATE "POSP"."TBL_N_TXN" SET "REVSAL_FLAG" = :a0, "REVSAL_SSN" = :a1 WHERE "KEY_RSP" = :b0
aggnb82v2yx68	SELECT KEY.KEY_NAME INDEX_NAME, KEY.COLUMN_NAME, KEY.DESCEND FROM (SELECT C.CONSTRAINT_NAME KEY_NAME, C.COLUMN_NAME COLUMN_NAME, C.POSITION POSITION, 'ASC' DESCEND FROM DBA_CONS_COLUMNS C WHERE C.OWNER = :B2 AND C.TABLE_NAME = :B1 AND C.CONSTRAINT_NAME IN ( SELECT CON1.NAME FROM SYS.USER$ USER1, SYS.USER$ USER2, SYS.CDEF$ CDEF, SYS.CON$ CON1, SYS.CON$ CON2, SYS.OBJ$ OBJ1, SYS.OBJ$ OBJ2 WHERE USER1.NAME = :B2 AND OBJ1.NAME = :B1 AND CDEF.TYPE# = 3 AND BITAND(CDEF.DEFER, 36) = 4 AND (CDEF.TYPE# = 5 OR CDEF.ENABLED IS NOT NULL) AND CON2.OWNER# = USER2.USER#(+) AND CDEF.ROBJ# = OBJ2.OBJ#(+) AND CDEF.RCON# = CON2.CON#(+) AND OBJ1.OWNER# = USER1.USER# AND CDEF.CON# = CON1.CON# AND CDEF.OBJ# = OBJ1.OBJ#) AND EXISTS ( SELECT 'x' FROM DBA_TAB_COLUMNS T WHERE T.OWNER = C.OWNER AND T.TABLE_NAME = C.TABLE_NAME AND T.COLUMN_NAME = C.COLUMN_NAME) UNION SELECT I.INDEX_NAME KEY_NAME, C.COLUMN_NAME COLUMN_NAME, C.COLUMN_POSITION POSITION, C.DESCEND DESCEND FROM DBA_INDEXES I, DBA_IND_COLUMNS C WHERE I.
bh3zgqqgas1vt	update WRH$_SQLTEXT set sql_text = SUBSTR(sql_text, 1, 1000)
bkd64nwytg71c	select MCHT_CD , TERM_ID , TERM_ID_ID , RECORD_STA , TERM_STA , TERM_SIGN_STA , CHK_STA , TERM_SEND_FLAG , TERM_I_CARD_FLAG , RESERVE_FLAG1 , RESERVE_FLAG2 , RESERVE_FLAG3 , RESERVE_FLAG4 , TERM_SET_CUR , TERM_MCC , TERM_FACTORY , TERM_MACH_TP , TERM_VER , TERM_SINGLE_LIMIT , PAY_STAGE_NUM , PAY_STAGE_LIMIT , FINANCE_CARD1 , FINANCE_CARD2 , FINANCE_CARD3 , RESERVE_AMOUNT1 , RESERVE_AMOUNT2 , TERM_TP , PARAM_DOWN_SIGN , PARAM1_DOWN_SIGN , IC_DOWN_SIGN , KEY_DOWN_SIGN , PROP_TP , PROP_INS_NM , F_CARD_SUP_FLAG , F_CARD_COMPANY , SUPPORT_IC , PSAM_ID , TERM_PLACE , CONNECT_MODE , DIAL_TP , TERM_BRANCH , TERM_BANK , TERM_INS , TERM_VER_TP , TERM_BATCH_NM , TERM_STLM_DT , TERM_TXN_SUP , TERM_PARA , TERM_PARA_1 , TERM_PARA_2 , BIND_TEL1 , BIND_TEL2 , BIND_TEL3 , ZONE_NUM , TERM_ADDR , OPR_NM , CONT_TEL , EQUIP_INV_ID , EQUIP_INV_NM , DEPOSIT_FLAG , DEPOSIT_AMT , RUN_MAIN_ID_1 , RUN_MAIN_NM_1 , RUN_MAIN_ID_2 , RUN_MAIN_NM_2 , OTH_SVR_ID , OTH_SVR_NM , REC_OPR_ID , REC_UPD_OPR , REC_CRT_OPR , REC_CHE_OPR , RESERVE_DATE , REC_CRT_TS , REC_UPD_TS , REC_DEL_TS , MISC_1 ,
cb5a5v704xhj0	select TMK into :b0 from tbl_pos_key_inf where (term_id=:b1 and merch_id=:b2)
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cspddch1nt462	select MAK into :b0 from tbl_pos_key_inf where (term_id=:b1 and merch_id=:b2)
ct0w8urak62ms	select ZPIK into :b0 from tbl_inst_key_inf where ((merch_id=:b1 and term_id=:b2) and inst_id=:b3)
cv2hft5wvknmq	select count(*) from SYN_TBL_N_TXN A left join SYN_TBL_DEF_MCHT_INF b on a.Card_Accp_Id=b.mcht_no left join SYN_TBL_INF_DISC_CD c on b.disc_no=c.disc_cd and c.disc_org='9900' left join SYN_TBL_ALGO_DTL d on a.Card_Accp_Id=d.mcht_cd and a.sys_seq_num=d.txn_ssn and substr(a.inst_date, 1, 8)=d.trans_date and substr(a.inst_date, 9, 14)=d.trans_date_time LEFT JOIN (select * from (SELECT ROW_NUMBER() OVER(PARTITION BY t.tbl_key, t.mat_type ORDER BY t.crt_date DESC) rn, t.* FROM tbl_file_inf t left join syn_tbl_n_txn h on t.tbl_key=h.CARD_ACCP_TERM_ID||h.DATE_LOCAL_TRANS||TRIM(h.TERM_SSN) where t.module_code='TXN_FILE' and t.MAT_TYPE='01' ) where rn=1) E ON A.CARD_ACCP_TERM_ID||A.DATE_LOCAL_TRANS||TRIM(A.TERM_SSN)=E.TBL_KEY WHERE ( A.INST_DATE >= :1 and A.INST_DATE <= :2 and A.CA
dk29pxvs7x6fb	update tbl_pos_key_inf set TRK=:b0 where (term_id=:b1 and merch_id=:b2)
dngc277bgapnc	select nvl(sum(d_count), 0) , nvl(sum(d_total), 0) into :b0:b1, :b2:b3 from cst_mertrans_cnt where (((mcht_cd=:b4 and month=:b5) and day=:b6) and card_tp=:b7)
dv5fcdh1qmzzm	select * from ( select row_.*, rownum rownum_ from ( select A.INST_DATE as A_INST_DATE, A.SYS_SEQ_NUM as A_SYS_SEQ_NUM, A.UPDT_DATE as A_UPDT_DATE, A.MSG_SRC_ID as A_MSG_SRC_ID, A.MSG_DEST_ID as A_MSG_DEST_ID, A.TXN_NUM as A_TXN_NUM, A.TRANS_CODE as A_TRANS_CODE, A.TRANS_TYPE as A_TRANS_TYPE, decode(A.trans_State, '0', 'ʧ°Ü', '1', '³É¹¦', '2', 'ʧ°Ü', '3', 'ʧ°Ü', '4', 'ʧ°Ü', '5', 'ʧ°Ü', '6', 'ʧ°Ü', '7', 'ʧ°Ü', '8', 'ʧ°Ü', 'R', '³É¹¦', A.trans_State) as A_TRANS_STATE, A.REVSAL_FLAG as A_REVSAL_FLAG, A.REVSAL_SSN as A_REVSAL_SSN, A.CANCEL_FLAG as A_CANCEL_FLAG, A.CANCEL_SSN as A_CANCEL_SSN, A.HOST_DATE as A_HOST_DATE, A.HOST_SSN as A_HOST_SSN, A.TERM_SSN as A_TERM_SSN, A.ORDER_NO as A_ORDER_NO, A.INST_FLAG as A_INST_FLAG, A.KEY_RSP as A_KEY_RSP, A.KEY_REVSAL as A_KEY_REVSAL, A.KEY_CANCEL as A_KEY_CANCEL, A.HEADER_BUF as A_HEADER_BUF, A.MSG_TYPE as A_MSG_TYPE, A.PAN_LEN as A_PAN_LEN, A.PAN as A_PAN, A.PROCESSING_CODE as A_PROCESSING_CODE, A.AMT_TR
dvsb6d7cy8x2v	select month , day , m_count , d_count , m_total , d_total , year into :b0, :b1, :b2, :b3, :b4, :b5, :b6 from cst_mertrans_cnt where (((mcht_cd=:b7 and term_id=:b8) and txn_num=:b9) and card_tp=:b10)
f996u9h198ws3	select ZPIK into :b0 from tbl_pos_key_inf where (term_id=:b1 and merch_id=:b2)
f9qsw6paz8yhc	select A.REC_ID as A_REC_ID, A.MCHT_REC_ID as A_MCHT_REC_ID, A.TERM_NO as A_TERM_NO, A.TERM_TYPE as A_TERM_TYPE, A.TERM_BRAND as A_TERM_BRAND, A.TERM_MODEL as A_TERM_MODEL, A.SN as A_SN, A.PHONE_NO as A_PHONE_NO, A.IMEI as A_IMEI, A.PRO_CODE as A_PRO_CODE, A.CITY_CODE as A_CITY_CODE, A.COUNTRY as A_COUNTRY, A.ADDRESS as A_ADDRESS, A.STATUS as A_STATUS, A.OPR_ID as A_OPR_ID, A.CRT_DATE as A_CRT_DATE, A.UPT_DATE as A_UPT_DATE, G.POSP_PUB_KEY AS reserve1 , G.TERM_PRI_KEY AS reserve2 , G.TERM_PUB_KEY AS reserve3 , G.TMK AS reserve4 , G.PIK AS reserve5 , G.TRK AS reserve6 , G.MAK AS reserve7 , G.SIGN_ST AS reserve8 , B.par_value as A_term_brand_escape , C.par_value as A_term_model_escape , D.par_value as A_term_type_escape , E.mcht_name as A_mcht_Rec_Id_Escape , J.par_value as reserve10Escape , E.mcht_no as reserve2Escape , H.CITY_DES AS proCodeEscape , I.CITY_DES AS cityCodeEscape , J.CITY_DES as countryEscape , K.PSAM_ID AS reserve9 , M.RESERVE3 as commType , decode(A.STATUS, '0', '
fd9ybuqtb2jyg	select ZTMK into :b0 from tbl_inst_key_inf where ((merch_id=:b1 and term_id=:b2) and inst_id=:b3)
gtzpg6z33j2g4	SELECT key.key_name, key.column_name, key.descend FROM (SELECT c.constraint_name key_name, c.column_name column_name, c.position position, 'ASC' descend FROM all_cons_columns c WHERE c.owner = :owner1 AND c.table_name = :table1 AND c.constraint_name in ( SELECT con1.name FROM sys.user$ user1, sys.user$ user2, sys.cdef$ cdef, sys.con$ con1, sys.con$ con2, sys.obj$ obj1, sys.obj$ obj2 WHERE user1.name = :owner2 AND obj1.name = :table2 AND cdef.type# = 3 AND bitand(cdef.defer, 36) = 4 AND (cdef.type# = 5 OR cdef.enabled is not null) AND con2.owne
gvc474ft1vh5g	SELECT C.CONSTRAINT_NAME, C.COLUMN_NAME FROM DBA_CONS_COLUMNS C WHERE C.OWNER = :B2 AND C.TABLE_NAME = :B1 AND C.CONSTRAINT_NAME = (SELECT C1.NAME FROM SYS.USER$ U1, SYS.USER$ U2, SYS.CDEF$ D, SYS.CON$ C1, SYS.CON$ C2, SYS.OBJ$ O1, SYS.OBJ$ O2 WHERE O1.OBJ# = :B3 AND D.TYPE# = 2 AND DECODE(D.TYPE#, 5, 'ENABLED', DECODE(D.ENABLED, NULL, 'DISABLED', 'ENABLED')) = 'ENABLED' AND BITAND(D.DEFER, 36) != 0 AND C2.OWNER# = U2.USER#(+) AND D.ROBJ# = O2.OBJ#(+) AND D.RCON# = C2.CON#(+) AND O1.OWNER# = U1.USER# AND D.CON# = C1.CON# AND D.OBJ# = O1.OBJ#) AND EXISTS (SELECT 'Y' FROM DBA_TAB_COLUMNS WHERE OWNER = :B2 AND TABLE_NAME = :B1 AND COLUMN_NAME = C.COLUMN_NAME) ORDER BY C.POSITION

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Ordered by (Data Read + Write) desc for each function

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Buffer Pool Statistics
• Checkpoint Activity

Buffer Pool Statistics

• Standard block size Pools D: default, K: keep, R: recycle
• Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

• Total Physical Writes: 10,160

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

• Instance Recovery Stats
• MTTR Advisory
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Instance Recovery Stats

• B: Begin Snapshot, E: End Snapshot

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

• When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

• SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
• Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.