WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

TEST 2081770787 test 1 31-May-12 13:05 11.2.0.3.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
TEST	2081770787	test	1	31-May-12 13:05	11.2.0.3.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

web5 Linux x86 64-bit 16 8 2 7.79

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
web5	Linux x86 64-bit	16	8	2	7.79

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1293 11-Jul-12 14:00:27 624 4.2

End Snap: 1294 11-Jul-12 15:00:32 558 4.6

Elapsed: 60.10 (mins)

DB Time: 40.40 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1293	11-Jul-12 14:00:27	624	4.2
End Snap:	1294	11-Jul-12 15:00:32	558	4.6
Elapsed:		60.10 (mins)
DB Time:		40.40 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 2,048M 2,048M Std Block Size: 8K

Shared Pool Size: 1,840M 1,840M Log Buffer: 12,436K

	Begin	End
Buffer Cache:	2,048M	2,048M	Std Block Size:	8K
Shared Pool Size:	1,840M	1,840M	Log Buffer:	12,436K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.7 0.2 0.01 0.01

DB CPU(s): 0.2 0.1 0.00 0.00

Redo size: 10,738.6 3,787.6

Logical reads: 18,833.2 6,642.7

Block changes: 49.9 17.6

Physical reads: 6,274.8 2,213.2

Physical writes: 1.2 0.4

User calls: 62.5 22.0

Parses: 40.5 14.3

Hard parses: 0.1 0.0

W/A MB processed: 0.2 0.1

Logons: 4.4 1.6

Executes: 55.6 19.6

Rollbacks: 0.0 0.0

Transactions: 2.8

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.7	0.2	0.01	0.01
DB CPU(s):	0.2	0.1	0.00	0.00
Redo size:	10,738.6	3,787.6
Logical reads:	18,833.2	6,642.7
Block changes:	49.9	17.6
Physical reads:	6,274.8	2,213.2
Physical writes:	1.2	0.4
User calls:	62.5	22.0
Parses:	40.5	14.3
Hard parses:	0.1	0.0
W/A MB processed:	0.2	0.1
Logons:	4.4	1.6
Executes:	55.6	19.6
Rollbacks:	0.0	0.0
Transactions:	2.8

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 100.00

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

Library Hit %: 99.80 Soft Parse %: 99.81

Execute to Parse %: 27.22 Latch Hit %: 99.45

Parse CPU to Parse Elapsd %: 85.65 % Non-Parse CPU: 97.75

Shared Pool Statistics

Begin End

Memory Usage %: 62.09 61.86

% SQL with executions>1: 96.53 96.90

% Memory for SQL w/exec>1: 95.36 95.74

	Begin	End
Memory Usage %:	62.09	61.86
% SQL with executions>1:	96.53	96.90
% Memory for SQL w/exec>1:	95.36	95.74

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
log file sync	41,671	1,258	30	51.90	Commit
DB CPU		845		34.85
direct path read	179,574	217	1	8.97	User I/O
library cache: mutex X	15,732	44	3	1.83	Concurrency
db file sequential read	800	7	9	0.29	User I/O

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

Load Average Begin Load Average End %User %System %WIO %Idle

1.84 1.67 1.2 0.7 1.3 98.1

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.84	1.67	1.2	0.7	1.3	98.1

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

1.5 78.6 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
1.5	78.6	0.0

Begin End

Host Mem (MB): 7,979.1 7,979.1

SGA use (MB): 3,968.0 3,968.0

PGA use (MB): 892.6 854.2

% Host Mem used for SGA+PGA: 60.92 60.44

	Begin	End
Host Mem (MB):	7,979.1	7,979.1
SGA use (MB):	3,968.0	3,968.0
PGA use (MB):	892.6	854.2
% Host Mem used for SGA+PGA:	60.92	60.44

Main Report

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

Wait Events Statistics

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

Time Model Statistics

Total time in database user-calls (DB Time): 2424.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
DB CPU	844.84	34.85
sql execute elapsed time	726.08	29.95
connection management call elapsed time	538.05	22.20
parse time elapsed	27.75	1.14
hard parse elapsed time	8.27	0.34
PL/SQL compilation elapsed time	3.32	0.14
PL/SQL execution elapsed time	3.19	0.13
hard parse (sharing criteria) elapsed time	0.36	0.01
repeated bind elapsed time	0.02	0.00
sequence load elapsed time	0.01	0.00
hard parse (bind mismatch) elapsed time	0.01	0.00
DB time	2,424.12
background elapsed time	611.29
background cpu time	12.34

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
BUSY_TIME	109,087
IDLE_TIME	5,654,749
IOWAIT_TIME	73,344
NICE_TIME	0
SYS_TIME	40,713
USER_TIME	66,776
LOAD	2	2
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	81,025,024
VM_OUT_BYTES	27,701,248
PHYSICAL_MEMORY_BYTES	8,366,673,920
NUM_CPUS	16
NUM_CPU_CORES	8
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
11-Jul 14:00:27	1.84
11-Jul 15:00:32	1.67	1.89	1.16	0.71	98.11	1.27

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 98.3% of Total DB time 2,424.12 (s)
Total FG Wait Time: 1,538.76 (s) DB CPU time: 844.84 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Commit	41,671	0	1,258	30	51.90
DB CPU			845		34.85
User I/O	190,796	0	226	1	9.32
Concurrency	22,378	0	51	2	2.12
Network	122,721	0	3	0	0.11
Configuration	115	0	0	4	0.02
Other	273	90	0	1	0.01
System I/O	660	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
log file sync	41,671	0	1,258	30	4.08	51.90
direct path read	179,574	0	217	1	17.57	8.97
library cache: mutex X	15,732	0	44	3	1.54	1.83
db file sequential read	800	0	7	9	0.08	0.29
buffer busy waits	5,831	0	4	1	0.57	0.17
library cache load lock	4	0	3	646	0.00	0.11
SQL*Net more data from client	164	0	3	16	0.02	0.11
db file scattered read	10,002	0	1	0	0.98	0.05
enq: HW - contention	115	0	0	4	0.01	0.02
latch: shared pool	240	0	0	1	0.02	0.01
latch: cache buffers chains	450	0	0	0	0.04	0.01
SQL*Net message to client	121,953	0	0	0	11.93	0.01
read by other session	1	0	0	134	0.00	0.01
latch free	8	0	0	15	0.00	0.00
Disk file operations I/O	419	0	0	0	0.04	0.00
latch: enqueue hash chains	4	0	0	13	0.00	0.00
cursor: pin S	103	0	0	0	0.01	0.00
SQL*Net more data to client	604	0	0	0	0.06	0.00
wait list latch free	6	0	0	4	0.00	0.00
cursor: mutex S	2	0	0	6	0.00	0.00
control file sequential read	660	0	0	0	0.06	0.00
latch: row cache objects	16	0	0	0	0.00	0.00
latch: call allocation	10	0	0	0	0.00	0.00
SQL*Net message from client	122,008	0	2,108,254	17280	11.93
jobq slave wait	979	99	489	500	0.10

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
log file parallel write	27,543	0	488	18	2.69	79.78
control file parallel write	1,267	0	43	34	0.12	7.04
db file async I/O submit	957	0	33	34	0.09	5.32
latch free	1,154	0	10	9	0.11	1.72
ADR block file write	266	0	3	13	0.03	0.55
ADR block file read	679	0	3	4	0.07	0.46
latch: call allocation	5,354	0	2	0	0.52	0.36
Disk file operations I/O	765	0	2	2	0.07	0.26
os thread startup	66	0	1	17	0.01	0.18
control file sequential read	5,057	0	1	0	0.49	0.16
enq: JS - queue lock	1	0	1	642	0.00	0.10
db file sequential read	231	0	0	2	0.02	0.06
asynch descriptor resize	15,881	100	0	0	1.55	0.02
direct path sync	1	0	0	96	0.00	0.02
SQL*Net message to client	50,509	0	0	0	4.94	0.01
log file sync	2	0	0	23	0.00	0.01
LGWR wait for redo copy	303	0	0	0	0.03	0.01
latch: shared pool	40	0	0	1	0.00	0.01
ADR file lock	276	0	0	0	0.03	0.00
direct path write	2	0	0	8	0.00	0.00
SQL*Net more data from client	2	0	0	3	0.00	0.00
wait list latch free	2	0	0	1	0.00	0.00
rdbms ipc message	42,299	44	60,651	1434	4.14
DIAG idle wait	7,185	100	7,192	1001	0.70
Space Manager: slave idle wait	1,035	98	5,118	4945	0.10
smon timer	16	69	3,605	225312	0.00
dispatcher timer	60	100	3,600	60005	0.01
shared server idle wait	120	100	3,600	30002	0.01
pmon timer	1,204	100	3,600	2990	0.12
Streams AQ: qmn coordinator idle wait	257	50	3,585	13950	0.03
Streams AQ: qmn slave idle wait	128	0	3,585	28009	0.01
SQL*Net message from client	66,303	0	2,029	31	6.49
class slave wait	51	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	679	53.2	5.2	9.1	21.4	5.9	2.7	2.7
ADR block file write	266			1.5	42.9	36.8	14.7	4.1
ADR file lock	276	99.6					.4
Disk file operations I/O	1183	90.4		1.7	3.4	2.9	.9	.8
LGWR wait for redo copy	303	99.3			.3	.3
SQL*Net message to client	172.2K	100.0
SQL*Net more data from client	166	21.1	10.2	16.3	11.4	8.4	27.7	4.8
SQL*Net more data to client	606	99.0	.2	.7	.2
asynch descriptor resize	16.1K	100.0
buffer busy waits	5817	84.3	12.1	1.5	1.3	.7	.1	.0
control file parallel write	1267					5.1	82.2	12.5	.2
control file sequential read	5717	99.5		.1	.1	.1	.1	.1
cursor: mutex S	2	50.0				50.0
cursor: pin S	103	95.1	1.0		1.0	2.9
db file async I/O submit	957				3.4	49.7	25.4	21.4
db file scattered read	10K	99.9	.0	.0	.0	.0	.0
db file sequential read	1029	71.5	.7	3.9	9.5	7.1	2.3	5.0
direct path read	179.5K	91.6	.3	5.6	.9	.9	.3	.5
direct path sync	1							100.0
direct path write	2				50.0	50.0
enq: HW - contention	109	63.3	6.4	7.3	5.5	15.6	1.8
enq: JS - queue lock	1							100.0
latch free	1158	.3	.1	.1	60.1	37.0	1.5	1.0
latch: active service list	7	100.0
latch: cache buffers chains	449	91.1	4.5	3.1	1.3
latch: call allocation	5356	97.1	1.3	.5	.6	.5		.0
latch: enqueue hash chains	4					100.0
latch: row cache objects	16	93.8		6.3
latch: shared pool	280	91.8	1.1	1.8	2.1	2.9		.4
library cache load lock	4	50.0						25.0	25.0
library cache: mutex X	15.7K	77.3	.6	.2	.0	19.6	2.0	.3
log file parallel write	27.5K				16.6	61.0	17.9	4.6	.0
log file sequential read	120	100.0
log file sync	41.2K	.1	.1	.6	12.6	35.9	38.4	12.2	.2
os thread startup	66					71.2	27.3	1.5
read by other session	1							100.0
wait list latch free	9		88.9				11.1
DIAG idle wait	7184							100.0
SQL*Net message from client	188.1K	23.1	31.1	4.4	.6	.2	5.8	15.0	19.8
Space Manager: slave idle wait	1035		.1					.6	99.3
Streams AQ: qmn coordinator idle wait	257	50.2							49.8
Streams AQ: qmn slave idle wait	128								100.0
class slave wait	51	100.0
dispatcher timer	60								100.0
jobq slave wait	976							100.0
pmon timer	1204							.2	99.8
rdbms ipc message	42.3K	9.7	.7	1.4	1.9	3.2	8.5	49.4	25.2
shared server idle wait	120								100.0
smon timer	16		6.3					6.3	87.5

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ADR block file read	18	97.3	2.5	.1
ADR block file write	11	95.9	3.4	.8
Disk file operations I/O	9	99.2	.6	.2
SQL*Net more data from client	8	95.2	3.6	.6			.6
buffer busy waits	1	100.0	.0
control file parallel write	161	87.3	8.4	2.0	1.3	.5	.3	.2
control file sequential read	8	99.9	.1	.0	.0
db file async I/O submit	205	78.6	10.7	6.1	3.6	.8	.3
db file sequential read	51	95.0	1.7	2.1	1.0	.1
direct path read	829	99.5	.2	.1	.1	.0	.0
direct path sync	1			100.0
enq: JS - queue lock	1						100.0
latch free	12	99.0	.3	.8
latch: call allocation	1	100.0		.0
latch: shared pool	1	99.6		.4
library cache load lock	2	50.0					25.0	25.0
library cache: mutex X	50	99.7	.3	.0
log file parallel write	1275	95.4	2.4	1.0	.8	.3	.1	.0
log file sync	5115	87.6	8.2	1.6	1.1	.9	.4	.2	.0
os thread startup	1	98.5	1.5
read by other session	1				100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
		% of Total Waits
