WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
M012BAND	209747035	m012band	1	28-Aug-15 21:08	11.2.0.4.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
dcrrbdb1	HP-UX IA (64-bit)	32	16	2	255.88

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	11126	30-Aug-15 19:30:20	66	25.5
End Snap:	11127	30-Aug-15 20:30:33	57	11.5
Elapsed:		60.22 (mins)
DB Time:		76.75 (mins)

Report Summary

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.3	0.1	0.00	0.00
DB CPU(s):	1.0	0.1	0.00	0.00
Redo size (bytes):	5,385,868.2	419,562.9
Logical read (blocks):	37,321.1	2,907.3
Block changes:	6,481.0	504.9
Physical read (blocks):	961.7	74.9
Physical write (blocks):	709.1	55.2
Read IO requests:	899.9	70.1
Write IO requests:	164.2	12.8
Read IO (MB):	7.5	0.6
Write IO (MB):	5.5	0.4
User calls:	10,252.8	798.7
Parses (SQL):	358.7	27.9
Hard parses (SQL):	0.8	0.1
SQL Work Area (MB):	0.1	0.0
Logons:	9.1	0.7
Executes (SQL):	9,887.8	770.3
Rollbacks:	0.0	0.0
Transactions:	12.8

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	99.98
Buffer Hit %:	97.58	In-memory Sort %:	100.00
Library Hit %:	99.99	Soft Parse %:	99.78
Execute to Parse %:	96.37	Latch Hit %:	99.78
Parse CPU to Parse Elapsd %:	86.20	% Non-Parse CPU:	99.20

Top 10 Foreground Events by Total Wait Time

Wait Classes by Total Wait Time

Host CPU

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
32	16	2	0.02	0.15	5.9	1.6	3.5	92.5

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
3.3	43.3	0.0

IO Profile

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	1,161.7	923.0	238.7
Database Requests:	1,064.1	899.9	164.2
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	31.1	5.6	25.4
Total (MB):	34.3	13.1	21.3
Database (MB):	13.1	7.5	5.5
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	10.5	5.2	5.2
Database (blocks):	1,670.8	961.7	709.1
Via Buffer Cache (blocks):	1,608.2	900.0	708.2
Direct (blocks):	62.6	61.7	0.9

Memory Statistics

	Begin	End
Host Mem (MB):	262,025.0	262,025.0
SGA use (MB):	2,000.0	2,000.0
PGA use (MB):	378.1	333.4
% Host Mem used for SGA+PGA:	0.91	0.89

Cache Sizes

	Begin	End
Buffer Cache:	1,472M	1,456M	Std Block Size:	8K
Shared Pool Size:	346M	346M	Log Buffer:	16,556K

Shared Pool Statistics

	Begin	End
