WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

C1DB0318 3371234238 c1db0318 1 10.2.0.5.0 NO c1db0318

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
C1DB0318	3371234238	c1db0318	1	10.2.0.5.0	NO	c1db0318

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 5008 18-Aug-14 07:00:33 2163 26.8

End Snap: 5009 18-Aug-14 08:00:35 2165 27.0

Elapsed: 60.02 (mins)

DB Time: 23.71 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	5008	18-Aug-14 07:00:33	2163	26.8
End Snap:	5009	18-Aug-14 08:00:35	2165	27.0
Elapsed:		60.02 (mins)
DB Time:		23.71 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 20,480M 20,480M Std Block Size: 8K

Shared Pool Size: 3,072M 3,072M Log Buffer: 14,276K

	Begin	End
Buffer Cache:	20,480M	20,480M	Std Block Size:	8K
Shared Pool Size:	3,072M	3,072M	Log Buffer:	14,276K

Load Profile

Per Second Per Transaction

Redo size: 104,944.54 959.71

Logical reads: 85,442.12 781.36

Block changes: 551.46 5.04

Physical reads: 0.02 0.00

Physical writes: 9.25 0.08

User calls: 2,259.07 20.66

Parses: 635.03 5.81

Hard parses: 0.03 0.00

Sorts: 225.82 2.07

Logons: 0.47 0.00

Executes: 1,437.39 13.14

Transactions: 109.35

	Per Second	Per Transaction
Redo size:	104,944.54	959.71
Logical reads:	85,442.12	781.36
Block changes:	551.46	5.04
Physical reads:	0.02	0.00
Physical writes:	9.25	0.08
User calls:	2,259.07	20.66
Parses:	635.03	5.81
Hard parses:	0.03	0.00
Sorts:	225.82	2.07
Logons:	0.47	0.00
Executes:	1,437.39	13.14
Transactions:	109.35

% Blocks changed per Read: 0.65 Recursive Call %: 49.04

Rollback per transaction %: 0.21 Rows per Sort: 0.41

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 100.05 Soft Parse %: 100.00

Execute to Parse %: 55.82 Latch Hit %: 99.15

Parse CPU to Parse Elapsd %: 25.19 % Non-Parse CPU: 99.46

Shared Pool Statistics

Begin End

Memory Usage %: 33.67 33.39

% SQL with executions>1: 96.42 93.01

% Memory for SQL w/exec>1: 97.19 96.60

	Begin	End
Memory Usage %:	33.67	33.39
% SQL with executions>1:	96.42	93.01
% Memory for SQL w/exec>1:	97.19	96.60

Top 5 Timed Events

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

CPU time 1,402 98.6

log file sync 55,600 49 1 3.5 Commit

latch: cache buffers chains 44,305 31 1 2.2 Concurrency

os thread startup 474 8 18 .6 Concurrency

buffer busy waits 6,950 5 1 .4 Concurrency

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		1,402		98.6
log file sync	55,600	49	1	3.5	Commit
latch: cache buffers chains	44,305	31	1	2.2	Concurrency
os thread startup	474	8	18	.6	Concurrency
buffer busy waits	6,950	5	1	.4	Concurrency

Main Report

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

Time Model Statistics

Total time in database user-calls (DB Time): 1422.5s
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	1,402.30	98.58
sql execute elapsed time	973.25	68.42
PL/SQL execution elapsed time	105.87	7.44
parse time elapsed	34.98	2.46
connection management call elapsed time	1.13	0.08
hard parse elapsed time	0.72	0.05
sequence load elapsed time	0.13	0.01
repeated bind elapsed time	0.01	0.00
DB time	1,422.50
background elapsed time	100.29
background cpu time	46.86

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%Total Call Time
CPU time			1,402		98.58
Commit	55,600	0	49	1	3.48
Concurrency	51,973	0	46	1	3.26
Network	8,941,367		6	0	0.43
System I/O	560,179		4	0	0.28
Other	9,823	0	2	0	0.11
Configuration	48		1	17	0.06
Application	44		0	11	0.04
User I/O	180		0	3	0.03

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)
%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
log file sync	55,600	0	49	1	0.14
latch: cache buffers chains	44,305		31	1	0.11
os thread startup	474	0	8	18	0.00
buffer busy waits	6,950		5	1	0.02
SQL*Net message to client	8,848,050		5	0	22.47
log file sequential read	473		2	4	0.00
SQL*Net more data to client	93,106		1	0	0.24
latch: library cache	125		1	10	0.00
log file parallel write	352,659		1	0	0.90
LGWR wait for redo copy	9,299	0	1	0	0.02
log file switch completion	43		1	19	0.00
control file sequential read	204,876		1	0	0.52
db file sequential read	151		0	3	0.00
enq: RO - fast object reuse	35		0	10	0.00
control file parallel write	1,700		0	0	0.00
Log archive I/O	469		0	0	0.00
cursor: pin S	153		0	1	0.00
enq: TX - row lock contention	9		0	17	0.00
CSS initialization	2		0	71	0.00
db file scattered read	5		0	22	0.00
latch: object queue header operation	1		0	100	0.00
latch: shared pool	29		0	3	0.00
rdbms ipc reply	46		0	1	0.00
enq: TX - index contention	5		0	11	0.00
latch free	147		0	0	0.00
wait list latch free	1		0	38	0.00
latch: session allocation	119		0	0	0.00
enq: HW - contention	3		0	6	0.00
jobq slave TJ process wait	1	100	0	10	0.00
latch: row cache objects	46		0	0	0.00
latch: library cache lock	30		0	0	0.00
reliable message	37		0	0	0.00
log file single write	2		0	2	0.00
SQL*Net more data from client	211		0	0	0.00
latch: redo allocation	12		0	0	0.00
latch: library cache pin	9		0	0	0.00
buffer deadlock	3	100	0	0	0.00
latch: redo writing	2		0	0	0.00
direct path read	12		0	0	0.00
direct path write	12		0	0	0.00
latch: enqueue hash chains	2		0	0	0.00
SQL*Net message from client	8,848,336		7,411,748	838	22.47
jobq slave wait	23,834	96	68,445	2872	0.06
Streams AQ: qmn slave idle wait	134		3,528	26328	0.00
Streams AQ: qmn coordinator idle wait	382	34	3,528	9236	0.00
virtual circuit status	120	100	3,519	29325	0.00
Streams AQ: waiting for messages in the queue	720	100	3,516	4883	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100	2,098	2097714	0.00
class slave wait	9		0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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
os thread startup	474	0	8	18	0.00
log file sequential read	473		2	4	0.00
log file parallel write	352,660		1	0	0.90
events in waitclass Other	9,357	0	1	0	0.02
control file parallel write	1,700		0	0	0.00
Log archive I/O	469		0	0	0.00
control file sequential read	3,362		0	0	0.01
latch: cache buffers chains	2		0	41	0.00
buffer busy waits	3		0	2	0.00
log file single write	2		0	2	0.00
latch: redo writing	2		0	0	0.00
direct path read	12		0	0	0.00
direct path write	12		0	0	0.00
rdbms ipc message	356,276	4	49,158	138	0.90
Streams AQ: qmn slave idle wait	134		3,528	26328	0.00
Streams AQ: qmn coordinator idle wait	382	34	3,528	9236	0.00
smon timer	14	79	3,523	251635	0.00
pmon timer	1,392	100	3,516	2526	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100	2,098	2097714	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	159,462
IDLE_TIME	11,357,079
IOWAIT_TIME	60,431
NICE_TIME	0
SYS_TIME	37,476
USER_TIME	115,213
LOAD	1
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	5,735,752,704
VM_OUT_BYTES	3,046,744,064
PHYSICAL_MEMORY_BYTES	67,484,499,968
NUM_CPUS	32
NUM_CPU_SOCKETS	2

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
c1db0318.19pay.com	1,407.40	1,382.60	3	306,587,858
SYS$USERS	14.70	19.40	0	889,949
SYS$BACKGROUND	0.00	0.00	72	159,906
c1db0318XDB	0.00	0.00	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	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
c1db0318.19pay.com	2	50358	38	8937754	6
SYS$USERS	96	1135	0	2629	0
SYS$BACKGROUND	82	480	8	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
Total DB Time (s): 1,422
Captured SQL account for 91.1% of Total

