WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

SSTF505 2341272558 sstf505 1 10.2.0.4.0 NO sstfsrv1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
SSTF505	2341272558	sstf505	1	10.2.0.4.0	NO	sstfsrv1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 54501 23-Dec-14 10:00:52 192 2.8

End Snap: 54502 23-Dec-14 11:00:30 225 3.6

Elapsed: 59.64 (mins)

DB Time: 228.63 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	54501	23-Dec-14 10:00:52	192	2.8
End Snap:	54502	23-Dec-14 11:00:30	225	3.6
Elapsed:		59.64 (mins)
DB Time:		228.63 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 6,512M 6,512M Std Block Size: 8K

Shared Pool Size: 9,808M 9,808M Log Buffer: 14,316K

	Begin	End
Buffer Cache:	6,512M	6,512M	Std Block Size:	8K
Shared Pool Size:	9,808M	9,808M	Log Buffer:	14,316K

Load Profile

Per Second Per Transaction

Redo size: 73,602.33 1,956.69

Logical reads: 83,141.45 2,210.29

Block changes: 367.01 9.76

Physical reads: 9.71 0.26

Physical writes: 6.77 0.18

User calls: 858.72 22.83

Parses: 265.94 7.07

Hard parses: 4.51 0.12

Sorts: 105.54 2.81

Logons: 0.11 0.00

Executes: 266.80 7.09

Transactions: 37.62

	Per Second	Per Transaction
Redo size:	73,602.33	1,956.69
Logical reads:	83,141.45	2,210.29
Block changes:	367.01	9.76
Physical reads:	9.71	0.26
Physical writes:	6.77	0.18
User calls:	858.72	22.83
Parses:	265.94	7.07
Hard parses:	4.51	0.12
Sorts:	105.54	2.81
Logons:	0.11	0.00
Executes:	266.80	7.09
Transactions:	37.62

% Blocks changed per Read: 0.44 Recursive Call %: 16.95

Rollback per transaction %: 0.19 Rows per Sort: 69.09

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

Buffer Hit %: 99.99 In-memory Sort %: 100.00

Library Hit %: 95.84 Soft Parse %: 98.30

Execute to Parse %: 0.32 Latch Hit %: 91.03

Parse CPU to Parse Elapsd %: 3.18 % Non-Parse CPU: 96.19

Shared Pool Statistics

Begin End

Memory Usage %: 92.36 91.77

% SQL with executions>1: 93.94 95.37

% Memory for SQL w/exec>1: 94.54 95.43

	Begin	End
Memory Usage %:	92.36	91.77
% SQL with executions>1:	93.94	95.37
% Memory for SQL w/exec>1:	94.54	95.43

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

CPU time 4,218 30.8

latch: shared pool 17,135 1,925 112 14.0 Concurrency

latch: library cache 17,984 1,614 90 11.8 Concurrency

cursor: pin S wait on X 71,119 721 10 5.3 Concurrency

latch free 1,288 168 130 1.2 Other

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		4,218		30.8
latch: shared pool	17,135	1,925	112	14.0	Concurrency
latch: library cache	17,984	1,614	90	11.8	Concurrency
cursor: pin S wait on X	71,119	721	10	5.3	Concurrency
latch free	1,288	168	130	1.2	Other

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
init.ora Parameters

Time Model Statistics