Memory Usage %:	82.84	82.95
% SQL with executions>1:	80.85	84.30
% Memory for SQL w/exec>1:	74.60	79.43

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): 4605.2s
• 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 117.5% of Total DB time 4,605.17 (s)
• Total FG Wait Time: 1,917.72 (s) DB CPU time: 3,495.18 (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 25.3% of Total DB Time (s): 4,605
• Captured PL/SQL account for 0.1% of Total DB Time (s): 4,605

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 25.7% of Total CPU Time (s): 3,495
• Captured PL/SQL account for 0.1% of Total CPU Time (s): 3,495

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 12.4% of Total User I/O Wait Time (s): 1,594
• Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 1,594

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: 134,851,239
• Captured SQL account for 59.6% 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: 3,474,739
• Captured SQL account for 11.9% 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: 3,251,646
• Captured SQL account for 12.5% of Total
• Total UnOptimized Read Requests: 3,251,646
• Captured SQL account for 12.5% 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: 35,727,387
• Captured SQL account for 65.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 1,295,906
• Captured SQL account for 96.5% 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

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0z73hrsfz7rg1	INSERT INTO "EXPORT_USER"."SYS_EXPORT_SCHEMA_01" (object_type_path, object_path_seqno, dump_fileid, dump_position, dump_length, dump_orig_length, dump_allocation, process_order, duplicate, object_row, object_type, object_schema, original_object_schema, object_name, object_long_name, original_object_name, partition_name, subpartition_name, object_tablespace, grantor, flags, processing_state, processing_status, base_process_order, base_object_type, base_object_schema, base_object_name, domain_process_order, xml_clob, ancestor_process_order, property, trigflag, size_estimate, creation_level, parent_process_order, value_n, object_int_oid, metadata_io) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :13, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38)
26f17py8g4cf8	select /*+ INDEX_ASC(CUEV CUEVPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32 from CUEV where (((INST_NO=:b33 and ACCT_NO=:b34) and SYSTEM=:b35) and FIN_YEAR=:b36)
2jfqzrxhrm93b	select /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
3wrrjm9qtr2my	SELECT T.CLIENT_ID, T.OPERATION_ID, T.TARGET_TYPE, T.TARGET_NAME, T.CURR_JOB_NAME, TO_NUMBER(BITAND(T.ATTRIBUTES, 131072)), CASE NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'RUNNING' THEN 1 WHEN 'DISABLED' THEN 2 WHEN 'SCHEDULED' THEN 3 WHEN 'RETRY SCHEDULED' THEN 99 WHEN 'COMPLETED' THEN 99 WHEN 'BROKEN' THEN 99 WHEN 'FAILED' THEN 99 WHEN 'REMOTE' THEN 99 WHEN 'SUCCEEDED' THEN 99 WHEN 'STOPPED' THEN 99 WHEN 'CHAIN_STALLED' THEN 99 ELSE 99 END AS CONSOLIDATED_STATE, CASE NVL(JRD.STATUS, 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'SUCCEEDED' THEN 10 WHEN 'FAILED' THEN 11 WHEN 'STOPPED' THEN CASE WHEN JRD.ADDITIONAL_INFO LIKE '%called by user%' THEN 12 WHEN JRD.ADDITIONAL_INFO LIKE '%window was closed%' THEN 13 WHEN JRD.ADDITIONAL_INFO LIKE 'ORA-01014%' THEN 14 ELSE 15 END ELSE 99 END AS STATUS, NVL(JRD.RUN_DURATION, INTERVAL '0' SECOND), NVL(JRD.CPU_USED, INTERVAL '0' SECOND), NVL(JRD.ERROR#, 0), NVL (JRD.STATUS, 'NO LOG ENTRY') || '(jrd)' AS DBG_STATUS, NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') ||'(jobs)' AS DBG_STATE, NVL(JRD.LOG_DATE, TIMESTAMP '2001-01-01 01:01:01.01 +01:01'), NVL(JRD.LOG_ID, 0) FROM KET$_CLIENT_TASKS T, DBA_SCHEDULER_JOB_RUN_DETAILS JRD WHERE T.CURR_JOB_NAME IS NOT NULL AND T.CURR_JOB_NAME = JRD.JOB_NAME(+) AND 'SYS' = JRD.OWNER(+)
3ybumwkzuarjv	SELECT /*+ FULL(P) +*/ * FROM "BRHM" P
454f58f16k7d8	SELECT "INST", "SYST", "ACCT_TYPE", "ACCT_CAT", "ARR_COND_NO" FROM "ATAC" "TMP_1_ATAC" WHERE "SYST"=NVL(:1, :2) AND "ACCT_TYPE"=NVL(:3, :4) AND "INST"=NVL(:5, :6) AND "ACCT_CAT"=NVL(:7, :8) AND "ARR_COND_NO">NVL(:9, :10)
4x4wynpgzh91v	select /*+ INDEX_ASC(BORM BORMPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34, :b35, :b36, :b37, :b38, :b39, :b40, :b41, :b42, :b43, :b44, :b45, :b46, :b47, :b48, :b49, :b50, :b51, :b52, :b53, :b54, :b55, :b56, :b57, :b58, :b59, :b60, :b61, :b62, :b63, :b64, :b65, :b66, :b67, :b68, :b69, :b70, :b71, :b72, :b73, :b74, :b75, :b76, :b77, :b78, :b79, :b80, :b81, :b82, :b83, :b84, :b85, :b86, :b87, :b88, :b89, :b90, :b91, :b92, :b93, :b94, :b95, :b96, :b97, :b98, :b99, :b100, :b101, :b102, :b103, :b104, :b105, :b106, :b107, :b108, :b109, :b110, :b111, :b112, :b113, :b114, :b115, :b116, :b117, :b118, :b119, :b120, :b121, :b122, :b123, :b124, :b125, :b126, :b127, :b128, :b129, :b130, :b131, :b132, :b133, :b134, :b135, :b136, :b137, :b138, :b139, :b140, :b141, :b142, :b143, :b144, :b145, :b146, :b147, :b148, :b149, :b150, :b151, :b152, :b153, :b154, :b155, :b156, :b157, :b158, :b159, :b160, :b161, :b162, :b163, :b164, :b165, :b166, :b167, :b168, :b169, :b170, :b171, :b172, :b173, :b174, :b175, :b176, :b177, :b178, :b179, :b180, :b181, :b182, :b183, :b184, :b185, :b186, :b187, :b188, :b189, :b190, :b191, :b192, :b193, :b194, :b195, :b196, :b197, :b198, :b199, :b200, :b201, :b202, :b203, :b204, :b205, :b206, :b207, :b208, :b209, :b210, :b211, :b212, :b213, :b214, :b215, :b216, :b217, :b218, :b219, :b220, :b221, :b222, :b223, :b224, :b225, :b226, :b227, :b228, :b229, :b230, :b231, :b232, :b233, :b234, :b235, :b236, :b237, :b238, :b239, :b240, :b241, :b242, :b243, :b244, :b245, :b246, :b247, :b248, :b249, :b250, :b251, :b252, :b253, :b254, :b255, :b256 from BORM where KEY_1=:b257
51xpjyrsbazcx	SELECT "KEY_1" FROM "CSTM" "TMP_1_CSTM" WHERE "KEY_1">NVL(:1, :2)
85fk0zstxmfz9	SELECT /*+ FULL(P) +*/ * FROM "ATAC" P
8kmbbtk53u21d	UPDATE "EXPORT_USER"."SYS_EXPORT_SCHEMA_01" SET last_update = sysdate, object_number = :1, object_schema = :2, object_name = :3, object_long_name = :4, object_type_path = :5, partition_name = DECODE(partition_name, NULL, NULL, :6), subpartition_name = DECODE(subpartition_name, NULL, NULL, :7), total_bytes = :8, completed_rows = :9, metadata_io = :10, cumulative_time = :11, parallelization = :12 WHERE process_order = :13 AND duplicate = :14
8rz8u2npd6gj8	select /*+ INDEX_ASC(BRHM BRHMPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34, :b35, :b36, :b37, :b38, :b39, :b40, :b41, :b42, :b43, :b44, :b45, :b46, :b47, :b48, :b49, :b50, :b51, :b52, :b53, :b54, :b55, :b56, :b57, :b58, :b59, :b60, :b61, :b62, :b63, :b64, :b65, :b66, :b67, :b68, :b69, :b70, :b71, :b72, :b73, :b74, :b75, :b76, :b77, :b78, :b79, :b80, :b81, :b82, :b83, :b84, :b85, :b86, :b87, :b88, :b89, :b90, :b91, :b92, :b93, :b94, :b95, :b96, :b97, :b98, :b99, :b100, :b101, :b102, :b103, :b104, :b105, :b106, :b107, :b108, :b109, :b110, :b111, :b112, :b113, :b114, :b115, :b116, :b117, :b118, :b119, :b120, :b121, :b122, :b123, :b124, :b125, :b126, :b127, :b128, :b129, :b130, :b131, :b132, :b133, :b134, :b135, :b136, :b137, :b138, :b139, :b140, :b141, :b142, :b143, :b144, :b145, :b146, :b147, :b148, :b149, :b150, :b151, :b152, :b153, :b154, :b155, :b156, :b157, :b158, :b159, :b160, :b161, :b162, :b163, :b164, :b165, :b166, :b167, :b168, :b169, :b170, :b171, :b172, :b173, :b174, :b175, :b176, :b177, :b178, :b179, :b180, :b181, :b182 from BRHM where KEY_1=:b183
8v3rx2ngm78s6	update BORM set BORVST=:b1, NO_TRN=:b2, NO_PER_TRN=:b3, REC_NO=:b4, NO_NON_FIN=:b5, SYS=:b6, BR_NO=:b7, STAT=:b8, ACT_TYPE=:b9, INT_REST=:b10, BORR_TYPE=:b11, ADD_LOAN_STAT=:b12, DISCH_REFERENCE=:b13, FCC_CLUS=:b14, REGISTRY_CODE=:b15, SECURITY_METHOD=:b16, SEC_ACCESS_IND=:b17, DISCH_FEE_CODE=:b18, INT_REPAY_FREQ=:b19, PURPOSE_CODE_A=:b20, TOM_RATE_TBL_ID=:b21, LOAN_OFFICER=:b22, PREVIOUS_OFFICER=:b23, REFERRAL_FLAG=:b24, REFERRAL_DATE=:b25, APPLIC_ISSUE_DATE=:b26, APPLIC_AMOUNT=:b27, INT_REPAY_DAY=:b28, VALUER_CODE=:b29, REPAY_COUNT=:b30, REPAY_IN_AFFECT=:b31, NO_OF_OWNER=:b32, NO_OF_MESSAGES=:b33, REPAY_DAY=:b34, REPAY_FREQ=:b35, EOY_BASIC_BAL=:b36, PEND_RATE=:b37, APP_AMT=:b38, LOAN_BAL=:b39, UNC_VAL=:b40, ADV_VAL=:b41, NPB_VAL=:b42, THEO_LOAN_BAL=:b43, INTEREST=:b44, SOP_BAL=:b45, SOP_THEO_BAL=:b46, DUE_AMT=:b47, LOAN_REPAY=:b48, PEND_DUES=:b49, EOM_THEO_BAL=:b50, EOM_BASIC_BAL=:b51, ADD_LOAN_APP=:b52, ADD_LOAN_ADV=:b53, ADD_DUES=:b54, GROUPS=:b55, SUB_GROUP=:b56, APPRV_DATE=:b57, LST_FIN_DATE=:b58, LST_MNT_DATE=:b59, ADV_DATE=:b60, DUE_STRT_DATE=:b61, ADD_DUES_STRT_DATE=:b62, LST_ARR_DATE=:b63, PEND_DUES_DATE=:b64, INT_STRT_DATE=:b65, REPAY_TYPE=:b66, PAY_DAY=:b67, RENEWAL_DATE=:b68, ATM_FLAG=:b69, INT_RATE=:b70, ADD_ADV_DATE=:b71, ADD_APPRV_DATE=:b72, BACK_DT_IND=:b73, CAT=:b74, STOP_IND=:b75, HOLD_IND=:b76, NO_UNC=:b77, NO_NPB=:b78, THEO_UNPD_TOM_INT=:b79, LOAN_TRM=:b80, REM_REPAYS=:b81, DISCH_MTHS=:b82, MISC_DR_01=:b83, TRN_CODE_01=:b84, LEDG_CODE_01=:b85, SUB_LEDG_01=:b86, MISC_DR_02=:b87, TRN_CODE_02=:b88, LEDG_CODE_02=:b89, SUB_LEDG_02=:b90, MISC_DR_03=:b91, TRN_CODE_03=:b92, LEDG_CODE_03=:b93, SUB_LEDG_03=:b94, SEGMENT_CODE=:b95, CONST_CDE=:b96, SOLICITOR_CDE=:b97, COUNCIL_CDE=:b98, SEC_LESD_CDE=:b99, INT_CDE=:b100, FINE_CDE=:b101, MPI_CDE=:b102, MORTGAGE_INSU=:b103, SPL_LOAN_CDE=:b104, RATIO_VAL_CDE=:b105, REASON_ARR_CDE=:b106, ADD_LOAN_CDE=:b107, SOURCE_CDE=:b108, INT_FLAG=:b109, LOANSAVER_IND=:b110, LOC_IND=:b111, SHRE_CAP_IND=:b112, INS_IND=:b113, IN T_REST_EOFY=:b114, BAD_DEBT_IND=:b115, STOP_TRAN_IND=:b116, REDRAW_IND=:b117, SWEEP_ACCT_FLAG=:b118, RESIDUAL_IND=:b119, CSLD_STMT_PROS=:b120, INTRO_BROKER_INDIC=:b121, INT_ACCR=:b122, INT_INCR=:b123, BPI_ACCR=:b124, BPI_INCR=:b125, CI_ACCR=:b126, CI_INCR=:b127, ARR_INT_ACCR=:b128, ARR_INT_INCR=:b129, ARR_NOT_FLAG=:b130, STAMPED_AMT=:b131, REPAY_CAP_PERC=:b132, REPAY_SCHED=:b133, CAPN_METHOD=:b134, FIXED_RT_DATE=:b135, INST_NOT_DAYS=:b136, INT_CONC=:b137, INT_CONC_MOV=:b138, INT_CONC_MOV_AD=:b139, MSGS_PENDING=:b140, SEVERITY_COUNT=:b141, RT_INCR=:b142, RT_INCR_MOV=:b143, RT_INCR_MOV_AD=:b144, PRINC_REDUCT_EFF=:b145, CUSTOMER_NO=:b146, PRINC_REDUCT_PEND=:b147, OLDEST_BDATE_DATE=:b148, ADV_TOM_RATE=:b149, MAN_APP_CREDIT=:b150, CURRENCY_IND=:b151, ENDOW_EXP_DT=:b152, STMT_PAGE_NO=:b153, CROSS_BORDER_RISK=:b154, SECURITY_IND=:b155, TIME_BAND=:b156, REPAY_METHOD=:b157, INT_TAX_YTD=:b158, STORE_RATE=:b159, GRACE_EXP_DT=:b160, UNEARNED_INT=:b161, RESIDUAL_BAL=:b162, LAST_BORV_46_DATE=:b163, CR_RATING=:b164, CAFM_TYPE=:b165, DUES_RECALC_IND=:b166, BASM_RECALC_IND=:b167, PDCC_VAL=:b168, STMT_FREQUENCY=:b169, STMT_CYCLE=:b170, STMT_DAY=:b171, POSTING_MASK=:b172, REPORT_MASK=:b173, STMT_DATE_IND=:b174, LAST_STMT_DATE=:b175, INT_ADJUSTMENT=:b176, ARR_INT_ADJUSTMENT=:b177, GL_CLASS_CODE=:b178, STMT_COPIES=:b179, INT_CODE=:b180, TRF_ACCT_NO=:b181, LAST_ACCT_TYPE_CHG=:b182, UNCL_NO_INT_VAL=:b183, TERM_BASIS=:b184, ARR_ACCR_AMT=:b185, FD_IND=:b186, IR_IND=:b187, IP_IND=:b188, CAP_UNPD_INT=:b189, CAP_THEO_UNPD_INT=:b190, UNPD_ARRS_INT_BAL=:b191, THEO_UNPD_ARRS_INT=:b192, UNPD_CHRG_BAL=:b193, THEO_UNPD_CHRG_BAL=:b194, UNPD_PRIN_BAL=:b195, THEO_UNPD_PRIN_BAL=:b196, NON_PERF_BAL=:b197, TOM_ACRU_AMT=:b198, UNPAID_TOM_INT=:b199, POOL_ID=:b200, POOL_DEPOSIT_DATE=:b201, CHR_EXEM_PROFILE=:b202, CHR_CNT_01=:b203, CHR_VAL_01=:b204, CHR_CNT_02=:b205, CHR_VAL_02=:b206, CHR_CNT_03=:b207, CHR_VAL_03=:b208, CHR_CNT_04=:b209, CHR_VAL_04=:b210, CHR_CNT_05=:b211, CHR_VAL_05=:b212, CHR_CNT_06=:b213, CHR_VAL_06=:b214, CHR_CNT_07=:b215, CHR_VAL_07=:b216, CHR_CNT_08=:b217, CHR_VAL_08=:b218, CHR_CNT_09=:b219, CHR_VAL_09=:b220, CHR_CNT_10=:b221, CHR_VAL_10=:b222, DRAWING_AMOUNT=:b223, SECURITY_AMOUNT=:b224, COMP_AMT=:b225, COMP_FREQUENCY=:b226, CUST_POST_MASK=:b227, MARKET_SEG_CODE=:b228, TIER_ID=:b229, CURR_RENEWAL_DT=:b230, REPAY_OPTION=:b231, EXT_CR_RATING_CODE=:b232, ACTUAL_RENEWAL_DT=:b233, LAST_UNDR_LIMIT_DT=:b234, LAST_CREDIT_DT=:b235, LAST_INT_ARR_DT=:b236, LAST_NO_INT_ARR_DT=:b237, OLD_BAD_DEBT_IND=:b238, LAST_UNDR_SECUR_DT=:b239, LAST_OVER_SECUR_DT=:b240, NPA_DATE=:b241, SCH_EXP_DT=:b242, ORI_SECURITY_VAL=:b243, EARL_STOK_CREAT_DT=:b244, COLLECTION_AMT=:b245, CAP_UNPD_INT_PY=:b246, CAP_TH_UNPD_INT_PY=:b247, PROVISION_AMOUNT=:b248, CUST_EVAL_FLAG=:b249, INCA=:b250, BKDT_INT_ADJ_IND=:b251, PASSBK_LST_LINE_NO=:b252, PASSBOOK_NO=:b253, EXTN_COUNTER=:b254, FIL_01=:b255 where rowid =:b256
a4b3hyn27yz94	UPDATE INMB SET TYP1_BAL_13 = :b1, TYP2_BAL_13 = :b2, TYP3_BAL_13 = :b3, TYP4_BAL_13 = :b4, TYP1_PREV_BAL_13 = :b5, TYP2_PREV_BAL_13 = :b6, TYP3_PREV_BAL_13 = :b7 WHERE ( INST_NO = :b8 AND ACCT_NO = :b9 )
a4sny3rp6udxn	select /*+ INDEX_ASC(DEPP DEPPPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34, :b35, :b36, :b37, :b38, :b39, :b40, :b41, :b42, :b43, :b44, :b45, :b46, :b47, :b48, :b49, :b50, :b51, :b52, :b53, :b54, :b55, :b56, :b57, :b58, :b59, :b60, :b61, :b62, :b63, :b64, :b65, :b66, :b67, :b68, :b69, :b70, :b71, :b72, :b73, :b74, :b75, :b76, :b77, :b78, :b79, :b80, :b81, :b82, :b83, :b84, :b85, :b86, :b87, :b88, :b89, :b90, :b91, :b92, :b93, :b94, :b95, :b96, :b97, :b98, :b99, :b100, :b101, :b102, :b103, :b104, :b105, :b106, :b107, :b108, :b109, :b110, :b111, :b112, :b113, :b114, :b115, :b116, :b117, :b118, :b119, :b120, :b121, :b122, :b123, :b124, :b125, :b126, :b127, :b128, :b129, :b130, :b131, :b132, :b133, :b134, :b135, :b136, :b137, :b138, :b139, :b140, :b141, :b142, :b143, :b144, :b145, :b146, :b147, :b148, :b149, :b150, :b151, :b152, :b153, :b154, :b155, :b156, :b157, :b158, :b159, :b160, :b161, :b162, :b163, :b164, :b165, :b166, :b167, :b168, :b169, :b170, :b171, :b172, :b173, :b174, :b175, :b176, :b177, :b178, :b179, :b180, :b181, :b182, :b183, :b184, :b185, :b186, :b187, :b188, :b189, :b190, :b191, :b192, :b193, :b194, :b195, :b196, :b197, :b198, :b199, :b200, :b201, :b202, :b203, :b204, :b205, :b206, :b207, :b208, :b209, :b210, :b211, :b212, :b213, :b214, :b215, :b216, :b217, :b218, :b219, :b220, :b221, :b222, :b223, :b224, :b225, :b226, :b227, :b228, :b229, :b230, :b231, :b232, :b233, :b234, :b235, :b236, :b237, :b238, :b239, :b240, :b241, :b242, :b243, :b244, :b245, :b246, :b247, :b248, :b249, :b250, :b251, :b252, :b253, :b254, :b255, :b256, :b257, :b258, :b259, :b260, :b261, :b262, :b263, :b264, :b265, :b266, :b267, :b268, :b269, :b270, :b271, :b272, :b273, :b274, :b275, :b276, :b277, :b278, :b279, :b280, :b281, :b282, :b283, :b284, :b285, :b286, :b287, :b288, :b289, :b290, :b291, :b292, :b293, :b294, :b295, :b296, :b297, :b298, :b299, :b300, :b301, :b302, :b303, :b304, :b305, :b306, :b307, :b308, :b309, :b310, :b311, :b312, :b313, :b314, :b315, :b316, :b317, :b318, :b319, :b320, :b321, :b322, :b323, :b324, :b325, :b326, :b327, :b328, :b329, :b330, :b331, :b332, :b333, :b334, :b335, :b336, :b337, :b338, :b339, :b340, :b341, :b342, :b343, :b344, :b345, :b346, :b347, :b348, :b349, :b350, :b351, :b352, :b353, :b354, :b355, :b356, :b357, :b358, :b359, :b360, :b361, :b362, :b363, :b364, :b365, :b366, :b367, :b368, :b369, :b370, :b371, :b372, :b373, :b374, :b375, :b376, :b377, :b378, :b379, :b380, :b381, :b382, :b383, :b384, :b385, :b386, :b387, :b388, :b389, :b390, :b391, :b392, :b393, :b394, :b395, :b396, :b397, :b398, :b399, :b400, :b401, :b402, :b403, :b404, :b405, :b406, :b407, :b408, :b409, :b410, :b411, :b412, :b413, :b414, :b415, :b416, :b417, :b418, :b419, :b420, :b421, :b422, :b423, :b424, :b425, :b426, :b427, :b428, :b429, :b430, :b431, :b432, :b433, :b434, :b435, :b436 from DEPP whe re (((INST_NO=:b437 and SYS=:b438) and TYPE=:b439) and INT_CAT=:b440)
af6jbfcvjh9cn	update BORM set BORVST=:b1, NO_TRN=:b2, NO_PER_TRN=:b3, REC_NO=:b4, NO_NON_FIN=:b5, SYS=:b6, BR_NO=:b7, STAT=:b8, ACT_TYPE=:b9, INT_REST=:b10, BORR_TYPE=:b11, ADD_LOAN_STAT=:b12, DISCH_REFERENCE=:b13, FCC_CLUS=:b14, REGISTRY_CODE=:b15, SECURITY_METHOD=:b16, SEC_ACCESS_IND=:b17, DISCH_FEE_CODE=:b18, INT_REPAY_FREQ=:b19, PURPOSE_CODE_A=:b20, TOM_RATE_TBL_ID=:b21, LOAN_OFFICER=:b22, PREVIOUS_OFFICER=:b23, REFERRAL_FLAG=:b24, REFERRAL_DATE=:b25, APPLIC_ISSUE_DATE=:b26, APPLIC_AMOUNT=:b27, INT_REPAY_DAY=:b28, VALUER_CODE=:b29, REPAY_COUNT=:b30, REPAY_IN_AFFECT=:b31, NO_OF_OWNER=:b32, NO_OF_MESSAGES=:b33, REPAY_DAY=:b34, REPAY_FREQ=:b35, EOY_BASIC_BAL=:b36, PEND_RATE=:b37, APP_AMT=:b38, LOAN_BAL=:b39, UNC_VAL=:b40, ADV_VAL=:b41, NPB_VAL=:b42, THEO_LOAN_BAL=:b43, INTEREST=:b44, SOP_BAL=:b45, SOP_THEO_BAL=:b46, DUE_AMT=:b47, LOAN_REPAY=:b48, PEND_DUES=:b49, EOM_THEO_BAL=:b50, EOM_BASIC_BAL=:b51, ADD_LOAN_APP=:b52, ADD_LOAN_ADV=:b53, ADD_DUES=:b54, GROUPS=:b55, SUB_GROUP=:b56, APPRV_DATE=:b57, LST_FIN_DATE=:b58, LST_MNT_DATE=:b59, ADV_DATE=:b60, DUE_STRT_DATE=:b61, ADD_DUES_STRT_DATE=:b62, LST_ARR_DATE=:b63, PEND_DUES_DATE=:b64, INT_STRT_DATE=:b65, REPAY_TYPE=:b66, PAY_DAY=:b67, RENEWAL_DATE=:b68, ATM_FLAG=:b69, INT_RATE=:b70, ADD_ADV_DATE=:b71, ADD_APPRV_DATE=:b72, BACK_DT_IND=:b73, CAT=:b74, STOP_IND=:b75, HOLD_IND=:b76, NO_UNC=:b77, NO_NPB=:b78, THEO_UNPD_TOM_INT=:b79, LOAN_TRM=:b80, REM_REPAYS=:b81, DISCH_MTHS=:b82, MISC_DR_01=:b83, TRN_CODE_01=:b84, LEDG_CODE_01=:b85, SUB_LEDG_01=:b86, MISC_DR_02=:b87, TRN_CODE_02=:b88, LEDG_CODE_02=:b89, SUB_LEDG_02=:b90, MISC_DR_03=:b91, TRN_CODE_03=:b92, LEDG_CODE_03=:b93, SUB_LEDG_03=:b94, SEGMENT_CODE=:b95, CONST_CDE=:b96, SOLICITOR_CDE=:b97, COUNCIL_CDE=:b98, SEC_LESD_CDE=:b99, INT_CDE=:b100, FINE_CDE=:b101, MPI_CDE=:b102, MORTGAGE_INSU=:b103, SPL_LOAN_CDE=:b104, RATIO_VAL_CDE=:b105, REASON_ARR_CDE=:b106, ADD_LOAN_CDE=:b107, SOURCE_CDE=:b108, INT_FLAG=:b109, LOANSAVER_IND=:b110, LOC_IND=:b111, SHRE_CAP_IND=:b112, INS_IND=:b113, IN T_REST_EOFY=:b114, BAD_DEBT_IND=:b115, STOP_TRAN_IND=:b116, REDRAW_IND=:b117, SWEEP_ACCT_FLAG=:b118, RESIDUAL_IND=:b119, CSLD_STMT_PROS=:b120, INTRO_BROKER_INDIC=:b121, INT_ACCR=:b122, INT_INCR=:b123, BPI_ACCR=:b124, BPI_INCR=:b125, CI_ACCR=:b126, CI_INCR=:b127, ARR_INT_ACCR=:b128, ARR_INT_INCR=:b129, ARR_NOT_FLAG=:b130, STAMPED_AMT=:b131, REPAY_CAP_PERC=:b132, REPAY_SCHED=:b133, CAPN_METHOD=:b134, FIXED_RT_DATE=:b135, INST_NOT_DAYS=:b136, INT_CONC=:b137, INT_CONC_MOV=:b138, INT_CONC_MOV_AD=:b139, MSGS_PENDING=:b140, SEVERITY_COUNT=:b141, RT_INCR=:b142, RT_INCR_MOV=:b143, RT_INCR_MOV_AD=:b144, PRINC_REDUCT_EFF=:b145, CUSTOMER_NO=:b146, PRINC_REDUCT_PEND=:b147, OLDEST_BDATE_DATE=:b148, ADV_TOM_RATE=:b149, MAN_APP_CREDIT=:b150, CURRENCY_IND=:b151, ENDOW_EXP_DT=:b152, STMT_PAGE_NO=:b153, CROSS_BORDER_RISK=:b154, SECURITY_IND=:b155, TIME_BAND=:b156, REPAY_METHOD=:b157, INT_TAX_YTD=:b158, STORE_RATE=:b159, GRACE_EXP_DT=:b160, UNEARNED_INT=:b161, RESIDUAL_BAL=:b162, LAST_BORV_46_DATE=:b163, CR_RATING=:b164, CAFM_TYPE=:b165, DUES_RECALC_IND=:b166, BASM_RECALC_IND=:b167, PDCC_VAL=:b168, STMT_FREQUENCY=:b169, STMT_CYCLE=:b170, STMT_DAY=:b171, POSTING_MASK=:b172, REPORT_MASK=:b173, STMT_DATE_IND=:b174, LAST_STMT_DATE=:b175, INT_ADJUSTMENT=:b176, ARR_INT_ADJUSTMENT=:b177, GL_CLASS_CODE=:b178, STMT_COPIES=:b179, INT_CODE=:b180, TRF_ACCT_NO=:b181, LAST_ACCT_TYPE_CHG=:b182, UNCL_NO_INT_VAL=:b183, TERM_BASIS=:b184, ARR_ACCR_AMT=:b185, FD_IND=:b186, IR_IND=:b187, IP_IND=:b188, CAP_UNPD_INT=:b189, CAP_THEO_UNPD_INT=:b190, UNPD_ARRS_INT_BAL=:b191, THEO_UNPD_ARRS_INT=:b192, UNPD_CHRG_BAL=:b193, THEO_UNPD_CHRG_BAL=:b194, UNPD_PRIN_BAL=:b195, THEO_UNPD_PRIN_BAL=:b196, NON_PERF_BAL=:b197, TOM_ACRU_AMT=:b198, UNPAID_TOM_INT=:b199, POOL_ID=:b200, POOL_DEPOSIT_DATE=:b201, CHR_EXEM_PROFILE=:b202, CHR_CNT_01=:b203, CHR_VAL_01=:b204, CHR_CNT_02=:b205, CHR_VAL_02=:b206, CHR_CNT_03=:b207, CHR_VAL_03=:b208, CHR_CNT_04=:b209, CHR_VAL_04=:b210, CHR_CNT_05=:b211, CHR_VAL_05=:b212, CHR_CNT_06=:b213, CHR_VAL_06=:b214, CHR_CNT_07=:b215, CHR_VAL_07=:b216, CHR_CNT_08=:b217, CHR_VAL_08=:b218, CHR_CNT_09=:b219, CHR_VAL_09=:b220, CHR_CNT_10=:b221, CHR_VAL_10=:b222, DRAWING_AMOUNT=:b223, SECURITY_AMOUNT=:b224, COMP_AMT=:b225, COMP_FREQUENCY=:b226, CUST_POST_MASK=:b227, MARKET_SEG_CODE=:b228, TIER_ID=:b229, CURR_RENEWAL_DT=:b230, REPAY_OPTION=:b231, EXT_CR_RATING_CODE=:b232, ACTUAL_RENEWAL_DT=:b233, LAST_UNDR_LIMIT_DT=:b234, LAST_CREDIT_DT=:b235, LAST_INT_ARR_DT=:b236, LAST_NO_INT_ARR_DT=:b237, OLD_BAD_DEBT_IND=:b238, LAST_UNDR_SECUR_DT=:b239, LAST_OVER_SECUR_DT=:b240, NPA_DATE=:b241, SCH_EXP_DT=:b242, ORI_SECURITY_VAL=:b243, EARL_STOK_CREAT_DT=:b244, COLLECTION_AMT=:b245, CAP_UNPD_INT_PY=:b246, CAP_TH_UNPD_INT_PY=:b247, PROVISION_AMOUNT=:b248, CUST_EVAL_FLAG=:b249, INCA=:b250, BKDT_INT_ADJ_IND=:b251, PASSBK_LST_LINE_NO=:b252, PASSBOOK_NO=:b253, EXTN_COUNTER=:b254, FIL_01=:b255 where KEY_1=:b256
azkycgjdmsrwb	select /*+ INDEX_ASC(DTEP DTEPPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23 from DTEP where (((INST_NO=:b24 and SYST=:b25) and DTEP_ID=:b26) and DATE_YYYYMM=:b27)
bzj8jz4b56c3f	select /*+ INDEX_ASC(CUSM CUSMPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34, :b35, :b36, :b37, :b38, :b39, :b40, :b41, :b42, :b43, :b44, :b45, :b46, :b47, :b48, :b49, :b50, :b51, :b52, :b53, :b54, :b55, :b56, :b57, :b58 from CUSM where (SOC_NO=:b59 and CUST_ACCT_NO=:b60)
cp0camudunxfv	select /*+ INDEX_ASC(RIGH RIGHPK) */ * from RIGH where ((KEY_1=:b1 and CHNG_DATE>:b2) and ROWNUM<2) order by KEY_1 asc , CHNG_DATE asc , CHNG_TIME asc
cwydgraajm81k	select /*+ INDEX_ASC(BLDVNN BLDVNNPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34, :b35, :b36, :b37, :b38, :b39, :b40, :b41, :b42, :b43, :b44, :b45, :b46, :b47, :b48, :b49, :b50, :b51, :b52, :b53, :b54, :b55, :b56, :b57, :b58, :b59, :b60, :b61, :b62, :b63, :b64, :b65, :b66, :b67, :b68, :b69, :b70, :b71, :b72, :b73, :b74, :b75, :b76, :b77, :b78, :b79, :b80, :b81, :b82, :b83, :b84, :b85, :b86, :b87, :b88, :b89, :b90, :b91, :b92, :b93, :b94, :b95, :b96, :b97, :b98, :b99, :b100, :b101, :b102, :b103, :b104, :b105, :b106, :b107, :b108, :b109, :b110, :b111 from BLDVNN where KEY_1=:b112
d8kta41txhr1m	select /*+ INDEX_ASC(RIGH RIGHPK) */ * from RIGH where (((KEY_1=:b1 and CHNG_DATE=:b2) and CHNG_TIME>:b3) and ROWNUM<2) order by KEY_1 asc , CHNG_DATE asc , CHNG_TIME asc
dyrr14c5djbwu	select /*+ FIRST_ROWS */ KEY_1 , BORVST , NO_TRN , NO_PER_TRN , REC_NO , NO_NON_FIN , SYS , BR_NO , STAT , ACT_TYPE , INT_REST , BORR_TYPE , ADD_LOAN_STAT , DISCH_REFERENCE , FCC_CLUS , REGISTRY_CODE , SECURITY_METHOD , SEC_ACCESS_IND , DISCH_FEE_CODE , INT_REPAY_FREQ , PURPOSE_CODE_A , TOM_RATE_TBL_ID , LOAN_OFFICER , PREVIOUS_OFFICER , REFERRAL_FLAG , REFERRAL_DATE , APPLIC_ISSUE_DATE , APPLIC_AMOUNT , INT_REPAY_DAY , VALUER_CODE , REPAY_COUNT , REPAY_IN_AFFECT , NO_OF_OWNER , NO_OF_MESSAGES , REPAY_DAY , REPAY_FREQ , EOY_BASIC_BAL , PEND_RATE , APP_AMT , LOAN_BAL , UNC_VAL , ADV_VAL , NPB_VAL , THEO_LOAN_BAL , INTEREST , SOP_BAL , SOP_THEO_BAL , DUE_AMT , LOAN_REPAY , PEND_DUES , EOM_THEO_BAL , EOM_BASIC_BAL , ADD_LOAN_APP , ADD_LOAN_ADV , ADD_DUES , GROUPS , SUB_GROUP , APPRV_DATE , LST_FIN_DATE , LST_MNT_DATE , ADV_DATE , DUE_STRT_DATE , ADD_DUES_STRT_DATE , LST_ARR_DATE , PEND_DUES_DATE , INT_STRT_DATE , REPAY_TYPE , PAY_DAY , RENEWAL_DATE , ATM_FLAG , INT_RATE , ADD_ADV_DATE , A DD_APPRV_DATE , BACK_DT_IND , CAT , STOP_IND , HOLD_IND , NO_UNC , NO_NPB , THEO_UNPD_TOM_INT , LOAN_TRM , REM_REPAYS , DISCH_MTHS , MISC_DR_01 , TRN_CODE_01 , LEDG_CODE_01 , SUB_LEDG_01 , MISC_DR_02 , TRN_CODE_02 , LEDG_CODE_02 , SUB_LEDG_02 , MISC_DR_03 , TRN_CODE_03 , LEDG_CODE_03 , SUB_LEDG_03 , SEGMENT_CODE , CONST_CDE , SOLICITOR_CDE , COUNCIL_CDE , SEC_LESD_CDE , INT_CDE , FINE_CDE , MPI_CDE , MORTGAGE_INSU , SPL_LOAN_CDE , RATIO_VAL_CDE , REASON_ARR_CDE , ADD_LOAN_CDE , SOURCE_CDE , INT_FLAG , LOANSAVER_IND , LOC_IND , SHRE_CAP_IND , INS_IND , INT_REST_EOFY , BAD_DEBT_IND , STOP_TRAN_IND , REDRAW_IND , SWEEP_ACCT_FLAG , RESIDUAL_IND , CSLD_STMT_PROS , INTRO_BROKER_INDIC , INT_ACCR , INT_INCR , BPI_ACCR , BPI_INCR , CI_ACCR , CI_INCR , ARR_INT_ACCR , ARR_INT_INCR , ARR_NOT_FLAG , STAMPED_AMT , REPAY_CAP_PERC , REPAY_SCHED , CAPN_METHOD , FIXED_RT_DATE , INST_NOT_DAYS , INT_CONC , INT_CONC_MOV , INT_CONC_MOV_AD , MSGS_PENDING , SEVERITY_COUNT , RT_INCR , RT_INCR_MOV , RT_INCR_MOV _AD , PRINC_REDUCT_EFF , CUSTOMER_NO , PRINC_REDUCT_PEND , OLDEST_BDATE_DATE , ADV_TOM_RATE , MAN_APP_CREDIT , CURRENCY_IND , ENDOW_EXP_DT , STMT_PAGE_NO , CROSS_BORDER_RISK , SECURITY_IND , TIME_BAND , REPAY_METHOD , INT_TAX_YTD , STORE_RATE , GRACE_EXP_DT , UNEARNED_INT , RESIDUAL_BAL , LAST_BORV_46_DATE , CR_RATING , CAFM_TYPE , DUES_RECALC_IND , BASM_RECALC_IND , PDCC_VAL , STMT_FREQUENCY , STMT_CYCLE , STMT_DAY , POSTING_MASK , REPORT_MASK , STMT_DATE_IND , LAST_STMT_DATE , INT_ADJUSTMENT , ARR_INT_ADJUSTMENT , GL_CLASS_CODE , STMT_COPIES , INT_CODE , TRF_ACCT_NO , LAST_ACCT_TYPE_CHG , UNCL_NO_INT_VAL , TERM_BASIS , ARR_ACCR_AMT , FD_IND , IR_IND , IP_IND , CAP_UNPD_INT , CAP_THEO_UNPD_INT , UNPD_ARRS_INT_BAL , THEO_UNPD_ARRS_INT , UNPD_CHRG_BAL , THEO_UNPD_CHRG_BAL , UNPD_PRIN_BAL , THEO_UNPD_PRIN_BAL , NON_PERF_BAL , TOM_ACRU_AMT , UNPAID_TOM_INT , POOL_ID , POOL_DEPOSIT_DATE , CHR_EXEM_PROFILE , CHR_CNT_01 , CHR_VAL_01 , CHR_CNT_02 , CHR_VAL_02 , CHR_CNT_03 , CHR_VAL_03 , CHR_C NT_04 , CHR_VAL_04 , CHR_CNT_05 , CHR_VAL_05 , CHR_CNT_06 , CHR_VAL_06 , CHR_CNT_07 , CHR_VAL_07 , CHR_CNT_08 , CHR_VAL_08 , CHR_CNT_09 , CHR_VAL_09 , CHR_CNT_10 , CHR_VAL_10 , DRAWING_AMOUNT , SECURITY_AMOUNT , COMP_AMT , COMP_FREQUENCY , CUST_POST_MASK , MARKET_SEG_CODE , TIER_ID , CURR_RENEWAL_DT , REPAY_OPTION , EXT_CR_RATING_CODE , ACTUAL_RENEWAL_DT , LAST_UNDR_LIMIT_DT , LAST_CREDIT_DT , LAST_INT_ARR_DT , LAST_NO_INT_ARR_DT , OLD_BAD_DEBT_IND , LAST_UNDR_SECUR_DT , LAST_OVER_SECUR_DT , NPA_DATE , SCH_EXP_DT , ORI_SECURITY_VAL , EARL_STOK_CREAT_DT , COLLECTION_AMT , CAP_UNPD_INT_PY , CAP_TH_UNPD_INT_PY , PROVISION_AMOUNT , CUST_EVAL_FLAG , INCA , BKDT_INT_ADJ_IND , PASSBK_LST_LINE_NO , PASSBOOK_NO , EXTN_COUNTER , FIL_01 , rowid from BORM where KEY_1 between :b1 and :b2
dzsjynxacg80s	SELECT "KEY_1" FROM "CSCM" "TMP_1_CSCM" WHERE "KEY_1">NVL(:1, :2)
f9jyt3tpyw0ha	SELECT BITAND(:B2 , :B1 ) FROM SYS.DUAL
ftxu44fqbahm5	update CUEV set CR_SUM=:b1, DR_SUM=:b2, CR_BAL_PROD=:b3, DR_BAL_PROD=:b4, CR_INT_ACRU=:b5, DR_INT_ACRU=:b6, CR_INT_CAP=:b7, DR_INT_CAP=:b8, CR_PEAK_BAL=:b9, DR_PEAK_BAL=:b10, DD_BC_COMM=:b11, DD_BC_PUR=:b12, SYS_GEN_INCOME_1=:b13, SYS_GEN_INCOME_2=:b14, SYS_GEN_INCOME_3=:b15, FX_SALES=:b16, FX_PUR=:b17, GOVT_BUSS_GEN=:b18, NON_FUND_LIAB=:b19, DRAWING_AMOUNT=:b20, UNPD_PRI_BAL_EOM_1=:b21, UNPD_CAP_INT_EOM_1=:b22, UNPD_ARR_INT_EOM_1=:b23, UNPD_CHG_BAL_EOM_1=:b24, MAX_ARRS_AMT_1=:b25, MAX_ARRS_DATE_1=:b26, NO_OF_DAYS_ARRS_1=:b27, NO_OF_TIMES_ARRS_1=:b28 where (((INST_NO=:b29 and ACCT_NO=:b30) and SYSTEM=:b31) and FIN_YEAR=:b32)
fu9qbqhb93mrk	select /*+ INDEX_ASC(RIGH RIGHPK) */ * from RIGH where (KEY_1>:b1 and ROWNUM<2) order by KEY_1 asc , CHNG_DATE asc , CHNG_TIME asc

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Key Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Other 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