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: 54410 19-Dec-14 15:01:00 236 2.9

End Snap: 54411 19-Dec-14 16:00:22 214 2.0

Elapsed: 59.37 (mins)

DB Time: 1,208.87 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	54410	19-Dec-14 15:01:00	236	2.9
End Snap:	54411	19-Dec-14 16:00:22	214	2.0
Elapsed:		59.37 (mins)
DB Time:		1,208.87 (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: 67,705.70 1,988.21

Logical reads: 32,464.16 953.33

Block changes: 323.37 9.50

Physical reads: 0.49 0.01

Physical writes: 7.03 0.21

User calls: 815.84 23.96

Parses: 244.31 7.17

Hard parses: 3.47 0.10

Sorts: 94.87 2.79

Logons: 0.24 0.01

Executes: 244.86 7.19

Transactions: 34.05

	Per Second	Per Transaction
Redo size:	67,705.70	1,988.21
Logical reads:	32,464.16	953.33
Block changes:	323.37	9.50
Physical reads:	0.49	0.01
Physical writes:	7.03	0.21
User calls:	815.84	23.96
Parses:	244.31	7.17
Hard parses:	3.47	0.10
Sorts:	94.87	2.79
Logons:	0.24	0.01
Executes:	244.86	7.19
Transactions:	34.05

% Blocks changed per Read: 1.00 Recursive Call %: 15.72

Rollback per transaction %: 0.41 Rows per Sort: 124.00

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 96.23 Soft Parse %: 98.58

Execute to Parse %: 0.22 Latch Hit %: 99.86

Parse CPU to Parse Elapsd %: 5.18 % Non-Parse CPU: 66.97

Shared Pool Statistics

Begin End

Memory Usage %: 92.12 92.13

% SQL with executions>1: 93.36 93.31

% Memory for SQL w/exec>1: 93.36 93.56

	Begin	End
Memory Usage %:	92.12	92.13
% SQL with executions>1:	93.36	93.31
% Memory for SQL w/exec>1:	93.36	93.56

Top 5 Timed Events

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

latch free 198,917 57,588 290 79.4 Other

latch: library cache 150,216 41,739 278 57.5 Concurrency

latch: session allocation 119,104 34,834 292 48.0 Other

latch: shared pool 103,678 28,946 279 39.9 Concurrency

CPU time 3,476 4.8

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
latch free	198,917	57,588	290	79.4	Other
latch: library cache	150,216	41,739	278	57.5	Concurrency
latch: session allocation	119,104	34,834	292	48.0	Other
latch: shared pool	103,678	28,946	279	39.9	Concurrency
CPU time		3,476		4.8

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): 72532.1s
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
parse time elapsed	22,296.12	30.74
sql execute elapsed time	11,491.10	15.84
connection management call elapsed time	4,072.24	5.61
DB CPU	3,475.90	4.79
hard parse elapsed time	1,741.59	2.40
sequence load elapsed time	503.09	0.69
PL/SQL execution elapsed time	65.68	0.09
PL/SQL compilation elapsed time	51.50	0.07
failed parse elapsed time	24.24	0.03
hard parse (sharing criteria) elapsed time	3.51	0.00
hard parse (bind mismatch) elapsed time	0.29	0.00
repeated bind elapsed time	0.00	0.00
DB time	72,532.10
background elapsed time	3,873.76
background cpu time	33.27

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
Other	76,643,158	0.00	92,515	1	631.84
Concurrency	259,613	0.05	71,556	276	2.14
Commit	124,653	0.00	109	1	1.03
System I/O	133,601	0.00	103	1	1.10
Application	1,611	0.00	26	16	0.01
User I/O	1,574	0.00	12	8	0.01
Network	2,148,305	0.00	8	0	17.71
Configuration	10	0.00	2	174	0.00

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 free	198,917	0.00	57,588	290	1.64
latch: library cache	150,216	0.00	41,739	278	1.24
latch: session allocation	119,104	0.00	34,834	292	0.98
latch: shared pool	103,678	0.00	28,946	279	0.85
latch: row cache objects	1,792	0.00	463	258	0.01
latch: cache buffers chains	3,528	0.00	174	49	0.03
row cache lock	70	64.29	145	2070	0.00
log file sync	124,653	0.00	109	1	1.03
log file parallel write	125,228	0.00	86	1	1.03
cursor: pin S	76,324,240	0.00	83	0	629.21
os thread startup	95	85.26	82	859	0.00
SQL*Net break/reset to client	1,611	0.00	26	16	0.01
db file sequential read	1,325	0.00	11	8	0.01
db file parallel write	1,048	0.00	6	6	0.01
SQL*Net message to client	2,074,277	0.00	6	0	17.10
control file parallel write	1,701	0.00	6	4	0.01
LGWR wait for redo copy	748	41.84	4	5	0.01
buffer busy waits	155	0.00	3	21	0.00
enq: TX - index contention	10	0.00	3	319	0.00
log file sequential read	279	0.00	3	10	0.00
latch: redo allocation	73	0.00	2	34	0.00
latch: library cache lock	63	0.00	2	36	0.00
Log archive I/O	283	0.00	2	8	0.00
SQL*Net more data to client	71,000	0.00	2	0	0.59
log file switch completion	8	0.00	2	209	0.00
rdbms ipc reply	27	0.00	1	48	0.00
latch: object queue header operation	23	0.00	1	54	0.00
db file scattered read	61	0.00	1	18	0.00
latch: cache buffers lru chain	5	0.00	1	104	0.00
enq: US - contention	12	0.00	0	39	0.00
latch: undo global data	1	0.00	0	131	0.00
latch: cache buffer handles	3	0.00	0	34	0.00
control file sequential read	5,056	0.00	0	0	0.04
latch: enqueue hash chains	2	0.00	0	32	0.00
cursor: pin S wait on X	6	100.00	0	10	0.00
direct path read	113	0.00	0	0	0.00
SQL*Net more data from client	3,028	0.00	0	0	0.02
enq: SQ - contention	1	0.00	0	37	0.00
enq: HW - contention	1	0.00	0	35	0.00
direct path write	75	0.00	0	0	0.00
log file single write	6	0.00	0	1	0.00
latch: messages	1	0.00	0	3	0.00
buffer deadlock	2	100.00	0	0	0.00
SQL*Net message from client	2,074,298	0.00	638,698	308	17.10
Streams AQ: qmn slave idle wait	127	0.00	3,465	27281	0.00
Streams AQ: qmn coordinator idle wait	260	51.15	3,463	13318	0.00
jobq slave wait	939	96.06	2,735	2913	0.01
Streams AQ: waiting for messages in the queue	460	100.00	2,246	4883	0.00
Streams AQ: waiting for time management or cleanup tasks	5	100.00	756	151232	0.00
class slave wait	3	0.00	0	36	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
latch: shared pool	4,300	0.00	1,242	289	0.04
latch: library cache	3,872	0.00	1,114	288	0.03
events in waitclass Other	2,753	11.37	563	204	0.02
log file parallel write	125,228	0.00	86	1	1.03
os thread startup	95	85.26	82	859	0.00
db file parallel write	1,048	0.00	6	6	0.01
control file parallel write	1,701	0.00	6	4	0.01
log file sequential read	279	0.00	3	10	0.00
Log archive I/O	283	0.00	2	8	0.00
latch: row cache objects	4	0.00	1	226	0.00
latch: library cache lock	3	0.00	0	87	0.00
db file sequential read	7	0.00	0	27	0.00
row cache lock	1	0.00	0	186	0.00
control file sequential read	4,145	0.00	0	0	0.03
buffer busy waits	7	0.00	0	6	0.00
direct path read	27	0.00	0	0	0.00
direct path write	27	0.00	0	0	0.00
log file single write	6	0.00	0	1	0.00
latch: cache buffers chains	1	0.00	0	3	0.00
rdbms ipc message	135,211	7.57	34,336	254	1.11
Streams AQ: qmn slave idle wait	127	0.00	3,465	27281	0.00
Streams AQ: qmn coordinator idle wait	260	51.15	3,463	13318	0.00
pmon timer	1,198	98.25	3,454	2883	0.01
smon timer	19	31.58	2,614	137558	0.00
Streams AQ: waiting for time management or cleanup tasks	5	100.00	756	151232	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	104,613
AVG_IDLE_TIME	251,541
AVG_IOWAIT_TIME	57,425
AVG_SYS_TIME	6,787
AVG_USER_TIME	97,727
BUSY_TIME	837,732
IDLE_TIME	2,013,120
IOWAIT_TIME	460,240
SYS_TIME	55,138
USER_TIME	782,594
LOAD	0
OS_CPU_WAIT_TIME	933,200
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	69,225.20	3,353.90	1,641	113,320,674
SYS$USERS	3,303.80	119.10	0	2,212,488
SYS$BACKGROUND	0.00	0.00	107	22,870

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	1370	1166	161700	4313412	2141878	602
SYS$USERS	54	0	11950	340542	2846	190
SYS$BACKGROUND	150	59	8344	244656	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
2,541	9	899	2.83	3.50	40kb7rvhsy3nu	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM LCK WHERE LCKSNR =...
1,084	2	510	2.13	1.49	g9mg54585mfgz	td2soci@sstfsrv1 (TNS V1-V3)	select count(*) from NTF where...
682	55	5,129	0.13	0.94	ddstpsqy9rpfa	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR FROM NTF WHERE ( SS...
675	2	1	674.95	0.93	5duayrrh6k5a8	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, PTYINR, NAM, PR...
627	1	1	626.84	0.86	akazb0unk6twa	td2soci@sstfsrv1 (TNS V1-V3)	select BLA.INR, BLA.OWNREF, ...
624	2	1	624.43	0.86	0csmvccjxkvqu	td2soci@sstfsrv1 (TNS V1-V3)	select BLA.INR, BLA.OWNREF, ...
612	1	1	612.09	0.84	ghzmcdstk5n63	td2soci@sstfsrv1 (TNS V1-V3)	select PTA.INR, PTA.NAM, PTA...
607	2	3	202.29	0.84	3sx76sntp7q9v	td2soci@sstfsrv1 (TNS V1-V3)	select COUNT(*) from cbe where...
604	1	366	1.65	0.83	cxm0nyjbg9ywq	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, EXTKEY, NAM, PT...
597	1	4	149.15	0.82	1tymgndw665yw	td2soci@sstfsrv1 (TNS V1-V3)	select PTS.OBJINR from PTS, C...

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
435	449	151	2.88	0.62	fhmr0c323uyn1	td2soci@sstfsrv1 (TNS V1-V3)	SELECT TRIM(TYP) FROM ACT WHER...
404	432	3,875	0.10	0.60	btuff29cwbx6v	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, USRINR, EXTKEY, ...
156	304	426	0.37	0.42	6ngschdubbuuv	td2soci@sstfsrv1 (TNS V1-V3)	select cur from xrt where to_c...
143	229	546	0.26	0.32	cdcmxy4zbadk3	td2soci@sstfsrv1 (TNS V1-V3)	SELECT COUNT(*) FROM SSN WHERE...
93	266	58,011	0.00	0.37	3bmfazzhuzcz1	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO LCK ( LCKSTR, LCK...
82	89	107	0.77	0.12	bqw1mnb4jj3x6	td2soci@sstfsrv1 (TNS V1-V3)	SELECT WFSINR, WFSSUB, STA, ...
58	96	60	0.96	0.13	9jmrmj85jvjan		INSERT INTO XS_XRT VALUE (SELE...
55	682	5,129	0.01	0.94	ddstpsqy9rpfa	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR FROM NTF WHERE ( SS...
51	91	32	1.60	0.13	0prmqa8nh4c5b		insert into xrt(inr, cur, begd...
51	58	28	1.80	0.08	67vq5yv0dnvqd		update xrt set enddat = TO_DAT...
9	2,541	899	0.01	3.50	40kb7rvhsy3nu	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM LCK WHERE LCKSNR =...
2	1,084	510	0.00	1.49	g9mg54585mfgz	td2soci@sstfsrv1 (TNS V1-V3)	select count(*) from NTF where...

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: 115,639,399
Captured SQL account for 34.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
6,426,455	1,089	5,901.24	5.56	35.36	110.11	6jbxqc4j15kkf	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, TRNINR, EVTTXT F...
5,654,181	5,129	1,102.39	4.89	55.44	682.10	ddstpsqy9rpfa	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR FROM NTF WHERE ( SS...
5,293,237	107	49,469.50	4.58	81.92	89.07	bqw1mnb4jj3x6	td2soci@sstfsrv1 (TNS V1-V3)	SELECT WFSINR, WFSSUB, STA, ...
2,079,178	20	103,958.90	1.80	39.20	68.62	2yk3t8pbwmh37	td2soci@sstfsrv1 (TNS V1-V3)	select distinct(substr(trim(ex...
1,432,541	109	13,142.58	1.24	13.64	111.11	7fs01fyhjb26t	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, OWNREF, VER, OB...
1,262,977	528	2,392.00	1.09	11.74	15.92	f14af6t91skac	td2soci@sstfsrv1 (TNS V1-V3)	select extkey from dct where c...
1,247,484	12	103,957.00	1.08	24.50	25.79	14j0ypycsbnzt	td2soci@sstfsrv1 (TNS V1-V3)	select distinct(substr(trim(ex...
1,022,414	426	2,400.03	0.88	155.85	303.67	6ngschdubbuuv	td2soci@sstfsrv1 (TNS V1-V3)	select cur from xrt where to_c...
1,012,373	77	13,147.70	0.88	45.93	57.75	bnfwkpwbvmg4u	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO CMI ( INR, OWNREF...
1,011,853	77	13,140.95	0.88	45.89	56.80	cvqj8skq9ndtg	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM CMI WHERE ROWID IN...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 1,747
Captured SQL account for 6.9% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
32	15,160	0.00	1.83	2.42	3.09	fytufwfc4tm67	td2soci@sstfsrv1 (TNS V1-V3)	SELECT WFSINR, WFSSUB, SRV, ...
27	58,011	0.00	1.55	92.66	266.07	3bmfazzhuzcz1	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO LCK ( LCKSTR, LCK...
16	1	16.00	0.92	0.01	0.05	0dwr2vd6vbqzs		SELECT count(*) over () as tot...
12	510	0.02	0.69	2.05	1084.04	g9mg54585mfgz	td2soci@sstfsrv1 (TNS V1-V3)	select count(*) from NTF where...
8	7	1.14	0.46	0.02	0.23	c731d01yzs6n1	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO LID ( INR, OWNREF...
7	1,483	0.00	0.40	0.62	17.21	3avtycgm901xc	td2soci@sstfsrv1 (TNS V1-V3)	UPDATE SSN SET INR = :V0, BEG...
4	5	0.80	0.23	0.00	0.17	51u6jnqpjxn75	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO ADR ( INR, EXTKEY...
4	77	0.05	0.23	45.93	57.75	bnfwkpwbvmg4u	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO CMI ( INR, OWNREF...
3	5	0.60	0.17	0.01	0.19	8swypbbr0m372		select order#, columns, types ...
2	4	0.50	0.11	0.74	596.58	1tymgndw665yw	td2soci@sstfsrv1 (TNS V1-V3)	select PTS.OBJINR from PTS, C...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 872,189
Captured SQL account for 88.2% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
224,849	0	0.00	anpw5shtv1m86	td2soci@sstfsrv1 (TNS V1-V3)	select smhinr from ned where s...
158,290	12,253	0.08	529br8svudttu	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM LCK WHERE LCKSNR =...
120,454	120,454	1.00	98f93q0w2732s	td2soci@sstfsrv1 (TNS V1-V3)	select MSGTYP, SNDKEY, RELCU...
58,011	57,838	1.00	3bmfazzhuzcz1	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO LCK ( LCKSTR, LCK...
44,792	44,792	1.00	5hbp28fq03mbx	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM LCK WHERE LCKSTR =...
36,336	36,336	1.00	93hyuhdd8w198	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, OBJTYP, OBJINR, ...
17,750	17,104	0.96	d7gzc3tkjsvjg	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, INIDATTIM, INIFR...
15,160	117,094	7.72	fytufwfc4tm67	td2soci@sstfsrv1 (TNS V1-V3)	SELECT WFSINR, WFSSUB, SRV, ...
14,664	14,664	1.00	gft02zzrfnvus	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, OBJTYP, OBJINR, ...
8,773	8,773	1.00	2wkqpwk877aaw	td2soci@sstfsrv1 (TNS V1-V3)	UPDATE WFE SET WFSINR = :V0, ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 870,239
Captured SQL account for 88.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
224,836	224,849	25.84	anpw5shtv1m86	td2soci@sstfsrv1 (TNS V1-V3)	select smhinr from ned where s...
158,284	158,290	18.19	529br8svudttu	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM LCK WHERE LCKSNR =...
120,454	120,454	13.84	98f93q0w2732s	td2soci@sstfsrv1 (TNS V1-V3)	select MSGTYP, SNDKEY, RELCU...
58,012	58,011	6.67	3bmfazzhuzcz1	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO LCK ( LCKSTR, LCK...
44,791	44,792	5.15	5hbp28fq03mbx	td2soci@sstfsrv1 (TNS V1-V3)	DELETE FROM LCK WHERE LCKSTR =...
36,336	36,336	4.18	93hyuhdd8w198	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, OBJTYP, OBJINR, ...
17,750	17,750	2.04	d7gzc3tkjsvjg	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, INIDATTIM, INIFR...
15,161	15,160	1.74	fytufwfc4tm67	td2soci@sstfsrv1 (TNS V1-V3)	SELECT WFSINR, WFSSUB, SRV, ...
14,664	14,664	1.69	gft02zzrfnvus	td2soci@sstfsrv1 (TNS V1-V3)	SELECT INR, OBJTYP, OBJINR, ...
8,773	8,773	1.01	2wkqpwk877aaw	td2soci@sstfsrv1 (TNS V1-V3)	UPDATE WFE SET WFSINR = :V0, ...

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
102	5	51u6jnqpjxn75	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO ADR ( INR, EXTKEY...
79	14	bz4jkykxt2vxq	td2soci@sstfsrv1 (TNS V1-V3)	UPDATE LIT SET INR = :V0, ADL...
78	14	44gm2ahj9a35t	td2soci@sstfsrv1 (TNS V1-V3)	UPDATE LID SET INR = :V0, OWN...
71	110	18naypzfmabd6		INSERT INTO MGMT_SYSTEM_PERFOR...
48	7	c731d01yzs6n1	td2soci@sstfsrv1 (TNS V1-V3)	INSERT INTO LID ( INR, OWNREF...
46	8,773	2wkqpwk877aaw	td2soci@sstfsrv1 (TNS V1-V3)	UPDATE WFE SET WFSINR = :V0, ...
22	77	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

0csmvccjxkvqu select BLA.INR, BLA.OWNREF, BLA.PTYCOD, BLA.PTYNAM, BLA.REPCOD, BLA.TRDWAY, BLA.BLARAT, BLA.TRDRAT, BLA.CURBID, BLA.CUR, BLA.AMT, BLA.LIQRAT, BLA.TRDWAY1, BLA.LIQCUR, BLA.LIQTRDWAY, BLA.LIQAMT, BLA.EXPNEWCOD, BLA.EXPTRDWAY1, BLA.EXPBLARAT, BLA.EXPTRDRAT, BLA.EXPCUR, BLA.EXPAMT, BLA.BCKTIM, BLA.EXPTRDWAY2, BLA.USEFLG, BLA.SETDAT, BLA.SPLITCCYPAIR, BLA.SPLITRATE from BLA BLA where ownref like '%NJB2014SH00352%'and cur='USD' and AMT=TO_NUMBER('1000000.000') and to_char(bcktim, 'YYYYMMDD')='20141219' AND CURBID='USD.CNY' and LIQAMT=0 and trim(useflg)<>'2' order by BLA.OWNREF

0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id

0prmqa8nh4c5b insert into xrt(inr, cur, begdat, enddat, buyrat, midrat, selrat, ttrrat, odrrat, ver, resrat, rebrat, ibrrat, sel1rat, buy1rat, etgextkey, xrttim, ratcnt, bidblarat, midblarat, askblarat, splitccypair, splitratebid, splitrateask) values( :1 , :2 , TO_DATE( :3 , 'YYYY-MM-DD'), TO_DATE( '2299-12-31' , 'YYYY-MM-DD'), :4 , :5 , :6 , '0' , '0' , '0000', '0', '0', '0', '0', '0', 'EIBANKG ', :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 )

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

18naypzfmabd6 INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))

1tymgndw665yw select PTS.OBJINR from PTS, CPD where PTS.OBJTYP = :W0 and PTS.OBJINR = CPD.INR and PTS.ROL = :W1 and PTS.REF = :W2 and PTS.PTAINR = :W3 and CPD.ETYEXTKEY = 'EIBANK' AND CPD.BCHKEYINR='00000028'

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

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

3avtycgm901xc UPDATE SSN SET INR = :V0, BEGDATTIM = :V1, ENDDATTIM = :V2, STA = :V3, LSTDATTIM = :V4, LSTFRM = :V5, APPSRV = :V6, DISSRV = :V7, ENG = :V8, APPPID = :V9, DISPID = :V10, BCKGRD = :V11, USR = :V12, ETY = :V13 WHERE INR = :W0

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

3sx76sntp7q9v select COUNT(*) from cbe where extid like '%OTH%' AND TRNINR='00579298' AND TRIM(CBT) IN('CCVIN', 'CCVOUT')

40kb7rvhsy3nu DELETE FROM LCK WHERE LCKSNR = :1

44gm2ahj9a35t UPDATE LID SET INR = :V0, OWNREF = :V1, NAM = :V2, OWNUSR = :V3, CREDAT = :V4, OPNDAT = :V5, CLSDAT = :V6, ADVNAM = :V7, ADVREF = :V8, AMEDAT = :V9, AMENBR = :V10, APLNAM = :V11, APLREF = :V12, AVBBY = :V13, AVBWTH = :V14, BENNAM = :V15, BENREF = :V16, CHATO = :V17, CNFDET = :V18, EXPDAT = :V19, EXPPLC = :V20, LCRTYP = :V21, NOMSPC = :V22, NOMTOP = :V23, NOMTON = :V24, PREADVDT = :V25, RMBACT = :V26, RMBCHA = :V27, RMBFLG = :V28, SHPDAT = :V29, SHPFRO = :V30, PORLOA = :V31, PORDIS = :V32, SHPPAR = :V33, SHPTO = :V34, SHPTRS = :V35, STACTY = :V36, STAGOD = :V37, UTLNBR = :V38, ADVNBR = :V39, REDCLSFLG = :V40, VER = :V41, LCITYP = :V42, B2BINR = :V43, B2BREF = :V44, REVNBR = :V45, REVTIMES = :V46, REVFLG = :V47, REVAWAPL = :V48, REVDAT = :V49, REVCUM = :V50, REVTYP = :V51, INITPTY = :V52, RESFLG = :V53, APPRUL = :V54, APPRULRMB = :V55, APPRULTXT = :V56, AUTDAT = :V57, ETYEXTKEY = :V58, BRANCHINR = :V59, BCHKEYINR = :V60, TENMAXDAY = :V61, DFLG = :V62, TRATYP = :V63, GUAFLG = :V64, USSFLG = :V65 WHERE INR = :W0

51u6jnqpjxn75 INSERT INTO ADR ( INR, EXTKEY, NAM, BIC, BICAUT, BID, BLZ, CLC, DPT, EML, FAX1, FAX2, NAM1, NAM2, NAM3, STR1, STR2, LOCZIP, LOCTXT, LOC2, LOCCTY, CORTYP, POB, POBZIP, POBTXT, TEL1, TEL2, TID, TLX, TLXAUT, UIL, VER, MANMOD, RTGFLG, TARFLG, DTACID, DTECID, ETGEXTKEY, ISBCHFLG, BCHIDN, ADR1, ADR2, ADR3, ADR4, EDICID ) 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, :V39, :V40, :V41, :V42, :V43, :V44 )

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

5duayrrh6k5a8 SELECT INR, PTYINR, NAM, PRI, ENO, OBJTYP, OBJINR, OBJKEY, USG, VER, BIC, ADRSTA, PTYTYP, PTYEXTKEY, TID, ETGEXTKEY, BRANCHINR, BCHKEYINR, ISSBCHINF FROM PTA WHERE ETGEXTKEY = 'EIBANKG' AND ( BRANCHINR IN (SELECT INR FROM BCH WHERE BCHKEY='2080004') or PTYTYP LIKE '%B%' or PTYTYP LIKE '%F%' ) and ( ( UPPER( PTA.PTYEXTKEY ) LIKE UPPER( '%AFNBUS4HXXX%' ) or UPPER( PTA.OBJKEY ) LIKE UPPER( '%AFNBUS4HXXX%' ) ) and ( ( PTA.PTYTYP LIKE '%B%' OR PTA.PTYTYP LIKE '%A%' ) AND PTA.ADRSTA = ' ' ) )

5hbp28fq03mbx DELETE FROM LCK WHERE LCKSTR = :1

67vq5yv0dnvqd update xrt set enddat = TO_DATE( :1 , 'YYYY-MM-DD') where trim(inr) = :2

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

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

7fs01fyhjb26t SELECT 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 FROM CMI WHERE OWNREF = :W0

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

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))

akazb0unk6twa select BLA.INR, BLA.OWNREF, BLA.PTYCOD, BLA.PTYNAM, BLA.REPCOD, BLA.TRDWAY, BLA.BLARAT, BLA.TRDRAT, BLA.CURBID, BLA.CUR, BLA.AMT, BLA.LIQRAT, BLA.TRDWAY1, BLA.LIQCUR, BLA.LIQTRDWAY, BLA.LIQAMT, BLA.EXPNEWCOD, BLA.EXPTRDWAY1, BLA.EXPBLARAT, BLA.EXPTRDRAT, BLA.EXPCUR, BLA.EXPAMT, BLA.BCKTIM, BLA.EXPTRDWAY2, BLA.USEFLG, BLA.SETDAT, BLA.SPLITCCYPAIR, BLA.SPLITRATE from BLA BLA where ownref like '%NJB2014SH00353%'and cur='' and AMT=TO_NUMBER('382636.800') and to_char(bcktim, 'YYYYMMDD')='20141219' AND CURBID='.CNY' and LIQAMT=0 and trim(useflg)<>'2' order by BLA.OWNREF

anpw5shtv1m86 select smhinr from ned where smhinr = ''

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

btuff29cwbx6v SELECT INR, USRINR, EXTKEY, NAM FROM USF WHERE USRINR = :W0 AND EXTKEY = :W1

bz4jkykxt2vxq UPDATE LIT SET INR = :V0, ADLCND = EMPTY_CLOB(), DEFDET = :V2, DFTAT = :V3, FEETXT = :V4, INSBNK = :V5, LCRDOC = EMPTY_CLOB(), LCRGOD = EMPTY_CLOB(), MIXDET = :V8, PREPER = :V9, RMBCHA = :V10, SHPPER = :V11, VER = :V12, ADLCNDAME = EMPTY_CLOB(), LCRGODAME = EMPTY_CLOB(), LCRDOCAME = EMPTY_CLOB(), NARHIS = EMPTY_CLOB(), FLDMODBLK = EMPTY_CLOB(), REVNOTES = :V18, REVCLS = :V19, AVBWTHTXT = :V20, ADDAMTCOV = :V21, INSBNKAME = EMPTY_CLOB(), CONTAG72 = EMPTY_CLOB(), CONTAG79 = EMPTY_CLOB(), PREPERDEF = :V25, PREPERFLG = :V26, AMTAMELST = EMPTY_CLOB() WHERE INR = :W0 RETURNING ADLCND, LCRDOC, LCRGOD, ADLCNDAME, LCRGODAME, LCRDOCAME, NARHIS, FLDMODBLK, INSBNKAME, CONTAG72, CONTAG79, AMTAMELST INTO :V1, :V6, :V7, :V13, :V14, :V15, :V16, :V17, :V22, :V23, :V24, :V27

c731d01yzs6n1 INSERT INTO LID ( INR, OWNREF, NAM, OWNUSR, CREDAT, OPNDAT, CLSDAT, ADVNAM, ADVREF, AMEDAT, AMENBR, APLNAM, APLREF, AVBBY, AVBWTH, BENNAM, BENREF, CHATO, CNFDET, EXPDAT, EXPPLC, LCRTYP, NOMSPC, NOMTOP, NOMTON, PREADVDT, RMBACT, RMBCHA, RMBFLG, SHPDAT, SHPFRO, PORLOA, PORDIS, SHPPAR, SHPTO, SHPTRS, STACTY, STAGOD, UTLNBR, ADVNBR, REDCLSFLG, VER, LCITYP, B2BINR, B2BREF, REVNBR, REVTIMES, REVFLG, REVAWAPL, REVDAT, REVCUM, REVTYP, INITPTY, RESFLG, APPRUL, APPRULRMB, APPRULTXT, AUTDAT, ETYEXTKEY, BRANCHINR, BCHKEYINR, TENMAXDAY, DFLG, TRATYP, GUAFLG, USSFLG ) 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, :V39, :V40, :V41, :V42, :V43, :V44, :V45, :V46, :V47, :V48, :V49, :V50, :V51, :V52, :V53, :V54, :V55, :V56, :V57, :V58, :V59, :V60, :V61, :V62, :V63, :V64, :V65 )

cdcmxy4zbadk3 SELECT COUNT(*) FROM SSN WHERE STA = 'A'

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

cxm0nyjbg9ywq SELECT INR, EXTKEY, NAM, PTYTYP, ACCUSR, HBKACCFLG, HBKCONFLG, HBKINR, HEQACCFLG, HEQCONFLG, HEQINR, PRFCTR, RESUSR, RSKCLS, RSKCTY, RSKTXT, UIL, VER, AKKBRA, AKKCOM, AKKREG, LIDCNDFLG, LIDMAXDUR, TRDCNDFLG, TRDTENTOT, TRDTENINI, TRDTENEXT, TRDEXTNMB, BADCNDFLG, BADTENEXT, ADRSTA, SELTYP, BUYTYP, SLA, ETGEXTKEY, NAM1, BRANCHINR, JUSCOD, BILVVV, CUNQII, IDCODE, IDTYPE, BCHKEYINR, CLSCTY, PROCOD, RGCP, CRNM, CRIT, CRID, RGCPCUR, CTVC, CRDCNT, CLIENTID FROM PTY WHERE INR = :W0

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

f14af6t91skac select extkey from dct where cur='USD' and subcod in ('215001') and bch='2040' order by inr

fhmr0c323uyn1 SELECT TRIM(TYP) FROM ACT WHERE EXTKEY='2220000111506040131'

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

g9mg54585mfgz select count(*) from NTF where USR = :W0 AND SHWSSNINR = ' ' and (EXPDATTIM > :W1 or EXPDATTIM is null)

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

ghzmcdstk5n63 select PTA.INR, PTA.NAM, PTA.OBJKEY, PTA.USG, PTA.VER, PTA.BIC, PTA.PTYTYP, PTA.PTYEXTKEY, PTA.TID from PTA PTA where PTA.ETGEXTKEY = 'EIBANKG' AND ( PTA.BRANCHINR IN (SELECT INR FROM BCH WHERE BCHKEY='2110004') or PTA.PTYTYP LIKE '%B%' or PTA.PTYTYP LIKE '%F%' ) and ( (PTA.NAM like '%26%' OR PTA.PTYEXTKEY like '%26%' OR PTA.OBJKEY like '%26%' OR PTA.BIC like '%26%' ) and ( ( PTA.PTYTYP LIKE '%C%' ) AND PTA.ADRSTA = ' ' ) ) order by PTA.NAM

SQL Id	SQL Text
0csmvccjxkvqu	select BLA.INR, BLA.OWNREF, BLA.PTYCOD, BLA.PTYNAM, BLA.REPCOD, BLA.TRDWAY, BLA.BLARAT, BLA.TRDRAT, BLA.CURBID, BLA.CUR, BLA.AMT, BLA.LIQRAT, BLA.TRDWAY1, BLA.LIQCUR, BLA.LIQTRDWAY, BLA.LIQAMT, BLA.EXPNEWCOD, BLA.EXPTRDWAY1, BLA.EXPBLARAT, BLA.EXPTRDRAT, BLA.EXPCUR, BLA.EXPAMT, BLA.BCKTIM, BLA.EXPTRDWAY2, BLA.USEFLG, BLA.SETDAT, BLA.SPLITCCYPAIR, BLA.SPLITRATE from BLA BLA where ownref like '%NJB2014SH00352%'and cur='USD' and AMT=TO_NUMBER('1000000.000') and to_char(bcktim, 'YYYYMMDD')='20141219' AND CURBID='USD.CNY' and LIQAMT=0 and trim(useflg)<>'2' order by BLA.OWNREF
0dwr2vd6vbqzs	SELECT count() over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash., evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe., nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap. FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count() as cnt FROM (SELECT t1. FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0prmqa8nh4c5b	insert into xrt(inr, cur, begdat, enddat, buyrat, midrat, selrat, ttrrat, odrrat, ver, resrat, rebrat, ibrrat, sel1rat, buy1rat, etgextkey, xrttim, ratcnt, bidblarat, midblarat, askblarat, splitccypair, splitratebid, splitrateask) values( :1 , :2 , TO_DATE( :3 , 'YYYY-MM-DD'), TO_DATE( '2299-12-31' , 'YYYY-MM-DD'), :4 , :5 , :6 , '0' , '0' , '0000', '0', '0', '0', '0', '0', 'EIBANKG ', :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 )
14j0ypycsbnzt	select distinct(substr(trim(expses), -4)) from gle where branchinr='00000017' and to_char(bucdat, 'YYYYMMDD')='20141219' and substr(trim(expses), 1, 1)='C' order by substr(trim(expses), -4) desc
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1tymgndw665yw	select PTS.OBJINR from PTS, CPD where PTS.OBJTYP = :W0 and PTS.OBJINR = CPD.INR and PTS.ROL = :W1 and PTS.REF = :W2 and PTS.PTAINR = :W3 and CPD.ETYEXTKEY = 'EIBANK' AND CPD.BCHKEYINR='00000028'
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
2yk3t8pbwmh37	select distinct(substr(trim(expses), -4)) from gle where branchinr='00000017' and to_char(bucdat, 'YYYYMMDD')='20141219' and substr(trim(expses), 1, 1)='A' order by substr(trim(expses), -4) desc
3avtycgm901xc	UPDATE SSN SET INR = :V0, BEGDATTIM = :V1, ENDDATTIM = :V2, STA = :V3, LSTDATTIM = :V4, LSTFRM = :V5, APPSRV = :V6, DISSRV = :V7, ENG = :V8, APPPID = :V9, DISPID = :V10, BCKGRD = :V11, USR = :V12, ETY = :V13 WHERE INR = :W0
3bmfazzhuzcz1	INSERT INTO LCK ( LCKSTR, LCKUSR, LCKSNR, LCKDATTIM, LCKHLD ) VALUES ( :1, :2, :3, :4, :5 )
3sx76sntp7q9v	select COUNT(*) from cbe where extid like '%OTH%' AND TRNINR='00579298' AND TRIM(CBT) IN('CCVIN', 'CCVOUT')
40kb7rvhsy3nu	DELETE FROM LCK WHERE LCKSNR = :1
44gm2ahj9a35t	UPDATE LID SET INR = :V0, OWNREF = :V1, NAM = :V2, OWNUSR = :V3, CREDAT = :V4, OPNDAT = :V5, CLSDAT = :V6, ADVNAM = :V7, ADVREF = :V8, AMEDAT = :V9, AMENBR = :V10, APLNAM = :V11, APLREF = :V12, AVBBY = :V13, AVBWTH = :V14, BENNAM = :V15, BENREF = :V16, CHATO = :V17, CNFDET = :V18, EXPDAT = :V19, EXPPLC = :V20, LCRTYP = :V21, NOMSPC = :V22, NOMTOP = :V23, NOMTON = :V24, PREADVDT = :V25, RMBACT = :V26, RMBCHA = :V27, RMBFLG = :V28, SHPDAT = :V29, SHPFRO = :V30, PORLOA = :V31, PORDIS = :V32, SHPPAR = :V33, SHPTO = :V34, SHPTRS = :V35, STACTY = :V36, STAGOD = :V37, UTLNBR = :V38, ADVNBR = :V39, REDCLSFLG = :V40, VER = :V41, LCITYP = :V42, B2BINR = :V43, B2BREF = :V44, REVNBR = :V45, REVTIMES = :V46, REVFLG = :V47, REVAWAPL = :V48, REVDAT = :V49, REVCUM = :V50, REVTYP = :V51, INITPTY = :V52, RESFLG = :V53, APPRUL = :V54, APPRULRMB = :V55, APPRULTXT = :V56, AUTDAT = :V57, ETYEXTKEY = :V58, BRANCHINR = :V59, BCHKEYINR = :V60, TENMAXDAY = :V61, DFLG = :V62, TRATYP = :V63, GUAFLG = :V64, USSFLG = :V65 WHERE INR = :W0
51u6jnqpjxn75	INSERT INTO ADR ( INR, EXTKEY, NAM, BIC, BICAUT, BID, BLZ, CLC, DPT, EML, FAX1, FAX2, NAM1, NAM2, NAM3, STR1, STR2, LOCZIP, LOCTXT, LOC2, LOCCTY, CORTYP, POB, POBZIP, POBTXT, TEL1, TEL2, TID, TLX, TLXAUT, UIL, VER, MANMOD, RTGFLG, TARFLG, DTACID, DTECID, ETGEXTKEY, ISBCHFLG, BCHIDN, ADR1, ADR2, ADR3, ADR4, EDICID ) 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, :V39, :V40, :V41, :V42, :V43, :V44 )
529br8svudttu	DELETE FROM LCK WHERE LCKSNR = :1 AND LCKHLD = :2
5duayrrh6k5a8	SELECT INR, PTYINR, NAM, PRI, ENO, OBJTYP, OBJINR, OBJKEY, USG, VER, BIC, ADRSTA, PTYTYP, PTYEXTKEY, TID, ETGEXTKEY, BRANCHINR, BCHKEYINR, ISSBCHINF FROM PTA WHERE ETGEXTKEY = 'EIBANKG' AND ( BRANCHINR IN (SELECT INR FROM BCH WHERE BCHKEY='2080004') or PTYTYP LIKE '%B%' or PTYTYP LIKE '%F%' ) and ( ( UPPER( PTA.PTYEXTKEY ) LIKE UPPER( '%AFNBUS4HXXX%' ) or UPPER( PTA.OBJKEY ) LIKE UPPER( '%AFNBUS4HXXX%' ) ) and ( ( PTA.PTYTYP LIKE '%B%' OR PTA.PTYTYP LIKE '%A%' ) AND PTA.ADRSTA = ' ' ) )
5hbp28fq03mbx	DELETE FROM LCK WHERE LCKSTR = :1
67vq5yv0dnvqd	update xrt set enddat = TO_DATE( :1 , 'YYYY-MM-DD') where trim(inr) = :2
6jbxqc4j15kkf	SELECT INR, TRNINR, EVTTXT FROM TRNEVT WHERE TRNINR = :W0
6ngschdubbuuv	select cur from xrt where to_char(begdat, 'YYYYMMDD')=:W0
7fs01fyhjb26t	SELECT 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 FROM CMI WHERE OWNREF = :W0
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
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))
akazb0unk6twa	select BLA.INR, BLA.OWNREF, BLA.PTYCOD, BLA.PTYNAM, BLA.REPCOD, BLA.TRDWAY, BLA.BLARAT, BLA.TRDRAT, BLA.CURBID, BLA.CUR, BLA.AMT, BLA.LIQRAT, BLA.TRDWAY1, BLA.LIQCUR, BLA.LIQTRDWAY, BLA.LIQAMT, BLA.EXPNEWCOD, BLA.EXPTRDWAY1, BLA.EXPBLARAT, BLA.EXPTRDRAT, BLA.EXPCUR, BLA.EXPAMT, BLA.BCKTIM, BLA.EXPTRDWAY2, BLA.USEFLG, BLA.SETDAT, BLA.SPLITCCYPAIR, BLA.SPLITRATE from BLA BLA where ownref like '%NJB2014SH00353%'and cur='' and AMT=TO_NUMBER('382636.800') and to_char(bcktim, 'YYYYMMDD')='20141219' AND CURBID='.CNY' and LIQAMT=0 and trim(useflg)<>'2' order by BLA.OWNREF
anpw5shtv1m86	select smhinr from ned where smhinr = ''
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
btuff29cwbx6v	SELECT INR, USRINR, EXTKEY, NAM FROM USF WHERE USRINR = :W0 AND EXTKEY = :W1
bz4jkykxt2vxq	UPDATE LIT SET INR = :V0, ADLCND = EMPTY_CLOB(), DEFDET = :V2, DFTAT = :V3, FEETXT = :V4, INSBNK = :V5, LCRDOC = EMPTY_CLOB(), LCRGOD = EMPTY_CLOB(), MIXDET = :V8, PREPER = :V9, RMBCHA = :V10, SHPPER = :V11, VER = :V12, ADLCNDAME = EMPTY_CLOB(), LCRGODAME = EMPTY_CLOB(), LCRDOCAME = EMPTY_CLOB(), NARHIS = EMPTY_CLOB(), FLDMODBLK = EMPTY_CLOB(), REVNOTES = :V18, REVCLS = :V19, AVBWTHTXT = :V20, ADDAMTCOV = :V21, INSBNKAME = EMPTY_CLOB(), CONTAG72 = EMPTY_CLOB(), CONTAG79 = EMPTY_CLOB(), PREPERDEF = :V25, PREPERFLG = :V26, AMTAMELST = EMPTY_CLOB() WHERE INR = :W0 RETURNING ADLCND, LCRDOC, LCRGOD, ADLCNDAME, LCRGODAME, LCRDOCAME, NARHIS, FLDMODBLK, INSBNKAME, CONTAG72, CONTAG79, AMTAMELST INTO :V1, :V6, :V7, :V13, :V14, :V15, :V16, :V17, :V22, :V23, :V24, :V27
c731d01yzs6n1	INSERT INTO LID ( INR, OWNREF, NAM, OWNUSR, CREDAT, OPNDAT, CLSDAT, ADVNAM, ADVREF, AMEDAT, AMENBR, APLNAM, APLREF, AVBBY, AVBWTH, BENNAM, BENREF, CHATO, CNFDET, EXPDAT, EXPPLC, LCRTYP, NOMSPC, NOMTOP, NOMTON, PREADVDT, RMBACT, RMBCHA, RMBFLG, SHPDAT, SHPFRO, PORLOA, PORDIS, SHPPAR, SHPTO, SHPTRS, STACTY, STAGOD, UTLNBR, ADVNBR, REDCLSFLG, VER, LCITYP, B2BINR, B2BREF, REVNBR, REVTIMES, REVFLG, REVAWAPL, REVDAT, REVCUM, REVTYP, INITPTY, RESFLG, APPRUL, APPRULRMB, APPRULTXT, AUTDAT, ETYEXTKEY, BRANCHINR, BCHKEYINR, TENMAXDAY, DFLG, TRATYP, GUAFLG, USSFLG ) 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, :V39, :V40, :V41, :V42, :V43, :V44, :V45, :V46, :V47, :V48, :V49, :V50, :V51, :V52, :V53, :V54, :V55, :V56, :V57, :V58, :V59, :V60, :V61, :V62, :V63, :V64, :V65 )
cdcmxy4zbadk3	SELECT COUNT(*) FROM SSN WHERE STA = 'A'
cvqj8skq9ndtg	DELETE FROM CMI WHERE ROWID IN(SELECT MIN(ROWID) FROM CMI GROUP BY OWNREF HAVING COUNT(*)>1)
cxm0nyjbg9ywq	SELECT INR, EXTKEY, NAM, PTYTYP, ACCUSR, HBKACCFLG, HBKCONFLG, HBKINR, HEQACCFLG, HEQCONFLG, HEQINR, PRFCTR, RESUSR, RSKCLS, RSKCTY, RSKTXT, UIL, VER, AKKBRA, AKKCOM, AKKREG, LIDCNDFLG, LIDMAXDUR, TRDCNDFLG, TRDTENTOT, TRDTENINI, TRDTENEXT, TRDEXTNMB, BADCNDFLG, BADTENEXT, ADRSTA, SELTYP, BUYTYP, SLA, ETGEXTKEY, NAM1, BRANCHINR, JUSCOD, BILVVV, CUNQII, IDCODE, IDTYPE, BCHKEYINR, CLSCTY, PROCOD, RGCP, CRNM, CRIT, CRID, RGCPCUR, CTVC, CRDCNT, CLIENTID FROM PTY WHERE INR = :W0
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
f14af6t91skac	select extkey from dct where cur='USD' and subcod in ('215001') and bch='2040' order by inr
fhmr0c323uyn1	SELECT TRIM(TYP) FROM ACT WHERE EXTKEY='2220000111506040131'
fytufwfc4tm67	SELECT WFSINR, WFSSUB, SRV, STA, RTYCNT, TARDATTIM, SSNINR, DATTIM, TXT, MANFLG, OPNDUR, WAIDUR, RETDUR, HDLDUR, BCHKEYINR FROM WFE where WFSINR = :W0
g9mg54585mfgz	select count(*) from NTF where USR = :W0 AND SHWSSNINR = ' ' and (EXPDATTIM > :W1 or EXPDATTIM is null)
gft02zzrfnvus	SELECT INR, OBJTYP, OBJINR, OBJNAM, ETYEXTKEY FROM WFS WHERE INR = :W0
ghzmcdstk5n63	select PTA.INR, PTA.NAM, PTA.OBJKEY, PTA.USG, PTA.VER, PTA.BIC, PTA.PTYTYP, PTA.PTYEXTKEY, PTA.TID from PTA PTA where PTA.ETGEXTKEY = 'EIBANKG' AND ( PTA.BRANCHINR IN (SELECT INR FROM BCH WHERE BCHKEY='2110004') or PTA.PTYTYP LIKE '%B%' or PTA.PTYTYP LIKE '%F%' ) and ( (PTA.NAM like '%26%' OR PTA.PTYEXTKEY like '%26%' OR PTA.OBJKEY like '%26%' OR PTA.BIC like '%26%' ) and ( ( PTA.PTYTYP LIKE '%C%' ) AND PTA.ADRSTA = ' ' ) ) order by PTA.NAM

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	318,208	89.33	2.62
CPU used when call started	317,215	89.05	2.62
CR blocks created	2,843	0.80	0.02
Cached Commit SCN referenced	330	0.09	0.00
Commit SCN cached	1	0.00	0.00
DB time	7,865,203	2,208.05	64.84
DBWR checkpoint buffers written	24,822	6.97	0.20
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	119	0.03	0.00
DBWR undo block writes	13,157	3.69	0.11
Misses for writing mapping	0	0.00	0.00
SMON posted for undo segment shrink	13	0.00	0.00
SQL*Net roundtrips to/from client	2,072,259	581.76	17.08
active txn count during cleanout	4,124	1.16	0.03
application wait time	606	0.17	0.00
background checkpoints completed	3	0.00	0.00
background checkpoints started	3	0.00	0.00
background timeouts	10,396	2.92	0.09
branch node splits	0	0.00	0.00
buffer is not pinned count	35,355,294	9,925.51	291.47
buffer is pinned count	151,888,589	42,640.62	1,252.16
bytes received via SQL*Net from client	266,999,473	74,956.42	2,201.13
bytes sent via SQL*Net to client	624,832,604	175,413.13	5,151.09
calls to get snapshot scn: kcmgss	1,237,172	347.32	10.20
calls to kcmgas	151,918	42.65	1.25
calls to kcmgcs	519	0.15	0.00
change write time	3,618	1.02	0.03
cleanout - number of ktugct calls	3,949	1.11	0.03
cleanouts and rollbacks - consistent read gets	2,515	0.71	0.02
cleanouts only - consistent read gets	108	0.03	0.00
cluster key scan block gets	5,298	1.49	0.04
cluster key scans	351	0.10	0.00
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	47	0.01	0.00
commit batch/immediate requested	47	0.01	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	90	0.03	0.00
commit cleanout failures: cannot pin	64	0.02	0.00
commit cleanouts	364,410	102.30	3.00
commit cleanouts successfully completed	364,256	102.26	3.00
commit immediate performed	47	0.01	0.00
commit immediate requested	47	0.01	0.00
commit txn count during cleanout	2,324	0.65	0.02
concurrency wait time	4,898,612	1,375.22	40.38
consistent changes	7,382	2.07	0.06
consistent gets	114,452,512	32,130.96	943.54
consistent gets - examination	11,330,802	3,180.97	93.41
consistent gets direct	136	0.04	0.00
consistent gets from cache	114,452,378	32,130.92	943.54
current blocks converted for CR	0	0.00	0.00
cursor authentications	4,392	1.23	0.04
data blocks consistent reads - undo records applied	7,349	2.06	0.06
db block changes	1,151,871	323.37	9.50
db block gets	1,186,915	333.21	9.78
db block gets direct	195	0.05	0.00
db block gets from cache	1,186,720	333.16	9.78
deferred (CURRENT) block cleanout applications	83,483	23.44	0.69
dirty buffers inspected	0	0.00	0.00
enqueue conversions	573	0.16	0.00
enqueue releases	424,958	119.30	3.50
enqueue requests	424,953	119.30	3.50
enqueue timeouts	1	0.00	0.00
enqueue waits	24	0.01	0.00
exchange deadlocks	2	0.00	0.00
execute count	872,189	244.86	7.19
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	19	0.01	0.00
free buffer requested	18,739	5.26	0.15
heap block compress	3,800	1.07	0.03
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	2,623	0.74	0.02
immediate (CURRENT) block cleanout applications	108,157	30.36	0.89
index crx upgrade (found)	44	0.01	0.00
index crx upgrade (positioned)	13,116	3.68	0.11
index fast full scans (full)	363	0.10	0.00
index fetch by key	4,386,425	1,231.43	36.16
index scans kdiixs1	2,043,711	573.74	16.85
leaf node 90-10 splits	58	0.02	0.00
leaf node splits	143	0.04	0.00
lob reads	40	0.01	0.00
lob writes	1,375	0.39	0.01
lob writes unaligned	98	0.03	0.00
logons cumulative	863	0.24	0.01
messages received	126,422	35.49	1.04
messages sent	126,422	35.49	1.04
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	102,892,679	28,885.70	848.24
opened cursors cumulative	870,316	244.33	7.17
parse count (failures)	279	0.08	0.00
parse count (hard)	12,358	3.47	0.10
parse count (total)	870,239	244.31	7.17
parse time cpu	114,805	32.23	0.95
parse time elapsed	2,215,833	622.06	18.27
physical read IO requests	1,435	0.40	0.01
physical read bytes	14,311,424	4,017.73	117.98
physical read total IO requests	6,833	1.92	0.06
physical read total bytes	377,523,200	105,984.43	3,112.28
physical read total multi block requests	329	0.09	0.00
physical reads	1,747	0.49	0.01
physical reads cache	1,594	0.45	0.01
physical reads cache prefetch	311	0.09	0.00
physical reads direct	153	0.04	0.00
physical reads direct (lob)	87	0.02	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	12,056	3.38	0.10
physical write bytes	205,160,448	57,595.96	1,691.33
physical write total IO requests	142,527	40.01	1.17
physical write total bytes	842,617,856	236,553.33	6,946.50
physical write total multi block requests	125,470	35.22	1.03
physical writes	25,044	7.03	0.21
physical writes direct	222	0.06	0.00
physical writes direct (lob)	46	0.01	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	24,822	6.97	0.20
physical writes non checkpoint	4,379	1.23	0.04
pinned buffers inspected	0	0.00	0.00
prefetch clients - default	67	0.02	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,563	1.00	0.03
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	542,090	152.18	4.47
recursive cpu usage	18,950	5.32	0.16
redo blocks written	535,146	150.23	4.41
redo buffer allocation retries	8	0.00	0.00
redo entries	640,705	179.87	5.28
redo log space requests	8	0.00	0.00
redo log space wait time	171	0.05	0.00
redo ordering marks	12,270	3.44	0.10
redo size	241,171,960	67,705.70	1,988.21
redo subscn max counts	14,857	4.17	0.12
redo synch time	11,516	3.23	0.09
redo synch writes	124,752	35.02	1.03
redo wastage	23,856,992	6,697.52	196.68
redo write time	9,102	2.56	0.08
redo writer latching time	354	0.10	0.00
redo writes	125,220	35.15	1.03
rollback changes - undo records applied	324	0.09	0.00
rollbacks only - consistent read gets	294	0.08	0.00
rows fetched via callback	4,190,936	1,176.55	34.55
session connect time	0	0.00	0.00
session cursor cache hits	788,094	221.25	6.50
session logical reads	115,639,399	32,464.16	953.33
session pga memory	44,237,432	12,419.05	364.69
session pga memory max	13,136,568	3,687.91	108.30
session uga memory	###############	56,673,625.74	1,664,248.65
session uga memory max	964,860,992	270,871.40	7,954.27
shared hash latch upgrades - no wait	18,151	5.10	0.15
shared hash latch upgrades - wait	55	0.02	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	337,919	94.87	2.79
sorts (rows)	41,903,269	11,763.76	345.45
sql area evicted	9,114	2.56	0.08
sql area purged	279	0.08	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	10,868	3.05	0.09
table fetch by rowid	32,761,376	9,197.30	270.08
table fetch continued row	3,901	1.10	0.03
table scan blocks gotten	75,368,898	21,158.78	621.34
table scan rows gotten	3,078,361,130	864,207.38	25,377.87
table scans (long tables)	62	0.02	0.00
table scans (short tables)	31,021	8.71	0.26
total number of times SMON posted	13	0.00	0.00
transaction rollbacks	47	0.01	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	97,337,100	27,326.05	802.44
user I/O wait time	1,235	0.35	0.01
user calls	2,906,080	815.84	23.96
user commits	120,805	33.91	1.00
user rollbacks	496	0.14	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	35,373	9.93	0.29
write clones created in background	0	0.00	0.00
write clones created in foreground	20	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,061,820	9,076,494
opened cursors current	693	432
workarea memory allocated	237	1,289
logons current	236	214

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.03

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 Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
USERS	1,144	8.93	1.27	8,005	2	92	23.15
SSTF	187	8.18	1.00	1,838	1	1	0.00
UNDOTBS1	7	15.71	1.00	1,600	0	60	19.33
SYSAUX	81	6.42	1.00	454	0	0	0.00
SYSTEM	16	5.63	1.00	157	0	2	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SSTF	/oradata/sstf505/sstf50501.dbf	42	9.05	1.00	366	0	0	0.00
SSTF	/oradata/sstf505/sstf50502.dbf	97	5.46	1.00	501	0	0	0.00
SSTF	/oradata/sstf505/sstf50503.dbf	48	12.92	1.00	971	0	1	0.00
SYSAUX	/oradata/sstf505/sysaux01.dbf	81	6.42	1.00	454	0	0	0.00
SYSTEM	/oradata/sstf505/system01.dbf	16	5.63	1.00	157	0	2	0.00
UNDOTBS1	/oradata/sstf505/undotbs01.dbf	7	15.71	1.00	1,600	0	60	19.33
USERS	/oradata/sstf505/users01.dbf	498	8.84	1.48	1,634	0	82	25.98
USERS	/oradata/sstf505/users02.dbf	214	9.72	1.35	1,806	1	10	0.00
USERS	/oradata/sstf505/users03.dbf	432	8.66	1.00	4,565	1	0	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	115,436,326	1,595	24,822	0	0	155

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	18	2570	60127	367885	368640	367885
E	0	16	1828	34409	180209	368640	180209

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.40	440,590,670
D	1,280	0.20	158,320	1.70	138,804,537
D	1,920	0.29	237,480	1.19	97,490,449
D	2,560	0.39	316,640	1.08	88,331,563
D	3,200	0.49	395,800	1.04	85,097,730
D	3,840	0.59	474,960	1.03	83,763,757
D	4,480	0.69	554,120	1.02	83,281,309
D	5,120	0.79	633,280	1.01	82,804,660
D	5,760	0.88	712,440	1.01	82,168,606
D	6,400	0.98	791,600	1.00	81,717,600
D	6,512	1.00	805,453	1.00	81,630,740
D	7,040	1.08	870,760	1.00	81,295,184
D	7,680	1.18	949,920	0.99	81,056,670
D	8,320	1.28	1,029,080	0.99	80,992,796
D	8,960	1.38	1,108,240	0.99	80,978,708
D	9,600	1.47	1,187,400	0.99	80,974,215
D	10,240	1.57	1,266,560	0.99	80,971,972
D	10,880	1.67	1,345,720	0.99	80,969,137
D	11,520	1.77	1,424,880	0.99	80,950,211
D	12,160	1.87	1,504,040	0.97	78,823,325
D	12,800	1.97	1,583,200	0.65	52,908,476

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	3,178	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,541	365.87	0.23	0.06	100.00	0.00	419,430
E	4,096	3,559	322.15	1.26	0.39	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	33,230	33,230
64K	128K	819	819
128K	256K	208	208
256K	512K	173	173
512K	1024K	720	720
1M	2M	37	37
2M	4M	13	13
4M	8M	5	5
8M	16M	156	156

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,312,613.46	10,136.48	100.00	5
1,024	0.25	2,312,613.46	8,070.47	100.00	0
2,048	0.50	2,312,613.46	7,495.96	100.00	0
3,072	0.75	2,312,613.46	7,495.96	100.00	0
4,096	1.00	2,312,613.46	7,495.96	100.00	0
4,915	1.20	2,312,613.46	1,452.63	100.00	0
5,734	1.40	2,312,613.46	1,452.63	100.00	0
6,554	1.60	2,312,613.46	1,452.63	100.00	0
7,373	1.80	2,312,613.46	1,452.63	100.00	0
8,192	2.00	2,312,613.46	1,452.63	100.00	0
12,288	3.00	2,312,613.46	1,452.63	100.00	0
16,384	4.00	2,312,613.46	1,452.63	100.00	0
24,576	6.00	2,312,613.46	1,452.63	100.00	0
32,768	8.00	2,312,613.46	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,035	188,755	29,679,978	0.93	3,031,282	3.69	743,512,655
3,856	0.39	2,018	247,182	31,058,639	0.97	1,652,621	2.01	744,657,579
4,848	0.49	3,009	319,194	31,274,262	0.98	1,436,998	1.75	744,836,018
5,840	0.60	4,000	383,594	31,351,129	0.98	1,360,131	1.66	744,973,756
6,832	0.70	4,991	435,165	31,524,023	0.99	1,187,237	1.45	745,217,523
7,824	0.80	5,982	482,926	31,656,642	0.99	1,054,618	1.28	745,357,191
8,816	0.90	6,973	530,633	31,834,304	1.00	876,956	1.07	745,473,142
9,808	1.00	7,964	578,295	31,889,789	1.00	821,471	1.00	745,563,439
10,800	1.10	8,955	626,429	32,039,019	1.00	672,241	0.82	745,645,111
11,792	1.20	9,946	674,111	32,096,635	1.01	614,625	0.75	745,715,098
12,784	1.30	10,937	723,035	32,126,304	1.01	584,956	0.71	745,797,199
13,776	1.40	11,928	771,140	32,136,235	1.01	575,025	0.70	745,892,180
14,768	1.51	12,919	819,232	32,183,770	1.01	527,490	0.64	746,007,110
15,760	1.61	13,910	867,457	32,239,253	1.01	472,007	0.57	746,118,252
16,752	1.71	14,901	915,284	32,326,305	1.01	384,955	0.47	746,242,069
17,744	1.81	15,892	963,299	32,473,155	1.02	238,105	0.29	746,395,588
18,736	1.91	16,883	1,011,514	32,546,121	1.02	165,139	0.20	746,549,112
19,728	2.01	17,874	1,060,277	32,622,139	1.02	89,121	0.11	746,710,114

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,392,898	407,165,883
8,192	0.50	4,780,872	128,274,518
12,288	0.75	4,234,337	128,274,518
16,384	1.00	4,021,595	81,630,723
20,480	1.25	3,664,075	81,630,723
24,576	1.50	3,494,766	76,961,446
28,672	1.75	3,489,941	74,839,047
32,768	2.00	3,450,127	48,896,803

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	821,471	1.00	103
32	1.00	7	103	3	1.00	821,471	1.00	103
48	1.50	7	103	3	1.00	821,471	1.00	103
64	2.00	7	103	3	1.00	821,471	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	95	2	22
undo header	47	1	21
undo block	13	0	14

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	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (index contention)	39	39	10	3	327.00
US-Undo Segment	31	31	12	0	40.58
SQ-Sequence Cache	16	16	1	0	54.00
HW-Segment High Water Mark	390	390	1	0	41.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

Error encountered in Undo Segment Summary While executing SQL statement: Len = 834 select undotsn , sum(undoblks)/1000 undob , sum(txncount) txcnt , max(maxquerylen) maxq , max(maxconcurrency) maxc , min(tuned_undoretention)/60 ||'/'|| max(tuned_undor etention)/60 mintun , sum(ssolderrcnt) ||'/'|| sum(nospaceerrcnt) snolno , sum (unxpstealcnt) ||'/'|| sum(unxpblkrelcnt) ||'/'| | sum(unxpblkreucnt) ||'/'|| sum(expstealcnt) || '/'|| sum(expblkrelcnt) ||'/'|| sum(expblkreucnt) blkst from dba_hist_undostat where dbid = :dbid a nd instance_number = :inst_num and end_time > :b_eitvtim e and begin_time < :e_eitvtime group by undotsn Encountered error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small Continuing to Next Section...

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

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

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
19-Dec 16:07	1,888	17,630	1,460	4	37	0/0	0/0/0/0/0/0
19-Dec 15:57	1,433	13,119	859	13	27	0/0	0/0/0/0/0/0
19-Dec 15:47	210	2,130	597	4	23	0/0	0/0/0/0/0/0
19-Dec 15:37	2,893	29,684	156	5	16	0/0	0/0/0/0/0/0
19-Dec 15:27	2,913	29,496	129	6	15	0/0	0/0/0/0/0/0
19-Dec 15:17	2,690	27,637	189	4	16	0/0	0/0/0/0/0/0
19-Dec 15:07	2,875	29,006	445	7	20	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,390	0.00		0	0
AWR Alerted Metric Element list	25,617	0.00		0	0
Consistent RBA	125,231	0.00		0	0
FAL request queue	76	0.00		0	0
FAL subheap alocation	76	0.00		0	0
FIB s.o chain latch	18	0.00		0	0
FOB s.o list latch	1,002	0.00		0	0
JS queue state obj latch	16,470	0.00		0	0
JS slv state obj latch	33	0.00		0	0
KMG MMAN ready and startup request latch	1,187	0.00		0	0
KTF sga latch	8	0.00		0	1,102	0.00
KWQMN job cache list latch	9	0.00		0	0
MQL Tracking Latch	0			0	71	0.00
Memory Management Latch	0			0	1,187	0.00
OS process	2,697	0.00		0	0
OS process allocation	2,804	8.02	129.75	8528	0
OS process: request allocation	1,720	12.33	747.04	46383	0
PL/SQL warning settings	998	0.00		0	0
SGA IO buffer pool latch	134	0.00		0	134	0.00
SQL memory manager latch	1	0.00		0	1,180	0.00
SQL memory manager workarea list latch	87,722	0.00		0	0
Shared B-Tree	159	0.00		0	0
active checkpoint queue latch	2,033	0.00		0	0
active service list	10,568	0.57	0.03	0	2,339	0.00
archive control	102	0.00		0	0
archive process latch	1,339	0.00		0	0
begin backup scn array	54	0.00		0	0
cache buffer handles	5,660	0.21	0.25	0	0
cache buffers chains	222,399,833	0.14	0.01	174	15,832	0.15
cache buffers lru chain	71,425	0.02	0.36	1	3,498,684	0.00
cache table scan latch	0			0	61	0.00
channel handle pool latch	1,721	7.55	16.46	610	0
channel operations parent latch	17,896	0.01	0.00	0	0
checkpoint queue latch	144,393	0.00		0	24,017	0.00
client/application info	6,848	0.01	0.00	0	0
commit callback allocation	8	0.00		0	0
compile environment latch	863	0.00		0	0
dictionary lookup	1	0.00		0	0
dml lock allocation	531,526	0.05	0.00	0	0
dummy allocation	1,748	0.63	0.00	0	0
enqueue hash chains	850,572	0.02	0.01	0	580	0.00
enqueues	463,304	0.02	0.00	0	0
event group latch	849	0.00		0	0
file cache latch	162	0.00		0	0
global KZLD latch for mem in SGA	603	0.00		0	0
hash table column usage latch	317	0.00		0	321,147	0.00
hash table modification latch	116	0.00		0	0
job workq parent latch	0			0	96	0.00
job_queue_processes parameter latch	94	0.00		0	0
kks stats	68,289	0.19	3.75	124	0
kokc descriptor allocation latch	20	0.00		0	0
ksuosstats global area	237	0.00		0	0
ktm global data	45	0.00		0	0
kwqbsn:qsga	159	0.00		0	0
lgwr LWN SCN	125,880	0.01	0.00	0	0
library cache	1,026,198	1.24	11.76	41738	37,596	4.96
library cache load lock	102	0.00		0	0
library cache lock	396,419	0.05	0.29	2	0
library cache lock allocation	9,046	0.00		0	0
library cache pin	127,929	0.03	0.00	0	0
library cache pin allocation	644	0.00		0	0
list of block allocation	1,918	0.00		0	0
loader state object freelist	300	0.00		0	0
longop free list parent	305	0.33	0.00	0	27	0.00
messages	401,245	0.01	0.02	0	0
mostly latch-free SCN	125,626	0.00	0.00	0	0
multiblock read objects	204	0.00		0	0
ncodef allocation latch	75	0.00		0	0
object queue header heap	71	0.00		0	0
object queue header operation	114,926	0.02	0.96	1	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	472	0.00		0	0
parameter list	6,142	0.39	0.00	0	0
parameter table allocation management	1,754	0.00		0	0
post/wait queue	187,402	0.00		0	124,652	0.01
process allocation	1,754	1.14	71.95	14	848	0.12
process group creation	1,720	0.52	0.00	0	0
qmn task queue latch	508	0.00		0	0
redo allocation	377,595	0.03	0.75	2	640,662	0.07
redo copy	0			0	640,841	0.14
redo writing	380,521	0.00		0	0
resmgr group change latch	1,273	0.00		0	0
resmgr:active threads	1,743	0.00		0	0
resmgr:actses change group	652	0.00		0	0
resmgr:free threads list	1,742	2.12	1.05	8	0
resmgr:schema config	1	0.00		0	0
row cache objects	2,526,271	0.39	0.18	463	349	0.00
rules engine aggregate statistics	4	0.00		0	0
rules engine rule set statistics	8	0.00		0	0
sequence cache	11,330	0.22	0.00	0	0
session allocation	802,786	0.13	112.16	34836	0
session idle bit	6,207,903	0.01	0.00	0	0
session state list latch	270	0.00		0	0
session switching	349	0.00		0	0
session timer	1,191	0.00		0	0
shared pool	553,811	1.51	12.42	28946	0
shared pool simulator	936,719	0.04	3.22	263	0
simulator hash latch	6,969,771	0.00	0.07	0	0
simulator lru latch	24,828	0.08	0.05	0	6,736,603	0.26
slave class	3	0.00		0	0
slave class create	12	8.33	1.00	0	0
sort extent pool	109	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	336	0.00		0	0
threshold alerts latch	204	0.00		0	0
trace latch	223	11.21	5.52	38	0
transaction allocation	15,782	0.00		0	0
transaction branch allocation	1,191	0.00		0	0
undo global data	389,120	0.00	0.08	0	12	0.00
user lock	2,946	22.17	9.03	1621	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	222,399,833	309,053	3,528	305,737
library cache	1,026,198	12,769	150,217	3,102
row cache objects	2,526,271	9,816	1,792	9,618
shared pool	553,811	8,350	103,678	1,836
session allocation	802,786	1,062	119,113	290
user lock	2,946	653	5,894	37
shared pool simulator	936,719	378	1,216	34
dml lock allocation	531,526	244	1	243
OS process allocation	2,804	225	29,193	16
library cache lock	396,419	214	63	152
OS process: request allocation	1,720	212	158,372	3
enqueue hash chains	850,572	143	2	141
channel handle pool latch	1,721	130	2,140	6
kks stats	68,289	130	488	39
simulator hash latch	6,969,771	107	7	100
redo allocation	377,595	97	73	24
active service list	10,568	60	2	58
messages	401,245	57	1	56
resmgr:free threads list	1,742	37	39	18
trace latch	223	25	138	10
object queue header operation	114,926	24	23	2
simulator lru latch	24,828	21	1	20
process allocation	1,754	20	1,439	1
cache buffers lru chain	71,425	14	5	9
undo global data	389,120	13	1	12
cache buffer handles	5,660	12	3	9
slave class create	12	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
OS process allocation	kso_new_process:2	29,182	27,556
OS process allocation	kso_delete_process:1	5	4
OS process allocation	ksosp_scrub:1	2	1,585
OS process allocation	ksoreq_submit	1	43
OS process: request allocation	kso_new_process	158,360	158,352
active service list	ksws_event: ksws event	19	18
cache buffer handles	kcbzgs	3	2
cache buffers chains	kcbgtcr: kslbegin excl	3,224	3,365
cache buffers chains	kcbchg: kslbegin: bufs not pinned	221	51
cache buffers chains	kcbgtcr: fast path	54	10
cache buffers chains	kcbrls: kslbegin	36	75
cache buffers chains	kcbget: pin buffer	15	12
cache buffers chains	kcbkzs	11	0
cache buffers chains	kcbbxsv	7	0
cache buffers chains	kcbnew: new latch again	5	0
cache buffers chains	kcbgcur: kslbegin	3	3
cache buffers chains	kcbzwb	1	0
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	2	0
cache buffers lru chain	kcbkflb : age buffer out	1	0
cache buffers lru chain	kcbzgws	1	0
cache buffers lru chain	kcbzswcu	1	0
channel handle pool latch	ksrchconnect()	2,137	1,967
cost function	kzulrl	3,750	4,014
cost function	kzulgt: find user res	2,141	1,877
dml lock allocation	ktaidm	1	0
enqueue hash chains	ksqgtl3	2	2
kks stats	kks stats alloc/free	488	488
library cache	kgldte: child 0	76,107	68,843
library cache	kglhdgn: child:	10,735	56,197
library cache	kglScanDependency	5,136	1,645
library cache	kglpndl: child: before processing	2,134	616
library cache	kgldti: 2child	1,403	111
library cache	kglLockCursor	1,250	639
library cache	kglati	894	3
library cache	kglobpn: child:	732	4,646
library cache	kglpndl: child: after processing	595	33
library cache	kglukp: child	320	571
library cache	kglpin	169	212
library cache	kglhdgc: child:	81	14
library cache	kglic	12	8
library cache	kglpnp: child	6	29
library cache	kglobld	5	143
library cache	kgldtld: 2child	4	2
library cache	kglget: unpin heap 0	1	0
library cache lock	kgllkdl: child: no lock handle	46,828	14,128
library cache lock	kgllkdl: child: cleanup	42	41
library cache lock	kgllkal: child: multiinstance	21	22
messages	ksarcv: after wait	1	1
object queue header operation	kcbo_switch_cq	13	18
object queue header operation	kcbw_unlink_q_bg	9	0
object queue header operation	kcbw_unlink_q	1	3
process allocation	ksuapc	1,420	1,428
process allocation	ksucrp	11	0
process allocation	ksudlp	8	11
redo allocation	kcrfw_redo_gen: redo allocation 1	66	0
redo allocation	kcrfw_redo_gen: redo allocation 3	6	3
redo allocation	kcrfw_redo_gen: redo allocation 2	1	0
resmgr:free threads list	kgskthrcreate	31	27
resmgr:free threads list	kgskthrsod	8	12
row cache objects	kqreqd	1,555	38
row cache objects	kqreqd: reget	114	4
row cache objects	kqrso	76	34
row cache objects	kqrpre: find obj	45	1,714
row cache objects	kqrpup	1	0
row cache objects	ksucallcbksafely: kqrhngc	1	0
session allocation	ksucrp	118,519	22,219
session allocation	ksucri	409	90,949
session allocation	ksuxds: not user session	142	4,637
session allocation	ksudlp	15	544
session allocation	ksuxds: KSUSFCLC not set	11	726
session allocation	ksuprc	7	26
shared pool	kghupr1	90,420	28,169
shared pool	kghalo	8,698	65,024
shared pool	kghfrunp: alloc: wait	3,167	133
shared pool	kghfrunp: clatch: nowait	2,328	0
shared pool	kghfrunp: clatch: wait	1,436	2,337
shared pool	kghfre	896	6,988
shared pool	kghalp	340	963
shared pool	kghasp	129	28
shared pool	kghfree_extents: scan	15	2,369
shared pool	kghfrh	4	0
shared pool	kghfen: not perm alloc class	1	0
shared pool simulator	kglsim_unpin_simhp	871	37
shared pool simulator	kglsim_upd_newhp	290	13
shared pool simulator	kglsim_unpin_simhp: fast path	27	1,076
shared pool simulator	kglsim_chg_simhp_free	14	0
shared pool simulator	kglsim_scan_lru: scan	13	90
shared pool simulator	kglsim_chg_simhp_inval	1	0
simulator hash latch	kcbsacc: lookup dba	6	7
simulator hash latch	kcbs_get_or_extract_simbufseq	1	0
simulator lru latch	kcbs_simulate: simulate set	1	0
slave class create	ksvcreate	1	0
trace latch	kstipg	138	138
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: 115,639,399
Captured Segments account for 97.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SSTF505	SSTF	DCT	TABLE	25,366,128	21.94
SSTF505	USERS	SPT	TABLE	21,367,840	18.48
SSTF505	SSTF	GLE	TABLE	8,309,728	7.19
SSTF505	USERS	CMI	TABLE	6,604,288	5.71
SSTF505	USERS	WFE	TABLE	5,636,800	4.87

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 1,747
Captured Segments account for 42.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SSTF505	USERS	LCK	TABLE	421	24.10
SSTF505	USERS	SYS_LOB0000042880C00004$$	LOB	33	1.89
SSTF505	USERS	QUE	TABLE	21	1.20
SSTF505	USERS	ORE	TABLE	19	1.09
SSTF505	USERS	SYS_LOB0000131481C00002$$	LOB	19	1.09

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	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
SSTF505	USERS	SSN_STA		INDEX	8	18.60
SSTF505	USERS	CBE_OBJ		INDEX	4	9.30
SSTF505	USERS	QUE_BAL		INDEX	4	9.30
SYS	SYSAUX	WRH$_LATCH_PK	2558_54397	INDEX PARTITION	4	9.30
SYS	SYSAUX	WRH$_PARAMETER_PK	2558_54397	INDEX PARTITION	4	9.30

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	69	72.63
SSTF505	USERS	SSN_STA	INDEX	12	12.63
SSTF505	USERS	LCKIDX	INDEX	6	6.32
SSTF505	USERS	LCK	TABLE	3	3.16
SSTF505	USERS	NTF_INR	INDEX	2	2.11

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	57	0.00	2	1
dc_database_links	1,407	0.00	0	1
dc_files	72	0.00	0	9
dc_global_oids	135	0.00	0	259
dc_histogram_data	636,807	0.00	0	10,598
dc_histogram_defs	149,311	0.01	0	12,382
dc_object_grants	21	28.57	0	4,252
dc_object_ids	296,139	0.01	1	3,181
dc_objects	16,535	0.23	1	2,671
dc_profiles	650	0.00	0	1
dc_rollback_segments	1,387	0.00	12	60
dc_segments	80,644	0.01	9	3,063
dc_sequences	4,135	0.46	4,135	222
dc_tablespaces	17,787	0.00	0	7
dc_usernames	3,222	0.00	0	47
dc_users	60,091	0.00	0	66
outstanding_alerts	74	2.70	4	12

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	555	0.00	711	0.00	0
CLUSTER	13	0.00	19	0.00	0
INDEX	2	0.00	22	0.00	0
JAVA RESOURCE	1	100.00	1	100.00	0
JAVA SOURCE	1	100.00	1	100.00	0
SQL AREA	92,924	25.85	906,533	4.04	322
TABLE/PROCEDURE	4,496	0.58	63,796	0.08	6
TRIGGER	95	1.05	351	0.28	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	256.12		1.09	2.39	22	23	236	236
	Freeable	105.81	0.00	1.10	2.27	23		96	96
	SQL	2.71	1.44	0.01	0.04	0	66	228	105
	PL/SQL	1.39	0.87	0.01	0.01	0	0	236	236
E	Other	229.75		1.07	2.51	22	23	214	214
	Freeable	87.63	0.00	1.17	2.57	23		75	75
	SQL	3.73	2.51	0.02	0.10	1	66	206	94
	PL/SQL	1.19	0.72	0.01	0.01	0	0	214	214

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,402.26	1,413.30	0.79
shared	Cursor Stats	130.80	130.80	0.00
shared	PCursor	953.17	959.48	0.66
shared	free memory	772.54	771.70	-0.11
shared	kglsim heap	124.10	124.10	0.00
shared	kglsim object batch	169.02	169.02	0.00
shared	library cache	658.41	660.15	0.26
shared	sql area	5,384.96	5,362.57	-0.42
	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	215	500	500	500
sessions	223	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:	1.00	Recursive Call %:	15.72
Rollback per transaction %:	0.41	Rows per Sort:	124.00

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	96.23	Soft Parse %:	98.58
Execute to Parse %:	0.22	Latch Hit %:	99.86
Parse CPU to Parse Elapsd %:	5.18	% Non-Parse CPU:	66.97