Elapsed Time (s)	CPU Time (s)	Executions	% Total DB Time	SQL Id	SQL Module	SQL Text
410	292	712,986	28.83	9hfkh0vxd9wq0	YB_UnicomCzA93.exe	SELECT HF_SERIALID FROM (SELEC...
75	25	712,820	5.27	0x48fcr1g013d	YB_UnicomCzA93.exe	SELECT 1, dual.ROWID FROM dual...
56	38	54,919	3.93	16a7x72p99w0r	DBP1.exe	BEGIN Sp_JP_A_NotifyBegin_Acc ...
41	18	358,417	2.91	9498cyp8t1vtc	YB_UnicomCzA93.exe	UPDATE JP_PLAT_MONITOR P SET P...
38	31	54,920	2.70	4md7xpk6b0gmc	DBP1.exe	SELECT HF_SERIALID FROM ( SELE...
35	13	803,888	2.44	an17juxmyktyh	YB_UnicomCzA93.exe	SELECT A.CHECK_TIME FROM JP_PL...
28	12	717,134	1.94	7ywqwcnj6knvp	YB_UnicomCzA93.exe	SELECT 'ChPlat'\|\|T.SYS_ID FROM...
26	24	5,377	1.83	cybdczzjrtp4b	DBP1.exe	BEGIN Sp_Jp_A_QueryResultBegin...
24	23	5,377	1.68	59s08wdart7nt	DBP2.exe	SELECT HF_SERIALID FROM ( SELE...
21	19	5,340	1.47	7p5n28hhz5vhv	DBP1.exe	BEGIN Sp_JP_A_NotifyBegin (:v0...
20	9	713,011	1.43	6n63d2d6az1zy	YB_UnicomCzA93.exe	SELECT O.ROBOT_DESC FROM JP_PL...
19	13	18,365	1.36	6ad7p0gdt9arz	UnicomAnyCz7.exe	begin SP_JP_A_GETORDER_ROBOT_7...
19	13	18,361	1.36	4x7vv1n7h1mqf	YB_UnicomCzC55.exe	begin SP_JP_A_GETORDER_ROBOT_5...
19	13	18,369	1.36	30k7bugqjwuz1	UNCz2.exe	begin SP_JP_A_GETORDER_ROBOT_2...
19	19	5,340	1.36	3r4rj9tu073tv	DBP1.exe	SELECT HF_SERIALID FROM ( SELE...
19	13	18,363	1.36	cds67hhxuswda	YB_UnicomCzB6.exe	begin SP_JP_A_GETORDER_ROBOT_6...
19	13	18,365	1.35	8htz4q5y3uapw	YB_UnicomCzA53.exe	begin SP_JP_A_GETORDER_ROBOT_3...
19	13	18,372	1.35	8frp0p6mt0r3n	UNCz4.exe	begin SP_JP_A_GETORDER_ROBOT_4...
19	13	18,370	1.34	7qcj2d6bnrmt6	UnicomCzA51.exe	begin SP_JP_A_GETORDER_ROBOT_1...
19	12	18,372	1.34	dvhu6p4mv7x9z	UNCz0.exe	begin SP_JP_A_GETORDER_ROBOT_0...
19	12	18,363	1.32	d8q6pmqawqx7j	UNCz9.exe	begin SP_JP_A_GETORDER_ROBOT_9...
19	13	18,370	1.32	54t86k4znb976	UNCz8.exe	begin SP_JP_A_GETORDER_ROBOT_8...
15	10	13,691	1.06	ban0rcd215wa8	UnicomCzE14.exe	begin SP_JP_A_GETORDER_ROBOT_1...
15	10	13,687	1.05	0u8h6ryzxbgda	YB_UnicomCzE18.exe	begin SP_JP_A_GETORDER_ROBOT_1...
15	9	13,325	1.04	9471x7x1yz2cf	UnicomCz87.exe	begin SP_JP_A_GETORDER_ROBOT_3...
15	9	13,693	1.03	5bx5wju9y0x30	YB_UnicomCzC63.exe	begin SP_JP_A_GETORDER_ROBOT_1...
15	9	13,324	1.02	936aq4c6csq0k	YB_UnicomCzA89.exe	begin SP_JP_A_GETORDER_ROBOT_3...
14	10	13,683	1.02	9m461hyhzrxh9	UnicomCzB67.exe	begin SP_JP_A_GETORDER_ROBOT_1...
14	9	13,695	1.02	cam40yc5mfzg9	UNCz10.exe	begin SP_JP_A_GETORDER_ROBOT_1...
14	9	13,689	1.01	8bj3xptnqr5m6	UNCz19.exe	begin SP_JP_A_GETORDER_ROBOT_1...
14	9	13,690	1.01	6p4dqjbc7xa3f	YB_UnicomCzB65.exe	begin SP_JP_A_GETORDER_ROBOT_1...
14	10	13,687	1.01	gzyt7swy75gbu	UnicomAnyCz16.exe	begin SP_JP_A_GETORDER_ROBOT_1...
14	10	13,694	1.00	gs9vmjtyxw8r8	UNCz11.exe	begin SP_JP_A_GETORDER_ROBOT_1...

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 is the CPU Time divided into the Total CPU Time times 100
Total CPU Time (s): 1,402
Captured SQL account for 60.2% of Total

CPU Time (s)	Elapsed Time (s)	Executions	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
292	410	712,986	20.85	28.83	9hfkh0vxd9wq0	YB_UnicomCzA93.exe	SELECT HF_SERIALID FROM (SELEC...
38	56	54,919	2.72	3.93	16a7x72p99w0r	DBP1.exe	BEGIN Sp_JP_A_NotifyBegin_Acc ...
31	38	54,920	2.25	2.70	4md7xpk6b0gmc	DBP1.exe	SELECT HF_SERIALID FROM ( SELE...
25	75	712,820	1.80	5.27	0x48fcr1g013d	YB_UnicomCzA93.exe	SELECT 1, dual.ROWID FROM dual...
24	26	5,377	1.73	1.83	cybdczzjrtp4b	DBP1.exe	BEGIN Sp_Jp_A_QueryResultBegin...
23	24	5,377	1.65	1.68	59s08wdart7nt	DBP2.exe	SELECT HF_SERIALID FROM ( SELE...
19	21	5,340	1.36	1.47	7p5n28hhz5vhv	DBP1.exe	BEGIN Sp_JP_A_NotifyBegin (:v0...
19	19	5,340	1.32	1.36	3r4rj9tu073tv	DBP1.exe	SELECT HF_SERIALID FROM ( SELE...
18	41	358,417	1.28	2.91	9498cyp8t1vtc	YB_UnicomCzA93.exe	UPDATE JP_PLAT_MONITOR P SET P...
13	35	803,888	0.94	2.44	an17juxmyktyh	YB_UnicomCzA93.exe	SELECT A.CHECK_TIME FROM JP_PL...

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: 307,710,470
Captured SQL account for 98.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
217,361,626	712,986	304.86	70.64	292.44	410.10	9hfkh0vxd9wq0	YB_UnicomCzA93.exe	SELECT HF_SERIALID FROM (SELEC...
37,462,324	54,919	682.14	12.17	38.18	55.94	16a7x72p99w0r	DBP1.exe	BEGIN Sp_JP_A_NotifyBegin_Acc ...
37,072,604	54,920	675.03	12.05	31.50	38.47	4md7xpk6b0gmc	DBP1.exe	SELECT HF_SERIALID FROM ( SELE...
19,932,790	5,377	3,707.05	6.48	24.27	26.09	cybdczzjrtp4b	DBP1.exe	BEGIN Sp_Jp_A_QueryResultBegin...
19,543,028	5,377	3,634.56	6.35	23.17	23.86	59s08wdart7nt	DBP2.exe	SELECT HF_SERIALID FROM ( SELE...
17,561,605	5,340	3,288.69	5.71	19.10	20.97	7p5n28hhz5vhv	DBP1.exe	BEGIN Sp_JP_A_NotifyBegin (:v0...
17,528,199	5,340	3,282.43	5.70	18.51	19.34	3r4rj9tu073tv	DBP1.exe	SELECT HF_SERIALID FROM ( SELE...
5,798,142	18,370	315.63	1.88	12.65	18.78	54t86k4znb976	UNCz8.exe	begin SP_JP_A_GETORDER_ROBOT_8...
5,797,943	18,372	315.59	1.88	12.49	19.00	dvhu6p4mv7x9z	UNCz0.exe	begin SP_JP_A_GETORDER_ROBOT_0...
5,797,556	18,370	315.60	1.88	12.70	19.09	7qcj2d6bnrmt6	UnicomCzA51.exe	begin SP_JP_A_GETORDER_ROBOT_1...
5,797,377	18,365	315.68	1.88	12.60	19.37	6ad7p0gdt9arz	UnicomAnyCz7.exe	begin SP_JP_A_GETORDER_ROBOT_7...
5,796,649	18,372	315.52	1.88	12.58	19.20	8frp0p6mt0r3n	UNCz4.exe	begin SP_JP_A_GETORDER_ROBOT_4...
5,796,381	18,369	315.55	1.88	12.64	19.35	30k7bugqjwuz1	UNCz2.exe	begin SP_JP_A_GETORDER_ROBOT_2...
5,796,186	18,363	315.64	1.88	12.70	19.31	cds67hhxuswda	YB_UnicomCzB6.exe	begin SP_JP_A_GETORDER_ROBOT_6...
5,795,889	18,363	315.63	1.88	12.47	18.82	d8q6pmqawqx7j	UNCz9.exe	begin SP_JP_A_GETORDER_ROBOT_9...
5,795,646	18,365	315.58	1.88	12.50	19.27	8htz4q5y3uapw	YB_UnicomCzA53.exe	begin SP_JP_A_GETORDER_ROBOT_3...
5,795,142	18,361	315.62	1.88	12.58	19.35	4x7vv1n7h1mqf	YB_UnicomCzC55.exe	begin SP_JP_A_GETORDER_ROBOT_5...
4,394,533	13,695	320.89	1.43	9.49	14.45	cam40yc5mfzg9	UNCz10.exe	begin SP_JP_A_GETORDER_ROBOT_1...
4,393,412	13,691	320.90	1.43	9.61	15.08	ban0rcd215wa8	UnicomCzE14.exe	begin SP_JP_A_GETORDER_ROBOT_1...
4,393,161	13,694	320.81	1.43	9.59	14.27	gs9vmjtyxw8r8	UNCz11.exe	begin SP_JP_A_GETORDER_ROBOT_1...
4,392,728	13,693	320.80	1.43	9.46	14.70	5bx5wju9y0x30	YB_UnicomCzC63.exe	begin SP_JP_A_GETORDER_ROBOT_1...
4,392,545	13,690	320.86	1.43	9.43	14.40	6p4dqjbc7xa3f	YB_UnicomCzB65.exe	begin SP_JP_A_GETORDER_ROBOT_1...
4,392,258	13,689	320.86	1.43	9.46	14.43	8bj3xptnqr5m6	UNCz19.exe	begin SP_JP_A_GETORDER_ROBOT_1...
4,391,296	13,687	320.84	1.43	9.52	14.87	0u8h6ryzxbgda	YB_UnicomCzE18.exe	begin SP_JP_A_GETORDER_ROBOT_1...
4,390,894	13,687	320.81	1.43	9.52	14.33	gzyt7swy75gbu	UnicomAnyCz16.exe	begin SP_JP_A_GETORDER_ROBOT_1...
4,390,379	13,685	320.82	1.43	9.50	14.13	g5kctsht98970	YB_UnicomCzC62.exe	begin SP_JP_A_GETORDER_ROBOT_1...
4,388,876	13,683	320.75	1.43	9.52	14.50	9m461hyhzrxh9	UnicomCzB67.exe	begin SP_JP_A_GETORDER_ROBOT_1...
4,242,235	13,338	318.06	1.38	9.24	14.09	fkqy3txc8cuff	UnicomCzF84.exe	begin SP_JP_A_GETORDER_ROBOT_3...
4,241,848	13,338	318.03	1.38	9.17	14.01	68zbvyzuuxya3	YB_UnicomCzA71.exe	begin SP_JP_A_GETORDER_ROBOT_2...
4,241,243	13,335	318.05	1.38	9.34	14.01	8cp7vz040pz3u	YB_UnicomCzC78.exe	begin SP_JP_A_GETORDER_ROBOT_2...
4,240,504	13,332	318.07	1.38	9.10	14.14	9ftj23hn1fxyp	YB_UnicomCzA81.exe	begin SP_JP_A_GETORDER_ROBOT_3...
4,240,417	13,330	318.11	1.38	9.19	13.94	03qhgdrjyufq2	YB_UnicomCzC82.exe	begin SP_JP_A_GETORDER_ROBOT_3...
4,240,351	13,331	318.08	1.38	9.14	13.65	2qn18gy9t4n4x	UnicomCzF85.exe	begin SP_JP_A_GETORDER_ROBOT_3...
4,238,730	13,329	318.01	1.38	9.30	14.22	g331rah8ccdbd	YB_UnicomCzC77.exe	begin SP_JP_A_GETORDER_ROBOT_2...
4,238,391	13,324	318.10	1.38	9.32	14.57	936aq4c6csq0k	YB_UnicomCzA89.exe	begin SP_JP_A_GETORDER_ROBOT_3...
4,237,018	13,325	317.98	1.38	9.19	14.78	9471x7x1yz2cf	UnicomCz87.exe	begin SP_JP_A_GETORDER_ROBOT_3...
4,236,136	13,330	317.79	1.38	9.12	13.84	2u95d4anbf9r0	YB_UnicomCzA86.exe	begin SP_JP_A_GETORDER_ROBOT_3...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 75
Captured SQL account for 0.0% of Total

Physical Reads	Executions	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1	3,632	1.33	3.53	13.73	8xq0b6c9tafr5	UNCardG70.exe	begin PKG_CH_Charge.CH_UpdateO...
0	3,632	0.00	0.36	3.60	023vnk3syux82	UNCardG70.exe	UPDATE CH_FULLNOTE F SET F.CHA...
0	13,330	0.00	9.19	13.94	03qhgdrjyufq2	YB_UnicomCzC82.exe	begin SP_JP_A_GETORDER_ROBOT_3...
0	3,631	0.00	0.05	0.09	0gbjmf63pknqf	UNCardG70.exe	SELECT ERROR_TYPE FROM JP_RETU...
0	13,687	0.00	9.52	14.87	0u8h6ryzxbgda	YB_UnicomCzE18.exe	begin SP_JP_A_GETORDER_ROBOT_1...
0	712,820	0.00	25.29	74.93	0x48fcr1g013d	YB_UnicomCzA93.exe	SELECT 1, dual.ROWID FROM dual...
0	54,919	0.00	38.18	55.94	16a7x72p99w0r	DBP1.exe	BEGIN Sp_JP_A_NotifyBegin_Acc ...
0	170	0.00	0.04	0.21	1b516g8bghvk4	TelecomCardBJ8.exe	begin sp_ch_verycode_log(:V000...
0	13,331	0.00	9.14	13.65	2qn18gy9t4n4x	UnicomCzF85.exe	begin SP_JP_A_GETORDER_ROBOT_3...
0	13,330	0.00	9.12	13.84	2u95d4anbf9r0	YB_UnicomCzA86.exe	begin SP_JP_A_GETORDER_ROBOT_3...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 5,176,593
Captured SQL account for 89.7% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
803,888	804,018	1.00	an17juxmyktyh	YB_UnicomCzA93.exe	SELECT A.CHECK_TIME FROM JP_PL...
717,134	717,181	1.00	7ywqwcnj6knvp	YB_UnicomCzA93.exe	SELECT 'ChPlat'\|\|T.SYS_ID FROM...
713,011	713,040	1.00	6n63d2d6az1zy	YB_UnicomCzA93.exe	SELECT O.ROBOT_DESC FROM JP_PL...
712,986	2,026	0.00	9hfkh0vxd9wq0	YB_UnicomCzA93.exe	SELECT HF_SERIALID FROM (SELEC...
712,820	712,892	1.00	0x48fcr1g013d	YB_UnicomCzA93.exe	SELECT 1, dual.ROWID FROM dual...
358,417	358,415	1.00	9498cyp8t1vtc	YB_UnicomCzA93.exe	UPDATE JP_PLAT_MONITOR P SET P...
54,920	2,019	0.04	4md7xpk6b0gmc	DBP1.exe	SELECT HF_SERIALID FROM ( SELE...
54,919	54,917	1.00	16a7x72p99w0r	DBP1.exe	BEGIN Sp_JP_A_NotifyBegin_Acc ...
18,372	18,372	1.00	8frp0p6mt0r3n	UNCz4.exe	begin SP_JP_A_GETORDER_ROBOT_4...
18,372	18,372	1.00	dvhu6p4mv7x9z	UNCz0.exe	begin SP_JP_A_GETORDER_ROBOT_0...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 2,286,974
Captured SQL account for 73.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
709,429	712,820	31.02	0x48fcr1g013d	YB_UnicomCzA93.exe	SELECT 1, dual.ROWID FROM dual...
54,908	54,919	2.40	16a7x72p99w0r	DBP1.exe	BEGIN Sp_JP_A_NotifyBegin_Acc ...
36,741	18,372	1.61	8frp0p6mt0r3n	UNCz4.exe	begin SP_JP_A_GETORDER_ROBOT_4...
36,741	18,372	1.61	dvhu6p4mv7x9z	UNCz0.exe	begin SP_JP_A_GETORDER_ROBOT_0...
36,740	18,370	1.61	54t86k4znb976	UNCz8.exe	begin SP_JP_A_GETORDER_ROBOT_8...
36,740	18,370	1.61	7qcj2d6bnrmt6	UnicomCzA51.exe	begin SP_JP_A_GETORDER_ROBOT_1...
36,738	18,369	1.61	30k7bugqjwuz1	UNCz2.exe	begin SP_JP_A_GETORDER_ROBOT_2...
36,730	18,365	1.61	8htz4q5y3uapw	YB_UnicomCzA53.exe	begin SP_JP_A_GETORDER_ROBOT_3...
36,728	18,365	1.61	6ad7p0gdt9arz	UnicomAnyCz7.exe	begin SP_JP_A_GETORDER_ROBOT_7...
36,728	18,363	1.61	cds67hhxuswda	YB_UnicomCzB6.exe	begin SP_JP_A_GETORDER_ROBOT_6...
36,725	18,363	1.61	d8q6pmqawqx7j	UNCz9.exe	begin SP_JP_A_GETORDER_ROBOT_9...
36,723	18,361	1.61	4x7vv1n7h1mqf	YB_UnicomCzC55.exe	begin SP_JP_A_GETORDER_ROBOT_5...
27,390	13,695	1.20	cam40yc5mfzg9	UNCz10.exe	begin SP_JP_A_GETORDER_ROBOT_1...
27,386	13,693	1.20	5bx5wju9y0x30	YB_UnicomCzC63.exe	begin SP_JP_A_GETORDER_ROBOT_1...
27,386	13,694	1.20	gs9vmjtyxw8r8	UNCz11.exe	begin SP_JP_A_GETORDER_ROBOT_1...
27,381	13,691	1.20	ban0rcd215wa8	UnicomCzE14.exe	begin SP_JP_A_GETORDER_ROBOT_1...
27,379	13,690	1.20	6p4dqjbc7xa3f	YB_UnicomCzB65.exe	begin SP_JP_A_GETORDER_ROBOT_1...
27,374	13,687	1.20	0u8h6ryzxbgda	YB_UnicomCzE18.exe	begin SP_JP_A_GETORDER_ROBOT_1...
27,374	13,689	1.20	8bj3xptnqr5m6	UNCz19.exe	begin SP_JP_A_GETORDER_ROBOT_1...
27,374	13,687	1.20	gzyt7swy75gbu	UnicomAnyCz16.exe	begin SP_JP_A_GETORDER_ROBOT_1...
27,368	13,685	1.20	g5kctsht98970	YB_UnicomCzC62.exe	begin SP_JP_A_GETORDER_ROBOT_1...
27,366	13,683	1.20	9m461hyhzrxh9	UnicomCzB67.exe	begin SP_JP_A_GETORDER_ROBOT_1...
26,676	13,338	1.17	68zbvyzuuxya3	YB_UnicomCzA71.exe	begin SP_JP_A_GETORDER_ROBOT_2...
26,675	13,338	1.17	fkqy3txc8cuff	UnicomCzF84.exe	begin SP_JP_A_GETORDER_ROBOT_3...
26,669	13,335	1.17	8cp7vz040pz3u	YB_UnicomCzC78.exe	begin SP_JP_A_GETORDER_ROBOT_2...
26,664	13,332	1.17	9ftj23hn1fxyp	YB_UnicomCzA81.exe	begin SP_JP_A_GETORDER_ROBOT_3...
26,662	13,330	1.17	2u95d4anbf9r0	YB_UnicomCzA86.exe	begin SP_JP_A_GETORDER_ROBOT_3...
26,661	13,331	1.17	2qn18gy9t4n4x	UnicomCzF85.exe	begin SP_JP_A_GETORDER_ROBOT_3...
26,660	13,330	1.17	03qhgdrjyufq2	YB_UnicomCzC82.exe	begin SP_JP_A_GETORDER_ROBOT_3...
26,658	13,329	1.17	g331rah8ccdbd	YB_UnicomCzC77.exe	begin SP_JP_A_GETORDER_ROBOT_2...
26,649	13,325	1.17	9471x7x1yz2cf	UnicomCz87.exe	begin SP_JP_A_GETORDER_ROBOT_3...
26,647	13,324	1.17	936aq4c6csq0k	YB_UnicomCzA89.exe	begin SP_JP_A_GETORDER_ROBOT_3...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

023vnk3syux82 UPDATE CH_FULLNOTE F SET F.CHARGE_STATUS = :B8 , F.ERROR_CODE = :B7 , F.CHARGE_SERIALID = :B6 , F.CHARGE_SERIALID_PAY = :B5 , F.FINISH_MONEY = :B4 , F.ERROR_INFO = :B3 , F.HTTP_WRAP = :B2 , F.END_TIME = SYSDATE WHERE F.HF_SERIALID = :B1

03qhgdrjyufq2 begin SP_JP_A_GETORDER_ROBOT_32(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

0gbjmf63pknqf SELECT ERROR_TYPE FROM JP_RETURN_CODE R WHERE ERROR_CODE = :B1

0u8h6ryzxbgda begin SP_JP_A_GETORDER_ROBOT_18(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

0x48fcr1g013d SELECT 1, dual.ROWID FROM dual

16a7x72p99w0r BEGIN Sp_JP_A_NotifyBegin_Acc (:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11); END;

1b516g8bghvk4 begin sp_ch_verycode_log(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008); end;

2qn18gy9t4n4x begin SP_JP_A_GETORDER_ROBOT_35(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

2u95d4anbf9r0 begin SP_JP_A_GETORDER_ROBOT_36(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

30k7bugqjwuz1 begin SP_JP_A_GETORDER_ROBOT_2(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

3r4rj9tu073tv SELECT HF_SERIALID FROM ( SELECT HF_SERIALID FROM JP_FULLNOTE S WHERE CHARGE_STATUS IN (0, 3) AND ( NOTIFY_FLAG = 1 OR (NOTIFY_FLAG = 2 AND END_TIME < :B1 - 3/1440) ) AND( BEGIN_TIME < :B1 -3/24 AND BEGIN_TIME > :B1 -10/24 ) ORDER BY END_TIME + NOTIFY_COUNT/1440 ASC ) WHERE ROWNUM <= 10

4md7xpk6b0gmc SELECT HF_SERIALID FROM ( SELECT HF_SERIALID FROM JP_FULLNOTE S WHERE CHARGE_STATUS IN (0, 3) AND ( NOTIFY_FLAG = 1 OR (NOTIFY_FLAG = 2 AND END_TIME < :B2 - 3/1440) ) AND BEGIN_TIME > :B2 -3/24 AND MOD(TO_NUMBER(SUBSTR(HF_SERIALID, LENGTH(HF_SERIALID), 1)), 10) = :B1 ORDER BY END_TIME + NOTIFY_COUNT/1440 ASC ) WHERE ROWNUM <= 10

4x7vv1n7h1mqf begin SP_JP_A_GETORDER_ROBOT_5(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

54t86k4znb976 begin SP_JP_A_GETORDER_ROBOT_8(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

59s08wdart7nt SELECT HF_SERIALID FROM ( SELECT F.HF_SERIALID FROM JP_FULLNOTE F, CH_FULLNOTE C, JP_AGENTINFO A, JP_AGENTRULE R WHERE F.AGENT_ID = A.AGENT_ID AND F.HF_SERIALID = C.HF_SERIALID AND A.CHANNEL_ID = R.CHANNEL_ID AND F.CHARGE_STATUS = 2 AND C.CHARGE_STATUS = 2 AND (C.BEGIN_TIME < :B1 - 3/24 AND C.BEGIN_TIME > :B1 - 10/24) AND A.QUERY_SUPPORTED <> 1 AND (F.QUERY_STATUS = 0 OR (F.QUERY_STATUS = 1 AND NVL(F.END_TIME, :B1 ) < :B1 - 2/1440) ) AND NVL(F.END_TIME, F.BEGIN_TIME + 15/1440) < :B1 - (R.QUERY_INTERVAL + NVL(F.QUERY_COUNT, 0)*R.QUERY_STEP*R.QUERY_INTERVAL)/86400 AND NVL(C.END_TIME, C.BEGIN_TIME + 15/1440) < :B1 - (R.QUERY_INTERVAL + NVL(F.QUERY_COUNT, 0)*R.QUERY_STEP*R.QUERY_INTERVAL)/86400 ORDER BY F.END_TIME + NVL(QUERY_COUNT, 0)*5/86400 ASC )WHERE ROWNUM<=10

5bx5wju9y0x30 begin SP_JP_A_GETORDER_ROBOT_13(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

68zbvyzuuxya3 begin SP_JP_A_GETORDER_ROBOT_21(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

6ad7p0gdt9arz begin SP_JP_A_GETORDER_ROBOT_7(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

6n63d2d6az1zy SELECT O.ROBOT_DESC FROM JP_PLAT_ROBOTINFO O WHERE O.ROBOT_CODE = :B1

6p4dqjbc7xa3f begin SP_JP_A_GETORDER_ROBOT_15(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

7p5n28hhz5vhv BEGIN Sp_JP_A_NotifyBegin (:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10); END;

7qcj2d6bnrmt6 begin SP_JP_A_GETORDER_ROBOT_1(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

7ywqwcnj6knvp SELECT 'ChPlat'||T.SYS_ID FROM JP_SYSPLAT T WHERE ROWNUM=1

8bj3xptnqr5m6 begin SP_JP_A_GETORDER_ROBOT_19(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

8cp7vz040pz3u begin SP_JP_A_GETORDER_ROBOT_28(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

8frp0p6mt0r3n begin SP_JP_A_GETORDER_ROBOT_4(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

8htz4q5y3uapw begin SP_JP_A_GETORDER_ROBOT_3(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

8xq0b6c9tafr5 begin PKG_CH_Charge.CH_UpdateOrder(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009); end;

936aq4c6csq0k begin SP_JP_A_GETORDER_ROBOT_39(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

9471x7x1yz2cf begin SP_JP_A_GETORDER_ROBOT_37(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

9498cyp8t1vtc UPDATE JP_PLAT_MONITOR P SET P.CHECK_TIME = :B3 , P.CHECK_DETAIL = :B2 , P.CHECK_COUNT = NVL(P.CHECK_COUNT, 0) + 1 WHERE P.CHECK_CODE = :B1

9ftj23hn1fxyp begin SP_JP_A_GETORDER_ROBOT_31(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

9hfkh0vxd9wq0 SELECT HF_SERIALID FROM (SELECT HF_SERIALID FROM CH_FULLNOTE WHERE BEGIN_TIME > :B3 - 15/1440 AND CHANNEL_ID IN (SELECT COLUMN_VALUE FROM TABLE(CAST(FUN_SPLIT_STR_TO_TABLE(:B4 , ', ') AS T_VC))) AND CHARGE_STATUS = 1 AND MOD(MOD_IDX, :B2 ) = :B1 ORDER BY BEGIN_TIME ASC) WHERE ROWNUM <= 20

9m461hyhzrxh9 begin SP_JP_A_GETORDER_ROBOT_17(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

an17juxmyktyh SELECT A.CHECK_TIME FROM JP_PLAT_MONITOR A WHERE A.CHECK_CODE = :B1 AND ROWNUM = 1

ban0rcd215wa8 begin SP_JP_A_GETORDER_ROBOT_14(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

cam40yc5mfzg9 begin SP_JP_A_GETORDER_ROBOT_10(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

cds67hhxuswda begin SP_JP_A_GETORDER_ROBOT_6(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

cybdczzjrtp4b BEGIN Sp_Jp_A_QueryResultBegin (:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11, :v12, :v13, :v14, :v15, :v16, :v17); END;

d8q6pmqawqx7j begin SP_JP_A_GETORDER_ROBOT_9(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

dvhu6p4mv7x9z begin SP_JP_A_GETORDER_ROBOT_0(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

fkqy3txc8cuff begin SP_JP_A_GETORDER_ROBOT_34(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

g331rah8ccdbd begin SP_JP_A_GETORDER_ROBOT_27(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

g5kctsht98970 begin SP_JP_A_GETORDER_ROBOT_12(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

gs9vmjtyxw8r8 begin SP_JP_A_GETORDER_ROBOT_11(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

gzyt7swy75gbu begin SP_JP_A_GETORDER_ROBOT_16(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

SQL Id	SQL Text
023vnk3syux82	UPDATE CH_FULLNOTE F SET F.CHARGE_STATUS = :B8 , F.ERROR_CODE = :B7 , F.CHARGE_SERIALID = :B6 , F.CHARGE_SERIALID_PAY = :B5 , F.FINISH_MONEY = :B4 , F.ERROR_INFO = :B3 , F.HTTP_WRAP = :B2 , F.END_TIME = SYSDATE WHERE F.HF_SERIALID = :B1
03qhgdrjyufq2	begin SP_JP_A_GETORDER_ROBOT_32(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
0gbjmf63pknqf	SELECT ERROR_TYPE FROM JP_RETURN_CODE R WHERE ERROR_CODE = :B1
0u8h6ryzxbgda	begin SP_JP_A_GETORDER_ROBOT_18(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
0x48fcr1g013d	SELECT 1, dual.ROWID FROM dual
16a7x72p99w0r	BEGIN Sp_JP_A_NotifyBegin_Acc (:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11); END;
1b516g8bghvk4	begin sp_ch_verycode_log(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008); end;
2qn18gy9t4n4x	begin SP_JP_A_GETORDER_ROBOT_35(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
2u95d4anbf9r0	begin SP_JP_A_GETORDER_ROBOT_36(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
30k7bugqjwuz1	begin SP_JP_A_GETORDER_ROBOT_2(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
3r4rj9tu073tv	SELECT HF_SERIALID FROM ( SELECT HF_SERIALID FROM JP_FULLNOTE S WHERE CHARGE_STATUS IN (0, 3) AND ( NOTIFY_FLAG = 1 OR (NOTIFY_FLAG = 2 AND END_TIME < :B1 - 3/1440) ) AND( BEGIN_TIME < :B1 -3/24 AND BEGIN_TIME > :B1 -10/24 ) ORDER BY END_TIME + NOTIFY_COUNT/1440 ASC ) WHERE ROWNUM <= 10
4md7xpk6b0gmc	SELECT HF_SERIALID FROM ( SELECT HF_SERIALID FROM JP_FULLNOTE S WHERE CHARGE_STATUS IN (0, 3) AND ( NOTIFY_FLAG = 1 OR (NOTIFY_FLAG = 2 AND END_TIME < :B2 - 3/1440) ) AND BEGIN_TIME > :B2 -3/24 AND MOD(TO_NUMBER(SUBSTR(HF_SERIALID, LENGTH(HF_SERIALID), 1)), 10) = :B1 ORDER BY END_TIME + NOTIFY_COUNT/1440 ASC ) WHERE ROWNUM <= 10
4x7vv1n7h1mqf	begin SP_JP_A_GETORDER_ROBOT_5(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
54t86k4znb976	begin SP_JP_A_GETORDER_ROBOT_8(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
59s08wdart7nt	SELECT HF_SERIALID FROM ( SELECT F.HF_SERIALID FROM JP_FULLNOTE F, CH_FULLNOTE C, JP_AGENTINFO A, JP_AGENTRULE R WHERE F.AGENT_ID = A.AGENT_ID AND F.HF_SERIALID = C.HF_SERIALID AND A.CHANNEL_ID = R.CHANNEL_ID AND F.CHARGE_STATUS = 2 AND C.CHARGE_STATUS = 2 AND (C.BEGIN_TIME < :B1 - 3/24 AND C.BEGIN_TIME > :B1 - 10/24) AND A.QUERY_SUPPORTED <> 1 AND (F.QUERY_STATUS = 0 OR (F.QUERY_STATUS = 1 AND NVL(F.END_TIME, :B1 ) < :B1 - 2/1440) ) AND NVL(F.END_TIME, F.BEGIN_TIME + 15/1440) < :B1 - (R.QUERY_INTERVAL + NVL(F.QUERY_COUNT, 0)R.QUERY_STEPR.QUERY_INTERVAL)/86400 AND NVL(C.END_TIME, C.BEGIN_TIME + 15/1440) < :B1 - (R.QUERY_INTERVAL + NVL(F.QUERY_COUNT, 0)R.QUERY_STEPR.QUERY_INTERVAL)/86400 ORDER BY F.END_TIME + NVL(QUERY_COUNT, 0)*5/86400 ASC )WHERE ROWNUM<=10
5bx5wju9y0x30	begin SP_JP_A_GETORDER_ROBOT_13(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
68zbvyzuuxya3	begin SP_JP_A_GETORDER_ROBOT_21(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
6ad7p0gdt9arz	begin SP_JP_A_GETORDER_ROBOT_7(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
6n63d2d6az1zy	SELECT O.ROBOT_DESC FROM JP_PLAT_ROBOTINFO O WHERE O.ROBOT_CODE = :B1
6p4dqjbc7xa3f	begin SP_JP_A_GETORDER_ROBOT_15(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
7p5n28hhz5vhv	BEGIN Sp_JP_A_NotifyBegin (:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10); END;
7qcj2d6bnrmt6	begin SP_JP_A_GETORDER_ROBOT_1(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
7ywqwcnj6knvp	SELECT 'ChPlat'\|\|T.SYS_ID FROM JP_SYSPLAT T WHERE ROWNUM=1
8bj3xptnqr5m6	begin SP_JP_A_GETORDER_ROBOT_19(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
8cp7vz040pz3u	begin SP_JP_A_GETORDER_ROBOT_28(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
8frp0p6mt0r3n	begin SP_JP_A_GETORDER_ROBOT_4(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
8htz4q5y3uapw	begin SP_JP_A_GETORDER_ROBOT_3(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
8xq0b6c9tafr5	begin PKG_CH_Charge.CH_UpdateOrder(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009); end;
936aq4c6csq0k	begin SP_JP_A_GETORDER_ROBOT_39(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
9471x7x1yz2cf	begin SP_JP_A_GETORDER_ROBOT_37(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
9498cyp8t1vtc	UPDATE JP_PLAT_MONITOR P SET P.CHECK_TIME = :B3 , P.CHECK_DETAIL = :B2 , P.CHECK_COUNT = NVL(P.CHECK_COUNT, 0) + 1 WHERE P.CHECK_CODE = :B1
9ftj23hn1fxyp	begin SP_JP_A_GETORDER_ROBOT_31(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
9hfkh0vxd9wq0	SELECT HF_SERIALID FROM (SELECT HF_SERIALID FROM CH_FULLNOTE WHERE BEGIN_TIME > :B3 - 15/1440 AND CHANNEL_ID IN (SELECT COLUMN_VALUE FROM TABLE(CAST(FUN_SPLIT_STR_TO_TABLE(:B4 , ', ') AS T_VC))) AND CHARGE_STATUS = 1 AND MOD(MOD_IDX, :B2 ) = :B1 ORDER BY BEGIN_TIME ASC) WHERE ROWNUM <= 20
9m461hyhzrxh9	begin SP_JP_A_GETORDER_ROBOT_17(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
an17juxmyktyh	SELECT A.CHECK_TIME FROM JP_PLAT_MONITOR A WHERE A.CHECK_CODE = :B1 AND ROWNUM = 1
ban0rcd215wa8	begin SP_JP_A_GETORDER_ROBOT_14(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
cam40yc5mfzg9	begin SP_JP_A_GETORDER_ROBOT_10(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
cds67hhxuswda	begin SP_JP_A_GETORDER_ROBOT_6(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
cybdczzjrtp4b	BEGIN Sp_Jp_A_QueryResultBegin (:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11, :v12, :v13, :v14, :v15, :v16, :v17); END;
d8q6pmqawqx7j	begin SP_JP_A_GETORDER_ROBOT_9(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
dvhu6p4mv7x9z	begin SP_JP_A_GETORDER_ROBOT_0(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
fkqy3txc8cuff	begin SP_JP_A_GETORDER_ROBOT_34(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
g331rah8ccdbd	begin SP_JP_A_GETORDER_ROBOT_27(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
g5kctsht98970	begin SP_JP_A_GETORDER_ROBOT_12(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
gs9vmjtyxw8r8	begin SP_JP_A_GETORDER_ROBOT_11(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;
gzyt7swy75gbu	begin SP_JP_A_GETORDER_ROBOT_16(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008, :V00009, :V00010, :V00011, :V00012, :V00013, :V00014, :V00015, :V00016, :V00017, :V00018, :V00019, :V00020, :V00021); end;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	68,401	18.99	0.17
CPU used when call started	67,820	18.83	0.17
CR blocks created	11,948	3.32	0.03
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	7,539,990	2,093.63	19.15
DBWR checkpoint buffers written	33,270	9.24	0.08
DBWR checkpoints	38	0.01	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 transaction table writes	427	0.12	0.00
DBWR undo block writes	20,739	5.76	0.05
RowCR - row contention	0	0.00	0.00
RowCR attempts	23	0.01	0.00
RowCR hits	23	0.01	0.00
SMON posted for undo segment shrink	3	0.00	0.00
SQL*Net roundtrips to/from client	8,848,730	2,457.03	22.47
active txn count during cleanout	4,507	1.25	0.01
application wait time	50	0.01	0.00
background checkpoints completed	1	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	15,187	4.22	0.04
branch node splits	0	0.00	0.00
buffer is not pinned count	296,310,469	82,276.67	752.42
buffer is pinned count	309,941,933	86,061.73	787.03
bytes received via SQL*Net from client	1,132,887,501	314,569.43	2,876.72
bytes sent via SQL*Net to client	783,974,673	217,686.63	1,990.73
calls to get snapshot scn: kcmgss	7,834,799	2,175.49	19.89
calls to kcmgas	431,792	119.90	1.10
calls to kcmgcs	1,971	0.55	0.01
change write time	1,504	0.42	0.00
cleanout - number of ktugct calls	12,283	3.41	0.03
cleanouts and rollbacks - consistent read gets	5,521	1.53	0.01
cleanouts only - consistent read gets	5,115	1.42	0.01
cluster key scan block gets	22,835	6.34	0.06
cluster key scans	18,010	5.00	0.05
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	4,501	1.25	0.01
commit batch/immediate requested	4,501	1.25	0.01
commit cleanout failures: block lost	12	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	374	0.10	0.00
commit cleanout failures: cannot pin	7,410	2.06	0.02
commit cleanouts	469,732	130.43	1.19
commit cleanouts successfully completed	461,936	128.27	1.17
commit immediate performed	4,501	1.25	0.01
commit immediate requested	4,501	1.25	0.01
commit txn count during cleanout	17,472	4.85	0.04
concurrency wait time	4,633	1.29	0.01
consistent changes	14,234	3.95	0.04
consistent gets	306,069,770	84,986.54	777.20
consistent gets - examination	5,290,924	1,469.13	13.44
consistent gets direct	0	0.00	0.00
consistent gets from cache	306,069,770	84,986.54	777.20
cursor authentications	11	0.00	0.00
data blocks consistent reads - undo records applied	12,544	3.48	0.03
db block changes	1,986,034	551.46	5.04
db block gets	1,640,700	455.57	4.17
db block gets direct	0	0.00	0.00
db block gets from cache	1,640,700	455.57	4.17
deferred (CURRENT) block cleanout applications	38,975	10.82	0.10
dirty buffers inspected	0	0.00	0.00
enqueue conversions	5,406	1.50	0.01
enqueue releases	862,343	239.45	2.19
enqueue requests	862,343	239.45	2.19
enqueue timeouts	0	0.00	0.00
enqueue waits	50	0.01	0.00
exchange deadlocks	3	0.00	0.00
execute count	5,176,593	1,437.39	13.14
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	87	0.02	0.00
free buffer requested	16,006	4.44	0.04
heap block compress	4,212	1.17	0.01
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	10,636	2.95	0.03
immediate (CURRENT) block cleanout applications	13,569	3.77	0.03
index crx upgrade (found)	583	0.16	0.00
index crx upgrade (positioned)	104,909	29.13	0.27
index fast full scans (full)	0	0.00	0.00
index fetch by key	856,985	237.96	2.18
index scans kdiixs1	2,187,716	607.46	5.56
leaf node 90-10 splits	52	0.01	0.00
leaf node splits	216	0.06	0.00
lob reads	1,263	0.35	0.00
lob writes	142	0.04	0.00
lob writes unaligned	142	0.04	0.00
logons cumulative	1,694	0.47	0.00
messages received	366,796	101.85	0.93
messages sent	366,796	101.85	0.93
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	297,585,302	82,630.66	755.65
opened cursors cumulative	1,469,644	408.08	3.73
parse count (failures)	0	0.00	0.00
parse count (hard)	93	0.03	0.00
parse count (total)	2,286,974	635.03	5.81
parse time cpu	758	0.21	0.00
parse time elapsed	3,009	0.84	0.01
physical read IO requests	60	0.02	0.00
physical read bytes	614,400	170.60	1.56
physical read total IO requests	205,573	57.08	0.52
physical read total bytes	3,850,882,560	1,069,276.44	9,778.48
physical read total multi block requests	474	0.13	0.00
physical reads	75	0.02	0.00
physical reads cache	63	0.02	0.00
physical reads cache prefetch	15	0.00	0.00
physical reads direct	12	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	15	0.00	0.00
physical write IO requests	12,317	3.42	0.03
physical write bytes	272,949,248	75,789.95	693.10
physical write total IO requests	372,876	103.54	0.95
physical write total bytes	1,262,665,216	350,604.87	3,206.26
physical write total multi block requests	341,645	94.86	0.87
physical writes	33,319	9.25	0.08
physical writes direct	12	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	33,307	9.25	0.08
physical writes non checkpoint	1,850	0.51	0.00
pinned buffers inspected	0	0.00	0.00
pinned cursors current	4	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
process last non-idle time	12,370	3.43	0.03
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	7,827,805	2,173.55	19.88
recursive cpu usage	47,331	13.14	0.12
redo blocks written	918,138	254.94	2.33
redo buffer allocation retries	35	0.01	0.00
redo entries	1,018,872	282.91	2.59
redo log space requests	46	0.01	0.00
redo log space wait time	74	0.02	0.00
redo ordering marks	18,925	5.25	0.05
redo size	377,946,316	104,944.54	959.71
redo subscn max counts	24,629	6.84	0.06
redo synch time	5,220	1.45	0.01
redo synch writes	379,057	105.25	0.96
redo wastage	77,108,200	21,410.67	195.80
redo write time	4,710	1.31	0.01
redo writer latching time	99	0.03	0.00
redo writes	352,675	97.93	0.90
rollback changes - undo records applied	8,151	2.26	0.02
rollbacks only - consistent read gets	3,898	1.08	0.01
rows fetched via callback	789,971	219.35	2.01
session connect time	0	0.00	0.00
session cursor cache hits	2,274,125	631.46	5.77
session logical reads	307,710,470	85,442.12	781.36
shared hash latch upgrades - no wait	105,598	29.32	0.27
shared hash latch upgrades - wait	588	0.16	0.00
sorts (memory)	813,255	225.82	2.07
sorts (rows)	329,860	91.59	0.84
sql area evicted	161	0.04	0.00
sql area purged	18	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	2,234	0.62	0.01
table fetch by rowid	292,363,746	81,180.78	742.39
table fetch continued row	21,161,734	5,875.99	53.74
table scan blocks gotten	1,609,835	447.00	4.09
table scan rows gotten	6,497,984	1,804.30	16.50
table scans (direct read)	0	0.00	0.00
table scans (long tables)	18	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	1,534,202	426.00	3.90
total number of times SMON posted	3	0.00	0.00
transaction rollbacks	4,501	1.25	0.01
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	143,934,996	39,966.50	365.49
user I/O wait time	50	0.01	0.00
user calls	8,135,810	2,259.07	20.66
user commits	392,992	109.12	1.00
user rollbacks	820	0.23	0.00
workarea executions - optimal	14,057	3.90	0.04
write clones created in background	1	0.00	0.00
write clones created in foreground	1	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 pga memory max	2.8E+11	2.8E+11
session cursor cache count	6,419,091	6,437,242
session uga memory	1.4E+15	1.4E+15
opened cursors current	57,945	58,479
logons current	2,163	2,165
session uga memory max	1.7E+11	1.7E+11
session pga memory	2.2E+11	2.2E+11

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

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
DATA4	2	0.00	1.00	6,561	2	1,970	0.67
DATA14	2	0.00	1.00	2,087	1	122	0.25
UNDOTBS1	2	0.00	1.00	1,764	0	338	1.42
SYSAUX	47	9.79	1.30	823	0	0	0.00
DATA13	4	7.50	1.25	727	0	3,920	0.79
SYSTEM	1	0.00	1.00	341	0	598	0.13
OGGDATA	1	0.00	1.00	11	0	0	0.00
USERS	1	0.00	1.00	1	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
DATA13	/home/app/oracle/oradata/C1DB0318/datafile/o1_mf_data13_9fsjtvng_.dbf	3	10.00	1.33	679	0	3,920	0.79
DATA13	/home/app/oracle/oradata/C1DB0318/datafile/o1_mf_data13_9qbso1s8_.dbf	1	0.00	1.00	48	0	0	0.00
DATA14	/home/app/oracle/oradata/C1DB0318/datafile/o1_mf_data14_9fsjv6k7_.dbf	1	0.00	1.00	2,042	1	122	0.25
DATA14	/home/app/oracle/oradata/C1DB0318/datafile/o1_mf_data14_9qbspzjl_.dbf	1	0.00	1.00	45	0	0	0.00
DATA4	/home/app/oracle/oradata/C1DB0318/datafile/o1_mf_data4_9fsjtkhw_.dbf	1	0.00	1.00	6,157	2	706	0.30
DATA4	/home/app/oracle/oradata/C1DB0318/datafile/o1_mf_data4_9qbsn4hm_.dbf	1	0.00	1.00	404	0	1,264	0.88
OGGDATA	/home/app/oracle/oradata/C1DB0318/datafile/o1_mf_oggdata_9g1k0fly_.dbf	1	0.00	1.00	11	0	0	0.00
SYSAUX	/home/app/oracle/oradata/C1DB0318/datafile/o1_mf_sysaux_9fsb9c8m_.dbf	47	9.79	1.30	823	0	0	0.00
SYSTEM	/home/app/oracle/oradata/C1DB0318/datafile/o1_mf_system_9fsb9c8l_.dbf	1	0.00	1.00	341	0	598	0.13
UNDOTBS1	/home/app/oracle/oradata/C1DB0318/datafile/o1_mf_undotbs1_9fsb9c98_.dbf	1	0.00	1.00	1,418	0	301	1.33
UNDOTBS1	/home/app/oracle/oradata/C1DB0318/datafile/o1_mf_undotbs1_9rtt0zrk_.dbf	1	0.00	1.00	346	0	37	2.16
USERS	/home/app/oracle/oradata/C1DB0318/datafile/o1_mf_users_9fsb9c99_.dbf	1	0.00	1.00	1	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	2,493,540	100	307,434,043	63	33,346	0	0	6,949

Advisory Statistics

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

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	8	2205	71549	417095	3686400	417095
E	0	8	2684	77477	448971	3686400	448971

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	2,016	0.10	249,354	1.44	7,667,378
D	4,032	0.20	498,708	1.40	7,444,584
D	6,048	0.30	748,062	1.10	5,856,466
D	8,064	0.40	997,416	1.00	5,325,494
D	10,080	0.50	1,246,770	1.00	5,314,187
D	12,096	0.60	1,496,124	1.00	5,313,458
D	14,112	0.70	1,745,478	1.00	5,313,400
D	16,128	0.80	1,994,832	1.00	5,313,400
D	18,144	0.90	2,244,186	1.00	5,313,400
D	20,160	1.00	2,493,540	1.00	5,313,400
D	22,176	1.10	2,742,894	1.00	5,313,400
D	24,192	1.20	2,992,248	1.00	5,313,400
D	26,208	1.30	3,241,602	1.00	5,313,400
D	28,224	1.40	3,490,956	1.00	5,313,400
D	30,240	1.50	3,740,310	1.00	5,313,400
D	32,256	1.60	3,989,664	1.00	5,313,400
D	34,272	1.70	4,239,018	1.00	5,313,400
D	36,288	1.80	4,488,372	1.00	5,313,400
D	38,304	1.90	4,737,726	1.00	5,313,400
D	40,320	2.00	4,987,080	1.00	5,313,396

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	231	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	6,144	3,471	4,368.16	0.00	0.00	0.00	0.00	629,140
E	6,144	3,463	4,388.89	0.00	0.00	0.00	0.00	629,140

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	13,754	13,754
64K	128K	59	59
128K	256K	8	8
512K	1024K	197	197
1M	2M	30	30

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
768	0.13	121,630.98	1,189.64	99.00	474
1,536	0.25	121,630.98	1,189.64	99.00	472
3,072	0.50	121,630.98	20.04	100.00	8
4,608	0.75	121,630.98	0.00	100.00	0
6,144	1.00	121,630.98	0.00	100.00	0
7,373	1.20	121,630.98	0.00	100.00	0
8,602	1.40	121,630.98	0.00	100.00	0
9,830	1.60	121,630.98	0.00	100.00	0
11,059	1.80	121,630.98	0.00	100.00	0
12,288	2.00	121,630.98	0.00	100.00	0
18,432	3.00	121,630.98	0.00	100.00	0
24,576	4.00	121,630.98	0.00	100.00	0
36,864	6.00	121,630.98	0.00	100.00	0
49,152	8.00	121,630.98	0.00	100.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
1,168	0.38	306	15,130	8,019,205	1.00	12,104	1.00	2,095,806
1,488	0.48	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
1,808	0.59	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
2,128	0.69	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
2,448	0.79	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
2,768	0.90	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
3,088	1.00	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
3,408	1.10	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
3,728	1.21	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
4,048	1.31	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
4,368	1.41	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
4,688	1.52	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
5,008	1.62	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
5,328	1.73	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
5,648	1.83	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
5,968	1.93	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806
6,288	2.04	327	16,223	8,019,209	1.00	12,100	1.00	2,095,806

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

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)
32	0.10	0	0	0	0
64	0.20	0	0	0	0
96	0.30	0	0	0	0
128	0.40	0	0	0	0
160	0.50	0	0	0	0
192	0.60	0	0	0	0
224	0.70	0	0	0	0
256	0.80	0	0	0	0
288	0.90	0	0	0	0
320	1.00	0	0	0	0
352	1.10	0	0	0	0
384	1.20	0	0	0	0
416	1.30	0	0	0	0
448	1.40	0	0	0	0
480	1.50	0	0	0	0
512	1.60	0	0	0	0
544	1.70	0	0	0	0
576	1.80	0	0	0	0
608	1.90	0	0	0	0
640	2.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,610	5	1
undo block	210	0	2
undo header	128	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	Waits	Av Wt Time(ms)
RO-Multiple Object Reuse (fast object reuse)	333	333	35	9.14
TX-Transaction (row lock contention)	9	9	8	18.75
TX-Transaction (index contention)	6	6	5	10.00
HW-Segment High Water Mark	7,632	7,632	2	10.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,558	0.00		0	0
ASM network background latch	2	0.00		0	0
AWR Alerted Metric Element list	146,938	0.00		0	0
Consistent RBA	352,696	0.00	0.36	0	0
FAL request queue	74	0.00		0	0
FAL subheap alocation	74	0.00		0	0
FIB s.o chain latch	6	0.00		0	0
FOB s.o list latch	282	0.00		0	0
JS mem alloc latch	4	0.00		0	0
JS queue access latch	4	0.00		0	0
JS queue state obj latch	25,990	0.00		0	0
JS slv state obj latch	19,407	2.38	0.09	0	0
KMG MMAN ready and startup request latch	1,200	0.00		0	0
KTF sga latch	7	0.00		0	1,208	0.00
KWQMN job cache list latch	1	0.00		0	0
KWQP Prop Status	2	0.00		0	0
Memory Management Latch	0			0	1,200	0.00
OS process	5,118	0.00		0	0
OS process allocation	4,615	0.28	0.00	0	0
OS process: request allocation	1,522	0.46	0.00	0	0
PL/SQL warning settings	1,537,638	0.00		0	0
SQL memory manager latch	1	0.00		0	1,200	0.00
SQL memory manager workarea list latch	1,539,885	0.02	0.00	0	0
Shared B-Tree	180	0.00		0	0
active checkpoint queue latch	18,119	0.51	0.00	0	0
active service list	16,970	0.28	0.06	0	2,809	0.00
alert log latch	2	0.00		0	0
archive control	126	0.00		0	0
archive process latch	1,350	0.00		0	0
cache buffer handles	2,228	0.00		0	0
cache buffers chains	613,440,987	0.95	0.01	31	14,808	0.63
cache buffers lru chain	76,293	0.01	0.00	0	28,761	0.05
channel handle pool latch	1,524	0.20	0.00	0	0
channel operations parent latch	20,944	0.03	0.00	0	0
checkpoint queue latch	581,552	0.00	0.00	0	33,776	0.00
client/application info	9,315	0.00		0	0
commit callback allocation	96	0.00		0	0
compile environment latch	1,694	0.00		0	0
dictionary lookup	90	0.00		0	0
dml lock allocation	818,378	0.69	0.00	0	0
dummy allocation	3,386	0.77	0.00	0	0
enqueue hash chains	1,730,109	0.10	0.00	0	0
enqueues	2,477,656	0.37	0.00	0	0
event group latch	762	0.00		0	0
file cache latch	467	0.00		0	0
global KZLD latch for mem in SGA	289	0.00		0	0
global tx hash mapping	14,234	0.00		0	0
hash table column usage latch	48	0.00		0	1,459	0.00
hash table modification latch	113	0.00		0	0
job workq parent latch	4	100.00	0.00	0	1,309	16.73
job_queue_processes parameter latch	248	0.00		0	0
kks stats	743	0.00		0	0
kokc descriptor allocation latch	12	0.00		0	0
ksuosstats global area	242	0.00		0	0
ktm global data	20	0.00		0	0
kwqbsn:qsga	179	0.00		0	0
lgwr LWN SCN	353,575	0.05	0.00	0	0
library cache	12,715,568	0.50	0.00	1	183	0.00
library cache load lock	406	0.00		0	0
library cache lock	16,661,624	0.23	0.00	0	0
library cache lock allocation	7,231	0.00		0	0
library cache pin	6,782,422	0.24	0.00	0	0
library cache pin allocation	82	0.00		0	0
list of block allocation	2,488	0.76	0.00	0	0
loader state object freelist	50	0.00		0	0
logminer context allocation	1	0.00		0	0
message pool operations parent latch	111	0.00		0	0
messages	1,145,433	0.18	0.00	0	0
mostly latch-free SCN	358,364	0.83	0.01	0	0
multiblock read objects	10	0.00		0	0
ncodef allocation latch	66	0.00		0	0
object queue header heap	71,506	0.00		0	507	0.00
object queue header operation	185,009	0.00	0.17	0	0
object stats modification	42	0.00		0	0
parallel query alloc buffer	452	0.00		0	0
parameter list	2,541	0.00		0	0
parameter table management	3,768	0.00		0	0
post/wait queue	66,967	0.17	0.00	0	56,050	0.27
process allocation	1,522	0.13	1.00	0	762	0.00
process group creation	1,522	0.66	0.00	0	0
qmn task queue latch	779	11.81	0.38	0	0
redo allocation	1,070,749	0.23	0.00	0	1,014,430	1.12
redo copy	0			0	1,018,937	0.97
redo writing	1,084,029	0.01	0.03	0	0
resmgr group change latch	1,813	0.00		0	0
resmgr:active threads	3,369	0.00		0	0
resmgr:actses change group	1,221	0.00		0	0
resmgr:free threads list	3,368	2.40	0.00	0	0
resmgr:resource group CPU method	1,219	0.16	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	4,874,099	1.27	0.00	0	0
rules engine rule set statistics	100	0.00		0	0
sequence cache	6,520	1.52	0.00	0	0
session allocation	4,748,413	0.90	0.00	0	0
session idle bit	18,638,900	0.02	0.01	0	0
session state list latch	3,212	1.28	0.00	0	0
session switching	3,866	0.16	0.00	0	0
session timer	1,392	0.00		0	0
shared pool	152,532	0.48	0.04	0	0
shared pool sim alloc	5	0.00		0	0
shared pool simulator	849	0.00		0	0
simulator hash latch	17,535,300	0.00	0.00	0	0
simulator lru latch	33,344	0.01	0.00	0	17,501,859	0.49
slave class	9	0.00		0	0
slave class create	36	2.78	1.00	0	0
sort extent pool	176	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	240	0.00		0	0
transaction allocation	886,054	0.00	0.00	0	0
transaction branch allocation	14,579	0.00		0	0
undo global data	1,297,315	0.02	0.00	0	0
user lock	3,016	2.88	0.07	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	613,440,987	5,807,856	44,307	5,766,744
library cache	12,715,568	64,047	125	63,938
row cache objects	4,874,099	61,996	46	61,954
session allocation	4,748,413	42,965	119	42,852
library cache lock	16,661,624	38,297	30	38,268
library cache pin	6,782,422	16,515	9	16,507
enqueues	2,477,656	9,211	26	9,185
dml lock allocation	818,378	5,628	8	5,620
session idle bit	18,638,900	3,691	33	3,662
mostly latch-free SCN	358,364	2,985	25	2,961
redo allocation	1,070,749	2,506	12	2,494
enqueue hash chains	1,730,109	1,660	2	1,658
shared pool	152,532	736	29	723
JS slv state obj latch	19,407	461	42	20
SQL memory manager workarea list latch	1,539,885	250	1	249
qmn task queue latch	779	92	35	57
user lock	3,016	87	6	81
redo writing	1,084,029	67	2	65
active service list	16,970	47	3	44
Consistent RBA	352,696	14	5	11
object queue header operation	185,009	6	1	5
process allocation	1,522	2	2	0
slave class create	36	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
JS slv state obj latch	jslvStateObjDel:1	2	2
SQL memory manager workarea list latch	qesmmIRegisterWorkArea	1	0
active service list	kswslogon: session logout	19	16
cache buffers chains	kcbgtcr: kslbegin excl	112,330	79,543
cache buffers chains	kcbrls: kslbegin	14,927	47,957
cache buffers chains	kcbchg: kslbegin: bufs not pinned	4,163	2,747
cache buffers chains	kcbgcur: kslbegin	985	412
cache buffers chains	kcbgtcr: fast path	822	17
cache buffers chains	kcbnlc	283	1,209
cache buffers chains	kcbzwb	250	144
cache buffers chains	kcbget: pin buffer	171	5
cache buffers chains	kcbzgb: scan from tail. nowait	17	0
cache buffers chains	kcbchg: kslbegin: call CR func	16	1,744
cache buffers chains	kcbcge	3	243
cache buffers chains	kcbbxsv	2	1
channel operations parent latch	ksrchdelete()	1	1
cost function	kzulgt: find user res	4	4
cost function	kzulrl	2	2
dml lock allocation	ktaiam	7	4
dml lock allocation	ktaidm	1	4
enqueue hash chains	ksqgtl3	2	1
enqueues	ksqgel: create enqueue	16	16
enqueues	ksqies	9	10
enqueues	ksqdel	1	0
event range base latch	No latch	63	62
lgwr LWN SCN	kcs023	9	0
library cache	kglpnp: child	46	79
library cache	kglpndl: child: after processing	19	2
library cache	kglivl: child	14	0
library cache	kgldte: child 0	11	16
library cache	kglhdiv: child	10	1
library cache	kglpndl: child: before processing	7	19
library cache	kglobpn: child:	5	4
library cache	kglhdgn: child:	3	4
library cache	kglpin	3	0
library cache	kglic	2	0
library cache	kglLockCursor	1	1
library cache	kglScanDependency	1	0
library cache	kgldti: 2child	1	0
library cache	kglini: child	1	0
library cache	kglupd: child	1	0
library cache lock	kgllkal: child: multiinstance	1	2
library cache lock	kgllkdl: child: cleanup	1	1
library cache lock	kgllkdl: child: no lock handle	1	0
library cache pin	kglpndl	5	6
library cache pin	kglpnp: child	4	3
mostly latch-free SCN	kcslcu3	16	25
mostly latch-free SCN	kcsnew_scn_rba	3	0
mostly latch-free SCN	kcs01	2	5
object queue header operation	kcbo_switch_cq	1	2
object queue header operation	kcbo_write_q	1	0
object queue header operation	kcbw_unlink_q	1	0
process allocation	ksucrp	2	0
redo allocation	kcrfw_redo_gen: redo allocation 1	12	0
redo writing	kcrfw_post: after write	1	0
redo writing	kcrfw_post: rba scn pair	1	0
row cache objects	kqreqd: reget	33	0
row cache objects	kqrpre: find obj	11	39
row cache objects	kqreqd	2	7
session allocation	ksucri	56	73
session allocation	ksuxds: not user session	35	37
session allocation	ksuxds: KSUSFCLC not set	18	9
session allocation	ksufap: active sessions	8	0
session allocation	ksusroll	1	0
session allocation	ksuxds: KSUSFCLC set	1	0
session idle bit	ksupuc: set busy	36	18
session idle bit	ksupuc: clear busy	16	33
session idle bit	ksuxds	7	8
shared pool	kghfre	20	0
shared pool	kghalo	4	6
shared pool	kghupr1	3	23
shared pool	kghfrh	2	0
slave class create	ksvcreate	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 307,710,470
Captured Segments account for 99.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
GUOYANGW	DATA4	CH_FULLNOTE	TABLE	226,676,944	73.67
GUOYANGW	DATA4	JP_FULLNOTE	TABLE	43,251,360	14.06
GYJQR14	DATA14	JP_FULLNOTE	TABLE	10,701,424	3.48
GYJQR14	DATA14	CH_FULLNOTE	TABLE	7,836,032	2.55
GUOYANGW	DATA4	IND_CH_FULLNOTE_BEGINTIME	INDEX	2,178,576	0.71

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 75
Captured Segments account for 12.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	WRI$_ADV_MESSAGE_GROUPS		TABLE	6	8.00
GYJQR13	DATA13	CH_FULLNOTE		TABLE	3	4.00

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
GUOYANGW	DATA4	JP_PLAT_MONITOR		TABLE	16	69.57
GUOYANGW	DATA4	IND_JP_FULLOTE_ENDTIME		INDEX	3	13.04
GUOYANGW	DATA4	IND_CH_FULLNOTE_BEGINTIME		INDEX	2	8.70
GYJQR13	DATA13	IND_JP_DBERRORINFO_INFO1		INDEX	1	4.35
SYS	SYSAUX	WRH$_ROWCACHE_SUMMARY_PK	34238_4987	INDEX PARTITION	1	4.35

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
GYJQR13	DATA13	JP_PLAT_MONITOR	TABLE	3,909	59.13
GUOYANGW	DATA4	JP_PLAT_MONITOR	TABLE	1,646	24.90
SYS	SYSTEM	JOB$	TABLE	366	5.54
SYS	SYSTEM	I_JOB_NEXT	INDEX	232	3.51
GUOYANGW	DATA4	IND_CH_FULLNOTE_BEGINTIME	INDEX	196	2.96

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	113	0.00	4	1
dc_database_links	580	0.00	0	1
dc_files	24	0.00	0	12
dc_global_oids	17	0.00	0	304
dc_histogram_data	2,735	5.45	157	6,734
dc_histogram_defs	85,650	1.24	290	6,708
dc_object_grants	168	0.00	0	107
dc_object_ids	2,510	3.27	56	2,617
dc_objects	5,143	3.03	198	2,825
dc_profiles	1,273	0.00	0	2
dc_rollback_segments	31,591	0.00	0	1,263
dc_segments	1,865	1.98	207	2,193
dc_sequences	89	0.00	89	20
dc_tablespaces	738,884	0.00	0	10
dc_usernames	3,046	0.00	0	58
dc_users	763,777	0.00	0	88
outstanding_alerts	86	0.00	0	15

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	53	0.00	820,493	0.00	0	0
INDEX	47	19.15	200	4.50	0	0
SQL AREA	12,331	1.27	8,165,093	-0.07	10	197
TABLE/PROCEDURE	2,271	0.00	2,658,262	0.00	64	0
TRIGGER	144	0.00	144	0.00	0	0

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	2,774.03		1.28	0.42	11	11	2,165	2,165
	Freeable	1,401.69	0.00	0.67	0.25	2		2,101	2,101
	SQL	111.49	1.69	0.05	0.10	4	14	2,136	2,131
	PL/SQL	82.49	53.78	0.04	0.01	0	0	2,163	2,163
E	Other	2,782.23		1.28	0.42	11	11	2,167	2,167
	Freeable	1,413.06	0.00	0.67	0.24	2		2,109	2,109
	SQL	112.57	1.74	0.05	0.10	4	14	2,138	2,132
	PL/SQL	82.56	53.79	0.04	0.01	0	0	2,165	2,165

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	21,139,292,160
Fixed Size	2,155,264
Redo Buffers	14,618,624
Variable Size	11,056,188,672

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	128.00	128.00	0.00
large	free memory	96.00	96.00	0.00
shared	ASH buffers	50.00	50.00	0.00
shared	CCursor	44.19	43.87	-0.72
shared	KTI-UNDO	32.51	32.51	0.00
shared	db_block_hash_buckets	180.00	180.00	0.00
shared	event statistics per sess	39.79	39.79	0.00
shared	free memory	2,037.72	2,046.33	0.42
shared	library cache	59.92	60.13	0.36
shared	private strands	60.97	60.97	0.00
shared	sql area	215.06	206.42	-4.02
shared	trace buffer	35.70	35.70	0.00
streams	free memory	319.99	319.99	0.00
	buffer_cache	20,160.00	20,160.00	0.00
	fixed_sga	2.06	2.06	0.00
	log_buffer	13.94	13.94	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

Streams processes ordered by CPU usage
CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Slaves	70,989	0	0
QMON Coordinator	70,989	0	0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
SYS.ALERT_QUE_R	0	0	0	0	0

Back to Streams Statistics
Back to Top

Resource Limit Stats

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

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
sessions	2,174	4,375	4405	4405

init.ora Parameters

Parameter Name	Begin value	End value (if different)
_b_tree_bitmap_plans	FALSE
_undo_autotune	FALSE
audit_file_dest	/home/app/oracle/admin/c1db0318/adump
audit_sys_operations	TRUE
audit_trail	DB_EXTENDED
background_dump_dest	/home/app/oracle/admin/c1db0318/bdump
compatible	10.2.0.5.0
control_file_record_keep_time	15
control_files	/home/app/oracle/oradata/C1DB0318/controlfile/o1_mf_9fsb9yvo_.ctl
core_dump_dest	/home/app/oracle/admin/c1db0318/cdump
db_block_size	8192
db_cache_size	21139292160
db_create_file_dest	/home/app/oracle/oradata
db_domain	19pay.com
db_file_multiblock_read_count	16
db_name	c1db0318
dispatchers	(PROTOCOL=TCP) (SERVICE=c1db0318XDB)
filesystemio_options	ASYNCH
java_pool_size	134217728
job_queue_processes	200
large_pool_size	100663296
log_archive_dest_1	location=/home/app/archivelog
log_archive_dest_2
open_cursors	2000
optimizer_index_caching	80
optimizer_index_cost_adj	20
pga_aggregate_target	6442450944
processes	4000
remote_login_passwordfile	EXCLUSIVE
session_cached_cursors	2000
sessions	4405
sga_max_size	32212254720
shared_pool_size	3221225472
undo_management	AUTO
undo_retention	3600
undo_tablespace	UNDOTBS1
user_dump_dest	/home/app/oracle/admin/c1db0318/udump

End of Report

% Blocks changed per Read:	0.65	Recursive Call %:	49.04
Rollback per transaction %:	0.21	Rows per Sort:	0.41

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	100.05	Soft Parse %:	100.00
Execute to Parse %:	55.82	Latch Hit %:	99.15
Parse CPU to Parse Elapsd %:	25.19	% Non-Parse CPU:	99.46