log file sync	5	100.0	.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
SYS$USERS	1,560	439	0	6,996
test	868	408	22,742	61,074
SYS$BACKGROUND	0	0	0	17
testXDB	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	374	5	22242	51	74528	3
test	191347	221	33	0	48278	0
SYS$BACKGROUND	999	2	66	1	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 User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

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

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
121.50	36	3.38	5.01	10.92	95.08	6krry9gtf60h8	JDBC Thin Client	select this_.id as id4_0_, thi...
119.09	4,959	0.02	4.91	99.79	0.00	3tm9gbjxbnarq	JDBC Thin Client	update BANK_ORDER_CHECK_LOG se...
116.26	4,972	0.02	4.80	99.90	0.00	1ubzb3w414tp3	JDBC Thin Client	select this_.id as id5_0_, thi...
78.99	144	0.55	3.26	57.67	62.87	1v85jkc3nx90h	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
69.94	603	0.12	2.89	72.74	51.62	bj4baa185a9au	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
34.78	20,934	0.00	1.43	93.44	0.00	az33m61ym46y4		SELECT NULL AS table_cat, o.ow...
22.36	234	0.10	0.92	88.89	41.02	fp9pzmut03smb	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
13.27	1	13.27	0.55	4.21	0.00	bt8w184q8xuty	PL/SQL Developer	select s.ext_txn_seq_id, t.* f...
12.61	15,845	0.00	0.52	37.60	0.28	f711myt0q6cma		insert into sys.aud$( sessioni...
11.72	1	11.72	0.48	15.42	3.23	4y7kwa54zhrxn	JDBC Thin Client	update pay_dtl p set p.txn_sta...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
118.84	4,959	0.02	14.07	119.09	99.79	0.00	3tm9gbjxbnarq	JDBC Thin Client	update BANK_ORDER_CHECK_LOG se...
116.14	4,972	0.02	13.75	116.26	99.90	0.00	1ubzb3w414tp3	JDBC Thin Client	select this_.id as id5_0_, thi...
50.88	603	0.08	6.02	69.94	72.74	51.62	bj4baa185a9au	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
45.55	144	0.32	5.39	78.99	57.67	62.87	1v85jkc3nx90h	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
32.50	20,934	0.00	3.85	34.78	93.44	0.00	az33m61ym46y4		SELECT NULL AS table_cat, o.ow...
19.88	234	0.08	2.35	22.36	88.89	41.02	fp9pzmut03smb	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
13.27	36	0.37	1.57	121.50	10.92	95.08	6krry9gtf60h8	JDBC Thin Client	select this_.id as id4_0_, thi...
10.47	67	0.16	1.24	10.47	100.00	17.99	gfdzv82sh9m6s	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
9.16	69	0.13	1.08	9.45	96.93	52.75	a79c99kr1mv0a	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
8.55	15,785	0.00	1.01	8.79	97.31	0.53	4vs91dcv7u1p6		insert into sys.aud$( sessioni...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
115.52	36	3.21	50.69	121.50	10.92	95.08	6krry9gtf60h8	JDBC Thin Client	select this_.id as id4_0_, thi...
49.66	144	0.34	21.79	78.99	57.67	62.87	1v85jkc3nx90h	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
36.11	603	0.06	15.84	69.94	72.74	51.62	bj4baa185a9au	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
9.17	234	0.04	4.02	22.36	88.89	41.02	fp9pzmut03smb	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
4.99	69	0.07	2.19	9.45	96.93	52.75	a79c99kr1mv0a	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
4.64	1	4.64	2.04	8.41	0.65	55.18	9kdnk5bapz9p4	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
2.25	7	0.32	0.99	2.80	0.18	80.31	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
2.02	15	0.13	0.88	3.42	6.29	58.98	aux14x0ad1zdd	SQL*Plus	select NVL(b.free, 0.0), a.tot...
1.88	67	0.03	0.83	10.47	100.00	17.99	gfdzv82sh9m6s	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
0.86	15	0.06	0.38	1.32	0.53	65.00	3ktacv9r56b51		select owner#, name, namespace...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

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

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
18,820,209	4,972	3,785.24	27.71	116.26	99.9	0	1ubzb3w414tp3	JDBC Thin Client	select this_.id as id5_0_, thi...
18,785,863	4,959	3,788.24	27.66	119.09	99.8	0	3tm9gbjxbnarq	JDBC Thin Client	update BANK_ORDER_CHECK_LOG se...
7,789,874	603	12,918.53	11.47	69.94	72.7	51.6	bj4baa185a9au	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
6,894,296	144	47,877.06	10.15	78.99	57.7	62.9	1v85jkc3nx90h	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
3,133,854	20,934	149.70	4.61	34.78	93.4	0	az33m61ym46y4		SELECT NULL AS table_cat, o.ow...
3,117,489	234	13,322.60	4.59	22.36	88.9	41	fp9pzmut03smb	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
2,156,341	69	31,251.32	3.18	9.45	96.9	52.7	a79c99kr1mv0a	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
1,723,800	36	47,883.33	2.54	121.50	10.9	95.1	6krry9gtf60h8	JDBC Thin Client	select this_.id as id4_0_, thi...
865,542	67	12,918.54	1.27	10.47	100	18	gfdzv82sh9m6s	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
400,429	3	133,476.33	0.59	0.68	92.9	0	9jdq430cfv5dy	JDBC Thin Client	select sum(ai.item_order_amt) ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 22,625,604
Captured SQL account for 100.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
7,720,596	603	12,803.64	34.12	69.94	72.74	51.62	bj4baa185a9au	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
6,862,752	144	47,658.00	30.33	78.99	57.67	62.87	1v85jkc3nx90h	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
3,002,454	234	12,831.00	13.27	22.36	88.89	41.02	fp9pzmut03smb	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
2,144,610	69	31,081.30	9.48	9.45	96.93	52.75	a79c99kr1mv0a	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
1,616,064	36	44,890.67	7.14	121.50	10.92	95.08	6krry9gtf60h8	JDBC Thin Client	select this_.id as id4_0_, thi...
857,844	67	12,803.64	3.79	10.47	100.00	17.99	gfdzv82sh9m6s	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
140,232	1	140,232.00	0.62	11.72	15.42	3.23	4y7kwa54zhrxn	JDBC Thin Client	update pay_dtl p set p.txn_sta...
140,230	1	140,230.00	0.62	7.65	23.13	4.72	ap4s8z6tn1zww	JDBC Thin Client	update pay_dtl p set p.txn_sta...
140,094	1	140,094.00	0.62	11.46	16.99	3.32	aa8wkj898d4y6	JDBC Thin Client	update pay_dtl p set p.txn_sta...
360	15	24.00	0.00	3.42	6.29	58.98	aux14x0ad1zdd	SQL*Plus	select NVL(b.free, 0.0), a.tot...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 190,399
Captured SQL account for 100.3% of Total
Total UnOptimized Read Requests: 190,399
Captured SQL account for 100.3% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
62,586	62,586	603	103.79	32.87	bj4baa185a9au	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
55,632	55,632	144	386.33	29.22	1v85jkc3nx90h	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
24,339	24,339	234	104.01	12.78	fp9pzmut03smb	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
17,385	17,385	69	251.96	9.13	a79c99kr1mv0a	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
12,672	12,672	36	352.00	6.66	6krry9gtf60h8	JDBC Thin Client	select this_.id as id4_0_, thi...
6,954	6,954	67	103.79	3.65	gfdzv82sh9m6s	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
3,530	3,530	1	3,530.00	1.85	aa8wkj898d4y6	JDBC Thin Client	update pay_dtl p set p.txn_sta...
3,412	3,412	1	3,412.00	1.79	ap4s8z6tn1zww	JDBC Thin Client	update pay_dtl p set p.txn_sta...
3,409	3,409	1	3,409.00	1.79	4y7kwa54zhrxn	JDBC Thin Client	update pay_dtl p set p.txn_sta...
1,020	1,020	15	68.00	0.54	aux14x0ad1zdd	SQL*Plus	select NVL(b.free, 0.0), a.tot...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 200,626
Captured SQL account for 93.6% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
32,384	57,935	1.79	6.91	99.7	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
21,925	21,923	1.00	0.90	95.5	0	520mkxqpf15q8	JDBC Thin Client	select 1 from dual
20,934	0	0.00	34.78	93.4	0	az33m61ym46y4		SELECT NULL AS table_cat, o.ow...
15,845	15,845	1.00	12.61	37.6	.3	f711myt0q6cma		insert into sys.aud$( sessioni...
15,790	32,386	2.05	6.33	93.5	0	0k8522rmdzg4k		select privilege# from sysauth...
15,785	15,784	1.00	5.24	98.5	0	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
15,785	15,785	1.00	4.07	94.8	0	459f3z9u4fb3u		select value$ from props$ wher...
15,785	15,785	1.00	8.79	97.3	.5	4vs91dcv7u1p6		insert into sys.aud$( sessioni...
15,785	15,784	1.00	3.35	77.6	0	5ur69atw3vfhj		select decode(failover_method,...
5,027	4,999	0.99	1.13	99.8	.1	bdkfqz9umhbvg	JDBC Thin Client	update PAY_DTL set version=:1 ...
4,972	4,958	1.00	116.26	99.9	0	1ubzb3w414tp3	JDBC Thin Client	select this_.id as id5_0_, thi...
4,959	4,960	1.00	119.09	99.8	0	3tm9gbjxbnarq	JDBC Thin Client	update BANK_ORDER_CHECK_LOG se...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 146,023
Captured SQL account for 86.8% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
15,832	15,845	10.84	f711myt0q6cma	insert into sys.aud$( sessioni...
15,791	32,384	10.81	cm5vu20fhtnq1	select /*+ connect_by_filterin...
15,790	15,790	10.81	0k8522rmdzg4k	select privilege# from sysauth...
15,785	15,785	10.81	0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', ...
15,785	15,785	10.81	459f3z9u4fb3u	select value$ from props$ wher...
15,785	15,785	10.81	4vs91dcv7u1p6	insert into sys.aud$( sessioni...
15,785	15,785	10.81	5ur69atw3vfhj	select decode(failover_method,...
15,201	20,934	10.41	az33m61ym46y4	SELECT NULL AS table_cat, o.ow...
60	198	0.04	cp45v4t9w61fs	select OPR_NAME from OPR_INFO ...
47	66	0.03	2cahu5zgtkzgm	select OPR_NAME from OPR_INFO ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,149,699	20,934	0.06	az33m61ym46y4		SELECT NULL AS table_cat, o.ow...

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
34	53	1sbzggatbmvgq		select t.PAYGOPAYID, t.tranid,...
33	234	fp9pzmut03smb	JDBC Thin Client	select paydtl0_.DTL_SQ as DTL1...
28	5,027	bdkfqz9umhbvg	JDBC Thin Client	update PAY_DTL set version=:1 ...
27	15,845	f711myt0q6cma		insert into sys.aud$( sessioni...
22	15	3ktacv9r56b51		select owner#, name, namespace...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

1sbzggatbmvgq select t.PAYGOPAYID, t.tranid, count(*) from risk_trans_line t group by t.PAYGOPAYID, t.tranid

1ubzb3w414tp3 select this_.id as id5_0_, this_.ORDER_ID as ORDER2_5_0_, this_.TRANS_TIME as TRANS3_5_0_, this_.BANK_CODE as BANK4_5_0_, this_.TO_BANK_ORDER_ID as TO5_5_0_, this_.TOTAL_COUNT as TOTAL6_5_0_, this_.IS_CHECK_OK as IS7_5_0_, this_.BANK_RESPCODE as BANK8_5_0_, this_.LAST_CHECK_TM as LAST9_5_0_, this_.REMARK as REMARK5_0_ from BANK_ORDER_CHECK_LOG this_ where this_.ORDER_ID=:1

1v85jkc3nx90h select paydtl0_.DTL_SQ as DTL1_0_, paydtl0_.INT_TXN_DT as INT2_0_, paydtl0_.version as version0_, paydtl0_.LAST_UPD_TS as LAST4_0_, paydtl0_.MER_ID as MER5_0_, paydtl0_.SUB_MER_ID as SUB6_0_, paydtl0_.TXN_TYPE as TXN7_0_, paydtl0_.INT_TXN_CD as INT8_0_, paydtl0_.EXT_TXN_CD as EXT9_0_, paydtl0_.EXT_TXN_DT as EXT10_0_, paydtl0_.INT_TXN_TM as INT11_0_, paydtl0_.STLM_DATE as STLM12_0_, paydtl0_.CUPS_TRACE_NUM as CUPS13_0_, paydtl0_.INT_TXN_SEQ_ID as INT14_0_, paydtl0_.EXT_TXN_SEQ_ID as EXT15_0_, paydtl0_.ORDER_ID as ORDER16_0_, paydtl0_.PAY_CUST_ID as PAY17_0_, paydtl0_.PAY_CUST_USER_ID as PAY18_0_, paydtl0_.PAY_ACCOUNT as PAY19_0_, paydtl0_.PAY_TYPE as PAY20_0_, paydtl0_.TXN_AT as TXN21_0_, paydtl0_.FEE_AMT as FEE22_0_, paydtl0_.TILIU_AMT as TILIU23_0_, paydtl0_.OUT_STLM_ID as OUT24_0_, paydtl0_.IN_STLM_ID as IN25_0_, paydtl0_.CUR_TYPE as CUR26_0_, paydtl0_.CUR_EXP as CUR27_0_, paydtl0_.SEC_MODE as SEC28_0_, paydtl0_.TXN_STA_CD as TXN29_0_, paydtl0_.AUTH_ID as AUTH30_0_, paydtl0_.AUTH_STAT as AUTH31_0_, paydtl0_.RETURN_AMT as RETURN32_0_, paydtl0_.ORIG_LOG_SEQ as ORIG33_0_, paydtl0_.RECV_ACCT as RECV34_0_, paydtl0_.BATCH_ID as BATCH35_0_, paydtl0_.TRAN_IP as TRAN36_0_, paydtl0_.MISC_TX as MISC37_0_, paydtl0_.INITIATE_TYPE as INITIATE38_0_, paydtl0_.EXT_TXN_TM as EXT39_0_, paydtl0_.RSP_CODE as RSP40_0_, paydtl0_.IS_DISPUTE as IS41_0_, paydtl0_.ORIG_TXN_DT as ORIG42_0_, paydtl0_.RECV_CUST_ID as RECV43_0_, paydtl0_.MER_URL as MER44_0_, paydtl0_.CONFLICT as CONFLICT0_, paydtl0_.DESCRIPTION as DESCRIP46_0_, paydtl0_.BIND_NO as BIND47_0_, paydtl0_.TICKET_AMT as TICKET48_0_, paydtl0_.GOODS_INFO as GOODS49_0_, paydtl0_.SEND_BANK_DT as SEND50_0_, paydtl0_.PROXY_FEE as PROXY51_0_, paydtl0_.BANK_FEE_AT as BANK52_0_, paydtl0_.AUTH_RETURN_AMT as AUTH53_0_, paydtl0_.FAIL_COUNT as FAIL54_0_, paydtl0_.IS_CHINAPAY as IS55_0_, paydtl0_.BATCHTRANS_NO as BATCHTRANS56_0_, paydtl0_.IS_BATCHMAIN as IS57_0_, paydtl0_.TOTAL_BATCHAMT as TOTAL58_0_, paydtl0_.GOPAY_OUT_ORDER_ID as GOPAY59_0_, paydtl0_.IS_ORDER_REPAET as IS60_0_, paydtl0_.TRANS_FINISH_TIME as TRANS61_0_, paydtl0_.GATEWAY_VERSION as GATEWAY62_0_, paydtl0_.BANK_SERIAL_NUMBER as BANK63_0_, paydtl0_.CONTRACT_NO as CONTRACT64_0_ from PAY_DTL paydtl0_ where ((paydtl0_.INT_TXN_CD=:1 )or(paydtl0_.INT_TXN_CD=:2 ))and(paydtl0_.TXN_STA_CD=:3 )

2cahu5zgtkzgm select OPR_NAME from OPR_INFO where OPR_ID = ''

3ktacv9r56b51 select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

3tm9gbjxbnarq update BANK_ORDER_CHECK_LOG set ORDER_ID=:1 , TRANS_TIME=:2 , BANK_CODE=:3 , TO_BANK_ORDER_ID=:4 , TOTAL_COUNT=:5 , IS_CHECK_OK=:6 , BANK_RESPCODE=:7 , LAST_CHECK_TM=:8 , REMARK=:9 where id=:10

459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'

4vs91dcv7u1p6 insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)

4y7kwa54zhrxn update pay_dtl p set p.txn_sta_cd = '1' where p.txn_sta_cd = 'b' and p.int_txn_tm < '201207111229434'

520mkxqpf15q8 select 1 from dual

5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1

6krry9gtf60h8 select this_.id as id4_0_, this_.ORDER_ID as ORDER2_4_0_, this_.TRANS_TIME as TRANS3_4_0_, this_.ORDER_TYPE as ORDER4_4_0_, this_.MER_ID as MER5_4_0_, this_.NOTIFY_DATA as NOTIFY6_4_0_, this_.FRONT_MERURL as FRONT7_4_0_, this_.BACKGROUD_MERURL as BACKGROUD8_4_0_, this_.IS_NOTIFY_OK as IS9_4_0_, this_.GATEWAY_VERSION as GATEWAY10_4_0_, this_.TOTAL_COUNT as TOTAL11_4_0_, this_.LAST_CHECK_TM as LAST12_4_0_, this_.REMARK as REMARK4_0_, this_.NOTIFY_TYPE as NOTIFY14_4_0_ from MERCHANT_ORDER_NOTIFY_INFO this_ where (this_.IS_NOTIFY_OK=:1 or this_.IS_NOTIFY_OK=:2 ) and this_.NOTIFY_TYPE=:3 and this_.TOTAL_COUNT<:4

9jdq430cfv5dy select sum(ai.item_order_amt) from pay_dtl p, AUDIT_BANK_TRANSFER_ORDER a, AUDIT_BANK_TRANSFER_ORDER_ITEM ai where p.order_id = a.TRAN_ORDER_ID and a.order_id = ai.order_id and p.pay_cust_id = '0000032534' and p.int_txn_cd = '4027' and p.ext_txn_dt = '20120711' and ai.corp_person_flag = '2' and ai.pay_status in ('0', '3', '4', '6')

9kdnk5bapz9p4 DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN sys.dbms_streams_auto_int.clean_recoverable_script; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

a79c99kr1mv0a select paydtl0_.DTL_SQ as DTL1_0_, paydtl0_.INT_TXN_DT as INT2_0_, paydtl0_.version as version0_, paydtl0_.LAST_UPD_TS as LAST4_0_, paydtl0_.MER_ID as MER5_0_, paydtl0_.SUB_MER_ID as SUB6_0_, paydtl0_.TXN_TYPE as TXN7_0_, paydtl0_.INT_TXN_CD as INT8_0_, paydtl0_.EXT_TXN_CD as EXT9_0_, paydtl0_.EXT_TXN_DT as EXT10_0_, paydtl0_.INT_TXN_TM as INT11_0_, paydtl0_.STLM_DATE as STLM12_0_, paydtl0_.CUPS_TRACE_NUM as CUPS13_0_, paydtl0_.INT_TXN_SEQ_ID as INT14_0_, paydtl0_.EXT_TXN_SEQ_ID as EXT15_0_, paydtl0_.ORDER_ID as ORDER16_0_, paydtl0_.PAY_CUST_ID as PAY17_0_, paydtl0_.PAY_CUST_USER_ID as PAY18_0_, paydtl0_.PAY_ACCOUNT as PAY19_0_, paydtl0_.PAY_TYPE as PAY20_0_, paydtl0_.TXN_AT as TXN21_0_, paydtl0_.FEE_AMT as FEE22_0_, paydtl0_.TILIU_AMT as TILIU23_0_, paydtl0_.OUT_STLM_ID as OUT24_0_, paydtl0_.IN_STLM_ID as IN25_0_, paydtl0_.CUR_TYPE as CUR26_0_, paydtl0_.CUR_EXP as CUR27_0_, paydtl0_.SEC_MODE as SEC28_0_, paydtl0_.TXN_STA_CD as TXN29_0_, paydtl0_.AUTH_ID as AUTH30_0_, paydtl0_.AUTH_STAT as AUTH31_0_, paydtl0_.RETURN_AMT as RETURN32_0_, paydtl0_.ORIG_LOG_SEQ as ORIG33_0_, paydtl0_.RECV_ACCT as RECV34_0_, paydtl0_.BATCH_ID as BATCH35_0_, paydtl0_.TRAN_IP as TRAN36_0_, paydtl0_.MISC_TX as MISC37_0_, paydtl0_.INITIATE_TYPE as INITIATE38_0_, paydtl0_.EXT_TXN_TM as EXT39_0_, paydtl0_.RSP_CODE as RSP40_0_, paydtl0_.IS_DISPUTE as IS41_0_, paydtl0_.ORIG_TXN_DT as ORIG42_0_, paydtl0_.RECV_CUST_ID as RECV43_0_, paydtl0_.MER_URL as MER44_0_, paydtl0_.CONFLICT as CONFLICT0_, paydtl0_.DESCRIPTION as DESCRIP46_0_, paydtl0_.BIND_NO as BIND47_0_, paydtl0_.TICKET_AMT as TICKET48_0_, paydtl0_.GOODS_INFO as GOODS49_0_, paydtl0_.SEND_BANK_DT as SEND50_0_, paydtl0_.PROXY_FEE as PROXY51_0_, paydtl0_.BANK_FEE_AT as BANK52_0_, paydtl0_.AUTH_RETURN_AMT as AUTH53_0_, paydtl0_.FAIL_COUNT as FAIL54_0_, paydtl0_.IS_CHINAPAY as IS55_0_, paydtl0_.BATCHTRANS_NO as BATCHTRANS56_0_, paydtl0_.IS_BATCHMAIN as IS57_0_, paydtl0_.TOTAL_BATCHAMT as TOTAL58_0_, paydtl0_.GOPAY_OUT_ORDER_ID as GOPAY59_0_, paydtl0_.IS_ORDER_REPAET as IS60_0_, paydtl0_.TRANS_FINISH_TIME as TRANS61_0_, paydtl0_.GATEWAY_VERSION as GATEWAY62_0_, paydtl0_.BANK_SERIAL_NUMBER as BANK63_0_, paydtl0_.CONTRACT_NO as CONTRACT64_0_ from PAY_DTL paydtl0_ where (paydtl0_.INT_TXN_CD=:1 )and(paydtl0_.TXN_STA_CD=:2 )

aa8wkj898d4y6 update pay_dtl p set p.txn_sta_cd = '1' where p.txn_sta_cd = 'b' and p.int_txn_tm < '201207111209436'

ap4s8z6tn1zww update pay_dtl p set p.txn_sta_cd = '1' where p.txn_sta_cd = 'b' and p.int_txn_tm < '201207111249432'

aux14x0ad1zdd select NVL(b.free, 0.0), a.total, 100 - trunc(NVL(b.free, 0.0)/a.total * 1000) / 10 prc from ( select tablespace_name, sum(bytes)/1024/1024 total from dba_data_files group by tablespace_name) A LEFT OUTER JOIN ( select tablespace_name, sum(bytes)/1024/1024 free from dba_free_space group by tablespace_name) B ON a.tablespace_name=b.tablespace_name WHERE a.tablespace_name='TS_PAY_DAT'

az33m61ym46y4 SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name

bdkfqz9umhbvg update PAY_DTL set version=:1 , LAST_UPD_TS=:2 , MER_ID=:3 , SUB_MER_ID=:4 , TXN_TYPE=:5 , INT_TXN_CD=:6 , EXT_TXN_CD=:7 , EXT_TXN_DT=:8 , INT_TXN_TM=:9 , STLM_DATE=:10 , CUPS_TRACE_NUM=:11 , INT_TXN_SEQ_ID=:12 , EXT_TXN_SEQ_ID=:13 , ORDER_ID=:14 , PAY_CUST_ID=:15 , PAY_CUST_USER_ID=:16 , PAY_ACCOUNT=:17 , PAY_TYPE=:18 , TXN_AT=:19 , FEE_AMT=:20 , TILIU_AMT=:21 , OUT_STLM_ID=:22 , IN_STLM_ID=:23 , CUR_TYPE=:24 , CUR_EXP=:25 , SEC_MODE=:26 , TXN_STA_CD=:27 , AUTH_ID=:28 , AUTH_STAT=:29 , RETURN_AMT=:30 , ORIG_LOG_SEQ=:31 , RECV_ACCT=:32 , BATCH_ID=:33 , TRAN_IP=:34 , MISC_TX=:35 , INITIATE_TYPE=:36 , EXT_TXN_TM=:37 , RSP_CODE=:38 , IS_DISPUTE=:39 , ORIG_TXN_DT=:40 , RECV_CUST_ID=:41 , MER_URL=:42 , CONFLICT=:43 , DESCRIPTION=:44 , BIND_NO=:45 , TICKET_AMT=:46 , GOODS_INFO=:47 , SEND_BANK_DT=:48 , PROXY_FEE=:49 , BANK_FEE_AT=:50 , AUTH_RETURN_AMT=:51 , FAIL_COUNT=:52 , IS_CHINAPAY=:53 , BATCHTRANS_NO=:54 , IS_BATCHMAIN=:55 , TOTAL_BATCHAMT=:56 , GOPAY_OUT_ORDER_ID=:57 , IS_ORDER_REPAET=:58 , TRANS_FINISH_TIME=:59 , GATEWAY_VERSION=:60 , BANK_SERIAL_NUMBER=:61 , CONTRACT_NO=:62 where DTL_SQ=:63 and INT_TXN_DT=:64 and version=:65

bj4baa185a9au select paydtl0_.DTL_SQ as DTL1_0_, paydtl0_.INT_TXN_DT as INT2_0_, paydtl0_.version as version0_, paydtl0_.LAST_UPD_TS as LAST4_0_, paydtl0_.MER_ID as MER5_0_, paydtl0_.SUB_MER_ID as SUB6_0_, paydtl0_.TXN_TYPE as TXN7_0_, paydtl0_.INT_TXN_CD as INT8_0_, paydtl0_.EXT_TXN_CD as EXT9_0_, paydtl0_.EXT_TXN_DT as EXT10_0_, paydtl0_.INT_TXN_TM as INT11_0_, paydtl0_.STLM_DATE as STLM12_0_, paydtl0_.CUPS_TRACE_NUM as CUPS13_0_, paydtl0_.INT_TXN_SEQ_ID as INT14_0_, paydtl0_.EXT_TXN_SEQ_ID as EXT15_0_, paydtl0_.ORDER_ID as ORDER16_0_, paydtl0_.PAY_CUST_ID as PAY17_0_, paydtl0_.PAY_CUST_USER_ID as PAY18_0_, paydtl0_.PAY_ACCOUNT as PAY19_0_, paydtl0_.PAY_TYPE as PAY20_0_, paydtl0_.TXN_AT as TXN21_0_, paydtl0_.FEE_AMT as FEE22_0_, paydtl0_.TILIU_AMT as TILIU23_0_, paydtl0_.OUT_STLM_ID as OUT24_0_, paydtl0_.IN_STLM_ID as IN25_0_, paydtl0_.CUR_TYPE as CUR26_0_, paydtl0_.CUR_EXP as CUR27_0_, paydtl0_.SEC_MODE as SEC28_0_, paydtl0_.TXN_STA_CD as TXN29_0_, paydtl0_.AUTH_ID as AUTH30_0_, paydtl0_.AUTH_STAT as AUTH31_0_, paydtl0_.RETURN_AMT as RETURN32_0_, paydtl0_.ORIG_LOG_SEQ as ORIG33_0_, paydtl0_.RECV_ACCT as RECV34_0_, paydtl0_.BATCH_ID as BATCH35_0_, paydtl0_.TRAN_IP as TRAN36_0_, paydtl0_.MISC_TX as MISC37_0_, paydtl0_.INITIATE_TYPE as INITIATE38_0_, paydtl0_.EXT_TXN_TM as EXT39_0_, paydtl0_.RSP_CODE as RSP40_0_, paydtl0_.IS_DISPUTE as IS41_0_, paydtl0_.ORIG_TXN_DT as ORIG42_0_, paydtl0_.RECV_CUST_ID as RECV43_0_, paydtl0_.MER_URL as MER44_0_, paydtl0_.CONFLICT as CONFLICT0_, paydtl0_.DESCRIPTION as DESCRIP46_0_, paydtl0_.BIND_NO as BIND47_0_, paydtl0_.TICKET_AMT as TICKET48_0_, paydtl0_.GOODS_INFO as GOODS49_0_, paydtl0_.SEND_BANK_DT as SEND50_0_, paydtl0_.PROXY_FEE as PROXY51_0_, paydtl0_.BANK_FEE_AT as BANK52_0_, paydtl0_.AUTH_RETURN_AMT as AUTH53_0_, paydtl0_.FAIL_COUNT as FAIL54_0_, paydtl0_.IS_CHINAPAY as IS55_0_, paydtl0_.BATCHTRANS_NO as BATCHTRANS56_0_, paydtl0_.IS_BATCHMAIN as IS57_0_, paydtl0_.TOTAL_BATCHAMT as TOTAL58_0_, paydtl0_.GOPAY_OUT_ORDER_ID as GOPAY59_0_, paydtl0_.IS_ORDER_REPAET as IS60_0_, paydtl0_.TRANS_FINISH_TIME as TRANS61_0_, paydtl0_.GATEWAY_VERSION as GATEWAY62_0_, paydtl0_.BANK_SERIAL_NUMBER as BANK63_0_, paydtl0_.CONTRACT_NO as CONTRACT64_0_ from PAY_DTL paydtl0_ where ((paydtl0_.INT_TXN_CD='1001' )or(paydtl0_.INT_TXN_CD='1002' )or(paydtl0_.INT_TXN_CD='1004' )or(paydtl0_.INT_TXN_CD='2004' )or(paydtl0_.INT_TXN_CD='4006' )or(paydtl0_.INT_TXN_CD='4014' ))and(paydtl0_.TXN_STA_CD='b' )and((paydtl0_.IS_CHINAPAY='0' )or(paydtl0_.IS_CHINAPAY is null ))and(paydtl0_.OUT_STLM_ID=:1 )and(paydtl0_.FAIL_COUNT<=:2 )

bt8w184q8xuty select s.ext_txn_seq_id, t.* from PAY_DTL_EXPAND_INFO t LEFT JOIN pay_dtl s ON t.order_id=s.order_id ORDER BY t.order_id DESC

cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

cp45v4t9w61fs select OPR_NAME from OPR_INFO where OPR_ID = '555555'

cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#

f711myt0q6cma insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)

fp9pzmut03smb select paydtl0_.DTL_SQ as DTL1_0_, paydtl0_.INT_TXN_DT as INT2_0_, paydtl0_.version as version0_, paydtl0_.LAST_UPD_TS as LAST4_0_, paydtl0_.MER_ID as MER5_0_, paydtl0_.SUB_MER_ID as SUB6_0_, paydtl0_.TXN_TYPE as TXN7_0_, paydtl0_.INT_TXN_CD as INT8_0_, paydtl0_.EXT_TXN_CD as EXT9_0_, paydtl0_.EXT_TXN_DT as EXT10_0_, paydtl0_.INT_TXN_TM as INT11_0_, paydtl0_.STLM_DATE as STLM12_0_, paydtl0_.CUPS_TRACE_NUM as CUPS13_0_, paydtl0_.INT_TXN_SEQ_ID as INT14_0_, paydtl0_.EXT_TXN_SEQ_ID as EXT15_0_, paydtl0_.ORDER_ID as ORDER16_0_, paydtl0_.PAY_CUST_ID as PAY17_0_, paydtl0_.PAY_CUST_USER_ID as PAY18_0_, paydtl0_.PAY_ACCOUNT as PAY19_0_, paydtl0_.PAY_TYPE as PAY20_0_, paydtl0_.TXN_AT as TXN21_0_, paydtl0_.FEE_AMT as FEE22_0_, paydtl0_.TILIU_AMT as TILIU23_0_, paydtl0_.OUT_STLM_ID as OUT24_0_, paydtl0_.IN_STLM_ID as IN25_0_, paydtl0_.CUR_TYPE as CUR26_0_, paydtl0_.CUR_EXP as CUR27_0_, paydtl0_.SEC_MODE as SEC28_0_, paydtl0_.TXN_STA_CD as TXN29_0_, paydtl0_.AUTH_ID as AUTH30_0_, paydtl0_.AUTH_STAT as AUTH31_0_, paydtl0_.RETURN_AMT as RETURN32_0_, paydtl0_.ORIG_LOG_SEQ as ORIG33_0_, paydtl0_.RECV_ACCT as RECV34_0_, paydtl0_.BATCH_ID as BATCH35_0_, paydtl0_.TRAN_IP as TRAN36_0_, paydtl0_.MISC_TX as MISC37_0_, paydtl0_.INITIATE_TYPE as INITIATE38_0_, paydtl0_.EXT_TXN_TM as EXT39_0_, paydtl0_.RSP_CODE as RSP40_0_, paydtl0_.IS_DISPUTE as IS41_0_, paydtl0_.ORIG_TXN_DT as ORIG42_0_, paydtl0_.RECV_CUST_ID as RECV43_0_, paydtl0_.MER_URL as MER44_0_, paydtl0_.CONFLICT as CONFLICT0_, paydtl0_.DESCRIPTION as DESCRIP46_0_, paydtl0_.BIND_NO as BIND47_0_, paydtl0_.TICKET_AMT as TICKET48_0_, paydtl0_.GOODS_INFO as GOODS49_0_, paydtl0_.SEND_BANK_DT as SEND50_0_, paydtl0_.PROXY_FEE as PROXY51_0_, paydtl0_.BANK_FEE_AT as BANK52_0_, paydtl0_.AUTH_RETURN_AMT as AUTH53_0_, paydtl0_.FAIL_COUNT as FAIL54_0_, paydtl0_.IS_CHINAPAY as IS55_0_, paydtl0_.BATCHTRANS_NO as BATCHTRANS56_0_, paydtl0_.IS_BATCHMAIN as IS57_0_, paydtl0_.TOTAL_BATCHAMT as TOTAL58_0_, paydtl0_.GOPAY_OUT_ORDER_ID as GOPAY59_0_, paydtl0_.IS_ORDER_REPAET as IS60_0_, paydtl0_.TRANS_FINISH_TIME as TRANS61_0_, paydtl0_.GATEWAY_VERSION as GATEWAY62_0_, paydtl0_.BANK_SERIAL_NUMBER as BANK63_0_, paydtl0_.CONTRACT_NO as CONTRACT64_0_ from PAY_DTL paydtl0_ where ((paydtl0_.INT_TXN_CD='1011' )or(paydtl0_.INT_TXN_CD='1003' )or(paydtl0_.INT_TXN_CD='2014' )or(paydtl0_.INT_TXN_CD='4006' )or(paydtl0_.INT_TXN_CD='4024' ))and(paydtl0_.TXN_STA_CD='c' )and(paydtl0_.OUT_STLM_ID=:1 )

gfdzv82sh9m6s select paydtl0_.DTL_SQ as DTL1_0_, paydtl0_.INT_TXN_DT as INT2_0_, paydtl0_.version as version0_, paydtl0_.LAST_UPD_TS as LAST4_0_, paydtl0_.MER_ID as MER5_0_, paydtl0_.SUB_MER_ID as SUB6_0_, paydtl0_.TXN_TYPE as TXN7_0_, paydtl0_.INT_TXN_CD as INT8_0_, paydtl0_.EXT_TXN_CD as EXT9_0_, paydtl0_.EXT_TXN_DT as EXT10_0_, paydtl0_.INT_TXN_TM as INT11_0_, paydtl0_.STLM_DATE as STLM12_0_, paydtl0_.CUPS_TRACE_NUM as CUPS13_0_, paydtl0_.INT_TXN_SEQ_ID as INT14_0_, paydtl0_.EXT_TXN_SEQ_ID as EXT15_0_, paydtl0_.ORDER_ID as ORDER16_0_, paydtl0_.PAY_CUST_ID as PAY17_0_, paydtl0_.PAY_CUST_USER_ID as PAY18_0_, paydtl0_.PAY_ACCOUNT as PAY19_0_, paydtl0_.PAY_TYPE as PAY20_0_, paydtl0_.TXN_AT as TXN21_0_, paydtl0_.FEE_AMT as FEE22_0_, paydtl0_.TILIU_AMT as TILIU23_0_, paydtl0_.OUT_STLM_ID as OUT24_0_, paydtl0_.IN_STLM_ID as IN25_0_, paydtl0_.CUR_TYPE as CUR26_0_, paydtl0_.CUR_EXP as CUR27_0_, paydtl0_.SEC_MODE as SEC28_0_, paydtl0_.TXN_STA_CD as TXN29_0_, paydtl0_.AUTH_ID as AUTH30_0_, paydtl0_.AUTH_STAT as AUTH31_0_, paydtl0_.RETURN_AMT as RETURN32_0_, paydtl0_.ORIG_LOG_SEQ as ORIG33_0_, paydtl0_.RECV_ACCT as RECV34_0_, paydtl0_.BATCH_ID as BATCH35_0_, paydtl0_.TRAN_IP as TRAN36_0_, paydtl0_.MISC_TX as MISC37_0_, paydtl0_.INITIATE_TYPE as INITIATE38_0_, paydtl0_.EXT_TXN_TM as EXT39_0_, paydtl0_.RSP_CODE as RSP40_0_, paydtl0_.IS_DISPUTE as IS41_0_, paydtl0_.ORIG_TXN_DT as ORIG42_0_, paydtl0_.RECV_CUST_ID as RECV43_0_, paydtl0_.MER_URL as MER44_0_, paydtl0_.CONFLICT as CONFLICT0_, paydtl0_.DESCRIPTION as DESCRIP46_0_, paydtl0_.BIND_NO as BIND47_0_, paydtl0_.TICKET_AMT as TICKET48_0_, paydtl0_.GOODS_INFO as GOODS49_0_, paydtl0_.SEND_BANK_DT as SEND50_0_, paydtl0_.PROXY_FEE as PROXY51_0_, paydtl0_.BANK_FEE_AT as BANK52_0_, paydtl0_.AUTH_RETURN_AMT as AUTH53_0_, paydtl0_.FAIL_COUNT as FAIL54_0_, paydtl0_.IS_CHINAPAY as IS55_0_, paydtl0_.BATCHTRANS_NO as BATCHTRANS56_0_, paydtl0_.IS_BATCHMAIN as IS57_0_, paydtl0_.TOTAL_BATCHAMT as TOTAL58_0_, paydtl0_.GOPAY_OUT_ORDER_ID as GOPAY59_0_, paydtl0_.IS_ORDER_REPAET as IS60_0_, paydtl0_.TRANS_FINISH_TIME as TRANS61_0_, paydtl0_.GATEWAY_VERSION as GATEWAY62_0_, paydtl0_.BANK_SERIAL_NUMBER as BANK63_0_, paydtl0_.CONTRACT_NO as CONTRACT64_0_ from PAY_DTL paydtl0_ where ((paydtl0_.INT_TXN_CD='1001' )or(paydtl0_.INT_TXN_CD='1002' )or(paydtl0_.INT_TXN_CD='1004' )or(paydtl0_.INT_TXN_CD='2004' )or(paydtl0_.INT_TXN_CD='4006' )or(paydtl0_.INT_TXN_CD='4014' ))and(paydtl0_.TXN_STA_CD='b' )and(paydtl0_.IS_CHINAPAY='1' )and(paydtl0_.FAIL_COUNT<=:1 )

SQL Id	SQL Text
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1sbzggatbmvgq	select t.PAYGOPAYID, t.tranid, count(*) from risk_trans_line t group by t.PAYGOPAYID, t.tranid
1ubzb3w414tp3	select this_.id as id5_0_, this_.ORDER_ID as ORDER2_5_0_, this_.TRANS_TIME as TRANS3_5_0_, this_.BANK_CODE as BANK4_5_0_, this_.TO_BANK_ORDER_ID as TO5_5_0_, this_.TOTAL_COUNT as TOTAL6_5_0_, this_.IS_CHECK_OK as IS7_5_0_, this_.BANK_RESPCODE as BANK8_5_0_, this_.LAST_CHECK_TM as LAST9_5_0_, this_.REMARK as REMARK5_0_ from BANK_ORDER_CHECK_LOG this_ where this_.ORDER_ID=:1
1v85jkc3nx90h	select paydtl0_.DTL_SQ as DTL1_0_, paydtl0_.INT_TXN_DT as INT2_0_, paydtl0_.version as version0_, paydtl0_.LAST_UPD_TS as LAST4_0_, paydtl0_.MER_ID as MER5_0_, paydtl0_.SUB_MER_ID as SUB6_0_, paydtl0_.TXN_TYPE as TXN7_0_, paydtl0_.INT_TXN_CD as INT8_0_, paydtl0_.EXT_TXN_CD as EXT9_0_, paydtl0_.EXT_TXN_DT as EXT10_0_, paydtl0_.INT_TXN_TM as INT11_0_, paydtl0_.STLM_DATE as STLM12_0_, paydtl0_.CUPS_TRACE_NUM as CUPS13_0_, paydtl0_.INT_TXN_SEQ_ID as INT14_0_, paydtl0_.EXT_TXN_SEQ_ID as EXT15_0_, paydtl0_.ORDER_ID as ORDER16_0_, paydtl0_.PAY_CUST_ID as PAY17_0_, paydtl0_.PAY_CUST_USER_ID as PAY18_0_, paydtl0_.PAY_ACCOUNT as PAY19_0_, paydtl0_.PAY_TYPE as PAY20_0_, paydtl0_.TXN_AT as TXN21_0_, paydtl0_.FEE_AMT as FEE22_0_, paydtl0_.TILIU_AMT as TILIU23_0_, paydtl0_.OUT_STLM_ID as OUT24_0_, paydtl0_.IN_STLM_ID as IN25_0_, paydtl0_.CUR_TYPE as CUR26_0_, paydtl0_.CUR_EXP as CUR27_0_, paydtl0_.SEC_MODE as SEC28_0_, paydtl0_.TXN_STA_CD as TXN29_0_, paydtl0_.AUTH_ID as AUTH30_0_, paydtl0_.AUTH_STAT as AUTH31_0_, paydtl0_.RETURN_AMT as RETURN32_0_, paydtl0_.ORIG_LOG_SEQ as ORIG33_0_, paydtl0_.RECV_ACCT as RECV34_0_, paydtl0_.BATCH_ID as BATCH35_0_, paydtl0_.TRAN_IP as TRAN36_0_, paydtl0_.MISC_TX as MISC37_0_, paydtl0_.INITIATE_TYPE as INITIATE38_0_, paydtl0_.EXT_TXN_TM as EXT39_0_, paydtl0_.RSP_CODE as RSP40_0_, paydtl0_.IS_DISPUTE as IS41_0_, paydtl0_.ORIG_TXN_DT as ORIG42_0_, paydtl0_.RECV_CUST_ID as RECV43_0_, paydtl0_.MER_URL as MER44_0_, paydtl0_.CONFLICT as CONFLICT0_, paydtl0_.DESCRIPTION as DESCRIP46_0_, paydtl0_.BIND_NO as BIND47_0_, paydtl0_.TICKET_AMT as TICKET48_0_, paydtl0_.GOODS_INFO as GOODS49_0_, paydtl0_.SEND_BANK_DT as SEND50_0_, paydtl0_.PROXY_FEE as PROXY51_0_, paydtl0_.BANK_FEE_AT as BANK52_0_, paydtl0_.AUTH_RETURN_AMT as AUTH53_0_, paydtl0_.FAIL_COUNT as FAIL54_0_, paydtl0_.IS_CHINAPAY as IS55_0_, paydtl0_.BATCHTRANS_NO as BATCHTRANS56_0_, paydtl0_.IS_BATCHMAIN as IS57_0_, paydtl0_.TOTAL_BATCHAMT as TOTAL58_0_, paydtl0_.GOPAY_OUT_ORDER_ID as GOPAY59_0_, paydtl0_.IS_ORDER_REPAET as IS60_0_, paydtl0_.TRANS_FINISH_TIME as TRANS61_0_, paydtl0_.GATEWAY_VERSION as GATEWAY62_0_, paydtl0_.BANK_SERIAL_NUMBER as BANK63_0_, paydtl0_.CONTRACT_NO as CONTRACT64_0_ from PAY_DTL paydtl0_ where ((paydtl0_.INT_TXN_CD=:1 )or(paydtl0_.INT_TXN_CD=:2 ))and(paydtl0_.TXN_STA_CD=:3 )
2cahu5zgtkzgm	select OPR_NAME from OPR_INFO where OPR_ID = ''
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3tm9gbjxbnarq	update BANK_ORDER_CHECK_LOG set ORDER_ID=:1 , TRANS_TIME=:2 , BANK_CODE=:3 , TO_BANK_ORDER_ID=:4 , TOTAL_COUNT=:5 , IS_CHECK_OK=:6 , BANK_RESPCODE=:7 , LAST_CHECK_TM=:8 , REMARK=:9 where id=:10
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
4y7kwa54zhrxn	update pay_dtl p set p.txn_sta_cd = '1' where p.txn_sta_cd = 'b' and p.int_txn_tm < '201207111229434'
520mkxqpf15q8	select 1 from dual
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6krry9gtf60h8	select this_.id as id4_0_, this_.ORDER_ID as ORDER2_4_0_, this_.TRANS_TIME as TRANS3_4_0_, this_.ORDER_TYPE as ORDER4_4_0_, this_.MER_ID as MER5_4_0_, this_.NOTIFY_DATA as NOTIFY6_4_0_, this_.FRONT_MERURL as FRONT7_4_0_, this_.BACKGROUD_MERURL as BACKGROUD8_4_0_, this_.IS_NOTIFY_OK as IS9_4_0_, this_.GATEWAY_VERSION as GATEWAY10_4_0_, this_.TOTAL_COUNT as TOTAL11_4_0_, this_.LAST_CHECK_TM as LAST12_4_0_, this_.REMARK as REMARK4_0_, this_.NOTIFY_TYPE as NOTIFY14_4_0_ from MERCHANT_ORDER_NOTIFY_INFO this_ where (this_.IS_NOTIFY_OK=:1 or this_.IS_NOTIFY_OK=:2 ) and this_.NOTIFY_TYPE=:3 and this_.TOTAL_COUNT<:4
9jdq430cfv5dy	select sum(ai.item_order_amt) from pay_dtl p, AUDIT_BANK_TRANSFER_ORDER a, AUDIT_BANK_TRANSFER_ORDER_ITEM ai where p.order_id = a.TRAN_ORDER_ID and a.order_id = ai.order_id and p.pay_cust_id = '0000032534' and p.int_txn_cd = '4027' and p.ext_txn_dt = '20120711' and ai.corp_person_flag = '2' and ai.pay_status in ('0', '3', '4', '6')
9kdnk5bapz9p4	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN sys.dbms_streams_auto_int.clean_recoverable_script; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
a79c99kr1mv0a	select paydtl0_.DTL_SQ as DTL1_0_, paydtl0_.INT_TXN_DT as INT2_0_, paydtl0_.version as version0_, paydtl0_.LAST_UPD_TS as LAST4_0_, paydtl0_.MER_ID as MER5_0_, paydtl0_.SUB_MER_ID as SUB6_0_, paydtl0_.TXN_TYPE as TXN7_0_, paydtl0_.INT_TXN_CD as INT8_0_, paydtl0_.EXT_TXN_CD as EXT9_0_, paydtl0_.EXT_TXN_DT as EXT10_0_, paydtl0_.INT_TXN_TM as INT11_0_, paydtl0_.STLM_DATE as STLM12_0_, paydtl0_.CUPS_TRACE_NUM as CUPS13_0_, paydtl0_.INT_TXN_SEQ_ID as INT14_0_, paydtl0_.EXT_TXN_SEQ_ID as EXT15_0_, paydtl0_.ORDER_ID as ORDER16_0_, paydtl0_.PAY_CUST_ID as PAY17_0_, paydtl0_.PAY_CUST_USER_ID as PAY18_0_, paydtl0_.PAY_ACCOUNT as PAY19_0_, paydtl0_.PAY_TYPE as PAY20_0_, paydtl0_.TXN_AT as TXN21_0_, paydtl0_.FEE_AMT as FEE22_0_, paydtl0_.TILIU_AMT as TILIU23_0_, paydtl0_.OUT_STLM_ID as OUT24_0_, paydtl0_.IN_STLM_ID as IN25_0_, paydtl0_.CUR_TYPE as CUR26_0_, paydtl0_.CUR_EXP as CUR27_0_, paydtl0_.SEC_MODE as SEC28_0_, paydtl0_.TXN_STA_CD as TXN29_0_, paydtl0_.AUTH_ID as AUTH30_0_, paydtl0_.AUTH_STAT as AUTH31_0_, paydtl0_.RETURN_AMT as RETURN32_0_, paydtl0_.ORIG_LOG_SEQ as ORIG33_0_, paydtl0_.RECV_ACCT as RECV34_0_, paydtl0_.BATCH_ID as BATCH35_0_, paydtl0_.TRAN_IP as TRAN36_0_, paydtl0_.MISC_TX as MISC37_0_, paydtl0_.INITIATE_TYPE as INITIATE38_0_, paydtl0_.EXT_TXN_TM as EXT39_0_, paydtl0_.RSP_CODE as RSP40_0_, paydtl0_.IS_DISPUTE as IS41_0_, paydtl0_.ORIG_TXN_DT as ORIG42_0_, paydtl0_.RECV_CUST_ID as RECV43_0_, paydtl0_.MER_URL as MER44_0_, paydtl0_.CONFLICT as CONFLICT0_, paydtl0_.DESCRIPTION as DESCRIP46_0_, paydtl0_.BIND_NO as BIND47_0_, paydtl0_.TICKET_AMT as TICKET48_0_, paydtl0_.GOODS_INFO as GOODS49_0_, paydtl0_.SEND_BANK_DT as SEND50_0_, paydtl0_.PROXY_FEE as PROXY51_0_, paydtl0_.BANK_FEE_AT as BANK52_0_, paydtl0_.AUTH_RETURN_AMT as AUTH53_0_, paydtl0_.FAIL_COUNT as FAIL54_0_, paydtl0_.IS_CHINAPAY as IS55_0_, paydtl0_.BATCHTRANS_NO as BATCHTRANS56_0_, paydtl0_.IS_BATCHMAIN as IS57_0_, paydtl0_.TOTAL_BATCHAMT as TOTAL58_0_, paydtl0_.GOPAY_OUT_ORDER_ID as GOPAY59_0_, paydtl0_.IS_ORDER_REPAET as IS60_0_, paydtl0_.TRANS_FINISH_TIME as TRANS61_0_, paydtl0_.GATEWAY_VERSION as GATEWAY62_0_, paydtl0_.BANK_SERIAL_NUMBER as BANK63_0_, paydtl0_.CONTRACT_NO as CONTRACT64_0_ from PAY_DTL paydtl0_ where (paydtl0_.INT_TXN_CD=:1 )and(paydtl0_.TXN_STA_CD=:2 )
aa8wkj898d4y6	update pay_dtl p set p.txn_sta_cd = '1' where p.txn_sta_cd = 'b' and p.int_txn_tm < '201207111209436'
ap4s8z6tn1zww	update pay_dtl p set p.txn_sta_cd = '1' where p.txn_sta_cd = 'b' and p.int_txn_tm < '201207111249432'
aux14x0ad1zdd	select NVL(b.free, 0.0), a.total, 100 - trunc(NVL(b.free, 0.0)/a.total * 1000) / 10 prc from ( select tablespace_name, sum(bytes)/1024/1024 total from dba_data_files group by tablespace_name) A LEFT OUTER JOIN ( select tablespace_name, sum(bytes)/1024/1024 free from dba_free_space group by tablespace_name) B ON a.tablespace_name=b.tablespace_name WHERE a.tablespace_name='TS_PAY_DAT'
az33m61ym46y4	SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name
bdkfqz9umhbvg	update PAY_DTL set version=:1 , LAST_UPD_TS=:2 , MER_ID=:3 , SUB_MER_ID=:4 , TXN_TYPE=:5 , INT_TXN_CD=:6 , EXT_TXN_CD=:7 , EXT_TXN_DT=:8 , INT_TXN_TM=:9 , STLM_DATE=:10 , CUPS_TRACE_NUM=:11 , INT_TXN_SEQ_ID=:12 , EXT_TXN_SEQ_ID=:13 , ORDER_ID=:14 , PAY_CUST_ID=:15 , PAY_CUST_USER_ID=:16 , PAY_ACCOUNT=:17 , PAY_TYPE=:18 , TXN_AT=:19 , FEE_AMT=:20 , TILIU_AMT=:21 , OUT_STLM_ID=:22 , IN_STLM_ID=:23 , CUR_TYPE=:24 , CUR_EXP=:25 , SEC_MODE=:26 , TXN_STA_CD=:27 , AUTH_ID=:28 , AUTH_STAT=:29 , RETURN_AMT=:30 , ORIG_LOG_SEQ=:31 , RECV_ACCT=:32 , BATCH_ID=:33 , TRAN_IP=:34 , MISC_TX=:35 , INITIATE_TYPE=:36 , EXT_TXN_TM=:37 , RSP_CODE=:38 , IS_DISPUTE=:39 , ORIG_TXN_DT=:40 , RECV_CUST_ID=:41 , MER_URL=:42 , CONFLICT=:43 , DESCRIPTION=:44 , BIND_NO=:45 , TICKET_AMT=:46 , GOODS_INFO=:47 , SEND_BANK_DT=:48 , PROXY_FEE=:49 , BANK_FEE_AT=:50 , AUTH_RETURN_AMT=:51 , FAIL_COUNT=:52 , IS_CHINAPAY=:53 , BATCHTRANS_NO=:54 , IS_BATCHMAIN=:55 , TOTAL_BATCHAMT=:56 , GOPAY_OUT_ORDER_ID=:57 , IS_ORDER_REPAET=:58 , TRANS_FINISH_TIME=:59 , GATEWAY_VERSION=:60 , BANK_SERIAL_NUMBER=:61 , CONTRACT_NO=:62 where DTL_SQ=:63 and INT_TXN_DT=:64 and version=:65
bj4baa185a9au	select paydtl0_.DTL_SQ as DTL1_0_, paydtl0_.INT_TXN_DT as INT2_0_, paydtl0_.version as version0_, paydtl0_.LAST_UPD_TS as LAST4_0_, paydtl0_.MER_ID as MER5_0_, paydtl0_.SUB_MER_ID as SUB6_0_, paydtl0_.TXN_TYPE as TXN7_0_, paydtl0_.INT_TXN_CD as INT8_0_, paydtl0_.EXT_TXN_CD as EXT9_0_, paydtl0_.EXT_TXN_DT as EXT10_0_, paydtl0_.INT_TXN_TM as INT11_0_, paydtl0_.STLM_DATE as STLM12_0_, paydtl0_.CUPS_TRACE_NUM as CUPS13_0_, paydtl0_.INT_TXN_SEQ_ID as INT14_0_, paydtl0_.EXT_TXN_SEQ_ID as EXT15_0_, paydtl0_.ORDER_ID as ORDER16_0_, paydtl0_.PAY_CUST_ID as PAY17_0_, paydtl0_.PAY_CUST_USER_ID as PAY18_0_, paydtl0_.PAY_ACCOUNT as PAY19_0_, paydtl0_.PAY_TYPE as PAY20_0_, paydtl0_.TXN_AT as TXN21_0_, paydtl0_.FEE_AMT as FEE22_0_, paydtl0_.TILIU_AMT as TILIU23_0_, paydtl0_.OUT_STLM_ID as OUT24_0_, paydtl0_.IN_STLM_ID as IN25_0_, paydtl0_.CUR_TYPE as CUR26_0_, paydtl0_.CUR_EXP as CUR27_0_, paydtl0_.SEC_MODE as SEC28_0_, paydtl0_.TXN_STA_CD as TXN29_0_, paydtl0_.AUTH_ID as AUTH30_0_, paydtl0_.AUTH_STAT as AUTH31_0_, paydtl0_.RETURN_AMT as RETURN32_0_, paydtl0_.ORIG_LOG_SEQ as ORIG33_0_, paydtl0_.RECV_ACCT as RECV34_0_, paydtl0_.BATCH_ID as BATCH35_0_, paydtl0_.TRAN_IP as TRAN36_0_, paydtl0_.MISC_TX as MISC37_0_, paydtl0_.INITIATE_TYPE as INITIATE38_0_, paydtl0_.EXT_TXN_TM as EXT39_0_, paydtl0_.RSP_CODE as RSP40_0_, paydtl0_.IS_DISPUTE as IS41_0_, paydtl0_.ORIG_TXN_DT as ORIG42_0_, paydtl0_.RECV_CUST_ID as RECV43_0_, paydtl0_.MER_URL as MER44_0_, paydtl0_.CONFLICT as CONFLICT0_, paydtl0_.DESCRIPTION as DESCRIP46_0_, paydtl0_.BIND_NO as BIND47_0_, paydtl0_.TICKET_AMT as TICKET48_0_, paydtl0_.GOODS_INFO as GOODS49_0_, paydtl0_.SEND_BANK_DT as SEND50_0_, paydtl0_.PROXY_FEE as PROXY51_0_, paydtl0_.BANK_FEE_AT as BANK52_0_, paydtl0_.AUTH_RETURN_AMT as AUTH53_0_, paydtl0_.FAIL_COUNT as FAIL54_0_, paydtl0_.IS_CHINAPAY as IS55_0_, paydtl0_.BATCHTRANS_NO as BATCHTRANS56_0_, paydtl0_.IS_BATCHMAIN as IS57_0_, paydtl0_.TOTAL_BATCHAMT as TOTAL58_0_, paydtl0_.GOPAY_OUT_ORDER_ID as GOPAY59_0_, paydtl0_.IS_ORDER_REPAET as IS60_0_, paydtl0_.TRANS_FINISH_TIME as TRANS61_0_, paydtl0_.GATEWAY_VERSION as GATEWAY62_0_, paydtl0_.BANK_SERIAL_NUMBER as BANK63_0_, paydtl0_.CONTRACT_NO as CONTRACT64_0_ from PAY_DTL paydtl0_ where ((paydtl0_.INT_TXN_CD='1001' )or(paydtl0_.INT_TXN_CD='1002' )or(paydtl0_.INT_TXN_CD='1004' )or(paydtl0_.INT_TXN_CD='2004' )or(paydtl0_.INT_TXN_CD='4006' )or(paydtl0_.INT_TXN_CD='4014' ))and(paydtl0_.TXN_STA_CD='b' )and((paydtl0_.IS_CHINAPAY='0' )or(paydtl0_.IS_CHINAPAY is null ))and(paydtl0_.OUT_STLM_ID=:1 )and(paydtl0_.FAIL_COUNT<=:2 )
bt8w184q8xuty	select s.ext_txn_seq_id, t.* from PAY_DTL_EXPAND_INFO t LEFT JOIN pay_dtl s ON t.order_id=s.order_id ORDER BY t.order_id DESC
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cp45v4t9w61fs	select OPR_NAME from OPR_INFO where OPR_ID = '555555'
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
f711myt0q6cma	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
fp9pzmut03smb	select paydtl0_.DTL_SQ as DTL1_0_, paydtl0_.INT_TXN_DT as INT2_0_, paydtl0_.version as version0_, paydtl0_.LAST_UPD_TS as LAST4_0_, paydtl0_.MER_ID as MER5_0_, paydtl0_.SUB_MER_ID as SUB6_0_, paydtl0_.TXN_TYPE as TXN7_0_, paydtl0_.INT_TXN_CD as INT8_0_, paydtl0_.EXT_TXN_CD as EXT9_0_, paydtl0_.EXT_TXN_DT as EXT10_0_, paydtl0_.INT_TXN_TM as INT11_0_, paydtl0_.STLM_DATE as STLM12_0_, paydtl0_.CUPS_TRACE_NUM as CUPS13_0_, paydtl0_.INT_TXN_SEQ_ID as INT14_0_, paydtl0_.EXT_TXN_SEQ_ID as EXT15_0_, paydtl0_.ORDER_ID as ORDER16_0_, paydtl0_.PAY_CUST_ID as PAY17_0_, paydtl0_.PAY_CUST_USER_ID as PAY18_0_, paydtl0_.PAY_ACCOUNT as PAY19_0_, paydtl0_.PAY_TYPE as PAY20_0_, paydtl0_.TXN_AT as TXN21_0_, paydtl0_.FEE_AMT as FEE22_0_, paydtl0_.TILIU_AMT as TILIU23_0_, paydtl0_.OUT_STLM_ID as OUT24_0_, paydtl0_.IN_STLM_ID as IN25_0_, paydtl0_.CUR_TYPE as CUR26_0_, paydtl0_.CUR_EXP as CUR27_0_, paydtl0_.SEC_MODE as SEC28_0_, paydtl0_.TXN_STA_CD as TXN29_0_, paydtl0_.AUTH_ID as AUTH30_0_, paydtl0_.AUTH_STAT as AUTH31_0_, paydtl0_.RETURN_AMT as RETURN32_0_, paydtl0_.ORIG_LOG_SEQ as ORIG33_0_, paydtl0_.RECV_ACCT as RECV34_0_, paydtl0_.BATCH_ID as BATCH35_0_, paydtl0_.TRAN_IP as TRAN36_0_, paydtl0_.MISC_TX as MISC37_0_, paydtl0_.INITIATE_TYPE as INITIATE38_0_, paydtl0_.EXT_TXN_TM as EXT39_0_, paydtl0_.RSP_CODE as RSP40_0_, paydtl0_.IS_DISPUTE as IS41_0_, paydtl0_.ORIG_TXN_DT as ORIG42_0_, paydtl0_.RECV_CUST_ID as RECV43_0_, paydtl0_.MER_URL as MER44_0_, paydtl0_.CONFLICT as CONFLICT0_, paydtl0_.DESCRIPTION as DESCRIP46_0_, paydtl0_.BIND_NO as BIND47_0_, paydtl0_.TICKET_AMT as TICKET48_0_, paydtl0_.GOODS_INFO as GOODS49_0_, paydtl0_.SEND_BANK_DT as SEND50_0_, paydtl0_.PROXY_FEE as PROXY51_0_, paydtl0_.BANK_FEE_AT as BANK52_0_, paydtl0_.AUTH_RETURN_AMT as AUTH53_0_, paydtl0_.FAIL_COUNT as FAIL54_0_, paydtl0_.IS_CHINAPAY as IS55_0_, paydtl0_.BATCHTRANS_NO as BATCHTRANS56_0_, paydtl0_.IS_BATCHMAIN as IS57_0_, paydtl0_.TOTAL_BATCHAMT as TOTAL58_0_, paydtl0_.GOPAY_OUT_ORDER_ID as GOPAY59_0_, paydtl0_.IS_ORDER_REPAET as IS60_0_, paydtl0_.TRANS_FINISH_TIME as TRANS61_0_, paydtl0_.GATEWAY_VERSION as GATEWAY62_0_, paydtl0_.BANK_SERIAL_NUMBER as BANK63_0_, paydtl0_.CONTRACT_NO as CONTRACT64_0_ from PAY_DTL paydtl0_ where ((paydtl0_.INT_TXN_CD='1011' )or(paydtl0_.INT_TXN_CD='1003' )or(paydtl0_.INT_TXN_CD='2014' )or(paydtl0_.INT_TXN_CD='4006' )or(paydtl0_.INT_TXN_CD='4024' ))and(paydtl0_.TXN_STA_CD='c' )and(paydtl0_.OUT_STLM_ID=:1 )
gfdzv82sh9m6s	select paydtl0_.DTL_SQ as DTL1_0_, paydtl0_.INT_TXN_DT as INT2_0_, paydtl0_.version as version0_, paydtl0_.LAST_UPD_TS as LAST4_0_, paydtl0_.MER_ID as MER5_0_, paydtl0_.SUB_MER_ID as SUB6_0_, paydtl0_.TXN_TYPE as TXN7_0_, paydtl0_.INT_TXN_CD as INT8_0_, paydtl0_.EXT_TXN_CD as EXT9_0_, paydtl0_.EXT_TXN_DT as EXT10_0_, paydtl0_.INT_TXN_TM as INT11_0_, paydtl0_.STLM_DATE as STLM12_0_, paydtl0_.CUPS_TRACE_NUM as CUPS13_0_, paydtl0_.INT_TXN_SEQ_ID as INT14_0_, paydtl0_.EXT_TXN_SEQ_ID as EXT15_0_, paydtl0_.ORDER_ID as ORDER16_0_, paydtl0_.PAY_CUST_ID as PAY17_0_, paydtl0_.PAY_CUST_USER_ID as PAY18_0_, paydtl0_.PAY_ACCOUNT as PAY19_0_, paydtl0_.PAY_TYPE as PAY20_0_, paydtl0_.TXN_AT as TXN21_0_, paydtl0_.FEE_AMT as FEE22_0_, paydtl0_.TILIU_AMT as TILIU23_0_, paydtl0_.OUT_STLM_ID as OUT24_0_, paydtl0_.IN_STLM_ID as IN25_0_, paydtl0_.CUR_TYPE as CUR26_0_, paydtl0_.CUR_EXP as CUR27_0_, paydtl0_.SEC_MODE as SEC28_0_, paydtl0_.TXN_STA_CD as TXN29_0_, paydtl0_.AUTH_ID as AUTH30_0_, paydtl0_.AUTH_STAT as AUTH31_0_, paydtl0_.RETURN_AMT as RETURN32_0_, paydtl0_.ORIG_LOG_SEQ as ORIG33_0_, paydtl0_.RECV_ACCT as RECV34_0_, paydtl0_.BATCH_ID as BATCH35_0_, paydtl0_.TRAN_IP as TRAN36_0_, paydtl0_.MISC_TX as MISC37_0_, paydtl0_.INITIATE_TYPE as INITIATE38_0_, paydtl0_.EXT_TXN_TM as EXT39_0_, paydtl0_.RSP_CODE as RSP40_0_, paydtl0_.IS_DISPUTE as IS41_0_, paydtl0_.ORIG_TXN_DT as ORIG42_0_, paydtl0_.RECV_CUST_ID as RECV43_0_, paydtl0_.MER_URL as MER44_0_, paydtl0_.CONFLICT as CONFLICT0_, paydtl0_.DESCRIPTION as DESCRIP46_0_, paydtl0_.BIND_NO as BIND47_0_, paydtl0_.TICKET_AMT as TICKET48_0_, paydtl0_.GOODS_INFO as GOODS49_0_, paydtl0_.SEND_BANK_DT as SEND50_0_, paydtl0_.PROXY_FEE as PROXY51_0_, paydtl0_.BANK_FEE_AT as BANK52_0_, paydtl0_.AUTH_RETURN_AMT as AUTH53_0_, paydtl0_.FAIL_COUNT as FAIL54_0_, paydtl0_.IS_CHINAPAY as IS55_0_, paydtl0_.BATCHTRANS_NO as BATCHTRANS56_0_, paydtl0_.IS_BATCHMAIN as IS57_0_, paydtl0_.TOTAL_BATCHAMT as TOTAL58_0_, paydtl0_.GOPAY_OUT_ORDER_ID as GOPAY59_0_, paydtl0_.IS_ORDER_REPAET as IS60_0_, paydtl0_.TRANS_FINISH_TIME as TRANS61_0_, paydtl0_.GATEWAY_VERSION as GATEWAY62_0_, paydtl0_.BANK_SERIAL_NUMBER as BANK63_0_, paydtl0_.CONTRACT_NO as CONTRACT64_0_ from PAY_DTL paydtl0_ where ((paydtl0_.INT_TXN_CD='1001' )or(paydtl0_.INT_TXN_CD='1002' )or(paydtl0_.INT_TXN_CD='1004' )or(paydtl0_.INT_TXN_CD='2004' )or(paydtl0_.INT_TXN_CD='4006' )or(paydtl0_.INT_TXN_CD='4014' ))and(paydtl0_.TXN_STA_CD='b' )and(paydtl0_.IS_CHINAPAY='1' )and(paydtl0_.FAIL_COUNT<=:1 )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	1	0.00	0.00
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	62,643	17.37	6.13
CPU used when call started	62,111	17.23	6.08
CR blocks created	66	0.02	0.01
Cached Commit SCN referenced	1,418,444	393.38	138.75
Commit SCN cached	67	0.02	0.01
DB time	200,406	55.58	19.60
DBWR checkpoint buffers written	4,475	1.24	0.44
DBWR checkpoints	0	0.00	0.00
DBWR object drop buffers written	0	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	107	0.03	0.01
DBWR undo block writes	1,404	0.39	0.14
HSC Heap Segment Block Changes	43,486	12.06	4.25
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	127	0.04	0.01
Heap Segment Array Updates	4,879	1.35	0.48
IMU CR rollbacks	5	0.00	0.00
IMU Flushes	38	0.01	0.00
IMU Redo allocation size	164,940	45.74	16.13
IMU commits	10,184	2.82	1.00
IMU contention	9	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	16,312,520	4,524.00	1,595.67
IMU- failed to get a private strand	0	0.00	0.00
LOB table id lookup cache misses	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	179,573	49.80	17.57
Requests to/from client	121,875	33.80	11.92
RowCR - row contention	0	0.00	0.00
RowCR attempts	60	0.02	0.01
RowCR hits	60	0.02	0.01
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	121,912	33.81	11.93
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	967	0.27	0.09
application wait time	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	18,778	5.21	1.84
branch node splits	0	0.00	0.00
buffer is not pinned count	2,277,943	631.75	222.83
buffer is pinned count	4,738,954	1,314.27	463.56
bytes received via SQL*Net from client	53,049,390	14,712.34	5,189.22
bytes sent via SQL*Net to client	65,319,118	18,115.14	6,389.43
calls to get snapshot scn: kcmgss	212,576	58.95	20.79
calls to kcmgas	48,708	13.51	4.76
calls to kcmgcs	257,696	71.47	25.21
cell physical IO interconnect bytes	185,616,427,008	51,477,554.34	18,156,747.24
change write time	397	0.11	0.04
cleanout - number of ktugct calls	4,332	1.20	0.42
cleanouts and rollbacks - consistent read gets	14	0.00	0.00
cleanouts only - consistent read gets	66	0.02	0.01
cluster key scan block gets	1,340	0.37	0.13
cluster key scans	933	0.26	0.09
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	1	0.00	0.00
commit batch/immediate requested	1	0.00	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	10	0.00	0.00
commit cleanout failures: cannot pin	4,435	1.23	0.43
commit cleanouts	43,266	12.00	4.23
commit cleanouts successfully completed	38,821	10.77	3.80
commit immediate performed	1	0.00	0.00
commit immediate requested	1	0.00	0.00
commit txn count during cleanout	4,525	1.25	0.44
concurrency wait time	5,244	1.45	0.51
consistent changes	52	0.01	0.01
consistent gets	67,747,799	18,788.70	6,627.00
consistent gets - examination	1,998,367	554.21	195.48
consistent gets direct	22,205,360	6,158.28	2,172.10
consistent gets from cache	45,542,439	12,630.42	4,454.90
consistent gets from cache (fastpath)	43,393,215	12,034.37	4,244.67
cursor authentications	188	0.05	0.02
data blocks consistent reads - undo records applied	26	0.01	0.00
db block changes	179,751	49.85	17.58
db block gets	160,447	44.50	15.69
db block gets direct	9	0.00	0.00
db block gets from cache	160,438	44.49	15.69
db block gets from cache (fastpath)	3,288	0.91	0.32
deferred (CURRENT) block cleanout applications	23,336	6.47	2.28
dirty buffers inspected	0	0.00	0.00
enqueue conversions	729	0.20	0.07
enqueue releases	147,523	40.91	14.43
enqueue requests	147,458	40.89	14.42
enqueue timeouts	0	0.00	0.00
enqueue waits	110	0.03	0.01
execute count	200,626	55.64	19.62
failed probes on index block reclamation	0	0.00	0.00
file io service time	210	0.06	0.02
file io wait time	40,886,461	11,339.16	3,999.46
frame signature mismatch	0	0.00	0.00
free buffer inspected	423,047	117.32	41.38
free buffer requested	427,271	118.50	41.80
heap block compress	72	0.02	0.01
hot buffers moved to head of LRU	1,053	0.29	0.10
immediate (CR) block cleanout applications	80	0.02	0.01
immediate (CURRENT) block cleanout applications	211	0.06	0.02
in call idle wait time	8,782,328	2,435.63	859.08
index crx upgrade (positioned)	0	0.00	0.00
index crx upgrade (prefetch)	2	0.00	0.00
index fast full scans (full)	83	0.02	0.01
index fetch by key	414,384	114.92	40.53
index scans kdiixs1	2,160,713	599.24	211.36
leaf node 90-10 splits	23	0.01	0.00
leaf node splits	31	0.01	0.00
lob reads	1,120	0.31	0.11
lob writes	96	0.03	0.01
lob writes unaligned	96	0.03	0.01
logical read bytes from cache	374,397,968,384	103,832,899.23	36,623,101.67
logons cumulative	15,856	4.40	1.55
max cf enq hold time	140	0.04	0.01
messages received	28,605	7.93	2.80
messages sent	28,605	7.93	2.80
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	35	0.01	0.00
no work - consistent read gets	65,387,980	18,134.24	6,396.16
non-idle wait count	478,762	132.78	46.83
non-idle wait time	211,050	58.53	20.64
opened cursors cumulative	214,962	59.62	21.03
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	276	0.08	0.03
parse count (total)	146,023	40.50	14.28
parse time cpu	1,898	0.53	0.19
parse time elapsed	2,216	0.61	0.22
physical read IO requests	190,399	52.80	18.62
physical read bytes	185,348,947,968	51,403,373.58	18,130,582.80
physical read total IO requests	196,443	54.48	19.22
physical read total bytes	185,444,372,480	51,429,837.94	18,139,917.10
physical read total multi block requests	186,148	51.62	18.21
physical reads	22,625,604	6,274.83	2,213.21
physical reads cache	421,058	116.77	41.19
physical reads cache prefetch	410,233	113.77	40.13
physical reads direct	22,204,546	6,158.05	2,172.02
physical reads direct (lob)	4	0.00	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	1,831	0.51	0.18
physical write bytes	36,732,928	10,187.25	3,593.17
physical write total IO requests	59,663	16.55	5.84
physical write total bytes	172,054,528	47,716.39	16,830.14
physical write total multi block requests	116	0.03	0.01
physical writes	4,484	1.24	0.44
physical writes direct	9	0.00	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	4,475	1.24	0.44
physical writes non checkpoint	1,312	0.36	0.13
pinned buffers inspected	0	0.00	0.00
prefetch clients - default	1	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	4	0.00	0.00
process last non-idle time	3,602	1.00	0.35
recursive calls	1,895,313	525.63	185.40
recursive cpu usage	8,593	2.38	0.84
redo KB read	0	0.00	0.00
redo blocks checksummed by FG (exclusive)	17,901	4.96	1.75
redo blocks read for recovery	0	0.00	0.00
redo blocks written	91,606	25.41	8.96
redo buffer allocation retries	0	0.00	0.00
redo entries	81,335	22.56	7.96
redo k-bytes read for recovery	0	0.00	0.00
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	888	0.25	0.09
redo size	38,720,856	10,738.57	3,787.62
redo size for direct writes	74,096	20.55	7.25
redo subscn max counts	1,858	0.52	0.18
redo synch long waits	589	0.16	0.06
redo synch poll writes	0	0.00	0.00
redo synch polls	0	0.00	0.00
redo synch time	125,747	34.87	12.30
redo synch time (usec)	1,257,231,687	348,671.79	122,980.70
redo synch writes	41,854	11.61	4.09
redo wastage	6,718,616	1,863.29	657.21
redo write time	48,760	13.52	4.77
redo writes	27,533	7.64	2.69
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	10	0.00	0.00
root node splits	0	0.00	0.00
rows fetched via callback	345,153	95.72	33.76
scheduler wait time	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	68,888	19.10	6.74
session logical reads	67,908,246	18,833.20	6,642.69
shared hash latch upgrades - no wait	120,760	33.49	11.81
shared hash latch upgrades - wait	7,578	2.10	0.74
sorts (disk)	0	0.00	0.00
sorts (memory)	116,207	32.23	11.37
sorts (rows)	2,342,865	649.75	229.18
sql area evicted	390	0.11	0.04
sql area purged	0	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	5,019	1.39	0.49
table fetch by rowid	2,647,737	734.30	259.00
table fetch continued row	1,759	0.49	0.17
table scan blocks gotten	61,940,741	17,178.21	6,058.96
table scan rows gotten	3,040,013,073	843,095.84	297,369.96
table scans (direct read)	157	0.04	0.02
table scans (long tables)	160	0.04	0.02
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	45,951	12.74	4.49
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	2,330	0.65	0.23
total number of cf enq holders	36	0.01	0.00
total number of times SMON posted	4	0.00	0.00
transaction rollbacks	0	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	9,881,960	2,740.59	966.64
user I/O wait time	22,790	6.32	2.23
user calls	225,168	62.45	22.03
user commits	10,223	2.84	1.00
user rollbacks	0	0.00	0.00
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	58,351	16.18	5.71
write clones created in background	0	0.00	0.00
write clones created in foreground	5	0.00	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 uga memory	38,683,243,224,744	38,727,009,341,976
opened cursors current	2,608	2,554
workarea memory allocated	51,318	60,396
logons current	624	558
session uga memory max	5,991,840,038,328	5,999,100,357,688
session pga memory	15,925,004,976	15,918,991,024
session pga memory max	26,108,880,112	26,084,071,696
session cursor cache count	106,049,070	106,177,546

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

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	169.4G	49.80	48.1050	0M	0.00	0M	179.6K	0.92
Buffer Cache Reads	3.2G	3.00	.912148	0M	0.00	0M	10.8K	0.65
Others	91M	1.68	.025237	40M	0.70	.011093	8578	10.01
LGWR	0M	0.00	0M	90M	15.34	.024959	55.1K	17.12
DBWR	0M	0.00	0M	35M	0.51	.009706	957	33.49
Direct Writes	0M	0.00	0M	0M	0.00	0M	2	8.00
TOTAL:	172.7G	54.48	49.0424	165M	16.55	.045759	255K	4.83

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	172.6G	52.80	49.0163	34M	0.51	.009429	1.67	0.86
Control File	90M	1.59	.024959	40M	0.70	.011093	0.16
Log File	0M	0.03	0M	90M	15.34	.024959	0.00
TOTAL:	172.7G	54.42	49.0413	164M	16.55	.045482	0.79	0.86

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	169.4G	49.80	48.1050	0M	0.00	0M	0
Direct Reads (Data File)	169.4G	49.80	48.1050	0M	0.00	0M	0
Buffer Cache Reads	3.2G	3.00	.912148	0M	0.00	0M	10.8K	0.65
Buffer Cache Reads (Data File)	3.2G	3.00	.912148	0M	0.00	0M	10.8K	0.65
Others	91M	1.68	.025237	40M	0.70	.011093	6040	0.16
Others (Control File)	89M	1.58	.024682	40M	0.70	.011093	5713	0.16
Others (Data File)	2M	0.06	.000554	0M	0.00	0M	207	0.37
Others (Log File)	0M	0.03	0M	0M	0.00	0M	120	0.00
LGWR	0M	0.00	0M	90M	15.34	.024959	0
LGWR (Log File)	0M	0.00	0M	90M	15.34	.024959	0
DBWR	0M	0.00	0M	35M	0.51	.009706	0
DBWR (Data File)	0M	0.00	0M	35M	0.51	.009706	0
Direct Writes	0M	0.00	0M	0M	0.00	0M	0
Direct Writes (Data File)	0M	0.00	0M	0M	0.00	0M	0
TOTAL:	172.7G	54.47	49.0424	165M	16.55	.045759	16.9K	0.48

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
TS_PAY_DAT	191,494	53	0.02	118.92	1,018	2	0.00
SYSAUX	26	0	14.23	1.00	396	0	0.00
UNDOTBS1	0	0	0.00	0.00	256	445	0.16
SYSTEM	70	0	67.71	1.40	147	6,322	0.72
USERS	15	0	5.33	1.00	15	0	0.00
SDTEST	15	0	4.00	1.00	0	0	0.00
TBANK	15	0	13.33	1.00	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	Buffer Waits	Av Buf Wt(ms)
SDTEST	/u01/oradata/test/sdtest.dbf	15	0	4.00	1.00	0	0	0.00
SYSAUX	/u01/oradata/test/sysaux01.dbf	26	0	14.23	1.00	396	0	0.00
SYSTEM	/u01/oradata/test/system01.dbf	70	0	67.71	1.40	147	6,322	0.72
TBANK	/u01/oradata/test/tank.dbf	15	0	13.33	1.00	0	0	0.00
TS_PAY_DAT	/u01/oradata/test/ts_pay_dat.dbf	185,011	51	0.01	118.85	2	0	0.00
TS_PAY_DAT	/u01/oradata/test/ts_pay_dat2.dbf	6,463	2	0.25	121.30	861	2	0.00
TS_PAY_DAT	/u01/oradata/test/ts_pay_dat3.dbf	17	0	7.65	1.00	56	0	0.00
TS_PAY_DAT	/u01/oradata/test/ts_pay_dat4.dbf	3	0	6.67	1.00	38	0	0.00
TS_PAY_DAT	/u01/oradata/test/ts_pay_dat6.dbf	0	0			46	0	0.00
TS_PAY_DAT	/u01/oradata/test/ts_pay_dat7.dbf	0	0			15	0	0.00
UNDOTBS1	/u01/oradata/test/undotbs01.dbf	0	0			256	445	0.16
USERS	/u01/oradata/test/users01.dbf	15	0	5.33	1.00	15	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	250,810	99	45,680,057	421,059	4,475	0	0	6,769

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 4,484

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	4,475	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

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

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	14	595	9336	46068	497664	46068
E	0	14	474	9019	45336	497664	45336

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	192	0.09	24	1.90	11,835,420	1	748635.00
D	384	0.19	47	1.76	10,982,372	1	659118.00
D	576	0.28	71	1.61	10,028,249	1	558994.00
D	768	0.38	95	1.46	9,133,811	1	465133.00
D	960	0.47	118	1.34	8,375,945	1	385604.00
D	1,152	0.56	142	1.25	7,770,617	1	322082.00
D	1,344	0.66	166	1.17	7,291,667	1	271822.00
D	1,536	0.75	189	1.11	6,910,938	1	231869.00
D	1,728	0.84	213	1.06	6,609,168	1	200202.00
D	1,920	0.94	237	1.02	6,371,490	1	175260.00
D	2,048	1.00	252	1.00	6,241,656	1	161636.00
D	2,112	1.03	260	0.99	6,183,174	1	155499.00
D	2,304	1.13	284	0.97	6,028,574	1	139275.00
D	2,496	1.22	307	0.94	5,890,937	1	124832.00
D	2,688	1.31	331	0.92	5,751,170	1	110165.00
D	2,880	1.41	355	0.90	5,590,782	1	107272.00
D	3,072	1.50	378	0.85	5,334,938	1	104470.00
D	3,264	1.59	402	0.81	5,032,753	1	101160.00
D	3,456	1.69	426	0.75	4,700,007	1	97516.00
D	3,648	1.78	449	0.69	4,333,057	1	93497.00
D	3,840	1.88	473	0.62	3,884,231	1	88581.00

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	601	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	500	31	892.56	31.30	3.51	100.00	0.00	32,000
E	500	31	854.23	40.16	4.70	100.00	0.00	29,629

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	57,835	57,835
64K	128K	100	100
128K	256K	6	6
256K	512K	2	2
512K	1024K	363	363
1M	2M	97	97
4M	8M	3	3
32M	64M	1	1

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	Estd Time
63	0.13	9,789,287.52	15,718,905.22	38.00	159,434	39,931,445,921
125	0.25	9,789,287.52	15,707,311.60	38.00	159,433	39,913,296,854
250	0.50	9,789,287.52	15,701,505.21	38.00	159,423	39,904,207,332
375	0.75	9,789,287.52	14,835,583.16	40.00	151,324	38,548,661,680
500	1.00	9,789,287.52	521,841.78	95.00	70,675	16,141,414,101
600	1.20	9,789,287.52	73,747.59	99.00	18,067	15,439,951,278
700	1.40	9,789,287.52	50,906.07	99.00	2,227	15,404,194,335
800	1.60	9,789,287.52	47,734.30	100.00	582	15,399,229,136
900	1.80	9,789,287.52	43,912.14	100.00	73	15,393,245,787
1,000	2.00	9,789,287.52	43,150.89	100.00	0	15,392,054,100
1,500	3.00	9,789,287.52	42,835.55	100.00	0	15,391,560,465
2,000	4.00	9,789,287.52	42,835.55	100.00	0	15,391,560,465
3,000	6.00	9,789,287.52	42,835.55	100.00	0	15,391,560,465
4,000	8.00	9,789,287.52	42,835.55	100.00	0	15,391,560,465

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 (K)
1,456	0.79	111	6,764	6,484,209	0.66	3,382,371	69.88	141,711
1,648	0.90	303	14,180	8,337,239	0.85	1,529,341	31.59	158,516
1,680	0.91	335	15,283	8,612,700	0.88	1,253,880	25.90	160,658
1,696	0.92	351	15,958	8,736,752	0.89	1,129,828	23.34	161,597
1,712	0.93	367	16,732	8,866,743	0.90	999,837	20.66	162,467
1,728	0.94	383	17,556	8,990,683	0.92	875,897	18.09	163,310
1,744	0.95	399	18,536	9,119,767	0.93	746,813	15.43	164,163
1,760	0.96	415	19,615	9,243,907	0.94	622,673	12.86	165,021
1,776	0.97	431	20,694	9,369,255	0.95	497,325	10.27	165,870
1,792	0.97	447	21,773	9,490,875	0.97	375,705	7.76	166,711
1,808	0.98	463	22,852	9,600,999	0.98	265,581	5.49	167,341
1,824	0.99	479	23,931	9,708,549	0.99	158,031	3.26	167,964
1,840	1.00	495	25,010	9,818,174	1.00	48,406	1.00	168,599
1,856	1.01	511	25,935	9,818,307	1.00	48,273	1.00	168,727
1,872	1.02	527	26,823	9,818,448	1.00	48,132	0.99	168,742
1,888	1.03	543	27,711	9,818,514	1.00	48,066	0.99	168,747
1,904	1.03	559	28,599	9,818,599	1.00	47,981	0.99	168,751
1,920	1.04	575	29,487	9,818,660	1.00	47,920	0.99	168,756
1,936	1.05	591	30,375	9,818,711	1.00	47,869	0.99	168,868
1,952	1.06	607	31,263	9,818,850	1.00	47,730	0.99	168,880
1,968	1.07	623	32,151	9,818,908	1.00	47,672	0.98	168,885
1,984	1.08	639	33,039	9,818,976	1.00	47,604	0.98	168,890
2,032	1.10	687	35,704	9,819,326	1.00	47,254	0.98	169,059
2,224	1.21	879	45,772	9,820,625	1.00	45,955	0.95	169,446
2,416	1.31	1,071	53,832	9,821,966	1.00	44,614	0.92	170,101
2,608	1.42	1,263	64,227	9,822,507	1.00	44,073	0.91	170,140
2,800	1.52	1,455	72,879	9,822,910	1.00	43,670	0.90	170,174
2,992	1.63	1,647	82,000	9,823,130	1.00	43,450	0.90	170,197
3,184	1.73	1,839	91,402	9,823,434	1.00	43,146	0.89	170,221
3,376	1.83	2,031	100,945	9,823,661	1.00	42,919	0.89	170,239
3,568	1.94	2,223	110,637	9,823,883	1.00	42,697	0.88	170,256
3,760	2.04	2,415	120,157	9,824,076	1.00	42,504	0.88	170,271

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,984	0.50	4,608,359	11,947,153,897
2,976	0.75	3,414,555	8,454,947,322
3,968	1.00	3,184,328	6,241,656,077
4,960	1.25	3,132,742	5,385,300,863
5,952	1.50	3,115,228	3,921,008,348
6,944	1.75	3,112,363	3,921,008,348
7,936	2.00	3,111,726	3,921,008,348

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	1.00	0	0	0	0
32	2.00	0	0	0	0
48	3.00	0	0	0	0
64	4.00	0	0	0	0
80	5.00	0	0	0	0
96	6.00	0	0	0	0
112	7.00	0	0	0	0
128	8.00	0	0	0	0
144	9.00	0	0	0	0
160	10.00	0	0	0	0
176	11.00	0	0	0	0
192	12.00	0	0	0	0
208	13.00	0	0	0	0
224	14.00	0	0	0	0
240	15.00	0	0	0	0
256	16.00	0	0	0	0
272	17.00	0	0	0	0
288	18.00	0	0	0	0
304	19.00	0	0	0	0
320	20.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

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	6,290	5	1
undo header	445	0	0
segment header	34	0	0

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)
JS-Job Scheduler (queue lock)	13,118	13,118	0	1	1	640.00
HW-Segment High Water Mark	357	357	0	115	0	3.83

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
2	1.32	42,550	1,291	5	15.5/35.5	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
11-Jul 14:56	216	7,383	685	3	25	0/0	0/0/0/0/0/0
11-Jul 14:46	195	6,774	1,288	3	35	0/0	0/0/0/0/0/0
11-Jul 14:36	196	7,114	687	2	25	0/0	0/0/0/0/0/0
11-Jul 14:26	200	7,136	1,291	3	36	0/0	0/0/0/0/0/0
11-Jul 14:16	205	7,039	688	5	26	0/0	0/0/0/0/0/0
11-Jul 14:06	310	7,104	87	4	15	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
Mutex Sleep Summary
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
AQ deq hash table latch	1	0.00		0	0
ASM db client latch	2,374	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	60	0.00		0	0
AWR Alerted Metric Element list	42,107	0.00		0	0
Change Notification Hash table latch	1,200	0.00		0	0
Consistent RBA	27,540	0.00		0	0
DML lock allocation	85,170	0.03	0.14	0	0
Event Group Locks	31,753	0.00		0	0
FAL Queue	96	0.00		0	0
FIB s.o chain latch	630	0.00		0	0
FOB s.o list latch	1,760	0.00		0	0
File State Object Pool Parent Latch	1	0.00		0	0
I/O Staticstics latch	1	0.00		0	0
IPC stats buffer allocation latch	1	0.00		0	0
In memory undo latch	82,325	0.00		0	11,023	0.00
JS Sh mem access	7	0.00		0	0
JS mem alloc latch	8	0.00		0	0
JS queue access latch	9	0.00		0	0
JS queue state obj latch	26,236	0.00		0	0
JS slv state obj latch	44	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	1	0.00		0	0
KJCT flow control latch	1	0.00		0	0
KMG MMAN ready and startup request latch	1,200	0.00		0	0
KTF sga latch	19	0.00		0	1,186	0.00
KWQMN job cache list latch	1	0.00		0	0
KWQP Prop Status	2	0.00		0	0
KWQS pqueue ctx latch	2	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	1	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	1	0.00		0	1,200	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	40	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	63,987	0.00		0	0
OS process allocation	39,232	0.24	0.00	0	0
OS process: request allocation	31,800	0.36	0.00	0	0
PL/SQL warning settings	16,146	0.00		0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	16,292	0.00		0	0
SGA IO buffer pool latch	2	0.00		0	2	0.00
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	1	0.00		0	1,187	0.00
SQL memory manager workarea list latch	81,598	0.00		0	0
Shared B-Tree	134	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	1,779	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	3,352	0.00		0	0
active service list	102,957	2.20	0.00	0	2,100	0.00
archive control	60	0.00		0	0
archive process latch	288	0.00		0	0
begin backup scn array	2	0.00		0	0
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	159	0.00		0	0
cache buffers chains	90,208,052	0.48	0.00	0	1,612,621	0.00
cache buffers lru chain	14,924	0.01	0.00	0	1,630,243	0.00
cache table scan latch	10,002	0.00		0	10,002	0.00
call allocation	60,549	13.72	0.80	2	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	31,801	0.08	0.00	0	0
channel operations parent latch	64,583	0.50	0.00	0	0
checkpoint queue latch	420,727	0.00		0	4,363	0.00
client/application info	107,591	0.00	0.00	0	0
compile environment latch	15,881	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	60	0.00		0	0
cvmap freelist lock	1	0.00		0	0
dbkea msgq latch	345	0.00		0	0
deferred cleanup latch	60	0.00		0	0
dml lock allocation	60	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	31,819	0.41	0.00	0	0
enqueue freelist latch	1	0.00		0	93,657	0.00
enqueue hash chains	296,138	0.56	0.00	0	0
enqueues	4	0.00		0	0
fifth spare latch	1	0.00		0	0
file cache latch	184	0.00		0	0
flashback copy	1	0.00		0	0
fourth Audit Vault latch	1	0.00		0	0
gc element	1	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs partitioned table hash	1	0.00		0	0
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs resource freelist	1	0.00		0	0
gcs resource hash	1	0.00		0	0
gcs resource scan list	1	0.00		0	0
gcs shadows freelist	1	0.00		0	0
ges domain table	1	0.00		0	0
ges enqueue table freelist	1	0.00		0	0
ges group table	1	0.00		0	0
ges process hash list	1	0.00		0	0
ges process parent latch	1	0.00		0	0
ges resource hash list	1	0.00		0	0
ges resource scan list	1	0.00		0	0
ges resource table freelist	1	0.00		0	0
ges value block free list	1	0.00		0	0
global KZLD latch for mem in SGA	15,805	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	234	0.00		0	136,958	0.00
hash table modification latch	105	0.00		0	0
heartbeat check	1	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	11	0.00		0	10	0.00
job_queue_processes free list latch	28	3.57	1.00	0	0
job_queue_processes parameter latch	793	0.00		0	0
k2q lock allocation	1	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kgnfs mount latch	1	0.00		0	0
kokc descriptor allocation latch	4	0.00		0	0
ksfv messages	1	0.00		0	0
ksim group membership cache	1	0.00		0	0
kss move lock	103	0.00		0	0
ksuosstats global area	363	0.00		0	0
ksv allocation latch	264	0.00		0	0
ksv class latch	205	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	31,800	0.66	0.00	0	0
ktm global data	59	0.00		0	0
kwqbsn:qsga	130	0.00		0	0
lgwr LWN SCN	27,569	0.00		0	0
list of block allocation	31,731	0.05	0.00	0	0
loader state object freelist	324	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	13	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	2	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	18	0.00		0	17	0.00
managed standby latch	96	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	1	0.00		0	0
messages	137,967	0.07	0.00	0	0
mostly latch-free SCN	27,620	0.00	0.00	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	20,662	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	60	0.00		0	0
object queue header heap	14,761	0.00		0	373	0.00
object queue header operation	882,709	0.00	0.00	0	0
object stats modification	22	0.00		0	0
parallel query alloc buffer	477	0.00		0	0
parallel query stats	1	0.00		0	0
parameter list	1,297	0.00		0	0
parameter table management	63,514	0.12	0.05	0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	51,275	0.33	0.00	0	47,828	0.29
process allocation	31,866	4.10	1.00	10	15,780	0.58
process group creation	31,800	0.72	0.00	0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	777	0.00		0	0
query server freelists	1	0.00		0	0
queued dump request	12	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	104,883	0.06	0.00	0	81,445	0.17
redo copy	1	0.00		0	81,509	0.70
redo writing	88,583	0.00		0	0
resmgr group change latch	15,852	0.00		0	0
resmgr:active threads	31,819	0.00		0	0
resmgr:actses change group	15,867	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	31,818	3.88	0.00	0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	81	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	1,610,156	0.63	0.00	0	0
rules engine rule set statistics	100	0.00		0	0
second Audit Vault latch	1	0.00		0	0
second spare latch	1	0.00		0	0
sequence cache	49,058	0.25	0.01	0	0
session allocation	90,021	0.02	0.00	0	58,247	0.09
session idle bit	492,799	0.02	0.00	0	0
session queue latch	1	0.00		0	0
session state list latch	31,768	0.32	0.00	0	0
session switching	15,993	1.51	0.00	0	0
session timer	1,204	0.00		0	0
shared pool	1,111,417	8.02	0.00	0	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	1,093	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	2,791,251	0.00	0.00	0	0
simulator lru latch	2,608	0.00		0	2,740,695	0.35
sort extent pool	100	0.00		0	0
space background state object latch	12	0.00		0	0
space background task latch	4,507	0.13	0.00	0	2,405	0.00
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
tablespace key chain	196	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
third spare latch	1	0.00		0	0
threshold alerts latch	155	0.00		0	0
transaction allocation	32,458	0.06	0.06	0	0
undo global data	154,628	0.06	0.00	0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	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	90,208,052	433,007	456	432,173
shared pool	1,111,417	89,110	283	88,837
row cache objects	1,610,156	10,210	16	10,194
call allocation	60,549	8,307	6,678	3,086
active service list	102,957	2,261	7	2,254
enqueue hash chains	296,138	1,647	4	1,643
process allocation	31,866	1,305	1,303	168
sequence cache	49,058	123	1	122
parameter table management	63,514	78	4	75
DML lock allocation	85,170	22	3	20
transaction allocation	32,458	18	1	17
job_queue_processes free list latch	28	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
DML lock allocation	ktaiam	2	0
DML lock allocation	ktaidm	1	3
active service list	kswslogon: session logout	25	25
cache buffers chains	kcbgtcr: fast path	280	34
cache buffers chains	kcbgcur_2	229	114
cache buffers chains	kcbgtcr: fast path (cr pin)	86	99
cache buffers chains	kcbgtcr_2	47	41
cache buffers chains	kcbrls_2	40	54
cache buffers chains	kcbchg1: clear MS bit	16	218
cache buffers chains	kcbrls: fast release	15	58
cache buffers chains	kcbnlc	3	28
cache buffers chains	kcbzwb	3	15
cache buffers chains	kcbchg1: mod cur pin	1	50
cache buffers chains	kcbrls_1	1	0
call allocation	ksuxds	6,058	6,194
call allocation	ksudlp: top call	592	446
call allocation	ksucrp: top call	18	27
call allocation	ksuinfos_modact	10	11
channel operations parent latch	ksrchdelete_sub()	2	2
enqueue hash chains	ksqcmi: kslgpl	2	0
enqueue hash chains	ksqcmi: get hash chain latch after wait	1	1
enqueue hash chains	ksqcmi: if deadlock detected	1	0
job_queue_processes free list latch	kkjfllat: role cache restore operation	1	1
parameter table management	ksp_param_table_free	6	0
parameter table management	kspcpy	3	0
process allocation	ksucrp:1	920	0
process allocation	ksudlp	228	183
process allocation	ksuapc	153	1,119
process allocation	ksu_reserve	1	0
row cache objects	kqreqd: reget	5	0
row cache objects	kqrpre: find obj	5	14
row cache objects	kqrso	4	1
row cache objects	kqreqd	2	1
sequence cache	kdnssd	1	0
shared pool	kghfre	175	181
shared pool	kghalo	105	78
shared pool	kghupr1	3	24
transaction allocation	ktcxbr	1	1

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kgllkdl1 85	9,482
Library Cache	kglhdgn2 106	9,189
Library Cache	kgllkc1 57	2,033
Library Cache	kglget1 1	2,024
Library Cache	kglhdgn1 62	508
Library Cache	kglpin1 4	320
Library Cache	kglpndl1 95	311
Library Cache	kglpnal1 90	100
Cursor Pin	kkslce [KKSCHLPIN2]	58
Cursor Pin	kksfbc [KKSCHLFSP2]	29
Cursor Pin	kksLockDelete [KKSCHLPIN6]	24
hash table	kkscsSearchChildList [KKSHBKLOC2]	4
Library Cache	kgllldl2 112	3
Cursor Pin	kksfbc [KKSCHLPIN1]	3
Library Cache	kglget2 2	2
Library Cache	kgldtin1 42	1

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 Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 67,908,246
Captured Segments account for 100.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
CIECC02	TS_PAY_DAT	BANK_ORDER_CHECK_LOG	TABLE	37,818,960	55.69
CIECCPAY	TS_PAY_DAT	PAY_DTL	TABLE	21,264,640	31.31
SYS	SYSTEM	I_OBJ2	INDEX	3,019,072	4.45
CIECCPAY	TS_PAY_DAT	MERCHANT_ORDER_NOTIFY_INFO	TABLE	1,616,176	2.38
BUGFIX	TS_PAY_DAT	VC_ACCT_DTL	TABLE	1,343,120	1.98

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 22,625,604
Captured Segments account for 100.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
CIECCPAY	TS_PAY_DAT	PAY_DTL		TABLE	21,179,880	93.61
CIECCPAY	TS_PAY_DAT	MERCHANT_ORDER_NOTIFY_INFO		TABLE	1,616,064	7.14
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_2081770787_1290	TABLE PARTITION	12	0.00
GFTTEST	TS_PAY_DAT	VC_ACCT_DTL_LH_IDX		INDEX	6	0.00
BUGFIX	TS_PAY_DAT	VC_ACCT_DTL		TABLE	3	0.00

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 190,399
Captured Segments account for 100.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
CIECCPAY	TS_PAY_DAT	PAY_DTL		TABLE	178,664	93.84
CIECCPAY	TS_PAY_DAT	MERCHANT_ORDER_NOTIFY_INFO		TABLE	12,672	6.66
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_2081770787_1290	TABLE PARTITION	12	0.01
GFTTEST	TS_PAY_DAT	VC_ACCT_DTL_LH_IDX		INDEX	6	0.00
BUGFIX	TS_PAY_DAT	VC_ACCT_DTL		TABLE	3	0.00

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 190,399
Captured Segments account for 100.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
CIECCPAY	TS_PAY_DAT	PAY_DTL		TABLE	178,664	93.84
CIECCPAY	TS_PAY_DAT	MERCHANT_ORDER_NOTIFY_INFO		TABLE	12,672	6.66
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_2081770787_1290	TABLE PARTITION	12	0.01
GFTTEST	TS_PAY_DAT	VC_ACCT_DTL_LH_IDX		INDEX	6	0.00
BUGFIX	TS_PAY_DAT	VC_ACCT_DTL		TABLE	3	0.00

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 22,204,546
Captured Segments account for 100.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
CIECCPAY	TS_PAY_DAT	PAY_DTL		TABLE	20,759,196	93.49
CIECCPAY	TS_PAY_DAT	MERCHANT_ORDER_NOTIFY_INFO		TABLE	1,616,064	7.28

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 4,484
Captured Segments account for 50.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
SYS	SYSTEM	AUD$	TABLE	780	17.40
CIECC02	TS_PAY_DAT	PAY_DTL	TABLE	589	13.14
CIECC02	TS_PAY_DAT	BANK_ORDER_CHECK_LOG	TABLE	446	9.95
GFTTEST	TS_PAY_DAT	VC_ACCT_DTL_LH_IDX	INDEX	42	0.94
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	29	0.65

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 1,831
Captured Segments account for 53.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
CIECC02	TS_PAY_DAT	PAY_DTL	TABLE	477	26.05
CIECC02	TS_PAY_DAT	BANK_ORDER_CHECK_LOG	TABLE	178	9.72
SYS	SYSTEM	AUD$	TABLE	60	3.28
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	24	1.31
CIECC02	TS_PAY_DAT	CON_TXN_LOG	TABLE	19	1.04

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 9
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_2081770787_1290	TABLE PARTITION	9	100.00

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 243
Captured Segments account for 78.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
CIECCPAY	TS_PAY_DAT	PAY_DTL	TABLE	149	61.32
CIECCPAY	TS_PAY_DAT	MERCHANT_ORDER_NOTIFY_INFO	TABLE	12	4.94
BUGFIX	TS_PAY_DAT	PAY_DTL_ORDER_ID_IDX	INDEX	12	4.94
CIECC02	TS_PAY_DAT	PAY_DTL_PK	INDEX	11	4.53
CIECC02	TS_PAY_DAT	IDX_PAY_DTL2	INDEX	3	1.23

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
SYS	SYSTEM	AUD$	TABLE	255,328	99.41
CIECC02	TS_PAY_DAT	IDX_PAY_DTL2	INDEX	320	0.12
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	304	0.12
CIECC02	TS_PAY_DAT	PAY_DTL	TABLE	128	0.05
SYS	SYSAUX	WRI$_ADV_MESSAGE_GROUPS	TABLE	112	0.04

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

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
SYS	SYSTEM	AUD$	TABLE	6,320	99.95
CIECC02	TS_PAY_DAT	BANK_ORDER_CHECK_LOG	TABLE	2	0.03
SYS	SYSTEM	SCHEDULER$_JOB	TABLE	1	0.02

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_files	195	0.00	0	13
dc_global_oids	25	0.00	0	37
dc_histogram_data	14,002	0.36	0	5,299
dc_histogram_defs	21,146	0.83	0	5,049
dc_object_grants	10	0.00	0	11
dc_objects	25,472	0.21	7	1,818
dc_profiles	15,819	0.00	0	1
dc_rollback_segments	851	0.00	0	22
dc_segments	2,538	1.26	9	1,208
dc_sequences	34	8.82	34	39
dc_tablespaces	24,480	0.00	0	8
dc_users	575,499	0.00	0	138
global database name	18,275	0.00	0	1
outstanding_alerts	36	0.00	0	6
sch_lj_oids	8	25.00	0	10

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
ACCOUNT_STATUS	31,610	0.00	0		0
BODY	185	1.62	1,121	0.36	0
CLUSTER	36	0.00	36	0.00	0
DBLINK	31,612	0.00	0		0
EDITION	15,860	0.00	31,673	0.00	0
SCHEMA	15,829	0.00	0		0
SQL AREA	146,289	0.13	390,575	0.15	75
SQL AREA BUILD	280	70.00	0		0
SQL AREA STATS	244	91.39	244	91.39	0
TABLE/PROCEDURE	19,038	0.12	36,893	0.24	25

Memory Statistics

Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Memory Dynamic Components

Min/Max sizes since instance startup
Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
ordered by Component

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	2,048.00	2,048.00	1,520.00	3,072.00	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	512.00	512.00	512.00	512.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	3,968.00	3,968.00	3,968.00	3,968.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	16.00	16.00	16.00	16.00	STA/
large pool	16.00	16.00	16.00	16.00	STA/
shared pool	1,840.00	1,840.00	800.00	2,368.00	GRO/DEF
streams pool	16.00	16.00	16.00	32.00	SHR/DEF

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

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	764.64		1.22	2.04	27	31	627	627
B	Freeable	86.06	0.00	0.80	0.48	3		107	107
B	SQL	46.87	40.21	0.08	1.27	31	59	607	600
B	PL/SQL	2.11	0.77	0.00	0.01	0	0	624	623
E	Other	719.80		1.27	2.14	27	31	569	569
E	Freeable	75.81	0.00	0.77	0.51	3		99	99
E	SQL	54.90	48.51	0.10	1.71	40	59	543	535
E	PL/SQL	2.02	0.82	0.00	0.01	0	0	559	557

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	2,147,483,648
Fixed Size	2,234,880
Redo Buffers	12,734,464
Variable Size	1,979,713,024

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	16.00	16.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	8.19	8.19	0.00
shared	ASH buffers	32.00	32.00	0.00
shared	KGH: NO ACCESS	212.76	212.76	0.00
shared	KGLH0	247.88	247.85	-0.01
shared	KGLHD	33.46	33.16	-0.88
shared	KKSSP	27.33	24.92	-8.79
shared	SQLA	352.70	351.70	-0.28
shared	db_block_hash_buckets	22.25	22.25	0.00
shared	dbktb: trace buffer	23.44	23.44	0.00
shared	event statistics per sess	28.36	28.36	0.00
shared	free memory	697.55	701.70	0.59
shared	kglsim heap	25.99	25.99	0.00
shared	kglsim object batch	41.19	41.19	0.00
shared	ksunfy : SSO free list	26.43	26.43	0.00
shared	private strands	32.34	32.34	0.00
streams	KGH: NO ACCESS	15.99	15.99	0.00
streams	free memory	15.99	15.99	0.00
	buffer_cache	2,048.00	2,048.00	0.00
	fixed_sga	2.13	2.13	0.00
	log_buffer	12.14	12.14	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

Streams processes ordered by CPU Time, descending

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	0531 13:07:26	0.01	0.00	0.00
QMON Coordinator	0531 13:07:16	0.01	0.00	0.00

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 Capture Rate

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

Streams Apply Rate

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

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Shared Server Statistics

Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections	Avg Active Connections	Avg Total Shared Srvrs	Avg Active Shared Srvrs	Avg Total Dispatchers	Avg Active Dispatchers
0	0	1	0	1	0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec	Disp Queue Per Sec	Server Msgs/Sec	Server KB/Sec	Common Queue Total	Disp Queue Total	Server Total Msgs	Server Total(KB)
0	0	0	0.00	0	0	0	0

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Statistics are combined for all servers
Incoming and Outgoing Net % are included in %Busy

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
3,602	0.00	100.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

Ordered by %Busy, descending
Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Name	Avg Conns	Total Disp Time (s)	%Busy	%Idle	Total Queued	Total Queue Wait (s)	Avg Queue Wait (ms)
D000	0.00	3,602	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/oracle/admin/test/adump
audit_trail	DB
compatible	11.2.0.0.0
control_files	/u01/oradata/test/control01.ctl, /u01/oracle/fast_recovery_area/test/control02.ctl
db_block_size	8192
db_domain
db_name	test
db_recovery_file_dest	/u01/oracle/fast_recovery_area
db_recovery_file_dest_size	21474836480
deferred_segment_creation	FALSE
diagnostic_dest	/u01/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=testXDB)
local_listener
log_archive_dest_1	LOCATION=/u01/archivelog
nls_language	SIMPLIFIED CHINESE
nls_territory	CHINA
open_cursors	300
pga_aggregate_target	524288000
processes	1500
remote_login_passwordfile	EXCLUSIVE
resource_limit	TRUE
sga_target	4160749568
undo_tablespace	UNDOTBS1

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

This section only displays parameters that have more one value
'(NULL)' indicates a missing parameter value
A blank in the End Snapshot indicates the same value as the BeginSnapshot

Parameter Name	Begin value	End value (if different)
control_files	/u01/oracle/fast_recovery_area/test/control02.ctl
control_files	/u01/oradata/test/control01.ctl

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	99.08	In-memory Sort %:	100.00
Library Hit %:	99.80	Soft Parse %:	99.81
Execute to Parse %:	27.22	Latch Hit %:	99.45
Parse CPU to Parse Elapsd %:	85.65	% Non-Parse CPU:	97.75