Total time in database user-calls (DB Time): 13717.7s
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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	7,251.44	52.86
parse time elapsed	4,993.18	36.40
DB CPU	4,218.27	30.75
hard parse elapsed time	2,055.42	14.98
PL/SQL execution elapsed time	34.37	0.25
connection management call elapsed time	24.75	0.18
hard parse (sharing criteria) elapsed time	20.36	0.15
hard parse (bind mismatch) elapsed time	18.75	0.14
failed parse elapsed time	16.36	0.12
sequence load elapsed time	7.97	0.06
PL/SQL compilation elapsed time	2.72	0.02
repeated bind elapsed time	0.00	0.00
DB time	13,717.71
background elapsed time	475.67
background cpu time	30.44

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
Concurrency	646,040	10.99	4,372	7	4.80
Other	2,547,942	0.01	185	0	18.93
System I/O	147,727	0.00	142	1	1.10
Commit	138,228	0.00	138	1	1.03
User I/O	29,855	0.00	119	4	0.22
Network	2,241,877	0.00	4	0	16.66
Configuration	31	77.42	1	29	0.00
Application	1,546	0.00	1	1	0.01

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
latch: shared pool	17,135	0.00	1,925	112	0.13
latch: library cache	17,984	0.00	1,614	90	0.13
cursor: pin S wait on X	71,119	99.87	721	10	0.53
latch free	1,288	0.00	168	130	0.01
log file sync	138,228	0.00	138	1	1.03
log file parallel write	138,945	0.00	112	1	1.03
db file sequential read	23,911	0.00	99	4	0.18
latch: cache buffers chains	6,467	0.00	95	15	0.05
db file scattered read	4,435	0.00	16	4	0.03
kksfbc child completion	334	92.22	15	46	0.00
db file parallel write	1,528	0.00	11	7	0.01
log file sequential read	282	0.00	10	35	0.00
control file parallel write	1,727	0.00	6	4	0.01
buffer busy waits	61	6.56	6	99	0.00
latch: row cache objects	192	0.00	6	31	0.00
read by other session	1,039	0.00	5	4	0.01
os thread startup	15	13.33	3	195	0.00
SQL*Net more data to client	79,631	0.00	2	0	0.59
Log archive I/O	282	0.00	2	8	0.00
SQL*Net message to client	2,160,141	0.00	2	0	16.05
cursor: pin S	2,545,921	0.00	2	0	18.92
log file switch completion	7	0.00	1	130	0.00
SQL*Net break/reset to client	1,546	0.00	1	1	0.01
latch: library cache lock	9	0.00	1	97	0.00
cursor: mutex S	383,900	0.00	1	0	2.85
LGWR wait for redo copy	351	2.28	0	1	0.00
enq: CF - contention	2	0.00	0	105	0.00
cursor: mutex X	149,157	0.00	0	0	1.11
direct path read	338	0.00	0	1	0.00
control file sequential read	4,957	0.00	0	0	0.04
rdbms ipc reply	26	0.00	0	2	0.00
latch: session allocation	4	0.00	0	13	0.00
SQL*Net more data from client	2,105	0.00	0	0	0.02
latch: redo allocation	9	0.00	0	3	0.00
direct path write	132	0.00	0	0	0.00
log file single write	6	0.00	0	1	0.00
latch: object queue header operation	2	0.00	0	0	0.00
undo segment extension	24	100.00	0	0	0.00
latch: enqueue hash chains	1	0.00	0	0	0.00
latch: undo global data	1	0.00	0	0	0.00
row cache lock	1	0.00	0	0	0.00
buffer deadlock	3	100.00	0	0	0.00
SQL*Net message from client	2,160,106	0.00	592,191	274	16.05
Streams AQ: qmn coordinator idle wait	259	50.97	3,467	13385	0.00
Streams AQ: qmn slave idle wait	127	0.00	3,467	27296	0.00
jobq slave wait	1,187	95.96	3,448	2904	0.01
Streams AQ: waiting for time management or cleanup tasks	2	100.00	792	395916	0.00
class slave wait	2	0.00	0	4	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	138,939	0.00	112	1	1.03
latch: shared pool	242	0.00	52	216	0.00
latch: library cache	171	0.00	33	196	0.00
db file parallel write	1,527	0.00	11	7	0.01
log file sequential read	282	0.00	10	35	0.00
control file parallel write	1,727	0.00	6	4	0.01
os thread startup	15	13.33	3	195	0.00
Log archive I/O	282	0.00	2	8	0.00
events in waitclass Other	391	2.05	1	2	0.00
db file sequential read	21	0.00	0	9	0.00
control file sequential read	4,251	0.00	0	0	0.03
latch: cache buffers chains	5	0.00	0	6	0.00
buffer busy waits	6	0.00	0	5	0.00
direct path write	27	0.00	0	1	0.00
direct path read	27	0.00	0	0	0.00
log file single write	6	0.00	0	1	0.00
rdbms ipc message	149,929	7.52	36,661	245	1.11
pmon timer	1,207	98.67	3,495	2896	0.01
Streams AQ: qmn coordinator idle wait	259	50.97	3,467	13385	0.00
Streams AQ: qmn slave idle wait	127	0.00	3,467	27296	0.00
smon timer	24	29.17	3,351	139607	0.00
Streams AQ: waiting for time management or cleanup tasks	2	100.00	792	395916	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	121,128
AVG_IDLE_TIME	236,794
AVG_IOWAIT_TIME	40,277
AVG_SYS_TIME	6,468
AVG_USER_TIME	114,543
BUSY_TIME	969,814
IDLE_TIME	1,895,208
IOWAIT_TIME	322,974
SYS_TIME	52,597
USER_TIME	917,217
LOAD	0
OS_CPU_WAIT_TIME	1,080,700
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,621,540,864
NUM_CPUS	8
NUM_CPU_CORES	4

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
sstf505	13,490.00	4,152.20	33,989	295,896,456
SYS$USERS	220.70	62.10	608	1,284,159
SYS$BACKGROUND	0.00	0.00	130	29,989

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 centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
sstf505	29091	11656	644815	416639	2239556	423
SYS$USERS	568	181	543	7544	1117	0
SYS$BACKGROUND	196	59	437	8862	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
190	133	177	1.07	1.38	bqw1mnb4jj3x6	td2soci@sstfsrv1 (TNS V1-V3)	SELECT WFSINR, WFSSUB, STA, ...
158	123	335	0.47	1.15	6ngschdubbuuv	td2soci@sstfsrv1 (TNS V1-V3)	select cur from xrt where to_c...
158	65	37	4.27	1.15	3pyhj5nz5g015	td2soci@sstfsrv1 (TNS V1-V3)	select distinct(substr(trim(ex...
114	24	63,859	0.00	0.83	3bmfazzhuzcz1	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO LCK ( LCKSTR, LCK...
114	13	49,656	0.00	0.83	5hbp28fq03mbx	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM LCK WHERE LCKSTR =...
107	38	5,234	0.02	0.78	ddstpsqy9rpfa	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR FROM NTF WHERE ( SS...
98	67	38	2.59	0.72	5y56rkabsj5q4	td2soci@sstfsrv1 (TNS V1-V3)	select distinct(substr(trim(ex...
93	24	174,535	0.00	0.68	529br8svudttu	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM LCK WHERE LCKSNR =...
80	4	1	79.66	0.58	gdxznwrva1x55	td2soci@sstfsrv1 (TNS V1-V3)	SELECT 'FIN', TO_CHAR(GL.COMDA...
60	3	2	30.17	0.44	0dt92qcmxx562	Golden32.exe	select * from acf where ownref...

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 DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
133	190	177	0.75	1.38	bqw1mnb4jj3x6	td2soci@sstfsrv1 (TNS V1-V3)	SELECT WFSINR, WFSSUB, STA, ...
123	158	335	0.37	1.15	6ngschdubbuuv	td2soci@sstfsrv1 (TNS V1-V3)	select cur from xrt where to_c...
67	98	38	1.76	0.72	5y56rkabsj5q4	td2soci@sstfsrv1 (TNS V1-V3)	select distinct(substr(trim(ex...
65	158	37	1.77	1.15	3pyhj5nz5g015	td2soci@sstfsrv1 (TNS V1-V3)	select distinct(substr(trim(ex...
38	107	5,234	0.01	0.78	ddstpsqy9rpfa	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR FROM NTF WHERE ( SS...
35	60	60	0.59	0.44	bnfwkpwbvmg4u	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO CMI ( INR, OWNREF...
35	58	60	0.59	0.42	cvqj8skq9ndtg	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM CMI WHERE ROWID IN...
33	41	67	0.49	0.30	g399fybscrt6m	td2soci@sstfsrv1 (TNS V1-V3)	SELECT COUNT(*) from SPT WHERE...
29	37	30	0.98	0.27	9jmrmj85jvjan		INSERT INTO XS_XRT VALUE (SELE...
27	37	2	13.54	0.27	fta1srvxh0vyh	td2soci@sstfsrv1 (TNS V1-V3)	select distinct cmdpep, cmdpep...

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: 297,498,319
Captured SQL account for 16.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
8,756,075	177	49,469.35	2.94	132.93	189.78	bqw1mnb4jj3x6	td2soci@sstfsrv1 (TNS V1-V3)	SELECT WFSINR, WFSSUB, STA, ...
5,797,189	5,234	1,107.60	1.95	38.00	107.18	ddstpsqy9rpfa	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR FROM NTF WHERE ( SS...
4,092,793	695	5,888.91	1.38	22.38	36.00	6jbxqc4j15kkf	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, TRNINR, EVTTXT F...
3,846,519	37	103,959.97	1.29	65.44	158.00	3pyhj5nz5g015	td2soci@sstfsrv1 (TNS V1-V3)	select distinct(substr(trim(ex...
3,846,484	38	101,223.26	1.29	66.99	98.27	5y56rkabsj5q4	td2soci@sstfsrv1 (TNS V1-V3)	select distinct(substr(trim(ex...
2,436,547	2	1,218,273.50	0.82	27.08	37.17	fta1srvxh0vyh	td2soci@sstfsrv1 (TNS V1-V3)	select distinct cmdpep, cmdpep...
1,253,408	524	2,392.00	0.42	12.07	17.46	48c8u9p49xv1q	td2soci@sstfsrv1 (TNS V1-V3)	select extkey from dct where c...
1,207,670	1	1,207,670.00	0.41	13.13	15.61	5nnndu3rypmvn	td2soci@sstfsrv1 (TNS V1-V3)	select distinct cmdpep, cmdpep...
1,207,608	1	1,207,608.00	0.41	13.85	34.59	86kjqrwgmwds7	td2soci@sstfsrv1 (TNS V1-V3)	select distinct cmdpep, cmdpep...
1,206,584	1	1,206,584.00	0.41	12.64	17.16	4u76qt2s50bpf	td2soci@sstfsrv1 (TNS V1-V3)	select distinct cmdpep, cmdpep...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 34,744
Captured SQL account for 80.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
19,972	2	9,986.00	57.48	2.59	60.34	0dt92qcmxx562	Golden32.exe	select * from acf where ownref...
2,523	1	2,523.00	7.26	13.85	34.59	86kjqrwgmwds7	td2soci@sstfsrv1 (TNS V1-V3)	select distinct cmdpep, cmdpep...
1,655	37	44.73	4.76	65.44	158.00	3pyhj5nz5g015	td2soci@sstfsrv1 (TNS V1-V3)	select distinct(substr(trim(ex...
1,433	1	1,433.00	4.12	4.14	79.66	gdxznwrva1x55	td2soci@sstfsrv1 (TNS V1-V3)	SELECT 'FIN', TO_CHAR(GL.COMDA...
583	2	291.50	1.68	4.46	49.08	572fbaj0fdw2b	sqlplus@sstfsrv1 (TNS V1-V3)	select output from table(dbms_...
537	8	67.13	1.55	11.43	51.44	b6g5845t0pr3c	td2soci@sstfsrv1 (TNS V1-V3)	select distinct(substr(trim(ex...
377	1	377.00	1.09	1.26	40.60	gx1pz1011jbmv	td2soci@sstfsrv1 (TNS V1-V3)	select DISTINCT A.OWNREF, A.IN...
197	1	197.00	0.57	4.04	36.78	br9kvc7p7tums	td2soci@sstfsrv1 (TNS V1-V3)	SELECT X.OBJINR, X.OBJTYP, X...
99	38	2.61	0.28	66.99	98.27	5y56rkabsj5q4	td2soci@sstfsrv1 (TNS V1-V3)	select distinct(substr(trim(ex...
68	1	68.00	0.20	4.84	33.67	f38ztwsazgmf8	td2soci@sstfsrv1 (TNS V1-V3)	SELECT 'SET', TO_CHAR(F.DONDA...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 954,661
Captured SQL account for 89.2% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
215,843	0	0.00	anpw5shtv1m86	td2soci@sstfsrv1 (TNS V1-V3)	select smhinr from ned where s...
174,535	13,116	0.08	529br8svudttu	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM LCK WHERE LCKSNR =...
174,202	174,202	1.00	98f93q0w2732s	td2soci@sstfsrv1 (TNS V1-V3)	select MSGTYP, SNDKEY, RELCU...
63,859	63,674	1.00	3bmfazzhuzcz1	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO LCK ( LCKSTR, LCK...
49,656	49,655	1.00	5hbp28fq03mbx	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM LCK WHERE LCKSTR =...
39,415	39,415	1.00	93hyuhdd8w198	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, OBJTYP, OBJINR, ...
21,079	20,726	0.98	d7gzc3tkjsvjg	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, INIDATTIM, INIFR...
16,818	122,603	7.29	fytufwfc4tm67	td2soci@sstfsrv1 (TNS V1-V3)	SELECT WFSINR, WFSSUB, SRV, ...
16,500	16,500	1.00	gft02zzrfnvus	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, OBJTYP, OBJINR, ...
10,420	10,420	1.00	2wkqpwk877aaw	td2soci@sstfsrv1 (TNS V1-V3)	UPDATE WFE SET WFSINR = :V0, ...
10,034	10,034	1.00	3wxx06muk7ccx	td2soci@sstfsrv1 (TNS V1-V3)	SELECT WFSINR, WFSSUB, SRV, ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 951,594
Captured SQL account for 89.5% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
215,809	215,843	22.68	anpw5shtv1m86	td2soci@sstfsrv1 (TNS V1-V3)	select smhinr from ned where s...
174,504	174,535	18.34	529br8svudttu	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM LCK WHERE LCKSNR =...
174,202	174,202	18.31	98f93q0w2732s	td2soci@sstfsrv1 (TNS V1-V3)	select MSGTYP, SNDKEY, RELCU...
63,859	63,859	6.71	3bmfazzhuzcz1	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO LCK ( LCKSTR, LCK...
49,656	49,656	5.22	5hbp28fq03mbx	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM LCK WHERE LCKSTR =...
39,415	39,415	4.14	93hyuhdd8w198	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, OBJTYP, OBJINR, ...
21,079	21,079	2.22	d7gzc3tkjsvjg	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, INIDATTIM, INIFR...
16,818	16,818	1.77	fytufwfc4tm67	td2soci@sstfsrv1 (TNS V1-V3)	SELECT WFSINR, WFSSUB, SRV, ...
16,500	16,500	1.73	gft02zzrfnvus	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, OBJTYP, OBJINR, ...
10,420	10,420	1.10	2wkqpwk877aaw	td2soci@sstfsrv1 (TNS V1-V3)	UPDATE WFE SET WFSINR = :V0, ...
10,034	10,034	1.05	3wxx06muk7ccx	td2soci@sstfsrv1 (TNS V1-V3)	SELECT WFSINR, WFSSUB, SRV, ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
56	157	5p8jryq7s0rkt	td2soci@sstfsrv1 (TNS V1-V3)	UPDATE PTS SET INR = :V0, OBJ...
49	2	5qfwxdxpvmdt4	td2soci@sstfsrv1 (TNS V1-V3)	UPDATE CORPTY SET INR = :V0, ...
48	10,420	2wkqpwk877aaw	td2soci@sstfsrv1 (TNS V1-V3)	UPDATE WFE SET WFSINR = :V0, ...
24	60	bnfwkpwbvmg4u	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO CMI ( INR, OWNREF...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0dt92qcmxx562 select * from acf where ownref='ZJP2010LG00010' order by inr desc

2wkqpwk877aaw UPDATE WFE SET WFSINR = :V0, WFSSUB = :V1, SRV = :V2, STA = :V3, RTYCNT = :V4, TARDATTIM = :V5, SSNINR = :V6, DATTIM = :V7, TXT = :V8, MANFLG = :V9, OPNDUR = :V10, WAIDUR = :V11, RETDUR = :V12, HDLDUR = :V13, BCHKEYINR = :V14 WHERE WFSINR = :W0 AND WFSSUB = :W1

3bmfazzhuzcz1 INSERT INTO LCK ( LCKSTR, LCKUSR, LCKSNR, LCKDATTIM, LCKHLD ) VALUES ( :1, :2, :3, :4, :5 )

3pyhj5nz5g015 select distinct(substr(trim(expses), -4)) from gle where branchinr='00000017' and to_char(bucdat, 'YYYYMMDD')='20141223' and substr(trim(expses), 1, 1)='A' order by substr(trim(expses), -4) desc

3wxx06muk7ccx SELECT WFSINR, WFSSUB, SRV, STA, RTYCNT, TARDATTIM, SSNINR, DATTIM, TXT, MANFLG, OPNDUR, WAIDUR, RETDUR, HDLDUR, BCHKEYINR FROM WFE WHERE WFSINR = :W0 AND WFSSUB = :W1

48c8u9p49xv1q select extkey from dct where cur='EUR' and subcod in ('215001') and bch='2120' order by inr

4u76qt2s50bpf select distinct cmdpep, cmdpep1, cmdtwo, cmdtwo1, crdprd, objtyp, objinr, ownref, prjnam, cur, maxamt, cmdpsn from cmi where ( cmdpep= 'CLD' or cmdtwo='CLD') and BEGDAT >=TO_DATE('2014-06-26', 'YYYY-MM-DD')and( INR IN ( select c.inr from x_fcd x, cmi c where x.ownref=c.ownref) ) ORDER BY OWNREF

529br8svudttu DELETE FROM LCK WHERE LCKSNR = :1 AND LCKHLD = :2

572fbaj0fdw2b select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))

5hbp28fq03mbx DELETE FROM LCK WHERE LCKSTR = :1

5nnndu3rypmvn select distinct cmdpep, cmdpep1, cmdtwo, cmdtwo1, crdprd, objtyp, objinr, ownref, prjnam, cur, maxamt, cmdpsn from cmi where ( cmdpep= 'CLD' or cmdtwo='CLD') and BEGDAT >=TO_DATE('2014-01-01', 'YYYY-MM-DD')and( INR IN ( select c.inr from x_fcd x, cmi c where x.ownref=c.ownref) ) ORDER BY OWNREF

5p8jryq7s0rkt UPDATE PTS SET INR = :V0, OBJTYP = :V1, OBJINR = :V2, ROL = :V3, PTAINR = :V4, PTYINR = :V5, EXTKEY = :V6, ADRBLK = :V7, REF = :V8, NAM = :V9, OWNREF = :V10, DFTCUR = :V11, DFTDSP = :V12, DFTACT = :V13, DFTFEECUR = :V14, DFTACTPTAINR = :V15, GLGGRPFLG = :V16, EXTACT = :V17, VER = :V18, ISSBANINF = :V19, BANKNO = :V20, CORCOD = :V21 WHERE INR = :W0

5qfwxdxpvmdt4 UPDATE CORPTY SET INR = :V0, NAM = :V1, PTYTYP = :V2, SLA = :V3, BRANCHINR = :V4, JUSCOD = :V5, IDCODE = :V6, IDTYPE = :V7, CTVC = :V8, CRDCNT = :V9, CLIENTID = :V10, UIL = :V11, NAM1 = :V12, NAM2 = :V13, NAM3 = :V14, LOCCTY = :V15, EXTKEY = :V16, FLG = :V17, STR1 = :V18, STR2 = :V19, LOCZIP = :V20, CORTYP = :V21, FAX1 = :V22, INIFRM = :V23 WHERE INR = :W0

5y56rkabsj5q4 select distinct(substr(trim(expses), -4)) from gle where branchinr='00000017' and to_char(bucdat, 'YYYYMMDD')='20141223' and substr(trim(expses), 1, 1)='C' order by substr(trim(expses), -4) desc

6jbxqc4j15kkf SELECT INR, TRNINR, EVTTXT FROM TRNEVT WHERE TRNINR = :W0

6ngschdubbuuv select cur from xrt where to_char(begdat, 'YYYYMMDD')=:W0

86kjqrwgmwds7 select distinct cmdpep, cmdpep1, cmdtwo, cmdtwo1, crdprd, objtyp, objinr, ownref, prjnam, cur, maxamt, cmdpsn from cmi where ( cmdpep= 'CLD' or cmdtwo='CLD') and BEGDAT >=TO_DATE('2013-12-23', 'YYYY-MM-DD')and( INR IN ( select c.inr from x_fcd x, cmi c where x.ownref=c.ownref) ) ORDER BY OWNREF

93hyuhdd8w198 SELECT INR, OBJTYP, OBJINR, OBJNAM, OBJREF, TXT, DATTIM, USR, SSNINR, FRM, PAN, STA, DELFLG, HLDFLG, INFDSP, INFTXT, OWNUSG, OWNUSR, SMHINR, MAPFLG, CRETRN, ORDINR, TARDATTIM, CREOBJTYP, CREOBJINR, TRLGRP, RELCUR, RELAMT, ETGEXTKEY, ETYEXTKEY, PTAINR, PAYFLG, WRKGRP, WRKUSR, BCHKEYINR FROM SPT WHERE INR = :W0

98f93q0w2732s select MSGTYP, SNDKEY, RELCUR, RELAMT from SMH where INR = :W0

9jmrmj85jvjan INSERT INTO XS_XRT VALUE (SELECT * FROM XRT WHERE INR IN( SELECT MIN(INR) FROM XRT GROUP BY TO_CHAR(BEGDAT, 'YYYYMM'), CUR)AND INR NOT IN(SELECT INR FROM XS_XRT))

anpw5shtv1m86 select smhinr from ned where smhinr = ''

b6g5845t0pr3c select distinct(substr(trim(expses), -4)) from gle where branchinr='00000005' and to_char(bucdat, 'YYYYMMDD')='20141223' and substr(trim(expses), 1, 1)='A' order by substr(trim(expses), -4) desc

bnfwkpwbvmg4u INSERT INTO CMI ( INR, OWNREF, VER, OBJTYP, OBJINR, PRJNAM, CNTNUM, CMDPSN, CMDPEP, CMDPEP1, CRDPRD, DETAIL, DEPNUB, BEGDAT, STACTY, CUR, MAXAMT, OPNAMT, REPINR, GARTYP, SECSTA, TRNINR, TRNSTA, BCHKEYINR, BRANCHINR, CMDTWO, CMDTWO1, RESULT, INONUM, INNTRN, USDAMT, LOAN, FINCOD, BRNCOD, YESORNO, RATTYP, RATLEV, NEWFIELD, CMDPSN1 ) VALUES ( :V0, :V1, :V2, :V3, :V4, :V5, :V6, :V7, :V8, :V9, :V10, :V11, :V12, :V13, :V14, :V15, :V16, :V17, :V18, :V19, :V20, :V21, :V22, :V23, :V24, :V25, :V26, :V27, :V28, :V29, :V30, :V31, :V32, :V33, :V34, :V35, :V36, :V37, :V38 )

bqw1mnb4jj3x6 SELECT WFSINR, WFSSUB, STA, RTYCNT, TARDATTIM FROM WFE WHERE( STA = 'W' or STA = 'R' ) and ( SRV = 'PRT' OR SRV = 'PDS' OR SRV = 'PDP' OR SRV = 'COM' OR SRV = 'PRR' OR SRV = 'SWT' OR SRV = 'TCO' OR SRV = 'TLX' OR SRV = 'PDA' OR SRV = 'PRS' OR SRV = 'SEP' OR SRV = 'RTG' OR SRV = 'TAR' OR SRV = 'DTE' OR SRV = 'DTA' OR SRV = 'EML' OR SRV = 'TXT' OR SRV = 'PDL' OR SRV = 'FIN' OR SRV = 'BOL' OR SRV = 'PDD' OR SRV = 'IZV' OR SRV = 'CCS' OR SRV = 'PDC' OR SRV = 'REL' OR SRV = 'EDI' OR SRV = 'DTF' ) order BY RTYCNT

br9kvc7p7tums SELECT X.OBJINR, X.OBJTYP, X.OWNREF, X.CUR, X.AMT, X.MIDRAT, X.RAT, TO_CHAR(X.VALDAT, 'YYYY-MM-DD'), X.CMDPET, X.CMDTWO, P.NAM1, TRNMAN, X.TRDTYP, TRDWAY, BNKCOD, CASE SUBSTR(F.FCDTYP, 2, 1) WHEN 'B' THEN J.CUSTCOD WHEN 'S' THEN W.CUSTCOD ELSE '' END, CASE SUBSTR(F.FCDTYP, 2, 1) WHEN 'B' THEN V.TXCODE WHEN 'S' THEN Y.TXCODE ELSE '' END FROM X_FCD X, PTY P, FCD F LEFT JOIN DBJ J ON F.OWNREF = J.BUSCODE LEFT JOIN DBV V ON J.RPTNO = V.RPTNO LEFT JOIN DBW W ON F.OWNREF = W.BUSCODE LEFT JOIN DBY Y ON W.RPTNO = Y.RPTNO WHERE X.OBJTYP='FCD' AND X.OBJINR=F.INR AND F.APLPTYINR=P.INR and X.VALDAT >=TO_DATE ('20141222', 'YYYYMMDD') ORDER BY X.OWNREF

cvqj8skq9ndtg DELETE FROM CMI WHERE ROWID IN(SELECT MIN(ROWID) FROM CMI GROUP BY OWNREF HAVING COUNT(*)>1)

d7gzc3tkjsvjg SELECT INR, INIDATTIM, INIFRM, INIUSR, ININAM, OWNREF, OBJTYP, OBJINR, OBJNAM, SSNINR, SMHNXT, USG, USR, CPLDATTIM, INFDSP, INFTXT, RELFLG, COMFLG, COMDAT, CORTRNINR, XREFLG, XRECURBLK, RELCUR, RELAMT, RELORICUR, RELORIAMT, RELREQ, RELRES, CNFFLG, EVTTXT, RPRUSR, ORDINR, EXEDAT, ETYEXTKEY, BCHKEYINR, ACCBCHINR, TRXSQNB, TRXSQNBADD, ACCSNDFLG, TRXSQNBPP FROM TRN WHERE INR = :W0

ddstpsqy9rpfa SELECT INR FROM NTF WHERE ( SSNINR = :W0 OR USR = :W1 ) AND SHWSSNINR = ' ' ORDER BY INR

f38ztwsazgmf8 SELECT 'SET', TO_CHAR(F.DONDAT, 'MM'), SUM(1*F.AMT*XR.MIDRAT*XG.REDUCE)/10000 FROM FEP F, CMI M, TRN T, REPXRT XR, XRTCHG XG WHERE F.DONTRNINR=T.INR AND F.OBJTYP IN('BCD', 'BED', 'BOD', 'BRD', 'BTD', 'CPD', 'FCD', 'LTD', 'LED', 'LID', 'MCD') AND F.FEEACC IN('506001', '506003', '506012', '506099') AND T.RELFLG IN('F', 'R') AND T.OBJTYP=M.OBJTYP AND T.OWNREF NOT LIKE '%WS%' AND T.OBJINR=M.OBJINR AND M.BCHKEYINR='00000008' AND TO_CHAR(F.DONDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(F.DONDAT, 'YYYY')='2014' AND F.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'SET', TO_CHAR(F.DONDAT, 'MM') UNION SELECT 'SET', TO_CHAR(F.DONDAT, 'MM'), SUM(1*F.AMT*XR.MIDRAT*XG.REDUCE)/10000 FROM FEP F, CMI M, TRN T, REPXRT XR, XRTCHG XG WHERE F.DONTRNINR=T.INR AND F.FEEACC IN('507001', '507002') AND T.RELFLG IN('F', 'R') AND T.OBJTYP=M.OBJTYP AND T.OBJINR=M.OBJINR AND M.BCHKEYINR='00000008' AND TO_CHAR(F.DONDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(F.DONDAT, 'YYYY')='2014' AND F.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'SET', TO_CHAR(F.DONDAT, 'MM') UNION SELECT 'SET', TO_CHAR(F.DONDAT, 'MM'), SUM(1*F.AMT*XR.MIDRAT*XG.REDUCE)/10000 FROM FEP F, TRN T, REPXRT XR, XRTCHG XG WHERE F.DONTRNINR=T.INR AND F.OBJTYP IN('BCD', 'BED', 'BOD', 'BRD', 'BTD', 'CPD', 'FCD', 'LTD', 'LED', 'LID', 'MCD') AND F.FEEACC IN('506001', '506003', '506012', '506099') AND T.RELFLG IN('F', 'R') AND T.OWNREF LIKE '%WS%' and t.bch keyinr='00000008' AND TO_CHAR(F.DONDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(F.DONDAT, 'YYYY')='2014' AND F.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'SET', TO_CHAR(F.DONDAT, 'MM') UNION SELECT 'FIN', TO_CHAR(F.DONDAT, 'MM'), SUM(1*F.AMT*XR.MIDRAT*XG.REDUCE)/10000 FROM FEP F, CMI M, TRN T, REPXRT XR, XRTCHG XG WHERE F.DONTRNINR=T.INR AND F.OBJTYP IN('BPD', 'DFD', 'EFD', 'EPD', 'ERD', 'FBD', 'FMD', 'FPD', 'FRD', 'PFD', 'TRD', 'FID') AND F.FEEACC IN('506001', '506003', '506012', '506099') AND T.RELFLG IN('F', 'R') AND T.OBJTYP=M.OBJTYP AND T.OBJINR=M.OBJINR AND M.BCHKEYINR='00000008' AND TO_CHAR(F.DONDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(F.DONDAT, 'YYYY')='2014' AND F.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'FIN', TO_CHAR(F.DONDAT, 'MM') UNION SELECT 'GID', TO_CHAR(F.DONDAT, 'MM'), SUM(1*F.AMT*XR.MIDRAT*XG.REDUCE)/10000 FROM FEP F, CMI M, TRN T, REPXRT XR, XRTCHG XG WHERE F.DONTRNINR=T.INR AND F.OBJTYP IN('GID', 'GCD') AND F.FEEACC IN('506001', '506003', '506012', '506099') AND T.RELFLG IN('F', 'R') AND T.OBJTYP=M.OBJTYP AND T.OBJINR=M.OBJINR AND M.BCHKEYINR='00000008' AND TO_CHAR(F.DONDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(F.DONDAT, 'YYYY')='2014' AND F.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'GID', TO_CHAR(F.DONDAT, 'MM') UNION SELECT 'GID', TO_CHAR(GL.COMDAT, 'MM'), SUM(1*GL.AMT*XR.MIDRAT*XG.REDUCE)/10000 FROM (SELECT G.CUR AS CUR, DECODE(G.DBTCDT, 'C', G.AMT, 'D', -G.AMT) AS AMT, G.VALDAT AS VALDAT, T.COMDAT AS COMDAT, T.BCHKEYINR AS BCHKEYINR, T.OBJTYP AS OBJTYP, T.OBJINR AS OBJINR FROM GLE G, DCT D, TRN T WHERE TRIM(G.ACT)=TRIM(D.EXTKEY) AND TRIM(D.SUBCOD) ='506004' AND G.TRNINR=T.INR and t.bchkeyinr='00000008' AND T.RELFLG IN('F', 'R') AND G.OBJTYP IN ('GID', 'GCD')) GL, REPXRT XR, XRTCHG XG WHERE TO_CHAR(GL.COMDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(GL.COMDAT, 'YYYY')='2014' AND GL.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'GID', TO_CHAR(GL.COMDAT, 'MM') UNION SELECT 'GID', TO_CHAR(GL.COMDAT, 'MM'), SUM(1*GL.AMT*XR.MIDRAT*XG.REDUCE)/10000 FROM (SELECT F.INTCUR AS CUR, F.INTAMT AS AMT, F.INTDAT AS COMDAT, F.BCHKEYINR AS BCHKEYINR, E.OWNREF FROM ACF F, ACE E, CMI I, TRN T WHERE E.OWNREF=I.OWNREF AND F.ACEINR=E.INR AND F.TRNINR=T.INR AND T.TRXSQNB<>' ' AND F.GLEINR<>'A0000001' AND I.OBJTYP IN ('GID', 'GCD')) GL, CMI M, REPXRT XR, XRTCHG XG WHERE TO_CHAR(GL.COMDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(GL.COMDAT, 'YYYY')='2014' AND GL.OWNREF=M.OWNREF AND M.BCHKEYINR='00000008' AND GL.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'GID', TO_CHAR(GL.COMDAT, 'MM') union select 'OTH', to_char(f.credat, 'mm'), sum(f.flxamt*xr.midrat*xg.reduce)/10000 from rephis f, repxrt xr, xrtchg xg where f.bchkeyinr = '00000008' and f.flxcur=xr.cur and xr.cur=xg.cur and to_char(f.credat, 'yyyymmdd') <= '20141222' and to_char(f.credat, 'yyyy') = '2014' and to_char(xr.begdat, 'yyyymmdd') = '20141222' group by to_char(f.credat, 'mm')

fta1srvxh0vyh select distinct cmdpep, cmdpep1, cmdtwo, cmdtwo1, crdprd, objtyp, objinr, ownref, prjnam, cur, maxamt, cmdpsn from cmi where ( cmdpep= 'CLD' or cmdtwo='CLD') and( INR IN ( select c.inr from x_fcd x, cmi c where x.ownref=c.ownref) ) ORDER BY OWNREF

fytufwfc4tm67 SELECT WFSINR, WFSSUB, SRV, STA, RTYCNT, TARDATTIM, SSNINR, DATTIM, TXT, MANFLG, OPNDUR, WAIDUR, RETDUR, HDLDUR, BCHKEYINR FROM WFE where WFSINR = :W0

g399fybscrt6m SELECT COUNT(*) from SPT WHERE ( ETYEXTKEY = 'EIBANK' and ETGEXTKEY = 'EIBANKG' ) and ( ( (STA = 'INC' and DELFLG = ' ') ) AND ( OWNUSG = '360000' OR OWNUSR in ( SELECT EXTKEY FROM USR WHERE USG = '360000' ) ) )

gdxznwrva1x55 SELECT 'FIN', TO_CHAR(GL.COMDAT, 'MM'), SUM(1*GL.AMT*XR.MIDRAT*XG.REDUCE)/10000 FROM (SELECT G.CUR AS CUR, DECODE(G.DBTCDT, 'C', G.AMT, 'D', -G.AMT) AS AMT, G.VALDAT AS VALDAT, T.COMDAT AS COMDAT, T.BCHKEYINR AS BCHKEYINR, T.OBJTYP AS OBJTYP, T.OBJINR AS OBJINR FROM GLE G, DCT D, TRN T WHERE TRIM(G.ACT)=TRIM(D.EXTKEY) AND TRIM(D.SUBCOD) IN ('501001', '502011', '502012', '502013', '502014') AND G.TRNINR=T.INR AND T.RELFLG IN('F', 'R') AND G.OBJTYP NOT IN ('PTE')) GL, CMI M, REPXRT XR, XRTCHG XG WHERE TO_CHAR(GL.COMDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(GL.COMDAT, 'YYYY')='2014' AND GL.OBJTYP=M.OBJTYP AND GL.OBJINR=M.OBJINR AND M.BCHKEYINR='00000008' AND GL.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'FIN', TO_CHAR(GL.COMDAT, 'MM') UNION SELECT 'FIN', TO_CHAR(GL.VALDAT, 'MM'), SUM(1*GL.AMT*XR.MIDRAT*XG.REDUCE)/10000 FROM (SELECT F.INTCUR AS CUR, F.INTAMT AS AMT, F.INTDAT AS VALDAT, I.BCHKEYINR AS BCHKEYINR, I.OBJTYP AS OBJTYP, I.OBJINR AS OBJINR FROM ACF F, CMI I, ACE A, TRN T WHERE F.INTACT <>'602010' AND F.INTACT <>'602016' AND F.INTACT <>'602017' AND F.TRNINR=T.INR AND T.TRXSQNB<>' ' AND A.INR=F.ACEINR AND SUBSTR(TRIM(A.FEECOD), 4, 6)='INT' AND F.GLEINR<>'A0000001' AND A.OWNREF=I.OWNREF and f.bchkeyinr='00000008') GL, CMI M, REPXRT XR, XRTCHG XG WHERE TO_CHAR(GL.VALDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(GL.VALDAT, 'YYYY')='2014' AND GL.OBJTYP=M.OBJTYP AND GL.OBJINR=M.OBJINR AND GL.CUR= XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'FIN', TO_CHAR(GL.VALDAT, 'MM') union select 'OTH', to_char(f.credat, 'mm'), sum(f.lixamt*xr.midrat*xg.reduce)/10000 from rephis f, repxrt xr, xrtchg xg where f.bchkeyinr = '00000008' and f.lixcur=xr.cur and xr.cur=xg.cur and to_char(f.credat, 'yyyymmdd') <= '20141222' and to_char(f.credat, 'yyyy') = '2014' and to_char(xr.begdat, 'yyyymmdd') = '20141222' group by to_char(f.credat, 'mm')

gft02zzrfnvus SELECT INR, OBJTYP, OBJINR, OBJNAM, ETYEXTKEY FROM WFS WHERE INR = :W0

gx1pz1011jbmv select DISTINCT A.OWNREF, A.INTCUR, A.INTAMT, (SELECT D1.EXTKEY FROM DCT D1 LEFT JOIN GLE G1 ON G1.ACT=D1.EXTKEY WHERE G1.TRNINR ='00581134' AND G1.DBTCDT='C') AS ACT1, (SELECT D1.SUBCOD FROM DCT D1 LEFT JOIN GLE G1 ON G1.ACT=D1.EXTKEY WHERE G1.TRNINR ='00581134' AND G1.DBTCDT='C') AS ACC1, (SELECT D1.EXTKEY FROM DCT D1 LEFT JOIN GLE G1 ON G1.ACT=D1.EXTKEY WHERE G1.TRNINR ='00581134' AND G1.DBTCDT='D') AS ACT2, (SELECT D1.EXTKEY FROM DCT D1 LEFT JOIN GLE G1 ON G1.ACT=D1.EXTKEY WHERE G1.TRNINR ='00581134' AND G1.DBTCDT='C') AS ACC2, T.COMDAT, T.INIDATTIM from TRN T, GLE G, ACF A WHERE T.INR=G.TRNINR AND T.INR=A.TRNINR AND T.INR='00581134'

SQL Id	SQL Text
0dt92qcmxx562	select * from acf where ownref='ZJP2010LG00010' order by inr desc
2wkqpwk877aaw	UPDATE WFE SET WFSINR = :V0, WFSSUB = :V1, SRV = :V2, STA = :V3, RTYCNT = :V4, TARDATTIM = :V5, SSNINR = :V6, DATTIM = :V7, TXT = :V8, MANFLG = :V9, OPNDUR = :V10, WAIDUR = :V11, RETDUR = :V12, HDLDUR = :V13, BCHKEYINR = :V14 WHERE WFSINR = :W0 AND WFSSUB = :W1
3bmfazzhuzcz1	INSERT INTO LCK ( LCKSTR, LCKUSR, LCKSNR, LCKDATTIM, LCKHLD ) VALUES ( :1, :2, :3, :4, :5 )
3pyhj5nz5g015	select distinct(substr(trim(expses), -4)) from gle where branchinr='00000017' and to_char(bucdat, 'YYYYMMDD')='20141223' and substr(trim(expses), 1, 1)='A' order by substr(trim(expses), -4) desc
3wxx06muk7ccx	SELECT WFSINR, WFSSUB, SRV, STA, RTYCNT, TARDATTIM, SSNINR, DATTIM, TXT, MANFLG, OPNDUR, WAIDUR, RETDUR, HDLDUR, BCHKEYINR FROM WFE WHERE WFSINR = :W0 AND WFSSUB = :W1
48c8u9p49xv1q	select extkey from dct where cur='EUR' and subcod in ('215001') and bch='2120' order by inr
4u76qt2s50bpf	select distinct cmdpep, cmdpep1, cmdtwo, cmdtwo1, crdprd, objtyp, objinr, ownref, prjnam, cur, maxamt, cmdpsn from cmi where ( cmdpep= 'CLD' or cmdtwo='CLD') and BEGDAT >=TO_DATE('2014-06-26', 'YYYY-MM-DD')and( INR IN ( select c.inr from x_fcd x, cmi c where x.ownref=c.ownref) ) ORDER BY OWNREF
529br8svudttu	DELETE FROM LCK WHERE LCKSNR = :1 AND LCKHLD = :2
572fbaj0fdw2b	select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
5hbp28fq03mbx	DELETE FROM LCK WHERE LCKSTR = :1
5nnndu3rypmvn	select distinct cmdpep, cmdpep1, cmdtwo, cmdtwo1, crdprd, objtyp, objinr, ownref, prjnam, cur, maxamt, cmdpsn from cmi where ( cmdpep= 'CLD' or cmdtwo='CLD') and BEGDAT >=TO_DATE('2014-01-01', 'YYYY-MM-DD')and( INR IN ( select c.inr from x_fcd x, cmi c where x.ownref=c.ownref) ) ORDER BY OWNREF
5p8jryq7s0rkt	UPDATE PTS SET INR = :V0, OBJTYP = :V1, OBJINR = :V2, ROL = :V3, PTAINR = :V4, PTYINR = :V5, EXTKEY = :V6, ADRBLK = :V7, REF = :V8, NAM = :V9, OWNREF = :V10, DFTCUR = :V11, DFTDSP = :V12, DFTACT = :V13, DFTFEECUR = :V14, DFTACTPTAINR = :V15, GLGGRPFLG = :V16, EXTACT = :V17, VER = :V18, ISSBANINF = :V19, BANKNO = :V20, CORCOD = :V21 WHERE INR = :W0
5qfwxdxpvmdt4	UPDATE CORPTY SET INR = :V0, NAM = :V1, PTYTYP = :V2, SLA = :V3, BRANCHINR = :V4, JUSCOD = :V5, IDCODE = :V6, IDTYPE = :V7, CTVC = :V8, CRDCNT = :V9, CLIENTID = :V10, UIL = :V11, NAM1 = :V12, NAM2 = :V13, NAM3 = :V14, LOCCTY = :V15, EXTKEY = :V16, FLG = :V17, STR1 = :V18, STR2 = :V19, LOCZIP = :V20, CORTYP = :V21, FAX1 = :V22, INIFRM = :V23 WHERE INR = :W0
5y56rkabsj5q4	select distinct(substr(trim(expses), -4)) from gle where branchinr='00000017' and to_char(bucdat, 'YYYYMMDD')='20141223' and substr(trim(expses), 1, 1)='C' order by substr(trim(expses), -4) desc
6jbxqc4j15kkf	SELECT INR, TRNINR, EVTTXT FROM TRNEVT WHERE TRNINR = :W0
6ngschdubbuuv	select cur from xrt where to_char(begdat, 'YYYYMMDD')=:W0
86kjqrwgmwds7	select distinct cmdpep, cmdpep1, cmdtwo, cmdtwo1, crdprd, objtyp, objinr, ownref, prjnam, cur, maxamt, cmdpsn from cmi where ( cmdpep= 'CLD' or cmdtwo='CLD') and BEGDAT >=TO_DATE('2013-12-23', 'YYYY-MM-DD')and( INR IN ( select c.inr from x_fcd x, cmi c where x.ownref=c.ownref) ) ORDER BY OWNREF
93hyuhdd8w198	SELECT INR, OBJTYP, OBJINR, OBJNAM, OBJREF, TXT, DATTIM, USR, SSNINR, FRM, PAN, STA, DELFLG, HLDFLG, INFDSP, INFTXT, OWNUSG, OWNUSR, SMHINR, MAPFLG, CRETRN, ORDINR, TARDATTIM, CREOBJTYP, CREOBJINR, TRLGRP, RELCUR, RELAMT, ETGEXTKEY, ETYEXTKEY, PTAINR, PAYFLG, WRKGRP, WRKUSR, BCHKEYINR FROM SPT WHERE INR = :W0
98f93q0w2732s	select MSGTYP, SNDKEY, RELCUR, RELAMT from SMH where INR = :W0
9jmrmj85jvjan	INSERT INTO XS_XRT VALUE (SELECT * FROM XRT WHERE INR IN( SELECT MIN(INR) FROM XRT GROUP BY TO_CHAR(BEGDAT, 'YYYYMM'), CUR)AND INR NOT IN(SELECT INR FROM XS_XRT))
anpw5shtv1m86	select smhinr from ned where smhinr = ''
b6g5845t0pr3c	select distinct(substr(trim(expses), -4)) from gle where branchinr='00000005' and to_char(bucdat, 'YYYYMMDD')='20141223' and substr(trim(expses), 1, 1)='A' order by substr(trim(expses), -4) desc
bnfwkpwbvmg4u	INSERT INTO CMI ( INR, OWNREF, VER, OBJTYP, OBJINR, PRJNAM, CNTNUM, CMDPSN, CMDPEP, CMDPEP1, CRDPRD, DETAIL, DEPNUB, BEGDAT, STACTY, CUR, MAXAMT, OPNAMT, REPINR, GARTYP, SECSTA, TRNINR, TRNSTA, BCHKEYINR, BRANCHINR, CMDTWO, CMDTWO1, RESULT, INONUM, INNTRN, USDAMT, LOAN, FINCOD, BRNCOD, YESORNO, RATTYP, RATLEV, NEWFIELD, CMDPSN1 ) VALUES ( :V0, :V1, :V2, :V3, :V4, :V5, :V6, :V7, :V8, :V9, :V10, :V11, :V12, :V13, :V14, :V15, :V16, :V17, :V18, :V19, :V20, :V21, :V22, :V23, :V24, :V25, :V26, :V27, :V28, :V29, :V30, :V31, :V32, :V33, :V34, :V35, :V36, :V37, :V38 )
bqw1mnb4jj3x6	SELECT WFSINR, WFSSUB, STA, RTYCNT, TARDATTIM FROM WFE WHERE( STA = 'W' or STA = 'R' ) and ( SRV = 'PRT' OR SRV = 'PDS' OR SRV = 'PDP' OR SRV = 'COM' OR SRV = 'PRR' OR SRV = 'SWT' OR SRV = 'TCO' OR SRV = 'TLX' OR SRV = 'PDA' OR SRV = 'PRS' OR SRV = 'SEP' OR SRV = 'RTG' OR SRV = 'TAR' OR SRV = 'DTE' OR SRV = 'DTA' OR SRV = 'EML' OR SRV = 'TXT' OR SRV = 'PDL' OR SRV = 'FIN' OR SRV = 'BOL' OR SRV = 'PDD' OR SRV = 'IZV' OR SRV = 'CCS' OR SRV = 'PDC' OR SRV = 'REL' OR SRV = 'EDI' OR SRV = 'DTF' ) order BY RTYCNT
br9kvc7p7tums	SELECT X.OBJINR, X.OBJTYP, X.OWNREF, X.CUR, X.AMT, X.MIDRAT, X.RAT, TO_CHAR(X.VALDAT, 'YYYY-MM-DD'), X.CMDPET, X.CMDTWO, P.NAM1, TRNMAN, X.TRDTYP, TRDWAY, BNKCOD, CASE SUBSTR(F.FCDTYP, 2, 1) WHEN 'B' THEN J.CUSTCOD WHEN 'S' THEN W.CUSTCOD ELSE '' END, CASE SUBSTR(F.FCDTYP, 2, 1) WHEN 'B' THEN V.TXCODE WHEN 'S' THEN Y.TXCODE ELSE '' END FROM X_FCD X, PTY P, FCD F LEFT JOIN DBJ J ON F.OWNREF = J.BUSCODE LEFT JOIN DBV V ON J.RPTNO = V.RPTNO LEFT JOIN DBW W ON F.OWNREF = W.BUSCODE LEFT JOIN DBY Y ON W.RPTNO = Y.RPTNO WHERE X.OBJTYP='FCD' AND X.OBJINR=F.INR AND F.APLPTYINR=P.INR and X.VALDAT >=TO_DATE ('20141222', 'YYYYMMDD') ORDER BY X.OWNREF
cvqj8skq9ndtg	DELETE FROM CMI WHERE ROWID IN(SELECT MIN(ROWID) FROM CMI GROUP BY OWNREF HAVING COUNT(*)>1)
d7gzc3tkjsvjg	SELECT INR, INIDATTIM, INIFRM, INIUSR, ININAM, OWNREF, OBJTYP, OBJINR, OBJNAM, SSNINR, SMHNXT, USG, USR, CPLDATTIM, INFDSP, INFTXT, RELFLG, COMFLG, COMDAT, CORTRNINR, XREFLG, XRECURBLK, RELCUR, RELAMT, RELORICUR, RELORIAMT, RELREQ, RELRES, CNFFLG, EVTTXT, RPRUSR, ORDINR, EXEDAT, ETYEXTKEY, BCHKEYINR, ACCBCHINR, TRXSQNB, TRXSQNBADD, ACCSNDFLG, TRXSQNBPP FROM TRN WHERE INR = :W0
ddstpsqy9rpfa	SELECT INR FROM NTF WHERE ( SSNINR = :W0 OR USR = :W1 ) AND SHWSSNINR = ' ' ORDER BY INR
f38ztwsazgmf8	SELECT 'SET', TO_CHAR(F.DONDAT, 'MM'), SUM(1F.AMTXR.MIDRATXG.REDUCE)/10000 FROM FEP F, CMI M, TRN T, REPXRT XR, XRTCHG XG WHERE F.DONTRNINR=T.INR AND F.OBJTYP IN('BCD', 'BED', 'BOD', 'BRD', 'BTD', 'CPD', 'FCD', 'LTD', 'LED', 'LID', 'MCD') AND F.FEEACC IN('506001', '506003', '506012', '506099') AND T.RELFLG IN('F', 'R') AND T.OBJTYP=M.OBJTYP AND T.OWNREF NOT LIKE '%WS%' AND T.OBJINR=M.OBJINR AND M.BCHKEYINR='00000008' AND TO_CHAR(F.DONDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(F.DONDAT, 'YYYY')='2014' AND F.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'SET', TO_CHAR(F.DONDAT, 'MM') UNION SELECT 'SET', TO_CHAR(F.DONDAT, 'MM'), SUM(1F.AMTXR.MIDRATXG.REDUCE)/10000 FROM FEP F, CMI M, TRN T, REPXRT XR, XRTCHG XG WHERE F.DONTRNINR=T.INR AND F.FEEACC IN('507001', '507002') AND T.RELFLG IN('F', 'R') AND T.OBJTYP=M.OBJTYP AND T.OBJINR=M.OBJINR AND M.BCHKEYINR='00000008' AND TO_CHAR(F.DONDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(F.DONDAT, 'YYYY')='2014' AND F.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'SET', TO_CHAR(F.DONDAT, 'MM') UNION SELECT 'SET', TO_CHAR(F.DONDAT, 'MM'), SUM(1F.AMTXR.MIDRATXG.REDUCE)/10000 FROM FEP F, TRN T, REPXRT XR, XRTCHG XG WHERE F.DONTRNINR=T.INR AND F.OBJTYP IN('BCD', 'BED', 'BOD', 'BRD', 'BTD', 'CPD', 'FCD', 'LTD', 'LED', 'LID', 'MCD') AND F.FEEACC IN('506001', '506003', '506012', '506099') AND T.RELFLG IN('F', 'R') AND T.OWNREF LIKE '%WS%' and t.bch keyinr='00000008' AND TO_CHAR(F.DONDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(F.DONDAT, 'YYYY')='2014' AND F.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'SET', TO_CHAR(F.DONDAT, 'MM') UNION SELECT 'FIN', TO_CHAR(F.DONDAT, 'MM'), SUM(1F.AMTXR.MIDRATXG.REDUCE)/10000 FROM FEP F, CMI M, TRN T, REPXRT XR, XRTCHG XG WHERE F.DONTRNINR=T.INR AND F.OBJTYP IN('BPD', 'DFD', 'EFD', 'EPD', 'ERD', 'FBD', 'FMD', 'FPD', 'FRD', 'PFD', 'TRD', 'FID') AND F.FEEACC IN('506001', '506003', '506012', '506099') AND T.RELFLG IN('F', 'R') AND T.OBJTYP=M.OBJTYP AND T.OBJINR=M.OBJINR AND M.BCHKEYINR='00000008' AND TO_CHAR(F.DONDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(F.DONDAT, 'YYYY')='2014' AND F.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'FIN', TO_CHAR(F.DONDAT, 'MM') UNION SELECT 'GID', TO_CHAR(F.DONDAT, 'MM'), SUM(1F.AMTXR.MIDRATXG.REDUCE)/10000 FROM FEP F, CMI M, TRN T, REPXRT XR, XRTCHG XG WHERE F.DONTRNINR=T.INR AND F.OBJTYP IN('GID', 'GCD') AND F.FEEACC IN('506001', '506003', '506012', '506099') AND T.RELFLG IN('F', 'R') AND T.OBJTYP=M.OBJTYP AND T.OBJINR=M.OBJINR AND M.BCHKEYINR='00000008' AND TO_CHAR(F.DONDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(F.DONDAT, 'YYYY')='2014' AND F.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'GID', TO_CHAR(F.DONDAT, 'MM') UNION SELECT 'GID', TO_CHAR(GL.COMDAT, 'MM'), SUM(1GL.AMTXR.MIDRATXG.REDUCE)/10000 FROM (SELECT G.CUR AS CUR, DECODE(G.DBTCDT, 'C', G.AMT, 'D', -G.AMT) AS AMT, G.VALDAT AS VALDAT, T.COMDAT AS COMDAT, T.BCHKEYINR AS BCHKEYINR, T.OBJTYP AS OBJTYP, T.OBJINR AS OBJINR FROM GLE G, DCT D, TRN T WHERE TRIM(G.ACT)=TRIM(D.EXTKEY) AND TRIM(D.SUBCOD) ='506004' AND G.TRNINR=T.INR and t.bchkeyinr='00000008' AND T.RELFLG IN('F', 'R') AND G.OBJTYP IN ('GID', 'GCD')) GL, REPXRT XR, XRTCHG XG WHERE TO_CHAR(GL.COMDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(GL.COMDAT, 'YYYY')='2014' AND GL.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'GID', TO_CHAR(GL.COMDAT, 'MM') UNION SELECT 'GID', TO_CHAR(GL.COMDAT, 'MM'), SUM(1GL.AMTXR.MIDRATXG.REDUCE)/10000 FROM (SELECT F.INTCUR AS CUR, F.INTAMT AS AMT, F.INTDAT AS COMDAT, F.BCHKEYINR AS BCHKEYINR, E.OWNREF FROM ACF F, ACE E, CMI I, TRN T WHERE E.OWNREF=I.OWNREF AND F.ACEINR=E.INR AND F.TRNINR=T.INR AND T.TRXSQNB<>' ' AND F.GLEINR<>'A0000001' AND I.OBJTYP IN ('GID', 'GCD')) GL, CMI M, REPXRT XR, XRTCHG XG WHERE TO_CHAR(GL.COMDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(GL.COMDAT, 'YYYY')='2014' AND GL.OWNREF=M.OWNREF AND M.BCHKEYINR='00000008' AND GL.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'GID', TO_CHAR(GL.COMDAT, 'MM') union select 'OTH', to_char(f.credat, 'mm'), sum(f.flxamtxr.midrat*xg.reduce)/10000 from rephis f, repxrt xr, xrtchg xg where f.bchkeyinr = '00000008' and f.flxcur=xr.cur and xr.cur=xg.cur and to_char(f.credat, 'yyyymmdd') <= '20141222' and to_char(f.credat, 'yyyy') = '2014' and to_char(xr.begdat, 'yyyymmdd') = '20141222' group by to_char(f.credat, 'mm')
fta1srvxh0vyh	select distinct cmdpep, cmdpep1, cmdtwo, cmdtwo1, crdprd, objtyp, objinr, ownref, prjnam, cur, maxamt, cmdpsn from cmi where ( cmdpep= 'CLD' or cmdtwo='CLD') and( INR IN ( select c.inr from x_fcd x, cmi c where x.ownref=c.ownref) ) ORDER BY OWNREF
fytufwfc4tm67	SELECT WFSINR, WFSSUB, SRV, STA, RTYCNT, TARDATTIM, SSNINR, DATTIM, TXT, MANFLG, OPNDUR, WAIDUR, RETDUR, HDLDUR, BCHKEYINR FROM WFE where WFSINR = :W0
g399fybscrt6m	SELECT COUNT(*) from SPT WHERE ( ETYEXTKEY = 'EIBANK' and ETGEXTKEY = 'EIBANKG' ) and ( ( (STA = 'INC' and DELFLG = ' ') ) AND ( OWNUSG = '360000' OR OWNUSR in ( SELECT EXTKEY FROM USR WHERE USG = '360000' ) ) )
gdxznwrva1x55	SELECT 'FIN', TO_CHAR(GL.COMDAT, 'MM'), SUM(1GL.AMTXR.MIDRATXG.REDUCE)/10000 FROM (SELECT G.CUR AS CUR, DECODE(G.DBTCDT, 'C', G.AMT, 'D', -G.AMT) AS AMT, G.VALDAT AS VALDAT, T.COMDAT AS COMDAT, T.BCHKEYINR AS BCHKEYINR, T.OBJTYP AS OBJTYP, T.OBJINR AS OBJINR FROM GLE G, DCT D, TRN T WHERE TRIM(G.ACT)=TRIM(D.EXTKEY) AND TRIM(D.SUBCOD) IN ('501001', '502011', '502012', '502013', '502014') AND G.TRNINR=T.INR AND T.RELFLG IN('F', 'R') AND G.OBJTYP NOT IN ('PTE')) GL, CMI M, REPXRT XR, XRTCHG XG WHERE TO_CHAR(GL.COMDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(GL.COMDAT, 'YYYY')='2014' AND GL.OBJTYP=M.OBJTYP AND GL.OBJINR=M.OBJINR AND M.BCHKEYINR='00000008' AND GL.CUR=XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'FIN', TO_CHAR(GL.COMDAT, 'MM') UNION SELECT 'FIN', TO_CHAR(GL.VALDAT, 'MM'), SUM(1GL.AMTXR.MIDRATXG.REDUCE)/10000 FROM (SELECT F.INTCUR AS CUR, F.INTAMT AS AMT, F.INTDAT AS VALDAT, I.BCHKEYINR AS BCHKEYINR, I.OBJTYP AS OBJTYP, I.OBJINR AS OBJINR FROM ACF F, CMI I, ACE A, TRN T WHERE F.INTACT <>'602010' AND F.INTACT <>'602016' AND F.INTACT <>'602017' AND F.TRNINR=T.INR AND T.TRXSQNB<>' ' AND A.INR=F.ACEINR AND SUBSTR(TRIM(A.FEECOD), 4, 6)='INT' AND F.GLEINR<>'A0000001' AND A.OWNREF=I.OWNREF and f.bchkeyinr='00000008') GL, CMI M, REPXRT XR, XRTCHG XG WHERE TO_CHAR(GL.VALDAT, 'YYYYMMDD')<='20141222' AND TO_CHAR(GL.VALDAT, 'YYYY')='2014' AND GL.OBJTYP=M.OBJTYP AND GL.OBJINR=M.OBJINR AND GL.CUR= XR.CUR AND XR.CUR=XG.CUR AND TO_CHAR(XR.BEGDAT, 'YYYYMMDD')='20141222' GROUP BY 'FIN', TO_CHAR(GL.VALDAT, 'MM') union select 'OTH', to_char(f.credat, 'mm'), sum(f.lixamtxr.midratxg.reduce)/10000 from rephis f, repxrt xr, xrtchg xg where f.bchkeyinr = '00000008' and f.lixcur=xr.cur and xr.cur=xg.cur and to_char(f.credat, 'yyyymmdd') <= '20141222' and to_char(f.credat, 'yyyy') = '2014' and to_char(xr.begdat, 'yyyymmdd') = '20141222' group by to_char(f.credat, 'mm')
gft02zzrfnvus	SELECT INR, OBJTYP, OBJINR, OBJNAM, ETYEXTKEY FROM WFS WHERE INR = :W0
gx1pz1011jbmv	select DISTINCT A.OWNREF, A.INTCUR, A.INTAMT, (SELECT D1.EXTKEY FROM DCT D1 LEFT JOIN GLE G1 ON G1.ACT=D1.EXTKEY WHERE G1.TRNINR ='00581134' AND G1.DBTCDT='C') AS ACT1, (SELECT D1.SUBCOD FROM DCT D1 LEFT JOIN GLE G1 ON G1.ACT=D1.EXTKEY WHERE G1.TRNINR ='00581134' AND G1.DBTCDT='C') AS ACC1, (SELECT D1.EXTKEY FROM DCT D1 LEFT JOIN GLE G1 ON G1.ACT=D1.EXTKEY WHERE G1.TRNINR ='00581134' AND G1.DBTCDT='D') AS ACT2, (SELECT D1.EXTKEY FROM DCT D1 LEFT JOIN GLE G1 ON G1.ACT=D1.EXTKEY WHERE G1.TRNINR ='00581134' AND G1.DBTCDT='C') AS ACC2, T.COMDAT, T.INIDATTIM from TRN T, GLE G, ACF A WHERE T.INR=G.TRNINR AND T.INR=A.TRNINR AND T.INR='00581134'

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

Statistic	Total	per Second	per Trans
CPU used by this session	388,751	108.64	2.89
CPU used when call started	388,306	108.52	2.88
CR blocks created	2,487	0.70	0.02
Cached Commit SCN referenced	276	0.08	0.00
Commit SCN cached	1	0.00	0.00
DB time	1,757,440	491.15	13.06
DBWR checkpoint buffers written	24,036	6.72	0.18
DBWR checkpoints	3	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	163	0.05	0.00
DBWR undo block writes	13,421	3.75	0.10
Misses for writing mapping	0	0.00	0.00
SMON posted for undo segment shrink	17	0.00	0.00
SQL*Net roundtrips to/from client	2,162,145	604.25	16.06
active txn count during cleanout	3,066	0.86	0.02
application wait time	91	0.03	0.00
background checkpoints completed	3	0.00	0.00
background checkpoints started	3	0.00	0.00
background timeouts	11,472	3.21	0.09
branch node splits	0	0.00	0.00
buffer is not pinned count	41,784,125	11,677.35	310.44
buffer is pinned count	142,191,184	39,737.98	1,056.42
bytes received via SQL*Net from client	289,888,019	81,014.61	2,153.75
bytes sent via SQL*Net to client	669,648,099	187,145.64	4,975.21
calls to get snapshot scn: kcmgss	1,603,214	448.05	11.91
calls to kcmgas	166,845	46.63	1.24
calls to kcmgcs	552	0.15	0.00
change write time	1,443	0.40	0.01
cleanout - number of ktugct calls	3,121	0.87	0.02
cleanouts and rollbacks - consistent read gets	2,132	0.60	0.02
cleanouts only - consistent read gets	72	0.02	0.00
cluster key scan block gets	6,067	1.70	0.05
cluster key scans	462	0.13	0.00
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	5	0.00	0.00
commit batch/immediate requested	5	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	1	0.00	0.00
commit cleanout failures: callback failure	99	0.03	0.00
commit cleanout failures: cannot pin	23	0.01	0.00
commit cleanouts	401,453	112.19	2.98
commit cleanouts successfully completed	401,330	112.16	2.98
commit immediate performed	5	0.00	0.00
commit immediate requested	5	0.00	0.00
commit txn count during cleanout	1,712	0.48	0.01
concurrency wait time	433,188	121.06	3.22
consistent changes	51,411	14.37	0.38
consistent gets	296,059,512	82,739.35	2,199.60
consistent gets - examination	22,401,230	6,260.44	166.43
consistent gets direct	403	0.11	0.00
consistent gets from cache	296,059,115	82,739.24	2,199.60
current blocks converted for CR	0	0.00	0.00
cursor authentications	8,132	2.27	0.06
data blocks consistent reads - undo records applied	6,123	1.71	0.05
db block changes	1,313,226	367.01	9.76
db block gets	1,438,905	402.13	10.69
db block gets direct	159	0.04	0.00
db block gets from cache	1,438,746	402.08	10.69
deferred (CURRENT) block cleanout applications	90,110	25.18	0.67
dirty buffers inspected	0	0.00	0.00
enqueue conversions	737	0.21	0.01
enqueue releases	472,622	132.08	3.51
enqueue requests	472,636	132.09	3.51
enqueue timeouts	2	0.00	0.00
enqueue waits	2	0.00	0.00
exchange deadlocks	3	0.00	0.00
execute count	954,661	266.80	7.09
failed probes on index block reclamation	2	0.00	0.00
free buffer inspected	47,028	13.14	0.35
free buffer requested	62,376	17.43	0.46
heap block compress	3,608	1.01	0.03
hot buffers moved to head of LRU	9,496	2.65	0.07
immediate (CR) block cleanout applications	2,204	0.62	0.02
immediate (CURRENT) block cleanout applications	113,268	31.65	0.84
index crx upgrade (found)	3	0.00	0.00
index crx upgrade (positioned)	12,639	3.53	0.09
index fast full scans (full)	331	0.09	0.00
index fetch by key	8,383,266	2,342.86	62.28
index scans kdiixs1	2,368,404	661.89	17.60
leaf node 90-10 splits	43	0.01	0.00
leaf node splits	130	0.04	0.00
lob reads	8,228	2.30	0.06
lob writes	13,337	3.73	0.10
lob writes unaligned	12,209	3.41	0.09
logons cumulative	399	0.11	0.00
messages received	140,573	39.29	1.04
messages sent	140,573	39.29	1.04
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	273,203,443	76,351.79	2,029.79
opened cursors cumulative	951,845	266.01	7.07
parse count (failures)	453	0.13	0.00
parse count (hard)	16,149	4.51	0.12
parse count (total)	951,594	265.94	7.07
parse time cpu	16,070	4.49	0.12
parse time elapsed	505,586	141.30	3.76
physical read IO requests	28,691	8.02	0.21
physical read bytes	284,622,848	79,543.16	2,114.63
physical read total IO requests	33,938	9.48	0.25
physical read total bytes	645,703,680	180,453.93	4,797.31
physical read total multi block requests	4,702	1.31	0.03
physical reads	34,744	9.71	0.26
physical reads cache	34,329	9.59	0.26
physical reads cache prefetch	6,053	1.69	0.04
physical reads direct	415	0.12	0.00
physical reads direct (lob)	311	0.09	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	10,786	3.01	0.08
physical write bytes	198,426,624	55,454.02	1,474.23
physical write total IO requests	155,361	43.42	1.15
physical write total bytes	864,745,472	241,669.24	6,424.70
physical write total multi block requests	138,487	38.70	1.03
physical writes	24,222	6.77	0.18
physical writes direct	186	0.05	0.00
physical writes direct (lob)	119	0.03	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	24,036	6.72	0.18
physical writes non checkpoint	5,031	1.41	0.04
pinned buffers inspected	2	0.00	0.00
prefetch clients - default	39	0.01	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	3,627	1.01	0.03
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	627,098	175.25	4.66
recursive cpu usage	22,930	6.41	0.17
redo blocks written	589,217	164.67	4.38
redo buffer allocation retries	7	0.00	0.00
redo entries	705,601	197.19	5.24
redo log space requests	7	0.00	0.00
redo log space wait time	92	0.03	0.00
redo ordering marks	13,175	3.68	0.10
redo size	263,365,272	73,602.33	1,956.69
redo subscn max counts	15,430	4.31	0.11
redo synch time	15,022	4.20	0.11
redo synch writes	138,255	38.64	1.03
redo wastage	28,394,376	7,935.34	210.96
redo write time	12,205	3.41	0.09
redo writer latching time	27	0.01	0.00
redo writes	138,857	38.81	1.03
rollback changes - undo records applied	187	0.05	0.00
rollbacks only - consistent read gets	313	0.09	0.00
rows fetched via callback	8,077,014	2,257.27	60.01
session connect time	0	0.00	0.00
session cursor cache hits	879,345	245.75	6.53
session logical reads	297,498,319	83,141.45	2,210.29
session pga memory	129,433,920	36,172.72	961.64
session pga memory max	445,619,072	124,536.56	3,310.77
session uga memory	###############	70,826,321.31	1,882,895.52
session uga memory max	818,476,072	228,738.40	6,080.94
shared hash latch upgrades - no wait	19,232	5.37	0.14
shared hash latch upgrades - wait	10	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	377,646	105.54	2.81
sorts (rows)	26,092,323	7,291.99	193.86
sql area evicted	21,563	6.03	0.16
sql area purged	453	0.13	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	11,433	3.20	0.08
table fetch by rowid	33,233,898	9,287.83	246.91
table fetch continued row	4,715	1.32	0.04
table scan blocks gotten	244,669,001	68,377.31	1,817.79
table scan rows gotten	5,026,470,079	1,404,740.76	37,344.59
table scans (long tables)	117	0.03	0.00
table scans (short tables)	50,222	14.04	0.37
total number of times SMON posted	17	0.00	0.00
transaction rollbacks	5	0.00	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	106,479,184	29,757.59	791.10
user I/O wait time	11,911	3.33	0.09
user calls	3,072,706	858.72	22.83
user commits	134,344	37.54	1.00
user rollbacks	253	0.07	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	39,150	10.94	0.29
write clones created in background	2	0.00	0.00
write clones created in foreground	21	0.01	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	9,295,915	9,306,710
opened cursors current	542	803
workarea memory allocated	237	237
logons current	192	225

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	3	3.02

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SSTF	24,479	7	3.02	1.22	1,442	0	1,005	4.60
USERS	3,516	1	11.02	1.19	7,667	2	70	70.00
UNDOTBS1	3	0	0.00	1.00	1,024	0	25	66.40
SYSAUX	447	0	3.40	1.09	498	0	0	0.00
SYSTEM	228	0	3.95	1.00	157	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SSTF	/oradata/sstf505/sstf50501.dbf	8,202	2	3.17	1.21	264	0	291	6.08
SSTF	/oradata/sstf505/sstf50502.dbf	8,017	2	3.07	1.24	403	0	352	4.20
SSTF	/oradata/sstf505/sstf50503.dbf	8,260	2	2.83	1.20	775	0	362	3.78
SYSAUX	/oradata/sstf505/sysaux01.dbf	447	0	3.40	1.09	498	0	0	0.00
SYSTEM	/oradata/sstf505/system01.dbf	228	0	3.95	1.00	157	0	0	0.00
UNDOTBS1	/oradata/sstf505/undotbs01.dbf	3	0	0.00	1.00	1,024	0	25	66.40
USERS	/oradata/sstf505/users01.dbf	1,722	0	11.93	1.13	1,651	0	39	120.51
USERS	/oradata/sstf505/users02.dbf	723	0	12.93	1.58	1,753	0	25	8.00
USERS	/oradata/sstf505/users03.dbf	1,071	0	8.27	1.02	4,263	1	6	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	805,453	100	296,658,940	34,323	24,036	0	0	1,100

Advisory Statistics

Instance Recovery Stats
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

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	17	2009	47201	262643	368640	262643
E	0	17	2469	57313	302588	368640	302588

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

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	640	0.10	79,160	5.45	461,480,824
D	1,280	0.20	158,320	1.71	145,079,130
D	1,920	0.29	237,480	1.20	101,395,269
D	2,560	0.39	316,640	1.08	91,740,491
D	3,200	0.49	395,800	1.04	88,326,307
D	3,840	0.59	474,960	1.03	86,913,746
D	4,480	0.69	554,120	1.02	86,405,857
D	5,120	0.79	633,280	1.01	85,902,739
D	5,760	0.88	712,440	1.01	85,228,505
D	6,400	0.98	791,600	1.00	84,743,127
D	6,512	1.00	805,453	1.00	84,651,824
D	7,040	1.08	870,760	1.00	84,301,613
D	7,680	1.18	949,920	0.99	84,053,634
D	8,320	1.28	1,029,080	0.99	83,981,549
D	8,960	1.38	1,108,240	0.99	83,965,953
D	9,600	1.47	1,187,400	0.99	83,961,250
D	10,240	1.57	1,266,560	0.99	83,958,790
D	10,880	1.67	1,345,720	0.99	83,955,850
D	11,520	1.77	1,424,880	0.99	83,936,459
D	12,160	1.87	1,504,040	0.97	81,767,571
D	12,800	1.97	1,583,200	0.65	54,835,111

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	52,977	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	4,096	3,568	302.45	0.23	0.08	100.00	0.00	419,430
E	4,096	3,542	349.28	0.23	0.07	100.00	0.00	419,430

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	32,660	32,660
64K	128K	558	558
128K	256K	106	106
256K	512K	316	316
512K	1024K	507	507
1M	2M	57	57
2M	4M	15	15
4M	8M	5	5
8M	16M	4,928	4,928

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
512	0.13	2,416,783.13	10,507.15	100.00	5
1,024	0.25	2,416,783.13	8,302.32	100.00	0
2,048	0.50	2,416,783.13	7,727.81	100.00	0
3,072	0.75	2,416,783.13	7,727.81	100.00	0
4,096	1.00	2,416,783.13	7,727.81	100.00	0
4,915	1.20	2,416,783.13	1,452.63	100.00	0
5,734	1.40	2,416,783.13	1,452.63	100.00	0
6,554	1.60	2,416,783.13	1,452.63	100.00	0
7,373	1.80	2,416,783.13	1,452.63	100.00	0
8,192	2.00	2,416,783.13	1,452.63	100.00	0
12,288	3.00	2,416,783.13	1,452.63	100.00	0
16,384	4.00	2,416,783.13	1,452.63	100.00	0
24,576	6.00	2,416,783.13	1,452.63	100.00	0
32,768	8.00	2,416,783.13	1,452.63	100.00	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.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
2,864	0.29	1,082	168,036	31,013,936	0.93	3,101,680	3.61	768,488,000
3,856	0.39	2,066	235,418	32,409,023	0.97	1,706,593	1.98	769,672,196
4,848	0.49	3,057	292,345	32,627,782	0.98	1,487,834	1.73	769,857,591
5,840	0.60	4,048	340,522	32,704,758	0.98	1,410,858	1.64	769,999,198
6,832	0.70	5,039	387,928	32,889,580	0.99	1,226,036	1.43	770,251,021
7,824	0.80	6,030	436,248	33,022,287	0.99	1,093,329	1.27	770,398,196
8,816	0.90	7,021	484,477	33,199,970	1.00	915,646	1.06	770,520,547
9,808	1.00	8,012	532,361	33,255,469	1.00	860,147	1.00	770,614,402
10,800	1.10	9,003	581,019	33,404,714	1.00	710,902	0.83	770,699,724
11,792	1.20	9,994	628,612	33,462,341	1.01	653,275	0.76	770,772,770
12,784	1.30	10,985	676,780	33,492,022	1.01	623,594	0.73	770,857,757
13,776	1.40	11,976	724,911	33,507,293	1.01	608,323	0.71	770,955,677
14,768	1.51	12,967	772,657	33,555,744	1.01	559,872	0.65	771,072,724
15,760	1.61	13,958	820,302	33,611,544	1.01	504,072	0.59	771,187,821
16,752	1.71	14,949	868,716	33,709,199	1.01	406,417	0.47	771,314,940
17,744	1.81	15,940	916,501	33,856,961	1.02	258,655	0.30	771,471,463
18,736	1.91	16,931	964,966	33,930,230	1.02	185,386	0.22	771,628,892
19,728	2.01	17,922	1,013,042	34,006,571	1.02	109,045	0.13	771,793,967

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
4,096	0.25	7,638,849	425,823,250
8,192	0.50	4,958,992	133,868,137
12,288	0.75	4,412,971	133,868,137
16,384	1.00	4,187,277	84,651,661
20,480	1.25	3,816,703	84,651,661
24,576	1.50	3,646,281	79,733,399
28,672	1.75	3,640,837	77,481,665
32,768	2.00	3,598,965	50,596,298

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)	JP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
16	0.50	7	103	3	1.00	860,147	1.00	103
32	1.00	7	103	3	1.00	860,147	1.00	103
48	1.50	7	103	3	1.00	860,147	1.00	103
64	2.00	7	103	3	1.00	860,147	1.00	103

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	1,075	10	9
undo header	17	2	96
undo block	8	0	4

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
CF-Controlfile Transaction	2,126	2,126	0	2	0	108.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	13.60	139,972	650	7	15/21.8333333333333333333333333333333333333	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
23-Dec 10:57	2,281	23,731	311	5	16	0/0	0/0/0/0/0/0
23-Dec 10:47	2,334	24,025	106	7	15	0/0	0/0/0/0/0/0
23-Dec 10:37	2,234	22,719	606	5	21	0/0	0/0/0/0/0/0
23-Dec 10:27	2,229	23,480	129	4	15	0/0	0/0/0/0/0/0
23-Dec 10:17	2,395	24,771	526	4	20	0/0	0/0/0/0/0/0
23-Dec 10:07	2,127	21,246	650	4	22	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,409	0.00		0	0
AWR Alerted Metric Element list	23,569	0.00		0	0
Consistent RBA	138,929	0.00	0.00	0	0
FAL request queue	78	0.00		0	0
FAL subheap alocation	78	0.00		0	0
FIB s.o chain latch	24	0.00		0	0
FOB s.o list latch	964	0.00		0	0
JS queue state obj latch	21,240	0.00		0	0
JS slv state obj latch	33	0.00		0	0
KMG MMAN ready and startup request latch	1,193	0.00		0	0
KTF sga latch	8	0.00		0	1,050	0.00
KWQMN job cache list latch	4	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	0			0	1,193	0.00
OS process	999	0.00		0	0
OS process allocation	1,892	0.00		0	0
OS process: request allocation	647	0.00		0	0
PL/SQL warning settings	521	0.00		0	0
SGA IO buffer pool latch	36	0.00		0	36	0.00
SQL memory manager latch	1	0.00		0	1,190	0.00
SQL memory manager workarea list latch	91,053	0.00	0.00	0	0
Shared B-Tree	127	0.00		0	0
active checkpoint queue latch	2,720	0.00		0	0
active service list	8,543	0.15	0.00	0	2,283	0.00
archive control	75	0.00		0	0
archive process latch	1,356	0.00		0	0
begin backup scn array	126	0.00		0	0
cache buffer handles	38,710	3.43	0.00	0	0
cache buffers chains	575,312,852	9.65	0.00	95	361,447	0.01
cache buffers lru chain	82,055	0.01	0.00	0	5,624,063	0.01
cache table scan latch	0			0	4,435	0.00
channel handle pool latch	647	0.00		0	0
channel operations parent latch	17,776	0.00		0	0
checkpoint queue latch	155,946	0.00		0	24,440	0.00
client/application info	3,359	0.00		0	0
commit callback allocation	4	0.00		0	0
compile environment latch	399	0.00		0	0
dml lock allocation	580,998	0.05	0.00	0	0
dummy allocation	765	0.39	0.00	0	0
enqueue hash chains	946,327	0.02	0.00	0	235	0.00
enqueues	528,972	0.03	0.00	0	0
event group latch	340	0.00		0	0
file cache latch	135	0.00		0	0
global KZLD latch for mem in SGA	325	0.00		0	0
hash table column usage latch	647	0.00		0	2,057,021	0.00
hash table modification latch	113	0.00		0	0
job workq parent latch	0			0	118	0.00
job_queue_processes parameter latch	118	0.00		0	0
kks stats	116,244	0.57	0.86	49	0
kokc descriptor allocation latch	62	0.00		0	0
ksuosstats global area	241	0.00		0	0
ktm global data	58	0.00		0	0
kwqbsn:qsga	127	0.00		0	0
lgwr LWN SCN	139,456	0.01	0.00	0	0
library cache	1,420,352	1.34	0.94	1614	101,882	4.80
library cache load lock	374	0.00		0	0
library cache lock	427,767	0.05	0.05	1	0
library cache lock allocation	6,723	0.00		0	0
library cache pin	208,817	0.01	0.00	0	0
library cache pin allocation	3,874	0.00		0	0
list of block allocation	1,586	0.00		0	0
loader state object freelist	798	0.00		0	0
longop free list parent	48	2.08	0.00	0	41	0.00
messages	445,781	0.02	0.00	0	0
mostly latch-free SCN	139,223	0.01	0.00	0	0
multiblock read objects	41,290	0.00		0	0
ncodef allocation latch	68	0.00		0	0
object queue header heap	306	0.00		0	20	0.00
object queue header operation	205,538	0.00	0.40	0	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	476	0.00		0	0
parameter list	3,302	0.00		0	0
parameter table allocation management	765	0.00		0	0
post/wait queue	207,416	0.00		0	138,206	0.02
process allocation	647	0.00		0	340	0.00
process group creation	647	0.00		0	0
qmn task queue latch	508	0.00		0	0
redo allocation	418,272	0.01	0.26	0	705,696	0.05
redo copy	0			0	705,839	0.06
redo writing	422,166	0.00	0.00	0	0
resmgr group change latch	683	0.00		0	0
resmgr:active threads	762	0.00		0	0
resmgr:actses change group	386	0.00		0	0
resmgr:free threads list	761	0.39	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	11,170,236	0.38	0.00	6	12	0.00
rules engine aggregate statistics	2	0.00		0	0
rules engine rule set statistics	4	0.00		0	0
sequence cache	9,933	0.01	0.00	0	0
session allocation	922,389	0.03	0.01	0	0
session idle bit	6,580,561	0.01	0.00	0	0
session state list latch	201	0.00		0	0
session switching	204	0.00		0	0
session timer	1,201	0.00		0	0
shared pool	809,993	2.02	1.05	1925	0
shared pool simulator	1,595,394	0.02	1.64	97	0
simulator hash latch	16,377,197	0.00	0.11	13	0
simulator lru latch	24,039	0.22	0.04	0	15,984,101	11.43
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	117	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	336	0.00		0	0
temp lob duration state obj allocation	1	0.00		0	0
threshold alerts latch	240	0.00		0	0
transaction allocation	844	0.00		0	0
transaction branch allocation	1,201	0.00		0	0
undo global data	428,948	0.02	0.01	0	0
user lock	1,354	2.51	1.29	8	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	575,312,852	55,539,273	6,467	55,533,265
row cache objects	11,170,236	42,091	192	41,958
library cache	1,420,352	19,058	17,986	5,798
shared pool	809,993	16,337	17,136	3,651
kks stats	116,244	661	566	170
simulator hash latch	16,377,197	518	59	502
shared pool simulator	1,595,394	376	616	69
session allocation	922,389	292	4	288
enqueue hash chains	946,327	204	1	203
library cache lock	427,767	199	9	192
undo global data	428,948	72	1	71
simulator lru latch	24,039	53	2	51
redo allocation	418,272	34	9	25
user lock	1,354	34	44	14
object queue header operation	205,538	5	2	4
slave class create	8	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
active service list	ksws_event: ksws event	9	9
cache buffers chains	kcbgtcr: kslbegin excl	7,681	5,591
cache buffers chains	kcbrls: kslbegin	1,195	3,641
cache buffers chains	kcbchg: kslbegin: bufs not pinned	294	110
cache buffers chains	kcbnew: new latch again	131	0
cache buffers chains	kcbget: pin buffer	50	11
cache buffers chains	kcbgcur: kslbegin	47	1
cache buffers chains	kcbgtcr: fast path	39	3
cache buffers chains	kcbbic1	1	4
cache buffers chains	kcbbxsv	1	0
cost function	kzulrl	43	41
cost function	kzulgt: find user res	1	3
enqueue hash chains	ksqgtl3	1	1
kks stats	kks stats alloc/free	566	566
library cache	kglhdgn: child:	1,949	4,703
library cache	kgldte: child 0	1,034	4,032
library cache	kglobpn: child:	909	2,325
library cache	kglpndl: child: after processing	785	54
library cache	kglukp: child	657	655
library cache	kglLockCursor	647	405
library cache	kglpin	559	434
library cache	kgldti: 2child	468	372
library cache	kglati	443	25
library cache	kglpndl: child: before processing	224	562
library cache	kglScanDependency	48	5
library cache	kglhdgc: child:	41	9
library cache	kglobld	13	59
library cache	kgldtld: 2child	3	0
library cache	kglpnp: child	3	11
library cache	kglic	2	0
library cache lock	kgllkdl: child: no lock handle	1,941	2,022
library cache lock	kgllkdl: child: cleanup	5	7
library cache lock	kgllkal: child: multiinstance	4	2
object queue header operation	kcbo_switch_cq	2	0
redo allocation	kcrfw_redo_gen: redo allocation 1	9	0
row cache objects	kqrso	71	24
row cache objects	kqreqd: reget	67	0
row cache objects	kqrpre: find obj	40	156
row cache objects	kqreqd	13	12
row cache objects	kqrpup	1	0
session allocation	ksucri	1	4
session allocation	ksucrp	1	0
session allocation	ksudlc	1	0
session allocation	ksuprc	1	0
shared pool	kghalo	9,056	5,940
shared pool	kghfrunp: clatch: nowait	6,288	0
shared pool	kghfrunp: alloc: wait	3,424	593
shared pool	kghupr1	2,596	7,670
shared pool	kghfrunp: clatch: wait	1,972	2,313
shared pool	kghfre	922	1,247
shared pool	kghalp	741	1,435
shared pool	kghasp	367	60
shared pool	kghfree_extents: scan	21	191
shared pool	kghfrh	9	0
shared pool simulator	kglsim_upd_newhp	285	9
shared pool simulator	kglsim_unpin_simhp	271	28
shared pool simulator	kglsim_unpin_simhp: fast path	22	349
shared pool simulator	kglsim_scan_lru: scan	20	226
shared pool simulator	kglsim_chg_simhp_free	15	2
shared pool simulator	kglsim_chg_simhp_noob	3	2
simulator hash latch	kcbs_get_or_extract_simbufseq	48	0
simulator hash latch	kcbsacc: lookup dba	11	59
simulator lru latch	kcbs_simulate: simulate set	2	0
slave class create	ksvcreate	1	0
undo global data	ktudba: KSLBEGIN	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 297,498,319
Captured Segments account for 98.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SSTF505	USERS	CMI	TABLE	169,583,936	57.00
SSTF505	SSTF	DCT	TABLE	27,483,856	9.24
SSTF505	USERS	SPT	TABLE	19,179,008	6.45
SSTF505	SSTF	GLE	TABLE	12,699,968	4.27
SSTF505	SSTF	TRN_INR	INDEX	12,134,544	4.08

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 34,744
Captured Segments account for 82.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SSTF505	SSTF	ACF	TABLE	21,847	62.88
SSTF505	SSTF	GLE	TABLE	3,281	9.44
SSTF505	SSTF	GLE_TRNINR	INDEX	1,891	5.44
SSTF505	USERS	NTF	TABLE	729	2.10
SSTF505	USERS	NTF_USR	INDEX	182	0.52

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
SSTF505	USERS	QUE_BAL	INDEX	2	28.57
SSTF505	SSTF	SLG_INR	INDEX	2	28.57
SSTF505	USERS	PTS_NAM	INDEX	1	14.29
SSTF505	SSTF	SLG_LOG	INDEX	1	14.29
SSTF505	USERS	TRS_SSNINR	INDEX	1	14.29

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
SSTF505	USERS	LCKSSN	INDEX	21	58.33
SSTF505	USERS	CMI	TABLE	7	19.44
SSTF505	USERS	LCKIDX	INDEX	7	19.44
SSTF505	SSTF	GLE_TRNINR	INDEX	1	2.78

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	65	0.00	2	1
dc_database_links	654	0.00	0	1
dc_global_oids	545	0.55	0	262
dc_histogram_data	3,730,873	0.00	0	11,013
dc_histogram_defs	685,594	0.03	0	12,437
dc_object_ids	862,222	0.00	0	3,126
dc_objects	59,565	0.20	0	2,779
dc_profiles	384	0.00	0	1
dc_rollback_segments	1,533	0.00	0	60
dc_segments	223,912	0.00	10	3,075
dc_sequences	4,170	0.65	4,170	163
dc_tablespace_quotas	1	100.00	1	2
dc_tablespaces	296,834	0.00	0	7
dc_usernames	2,566	0.00	0	42
dc_users	340,462	0.00	0	64
outstanding_alerts	87	1.15	2	12

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	766	0.39	1,285	0.23	0	0
CLUSTER	10	0.00	21	0.00	0	0
INDEX	55	0.00	155	0.00	0	0
SQL AREA	85,875	34.60	1,000,908	4.68	1,224	15
TABLE/PROCEDURE	4,526	1.92	128,276	0.14	20	0
TRIGGER	117	0.00	307	0.00	0	0

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

B: Begin snap E: End snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	216.45		1.13	2.64	22	23	192	192
	Freeable	82.56	0.00	1.20	2.67	23		69	69
	SQL	2.71	1.49	0.01	0.04	0	66	184	82
	PL/SQL	0.87	0.49	0.00	0.01	0	0	192	192
E	Other	251.62		1.12	2.48	22	23	225	225
	Freeable	93.63	0.00	1.10	2.42	23		85	85
	SQL	11.72	10.35	0.05	0.41	4	66	217	107
	PL/SQL	1.28	0.72	0.01	0.01	0	0	225	225

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	6,828,326,912
Fixed Size	2,114,248
Redo Buffers	14,659,584
Variable Size	10,334,768,440

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	26.30	26.30	0.00
java	joxlod exec hp	5.52	5.52	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	CCursor	1,351.69	1,328.34	-1.73
shared	Cursor Stats	130.80	130.80	0.00
shared	PCursor	911.14	895.63	-1.70
shared	free memory	749.07	807.65	7.82
shared	kglsim heap	124.88	124.88	0.00
shared	kglsim object batch	169.13	169.13	0.00
shared	library cache	682.37	668.86	-1.98
shared	sql area	5,473.85	5,465.33	-0.16
	buffer_cache	6,512.00	6,512.00	0.00
	fixed_sga	2.02	2.02	0.00
	log_buffer	13.98	13.98	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Apply
Buffered Queues
Buffered Subscribers
Rule Set

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

only rows with Current or Maximum Utilization > 80% of Limit are shown
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
processes	226	500	500	500
sessions	234	555	555	555

init.ora Parameters

Parameter Name	Begin value	End value (if different)
_cursor_features_enabled	10
_db_fast_obj_truncate	FALSE
_enable_shared_pool_durations	FALSE
audit_file_dest	/home/oracle/admin/sstf505/adump
background_dump_dest	/home/oracle/admin/sstf505/bdump
compatible	10.2.0.3.0
control_files	/oradata/sstf505/control01.ctl, /oradata/sstf505/control02.ctl, /oradata/sstf505/control03.ctl
core_dump_dest	/home/oracle/admin/sstf505/cdump
db_block_size	8192
db_cache_size	4294967296
db_domain
db_file_multiblock_read_count	16
db_name	sstf505
job_queue_processes	10
log_archive_dest_1	location=/archive/sstf505
log_archive_format	arch_%t_%s_%r.arc
open_cursors	300
pga_aggregate_target	4294967296
processes	500
remote_login_passwordfile	EXCLUSIVE
session_cached_cursors	50
sga_max_size	17179869184
sga_target	17179869184
shared_pool_size	0
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/home/oracle/admin/sstf505/udump

End of Report

% Blocks changed per Read:	0.44	Recursive Call %:	16.95
Rollback per transaction %:	0.19	Rows per Sort:	69.09

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	95.84	Soft Parse %:	98.30
Execute to Parse %:	0.32	Latch Hit %:	91.03
Parse CPU to Parse Elapsd %:	3.18	% Non-Parse CPU:	96.19