WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

PORTAL 4097524811 portal1 1 10.2.0.4.0 YES rbtdb1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
PORTAL	4097524811	portal1	1	10.2.0.4.0	YES	rbtdb1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 25458 27-Dec-12 13:00:17 292 8.2

End Snap: 25459 27-Dec-12 14:00:44 317 8.8

Elapsed: 60.45 (mins)

DB Time: 1,844.19 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	25458	27-Dec-12 13:00:17	292	8.2
End Snap:	25459	27-Dec-12 14:00:44	317	8.8
Elapsed:		60.45 (mins)
DB Time:		1,844.19 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 7,392M 7,456M Std Block Size: 8K

Shared Pool Size: 768M 704M Log Buffer: 14,360K

	Begin	End
Buffer Cache:	7,392M	7,456M	Std Block Size:	8K
Shared Pool Size:	768M	704M	Log Buffer:	14,360K

Load Profile

Per Second Per Transaction

Redo size: 12,123.20 2,648.70

Logical reads: 68,541.05 14,974.99

Block changes: 55.63 12.15

Physical reads: 429.86 93.92

Physical writes: 9.07 1.98

User calls: 136.08 29.73

Parses: 50.72 11.08

Hard parses: 0.34 0.07

Sorts: 14.61 3.19

Logons: 0.09 0.02

Executes: 61.97 13.54

Transactions: 4.58

	Per Second	Per Transaction
Redo size:	12,123.20	2,648.70
Logical reads:	68,541.05	14,974.99
Block changes:	55.63	12.15
Physical reads:	429.86	93.92
Physical writes:	9.07	1.98
User calls:	136.08	29.73
Parses:	50.72	11.08
Hard parses:	0.34	0.07
Sorts:	14.61	3.19
Logons:	0.09	0.02
Executes:	61.97	13.54
Transactions:	4.58

% Blocks changed per Read: 0.08 Recursive Call %: 48.58

Rollback per transaction %: 34.57 Rows per Sort: 7166.37

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95 Redo NoWait %: 99.93

Buffer Hit %: 99.38 In-memory Sort %: 99.98

Library Hit %: 98.43 Soft Parse %: 99.33

Execute to Parse %: 18.15 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 0.65 % Non-Parse CPU: 99.96

Shared Pool Statistics

Begin End

Memory Usage %: 84.38 83.96

% SQL with executions>1: 68.73 78.35

% Memory for SQL w/exec>1: 70.98 79.27

	Begin	End
Memory Usage %:	84.38	83.96
% SQL with executions>1:	68.73	78.35
% Memory for SQL w/exec>1:	70.98	79.27

Top 5 Timed Events

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

read by other session 130,623 15,516 119 14.0 User I/O

CPU time 13,839 12.5

db file sequential read 259,491 9,547 37 8.6 User I/O

log file sync 16,077 9,108 567 8.2 Commit

db file scattered read 82,229 8,054 98 7.3 User I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
read by other session	130,623	15,516	119	14.0	User I/O
CPU time		13,839		12.5
db file sequential read	259,491	9,547	37	8.6	User I/O
log file sync	16,077	9,108	567	8.2	Commit
db file scattered read	82,229	8,054	98	7.3	User I/O

RAC Statistics

Begin End

Number of Instances: 1 1

	Begin	End
Number of Instances:	1	1

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 0.00 0.00

Global Cache blocks served: 0.00 0.00

GCS/GES messages received: 0.00 0.00

GCS/GES messages sent: 0.00 0.00

DBWR Fusion writes: 0.00 0.00

Estd Interconnect traffic (KB) 0.00

	Per Second	Per Transaction
Global Cache blocks received:	0.00	0.00
Global Cache blocks served:	0.00	0.00
GCS/GES messages received:	0.00	0.00
GCS/GES messages sent:	0.00	0.00
DBWR Fusion writes:	0.00	0.00
Estd Interconnect traffic (KB)	0.00

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 99.38

Buffer access - remote cache %: 0.00

Buffer access - disk %: 0.62

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 12.1

Avg global cache cr block receive time (ms): 0.0

Avg global cache current block receive time (ms): 0.0

Avg global cache cr block build time (ms):

Avg global cache cr block send time (ms):

Global cache log flushes for cr blocks served %:

Avg global cache cr block flush time (ms):

Avg global cache current block pin time (ms):

Avg global cache current block send time (ms):

Global cache log flushes for current blocks served %:

Avg global cache current block flush time (ms):

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):

Avg message sent queue time on ksxp (ms):

Avg message received queue time (ms):

Avg GCS message process time (ms):

Avg GES message process time (ms):

% of direct sent messages:

% of indirect sent messages:

% of flow controlled messages:

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

Wait Events Statistics

Time Model Statistics
Wait Class
Wait Events
Background Wait Events
Operating System Statistics
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 110651.3s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	100,651.58	90.96
DB CPU	13,838.55	12.51
sequence load elapsed time	4,561.67	4.12
parse time elapsed	1,904.63	1.72
hard parse elapsed time	1,280.20	1.16
PL/SQL execution elapsed time	184.33	0.17
failed parse elapsed time	62.00	0.06
connection management call elapsed time	42.31	0.04
hard parse (sharing criteria) elapsed time	9.72	0.01
PL/SQL compilation elapsed time	5.75	0.01
hard parse (bind mismatch) elapsed time	4.77	0.00
repeated bind elapsed time	0.03	0.00
DB time	110,651.31
background elapsed time	5,849.94
background cpu time	26.44

Back to Wait Events Statistics
Back to Top

Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
User I/O	477,457	0.00	33,604	70	28.76
Commit	16,077	1.24	9,108	567	0.97
Concurrency	22,645	17.82	8,965	396	1.36
System I/O	22,322	0.00	5,567	249	1.34
Application	3,575	5.01	870	243	0.22
Other	28,852	57.67	360	12	1.74
Configuration	90	48.89	106	1176	0.01
Network	360,736	0.00	14	0	21.73
Cluster	489	0.00	12	24	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)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
read by other session	130,623	0.00	15,516	119	7.87
db file sequential read	259,491	0.00	9,547	37	15.63
log file sync	16,077	1.24	9,108	567	0.97
db file scattered read	82,229	0.00	8,054	98	4.95
row cache lock	15,912	0.17	6,102	383	0.96
control file sequential read	10,212	0.00	2,697	264	0.62
latch: cache buffers chains	2,451	0.00	2,133	870	0.15
log file parallel write	10,081	0.00	1,919	190	0.61
enq: TX - row lock contention	1,979	9.04	719	363	0.12
control file parallel write	1,089	0.00	644	591	0.07
cursor: pin S wait on X	3,982	100.00	570	143	0.24
direct path write temp	2,834	0.00	367	130	0.17
db file parallel write	818	0.00	286	350	0.05
rdbms ipc reply	369	0.00	170	460	0.02
SQL*Net break/reset to client	1,596	0.00	152	95	0.10
direct path read temp	2,050	0.00	114	56	0.12
latch: row cache objects	93	0.00	80	865	0.01
log file switch completion	75	54.67	78	1039	0.00
reliable message	231	0.43	63	271	0.01
latch free	70	0.00	45	643	0.00
enq: CF - contention	49	75.51	36	730	0.00
enq: SQ - contention	13	23.08	25	1960	0.00
buffer busy waits	35	51.43	25	718	0.00
library cache pin	133	0.00	23	174	0.01
log file sequential read	67	0.00	21	316	0.00
os thread startup	17	41.18	21	1211	0.00
gc buffer busy	489	0.00	12	24	0.03
enq: JS - queue lock	5	80.00	11	2225	0.00
DFS lock handle	19	5.26	11	574	0.00
enq: TX - index contention	20	10.00	10	508	0.00
ksxr poll remote instances	18,574	38.17	10	1	1.12
SQL*Net more data from client	11,055	0.00	8	1	0.67
enq: US - contention	12	75.00	7	596	0.00
SQL*Net more data to client	13,496	0.00	6	0	0.81
CGS wait for IPC msg	9,499	100.00	4	0	0.57
direct path write	83	0.00	3	36	0.00
latch: redo writing	2	0.00	2	1205	0.00
direct path read	141	0.00	2	16	0.01
LGWR wait for redo copy	13	0.00	2	117	0.00
latch: cache buffers lru chain	1	0.00	1	1318	0.00
latch: KCL gc element parent latch	6	0.00	1	134	0.00
latch: redo allocation	1	0.00	1	722	0.00
library cache load lock	1	0.00	1	585	0.00
SQL*Net message to client	336,185	0.00	0	0	20.25
latch: gcs resource hash	3	0.00	0	83	0.00
db file parallel read	6	0.00	0	28	0.00
log file single write	8	0.00	0	16	0.00
Log archive I/O	47	0.00	0	0	0.00
latch: shared pool	1	0.00	0	0	0.00
SQL*Net message from client	336,165	0.00	678,148	2017	20.25
gcs remote message	37,050	99.92	7,065	191	2.23
jobq slave wait	2,095	96.47	6,616	3158	0.13
Streams AQ: waiting for messages in the queue	956	100.00	6,291	6581	0.06
class slave wait	76	35.53	3,751	49352	0.00
ASM background timer	645	0.00	3,538	5485	0.04
ges remote message	14,421	96.83	3,534	245	0.87
DIAG idle wait	8,671	0.00	3,531	407	0.52
virtual circuit status	119	100.00	3,514	29530	0.01
Streams AQ: qmn coordinator idle wait	260	48.46	3,509	13495	0.02
Streams AQ: qmn slave idle wait	125	0.00	3,506	28044	0.01
Streams AQ: waiting for time management or cleanup tasks	1	100.00	125	125140	0.00
KSV master wait	52	11.54	46	878	0.00
SGA: MMAN sleep for component shrink	13	61.54	4	291	0.00
Streams AQ: RAC qmn coordinator idle wait	260	100.00	0	0	0.02

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	10,064	0.00	1,918	191	0.61
control file sequential read	6,669	0.00	1,802	270	0.40
control file parallel write	1,088	0.00	643	591	0.07
db file parallel write	817	0.00	286	350	0.05
events in waitclass Other	28,460	58.30	188	7	1.71
row cache lock	500	0.40	171	343	0.03
latch: row cache objects	29	0.00	26	893	0.00
log file sequential read	67	0.00	21	316	0.00
os thread startup	17	41.18	21	1211	0.00
library cache pin	35	0.00	11	315	0.00
latch: redo writing	2	0.00	2	1205	0.00
direct path write	76	0.00	1	13	0.00
log file single write	8	0.00	0	16	0.00
Log archive I/O	47	0.00	0	0	0.00
direct path read	128	0.00	0	0	0.01
latch: shared pool	1	0.00	0	0	0.00
rdbms ipc message	43,817	49.61	43,012	982	2.64
gcs remote message	37,030	99.92	7,059	191	2.23
ASM background timer	644	0.00	3,532	5485	0.04
ges remote message	14,394	96.82	3,531	245	0.87
DIAG idle wait	8,657	0.00	3,528	407	0.52
pmon timer	1,253	100.00	3,519	2808	0.08
Streams AQ: qmn coordinator idle wait	260	48.46	3,509	13495	0.02
Streams AQ: qmn slave idle wait	125	0.00	3,506	28044	0.01
class slave wait	69	37.68	3,431	49729	0.00
smon timer	82	0.00	3,416	41661	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100.00	125	125140	0.00
KSV master wait	52	11.54	46	878	0.00
SGA: MMAN sleep for component shrink	13	61.54	4	291	0.00
Streams AQ: RAC qmn coordinator idle wait	260	100.00	0	0	0.02

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	353,435
AVG_IDLE_TIME	6,712
AVG_IOWAIT_TIME	77
AVG_SYS_TIME	7,342
AVG_USER_TIME	345,860
BUSY_TIME	1,414,321
IDLE_TIME	26,999
IOWAIT_TIME	392
SYS_TIME	30,100
USER_TIME	1,384,221
LOAD	16
OS_CPU_WAIT_TIME	###############
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	16,384
VM_OUT_BYTES	0
PHYSICAL_MEMORY_BYTES	17,145,167,872
NUM_CPUS	4
NUM_CPU_SOCKETS	4

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
portal	108,679.20	14,035.40	1,003,031	243,318,059
SYS$USERS	4,574.80	103.50	554,775	9,187,768
SYS$BACKGROUND	0.00	0.00	541	82,372
portalXDB	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 centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
portal	442872	3072012	19839	807112	354834	1390
SYS$USERS	34797	326486	593	38845	8902	41
SYS$BACKGROUND	693	2912	2363	59683	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
SQL ordered by Cluster Wait Time
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
36,819	7,405	2,182	16.87	33.27	cpu7jxxvxu36h	JDBC Thin Client	BEGIN p_search_tone_keyword_en...
14,237	279	20	711.84	12.87	4219a0a7ba7x1	JDBC Thin Client	select tt.content, tt.ct, rown...
13,539	2,600	1,645	8.23	12.24	0v7k1jjnrk5v3	JDBC Thin Client	SELECT SINGER_NAME FROM (SELEC...
8,192	1,665	635	12.90	7.40	cx5cj03xss300	JDBC Thin Client	SELECT TONE_NAME_SINGER FROM (...
7,651	1,573	856	8.94	6.91	3gc1c8r2wn9r1	JDBC Thin Client	SELECT TONE_NAME FROM (SELECT ...
6,622	1,388	1,026	6.45	5.98	gfz3yuxt89hg5	JDBC Thin Client	SELECT TONE_NAME FROM (SELECT ...
5,693	22	52	109.49	5.15	2ht08a4ctcv8g	JDBC Thin Client	select feedaction2_.USER_ID as...
4,203	924	600	7.00	3.80	62x4mpf6cgj03	JDBC Thin Client	select count(*) as col_0_0_ fr...
3,366	43	0		3.04	5g7j8a21fr14b		DECLARE job BINARY_INTEGER := ...
3,365	43	0		3.04	1rbdshj6h2ru1		INSERT INTO T_RBT_USER_BEING (...
3,285	14	4	821.22	2.97	7cddggs1rvtfs	JDBC Thin Client	select receiversm0_.MSG_ID as ...
2,880	656	173	16.64	2.60	gc0630hwkjzt9	JDBC Thin Client	select count(*) as col_0_0_ fr...
2,872	40	4	717.94	2.60	360dut0ds5n1d	JDBC Thin Client	select tt.content, tt.ct, rown...
2,563	711	138	18.57	2.32	2cvda584xjrqw	JDBC Thin Client	select count(*) as col_0_0_ fr...
1,918	4	5,212	0.37	1.73	cmqhvqu3u4hd6	JDBC Thin Client	select SEQ_SYS_ACCESSLOGS.next...
1,190	326	212	5.61	1.08	ggy6b3sbus8yx	JDBC Thin Client	select count(*) as col_0_0_ fr...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
7,405	36,819	2,182	3.39	33.27	cpu7jxxvxu36h	JDBC Thin Client	BEGIN p_search_tone_keyword_en...
2,600	13,539	1,645	1.58	12.24	0v7k1jjnrk5v3	JDBC Thin Client	SELECT SINGER_NAME FROM (SELEC...
1,665	8,192	635	2.62	7.40	cx5cj03xss300	JDBC Thin Client	SELECT TONE_NAME_SINGER FROM (...
1,573	7,651	856	1.84	6.91	3gc1c8r2wn9r1	JDBC Thin Client	SELECT TONE_NAME FROM (SELECT ...
1,388	6,622	1,026	1.35	5.98	gfz3yuxt89hg5	JDBC Thin Client	SELECT TONE_NAME FROM (SELECT ...
924	4,203	600	1.54	3.80	62x4mpf6cgj03	JDBC Thin Client	select count(*) as col_0_0_ fr...
711	2,563	138	5.15	2.32	2cvda584xjrqw	JDBC Thin Client	select count(*) as col_0_0_ fr...
656	2,880	173	3.79	2.60	gc0630hwkjzt9	JDBC Thin Client	select count(*) as col_0_0_ fr...
326	1,190	212	1.54	1.08	ggy6b3sbus8yx	JDBC Thin Client	select count(*) as col_0_0_ fr...
279	14,237	20	13.95	12.87	4219a0a7ba7x1	JDBC Thin Client	select tt.content, tt.ct, rown...
43	3,366	0		3.04	5g7j8a21fr14b		DECLARE job BINARY_INTEGER := ...
43	3,365	0		3.04	1rbdshj6h2ru1		INSERT INTO T_RBT_USER_BEING (...
40	2,872	4	10.00	2.60	360dut0ds5n1d	JDBC Thin Client	select tt.content, tt.ct, rown...
22	5,693	52	0.43	5.15	2ht08a4ctcv8g	JDBC Thin Client	select feedaction2_.USER_ID as...
14	3,285	4	3.58	2.97	7cddggs1rvtfs	JDBC Thin Client	select receiversm0_.MSG_ID as ...
4	1,918	5,212	0.00	1.73	cmqhvqu3u4hd6	JDBC Thin Client	select SEQ_SYS_ACCESSLOGS.next...

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: 248,614,844
Captured SQL account for 92.7% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
161,826,915	2,182	74,164.49	65.09	7404.73	36818.66	cpu7jxxvxu36h	JDBC Thin Client	BEGIN p_search_tone_keyword_en...
69,552,269	1,645	42,281.01	27.98	2599.75	13539.20	0v7k1jjnrk5v3	JDBC Thin Client	SELECT SINGER_NAME FROM (SELEC...
36,192,549	856	42,281.02	14.56	1572.72	7650.51	3gc1c8r2wn9r1	JDBC Thin Client	SELECT TONE_NAME FROM (SELECT ...
26,848,451	635	42,281.03	10.80	1665.38	8191.83	cx5cj03xss300	JDBC Thin Client	SELECT TONE_NAME_SINGER FROM (...
25,368,612	600	42,281.02	10.20	924.36	4202.82	62x4mpf6cgj03	JDBC Thin Client	select count(*) as col_0_0_ fr...
13,341,148	2,182	6,114.18	5.37	85.96	404.32	8mxk2wj1cryt8	JDBC Thin Client	SELECT TONE_NAME FROM (SELECT ...
9,658,713	2,182	4,426.54	3.89	73.41	309.91	0kr4tvysfgh3t	JDBC Thin Client	SELECT SINGER_NAME FROM (SELEC...
8,963,574	212	42,281.01	3.61	326.17	1190.13	ggy6b3sbus8yx	JDBC Thin Client	select count(*) as col_0_0_ fr...
8,570,834	1	8,570,834.00	3.45	30.14	104.06	3byt73wt3hnan		DECLARE job BINARY_INTEGER := ...
8,565,552	873	9,811.63	3.45	28.40	100.23	4pwjpx607and5		SELECT SYNC.* FROM T_RBT_SM_RI...
4,628,232	1,026	4,510.95	1.86	1388.37	6622.47	gfz3yuxt89hg5	JDBC Thin Client	SELECT TONE_NAME FROM (SELECT ...
4,532,268	2,772	1,635.02	1.82	169.99	223.94	11y16nd2r3fu9	JDBC Thin Client	select * from ( select ugctone...
3,847,574	91	42,281.03	1.55	143.96	479.64	6azf2fn46477k	JDBC Thin Client	select * from ( select alltone...
2,629,539	173	15,199.65	1.06	655.75	2879.56	gc0630hwkjzt9	JDBC Thin Client	select count(*) as col_0_0_ fr...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 1,559,218
Captured SQL account for 63.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
562,446	0		36.07	42.61	3365.66	5g7j8a21fr14b		DECLARE job BINARY_INTEGER := ...
562,445	0		36.07	42.61	3365.16	1rbdshj6h2ru1		INSERT INTO T_RBT_USER_BEING (...
474,874	4	118,718.50	30.46	14.32	3284.87	7cddggs1rvtfs	JDBC Thin Client	select receiversm0_.MSG_ID as ...
236,503	52	4,548.13	15.17	22.14	5693.37	2ht08a4ctcv8g	JDBC Thin Client	select feedaction2_.USER_ID as...
170,743	4	42,685.75	10.95	40.00	2871.77	360dut0ds5n1d	JDBC Thin Client	select tt.content, tt.ct, rown...
88,693	20	4,434.65	5.69	279.10	14236.71	4219a0a7ba7x1	JDBC Thin Client	select tt.content, tt.ct, rown...
6,739	1	6,739.00	0.43	1.82	1087.14	dkya3u8g8r0w4	Lab128	--lab128 select ts# ts_id, s...
6,637	2	3,318.50	0.43	3.98	1093.16	1t5t8j5d3dgnw	JDBC Thin Client	select * from ( select ugcaudi...
2,770	11	251.82	0.18	4.56	440.03	1a5x7hwwfd1tu	Lab128	--lab128 select --+rule latc...
1,183	1,012	1.17	0.08	2.00	66.71	9ku8ak57mnjzk	JDBC Thin Client	select handbooklo0_.ID as ID21...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 224,770
Captured SQL account for 70.0% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
39,002	4,290	0.11	0.00	0.00	1h1yf5kaxn7yg	JDBC Thin Client	select ugcmusic0_.UTID as UTID...
38,998	38,998	1.00	0.00	0.00	846hr6j8gpa8h	JDBC Thin Client	select ugcring0_.UTID as UTID1...
10,781	10,781	1.00	0.00	0.01	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
5,212	5,212	1.00	0.00	0.37	cmqhvqu3u4hd6	JDBC Thin Client	select SEQ_SYS_ACCESSLOGS.next...
4,968	1	0.00	0.00	0.00	cgvjk98hpf04s	JDBC Thin Client	select rntransfer0_.id as id26...
4,589	4,589	1.00	0.00	0.00	axu9hf2wu97j7	JDBC Thin Client	select account0_.USER_ID as US...
4,589	4,589	1.00	0.00	0.00	ay1v7ux00rqs3	JDBC Thin Client	select privacy0_.USER_ID as US...
3,212	2,873	0.89	0.00	0.00	242dkf73atqpf	JDBC Thin Client	select * from ( select userinf...
2,772	27,720	10.00	0.06	0.08	11y16nd2r3fu9	JDBC Thin Client	select * from ( select ugctone...
2,373	2,373	1.00	0.07	0.21	0kj8y2dx5xz4p	JDBC Thin Client	select count(*) as col_0_0_ fr...
2,314	2,314	1.00	0.00	0.00	0gajt9syvr63a	JDBC Thin Client	select TOTAL from T_RBT_STAT

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 183,976
Captured SQL account for 80.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
39,002	39,002	21.20	1h1yf5kaxn7yg	JDBC Thin Client	select ugcmusic0_.UTID as UTID...
38,998	38,998	21.20	846hr6j8gpa8h	JDBC Thin Client	select ugcring0_.UTID as UTID1...
10,781	10,781	5.86	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
5,212	5,212	2.83	cmqhvqu3u4hd6	JDBC Thin Client	select SEQ_SYS_ACCESSLOGS.next...
4,968	4,968	2.70	cgvjk98hpf04s	JDBC Thin Client	select rntransfer0_.id as id26...
4,589	4,589	2.49	axu9hf2wu97j7	JDBC Thin Client	select account0_.USER_ID as US...
4,589	4,589	2.49	ay1v7ux00rqs3	JDBC Thin Client	select privacy0_.USER_ID as US...
3,212	3,212	1.75	242dkf73atqpf	JDBC Thin Client	select * from ( select userinf...
2,772	2,772	1.51	11y16nd2r3fu9	JDBC Thin Client	select * from ( select ugctone...
2,373	2,373	1.29	0kj8y2dx5xz4p	JDBC Thin Client	select count(*) as col_0_0_ fr...
2,314	2,314	1.26	0gajt9syvr63a	JDBC Thin Client	select TOTAL from T_RBT_STAT
2,182	2,182	1.19	cpu7jxxvxu36h	JDBC Thin Client	BEGIN p_search_tone_keyword_en...
2,096	2,096	1.14	0gy17xhghmu6g	JDBC Thin Client	select * from ( select ugctone...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
287	132	36704j2yztr6n	JDBC Thin Client	update T_SNS_UGC_TONE set PHON...
145	1,042	ckxra82ndyduf	JDBC Thin Client	update T_RBT_RECEIVE_SM set SE...
24	600	62x4mpf6cgj03	JDBC Thin Client	select count(*) as col_0_0_ fr...
24	173	gc0630hwkjzt9	JDBC Thin Client	select count(*) as col_0_0_ fr...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)	CWT % of Elapsd Time	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
8.58	0.06	14,236.71	279.10	20	4219a0a7ba7x1	JDBC Thin Client	select tt.content, tt.ct, rown...
3.38	0.12	2,871.77	40.00	4	360dut0ds5n1d	JDBC Thin Client	select tt.content, tt.ct, rown...
0.06	0.00	5,693.37	22.14	52	2ht08a4ctcv8g	JDBC Thin Client	select feedaction2_.USER_ID as...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0gajt9syvr63a select TOTAL from T_RBT_STAT

0gy17xhghmu6g select * from ( select ugctone0_.UTID as UTID183_, ugctone0_.PHONE_NUMBER as PHONE2_183_, ugctone0_.TONEID as TONEID183_, ugctone0_.TONECODE as TONECODE183_, ugctone0_.TONENAME as TONENAME183_, ugctone0_.TONENAMELETTER as TONENAME6_183_, ugctone0_.SINGER as SINGER183_, ugctone0_.SINGERSEX as SINGERSEX183_, ugctone0_.SINGERLETTER as SINGERLE9_183_, ugctone0_.UPLOADDATE as UPLOADDATE183_, ugctone0_.STATUS as STATUS183_, ugctone0_.INFO as INFO183_, ugctone0_.STORY as STORY183_, ugctone0_.REJECTTIMES as REJECTT14_183_, ugctone0_.TONEVALIDDAY as TONEVAL15_183_, ugctone0_.CATEGORY as CATEGORY183_, ugctone0_.ORDER_TIMES as ORDER17_183_, ugctone0_.TYPE as TYPE183_, ugctone0_.AUDITION_TIMES as AUDITION19_183_, ugctone0_.PUBLISH_TIMES as PUBLISH20_183_, ugctone0_.POPULARIZE as POPULARIZE183_, ugctone0_.POPULARIZE_STATE as POPULARIZE22_183_, ugctone0_.VISION_STATUS as VISION23_183_, ugctone0_.RECOMMEND_TIMES as RECOMMEND24_183_, ugctone0_.SHARE_TIMES as SHARE25_183_, ugctone0_.UPDATEDATE as UPDATEDATE183_, ugctone0_.CADENCE as CADENCE183_, ugctone0_.SENSIBILITY_EXPRESSION as SENSIBI28_183_, ugctone0_.MUSIC_TYPE as MUSIC29_183_, ugctone0_.LANGUAGE as LANGUAGE183_, ugctone0_.LISTEN_TO_WHO as LISTEN31_183_, ugctone0_.MUSICAL_INSTRUMENTS as MUSICAL32_183_, ugctone0_.SCENE as SCENE183_, ugctone0_.SUBJECT as SUBJECT183_, ugctone0_.TIMBRE as TIMBRE183_, ugctone0_.APPLAY_TIME as APPLAY36_183_, ugctone0_.APPLY_LANGUAGE as APPLY37_183_, ugctone0_.REJECTREASON as REJECTR38_183_, ugctone0_.REJECTDATE as REJECTDATE183_, ugctone0_.APPEAL_REASON as APPEAL40_183_, ugctone0_.APPEAL_DATE as APPEAL41_183_, ugctone0_.APPEAL_ADDRESS as APPEAL42_183_, ugctone0_.APPROVE_TIME as APPROVE43_183_, ugctone0_.HASSEARCHKEY as HASSEAR44_183_, ugctone0_.WAIT_REASON as WAIT45_183_, ugctone0_.WAIT_DATE as WAIT46_183_, ugctone0_.SUPDATE_DATE as SUPDATE47_183_, ugctone0_.CONCERT as CONCERT183_ from T_SNS_UGC_TONE ugctone0_ where 1=1 and ugctone0_.PHONE_NUMBER=:1 and ugctone0_.STATUS=:2 and (ugctone0_.AUDITION_TIMES is not null) order by ugctone0_.AUDITION_TIMES desc ) where rownum <= :3

0kj8y2dx5xz4p select count(*) as col_0_0_ from T_SNS_NOTIFICATIONS notificati0_ where 1=1 and notificati0_.TYPE=:1 and notificati0_.TO_STATUS=:2

0kr4tvysfgh3t SELECT SINGER_NAME FROM (SELECT DISTINCT (SINGER_NAME) FROM (SELECT SINGER_NAME FROM (SELECT T.SINGER_NAME FROM T_RBT_ALL_TONE T WHERE T.SINGER_NAME LIKE :B1 AND T.TONE_VALID_DAY > SYSDATE AND T.UPLOAD_TYPE IN ('1', '9') AND T.STATUS = '1' ORDER BY T.ORDER_TIMES DESC) WHERE ROWNUM < :B2 )) WHERE ROWNUM < :B3 + 1

0v7k1jjnrk5v3 SELECT SINGER_NAME FROM (SELECT DISTINCT (SINGER_NAME) FROM (SELECT SINGER_NAME FROM (SELECT T.SINGER_NAME FROM T_RBT_ALL_TONE T WHERE T.SINGER_NAME NOT LIKE :B3 AND T.SINGER_NAME_PINYIN NOT LIKE :B2 AND T.SINGER_NAME LIKE :B1 AND T.TONE_VALID_DAY > SYSDATE AND T.UPLOAD_TYPE IN ('1', '9') AND T.STATUS = '1' ORDER BY T.ORDER_TIMES DESC) WHERE ROWNUM < :B4 )) WHERE ROWNUM < :B6 - :B5 + 1

11y16nd2r3fu9 select * from ( select ugctone0_.UTID as UTID183_, ugctone0_.PHONE_NUMBER as PHONE2_183_, ugctone0_.TONEID as TONEID183_, ugctone0_.TONECODE as TONECODE183_, ugctone0_.TONENAME as TONENAME183_, ugctone0_.TONENAMELETTER as TONENAME6_183_, ugctone0_.SINGER as SINGER183_, ugctone0_.SINGERSEX as SINGERSEX183_, ugctone0_.SINGERLETTER as SINGERLE9_183_, ugctone0_.UPLOADDATE as UPLOADDATE183_, ugctone0_.STATUS as STATUS183_, ugctone0_.INFO as INFO183_, ugctone0_.STORY as STORY183_, ugctone0_.REJECTTIMES as REJECTT14_183_, ugctone0_.TONEVALIDDAY as TONEVAL15_183_, ugctone0_.CATEGORY as CATEGORY183_, ugctone0_.ORDER_TIMES as ORDER17_183_, ugctone0_.TYPE as TYPE183_, ugctone0_.AUDITION_TIMES as AUDITION19_183_, ugctone0_.PUBLISH_TIMES as PUBLISH20_183_, ugctone0_.POPULARIZE as POPULARIZE183_, ugctone0_.POPULARIZE_STATE as POPULARIZE22_183_, ugctone0_.VISION_STATUS as VISION23_183_, ugctone0_.RECOMMEND_TIMES as RECOMMEND24_183_, ugctone0_.SHARE_TIMES as SHARE25_183_, ugctone0_.UPDATEDATE as UPDATEDATE183_, ugctone0_.CADENCE as CADENCE183_, ugctone0_.SENSIBILITY_EXPRESSION as SENSIBI28_183_, ugctone0_.MUSIC_TYPE as MUSIC29_183_, ugctone0_.LANGUAGE as LANGUAGE183_, ugctone0_.LISTEN_TO_WHO as LISTEN31_183_, ugctone0_.MUSICAL_INSTRUMENTS as MUSICAL32_183_, ugctone0_.SCENE as SCENE183_, ugctone0_.SUBJECT as SUBJECT183_, ugctone0_.TIMBRE as TIMBRE183_, ugctone0_.APPLAY_TIME as APPLAY36_183_, ugctone0_.APPLY_LANGUAGE as APPLY37_183_, ugctone0_.REJECTREASON as REJECTR38_183_, ugctone0_.REJECTDATE as REJECTDATE183_, ugctone0_.APPEAL_REASON as APPEAL40_183_, ugctone0_.APPEAL_DATE as APPEAL41_183_, ugctone0_.APPEAL_ADDRESS as APPEAL42_183_, ugctone0_.APPROVE_TIME as APPROVE43_183_, ugctone0_.HASSEARCHKEY as HASSEAR44_183_, ugctone0_.WAIT_REASON as WAIT45_183_, ugctone0_.WAIT_DATE as WAIT46_183_, ugctone0_.SUPDATE_DATE as SUPDATE47_183_, ugctone0_.CONCERT as CONCERT183_ from T_SNS_UGC_TONE ugctone0_ where 1=1 and ugctone0_.STATUS=:1 order by ugctone0_.UPDATEDATE desc ) where rownum <= :2

1a5x7hwwfd1tu --lab128 select --+rule latch#, sum(gets) gets, sum(misses) misses, sum(sleeps) sleeps, sum(immediate_gets) immediate_gets, sum(immediate_misses) immediate_misses, sum(waits_holding_latch) waits_holding_latch, sum(spin_gets) spin_gets from v$latch_children where misses+immediate_misses>100 group by latch#

1h1yf5kaxn7yg select ugcmusic0_.UTID as UTID185_0_, ugcmusic0_.PRICE as PRICE185_0_, ugcmusic0_.MUSIC_ADDRESS as MUSIC3_185_0_, ugcmusic0_.FILE_SIZE as FILE4_185_0_ from T_SNS_UGC_MUSIC ugcmusic0_ where ugcmusic0_.UTID=:1

1rbdshj6h2ru1 INSERT INTO T_RBT_USER_BEING (SELECT T.RESOURCE_ID TONE_ID, T.PHONE_NUMBER PHONE_NUMBER, T.DOWNLOAD_TIME DO_TIME, '??' TYPE, SYSDATE CREATE_TIME FROM (SELECT * FROM T_RBT_ORDER_TONE_LOGS R WHERE R.RETURN_CODE = '000000' AND R.RESOURCE_TYPE = 1 ORDER BY R.DOWNLOAD_TIME DESC) T WHERE ROWNUM <= :B1 )

1t5t8j5d3dgnw select * from ( select ugcauditio0_.TONE_ID as col_0_0_ from T_SNS_UGC_AUDITION_TONE_LOGS ugcauditio0_, T_SNS_UGC_TONE ugctone1_ where ugctone1_.TONEID=ugcauditio0_.TONE_ID and (ugctone1_.PHONE_NUMBER not in ('15159776679' , '15159776680' , '15159776681' , '15159776682' , '15159776683' , '15159776684' , '15159776685' , '15860312530' , '18859112530' , '15960800011' , '11111111111')) and ugcauditio0_.AUDITION_DATE>=:1 and ugcauditio0_.AUDITION_DATE<:2 and ugctone1_.STATUS=:3 group by ugcauditio0_.TONE_ID order by count(ugcauditio0_.ID) desc ) where rownum <= :4

242dkf73atqpf select * from ( select userinfo0_.USER_ID as USER1_178_, userinfo0_.PHONE_NUMBER as PHONE2_178_, userinfo0_.EMAIL as EMAIL178_, userinfo0_.NICKNAME as NICKNAME178_, userinfo0_.NAME as NAME178_, userinfo0_.SPACE_NAME as SPACE6_178_, userinfo0_.SPACE_INTRO as SPACE7_178_, userinfo0_.SEX as SEX178_, userinfo0_.BIRTHDAY as BIRTHDAY178_, userinfo0_.PASSWORD as PASSWORD178_, userinfo0_.COUNTRY as COUNTRY178_, userinfo0_.PROVINCE as PROVINCE178_, userinfo0_.CITY as CITY178_, userinfo0_.COMPANY_NAME as COMPANY14_178_, userinfo0_.ADDRESS as ADDRESS178_, userinfo0_.TEL as TEL178_, userinfo0_.QQ as QQ178_, userinfo0_.MSN as MSN178_, userinfo0_.TINY_URL as TINY19_178_, userinfo0_.HEAD_URL as HEAD20_178_, userinfo0_.MAIN_URL as MAIN21_178_, userinfo0_.MUSICE_TYPE as MUSICE22_178_, userinfo0_.LIKE_SINGER as LIKE23_178_, userinfo0_.STATUS as STATUS178_, userinfo0_.TYPE as TYPE178_, userinfo0_.RECENT as RECENT178_, userinfo0_.LAST_UPDATE_RECENT_DATE as LAST27_178_, userinfo0_.INTEGRAL as INTEGRAL178_, userinfo0_.ON_LINE as ON29_178_, userinfo0_.CREATE_DATE as CREATE30_178_, userinfo0_.LAST_UPDATE_DATE as LAST31_178_, userinfo0_.REMARK as REMARK178_, userinfo0_.MODULE_CODE as MODULE33_178_, userinfo0_.CADENCE as CADENCE178_, userinfo0_.SENSIBILITY_EXPRESSION as SENSIBI35_178_, userinfo0_.MUSIC_TYPE as MUSIC36_178_, userinfo0_.LANGUAGE as LANGUAGE178_, userinfo0_.LISTEN_TO_WHO as LISTEN38_178_, userinfo0_.MUSICAL_INSTRUMENTS as MUSICAL39_178_, userinfo0_. SCENE as SCENE178_, userinfo0_.SUBJECT as SUBJECT178_, userinfo0_.TIMBRE as TIMBRE178_, userinfo0_.INFO as INFO178_, userinfo0_.ISFIRST as ISFIRST178_, userinfo0_.FEIXIN_URL as FEIXIN45_178_, userinfo0_.ADD_V_USER as ADD46_178_, userinfo0_.ADD_V_CONTENT as ADD47_178_ from T_SNS_USER_INFO userinfo0_ where 1=1 and userinfo0_.PHONE_NUMBER=:1 and userinfo0_.STATUS<>3 ) where rownum <= :2

2cvda584xjrqw select count(*) as col_0_0_ from T_RBT_ALL_TONE alltone0_ where 1=1 and (alltone0_.TONE_NAME not like :1) and (alltone0_.TONE_NAME_SINGER not like :2) and (alltone0_.TONE_NAME_SINGER not like :3) and (alltone0_.TONE_NAME_SINGER like :4) and (alltone0_.TONE_NAME like :5) and alltone0_.TONE_VALID_DAY>:6 and alltone0_.STATUS=:7 and alltone0_.UPLOAD_TYPE=:8

2ht08a4ctcv8g select feedaction2_.USER_ID as col_0_0_ from T_SNS_FEED_TARGETS feedtarget0_, T_SNS_FEED_ACTIONS feedaction2_, T_SNS_USER_LAST_FEEDLOG userlastfe1_ where feedtarget0_.FEED_ACTION_ID=feedaction2_.ID and feedtarget0_.USER_ID=userlastfe1_.USER_ID and feedtarget0_.USER_ID=:1 and feedtarget0_.STATUS<>:2 and (feedaction2_.RELATIONS_ID=:3 or feedaction2_.RELATIONS_ID=:4 or feedaction2_.RELATIONS_ID=:5 or feedaction2_.RELATIONS_ID=:6 or feedaction2_.RELATIONS_ID=:7 or feedaction2_.RELATIONS_ID=:8 or feedaction2_.RELATIONS_ID=:9 or feedaction2_.RELATIONS_ID=:10 or feedaction2_.RELATIONS_ID=:11 or feedaction2_.RELATIONS_ID=:12 or feedaction2_.RELATIONS_ID=:13) order by feedaction2_.PUBLISH_DATE desc

360dut0ds5n1d select tt.content, tt.ct, rownum rn from (select t.content, count(1) as ct from t_rbt_search_log t where t.type=11 group by t.content order by ct desc) tt where rownum < 51

36704j2yztr6n update T_SNS_UGC_TONE set PHONE_NUMBER=:1, TONEID=:2, TONECODE=:3, TONENAME=:4, TONENAMELETTER=:5, SINGER=:6, SINGERSEX=:7, SINGERLETTER=:8, UPLOADDATE=:9, STATUS=:10, INFO=:11, STORY=:12, REJECTTIMES=:13, TONEVALIDDAY=:14, CATEGORY=:15, ORDER_TIMES=:16, TYPE=:17, AUDITION_TIMES=:18, PUBLISH_TIMES=:19, POPULARIZE=:20, POPULARIZE_STATE=:21, VISION_STATUS=:22, RECOMMEND_TIMES=:23, SHARE_TIMES=:24, UPDATEDATE=:25, CADENCE=:26, SENSIBILITY_EXPRESSION=:27, MUSIC_TYPE=:28, LANGUAGE=:29, LISTEN_TO_WHO=:30, MUSICAL_INSTRUMENTS=:31, SCENE=:32, SUBJECT=:33, TIMBRE=:34, APPLAY_TIME=:35, APPLY_LANGUAGE=:36, REJECTREASON=:37, REJECTDATE=:38, APPEAL_REASON=:39, APPEAL_DATE=:40, APPEAL_ADDRESS=:41, APPROVE_TIME=:42, HASSEARCHKEY=:43, WAIT_REASON=:44, WAIT_DATE=:45, SUPDATE_DATE=:46, CONCERT=:47 where UTID=:48

3byt73wt3hnan DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN p_boss_sync_down_tone_data; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

3gc1c8r2wn9r1 SELECT TONE_NAME FROM (SELECT DISTINCT (TONE_NAME) FROM (SELECT TONE_NAME FROM (SELECT T.TONE_NAME FROM T_RBT_ALL_TONE T WHERE T.TONE_NAME NOT LIKE :B3 AND T.TONE_NAME_PINYIN NOT LIKE :B2 AND T.TONE_NAME LIKE :B1 AND T.TONE_VALID_DAY > SYSDATE AND T.UPLOAD_TYPE IN ('1', '9') AND T.STATUS = '1' ORDER BY T.ORDER_TIMES DESC) WHERE ROWNUM < :B4 )) WHERE ROWNUM < :B6 - :B5 + 1

4219a0a7ba7x1 select tt.content, tt.ct, rownum rn from (select t.content, count(1) as ct from t_rbt_search_log t where (instr(t.content, '|') = 0) and (instr(t.content, ':') = 0) and (instr(t.content, '?') = 0) and t.type=11 group by t.content order by ct desc) tt where rownum < 51

4m7m0t6fjcs5x update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1

4pwjpx607and5 SELECT SYNC.* FROM T_RBT_SM_RING_SYNC SYNC WHERE SYNC.CREATE_DATE > :B3 AND SYNC.START_TIME < :B3 + 1/24 AND SYNC.PHONE_NUMBER = :B2 AND SYNC.RING_ID = :B1 AND SYNC.RING_TYPE = 1 AND (SYNC.EUR_CUP_TYPE <> 1 OR SYNC.EUR_CUP_TYPE IS NULL) AND ROWNUM < 2

5g7j8a21fr14b DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN p_user_last_being; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

62x4mpf6cgj03 select count(*) as col_0_0_ from T_RBT_ALL_TONE alltone0_ where 1=1 and (alltone0_.SINGER_NAME like :1) and alltone0_.TONE_VALID_DAY>:2 and alltone0_.STATUS=:3 and alltone0_.UPLOAD_TYPE=:4

6azf2fn46477k select * from ( select alltone0_.TONE_ID as TONE1_275_, alltone0_.TONE_CODE as TONE2_275_, alltone0_.TONE_CODE_LONG as TONE3_275_, alltone0_.STATUS as STATUS275_, alltone0_.TONE_NAME as TONE5_275_, alltone0_.TONE_NAME_LETTER as TONE6_275_, alltone0_.TONE_NAME_PINYIN as TONE7_275_, alltone0_.TONE_NAME_SINGER as TONE8_275_, alltone0_.TONE_NAME_SINGER_PINYIN as TONE9_275_, alltone0_.SINGER_NAME as SINGER10_275_, alltone0_.SINGER_SEX as SINGER11_275_, alltone0_.SINGER_NAME_LETTER as SINGER12_275_, alltone0_.SINGER_NAME_PINYIN as SINGER13_275_, alltone0_.LANGUAGE as LANGUAGE275_, alltone0_.CP_CODE as CP15_275_, alltone0_.CP_NAME as CP16_275_, alltone0_.CORP_CODE as CORP17_275_, alltone0_.CORP_NAME as CORP18_275_, alltone0_.PRICE as PRICE275_, alltone0_.UPLOAD_TYPE as UPLOAD20_275_, alltone0_.DIY_USER_PHONE_NUMBER as DIY21_275_, alltone0_.ORDER_TIMES as ORDER22_275_, alltone0_.LISTEN_TIMES as LISTEN23_275_, alltone0_.TONE_VALID_DAY as TONE24_275_, alltone0_.UPDATE_TIME as UPDATE25_275_, alltone0_.UPLOAD_TIME as UPLOAD26_275_, alltone0_.CREATE_TIME as CREATE27_275_ from T_RBT_ALL_TONE alltone0_ where 1=1 and (alltone0_.SINGER_NAME like :1) and alltone0_.TONE_VALID_DAY>:2 and alltone0_.STATUS=:3 and alltone0_.UPLOAD_TYPE=:4 order by alltone0_.ORDER_TIMES desc ) where rownum <= :5

7cddggs1rvtfs select receiversm0_.MSG_ID as MSG1_46_, receiversm0_.SERVICE_ID as SERVICE2_46_, receiversm0_.SERVICE_NO as SERVICE3_46_, receiversm0_.MSG_FORMAT as MSG4_46_, receiversm0_.CONTENT as CONTENT46_, receiversm0_.SRC_TERMINAL_ID as SRC6_46_, receiversm0_.DEST_TERMINAL_ID as DEST7_46_, receiversm0_.RECEIVE_TIME as RECEIVE8_46_, receiversm0_.RETURN_CODE as RETURN9_46_, receiversm0_.RETURN_INFO as RETURN10_46_, receiversm0_.STATUS as STATUS46_, receiversm0_.SMSEQ as SMSEQ46_, receiversm0_.MODULECODE as MODULECODE46_, receiversm0_.OPERATOR as OPERATOR46_, receiversm0_.KEYCODE as KEYCODE46_, receiversm0_.CSCODE as CSCODE46_ from T_RBT_RECEIVE_SM receiversm0_ where receiversm0_.RECEIVE_TIME<:1 and receiversm0_.STATUS<>:2 and (receiversm0_.CONTENT like 'QL%')

846hr6j8gpa8h select ugcring0_.UTID as UTID184_0_, ugcring0_.PRICE as PRICE184_0_, ugcring0_.RING_ADDRESS as RING3_184_0_, ugcring0_.FILE_SIZE as FILE4_184_0_, ugcring0_.MODULE_CODE as MODULE5_184_0_, ugcring0_.FAN_SING_NAME as FAN6_184_0_, ugcring0_.FAN_SING_AUTHOR as FAN7_184_0_, ugcring0_.FAN_SINGER as FAN8_184_0_, ugcring0_.IDCARD as IDCARD184_0_, ugcring0_.SING_AUTHOR as SING10_184_0_, ugcring0_.OPERN as OPERN184_0_, ugcring0_.SING_MATERIAL as SING12_184_0_, ugcring0_.FAN_LYRIC_AUTHOR as FAN13_184_0_, ugcring0_.LYRIC_AUTHOR as LYRIC14_184_0_, ugcring0_.OTHER_REFERENCE as OTHER15_184_0_, ugcring0_.OTHER_AUTHOR as OTHER16_184_0_, ugcring0_.COMPANY_NAME as COMPANY17_184_0_, ugcring0_.BACK_MUSIC as BACK18_184_0_, ugcring0_.COPYRIGHT_FILE as COPYRIGHT19_184_0_ from T_SNS_UGC_RING ugcring0_ where ugcring0_.UTID=:1

8mxk2wj1cryt8 SELECT TONE_NAME FROM (SELECT DISTINCT (TONE_NAME) FROM (SELECT TONE_NAME FROM (SELECT T.TONE_NAME FROM T_RBT_ALL_TONE T WHERE T.TONE_NAME LIKE :B1 AND T.TONE_VALID_DAY > SYSDATE AND T.UPLOAD_TYPE IN ('1', '9') AND T.STATUS = '1' ORDER BY T.ORDER_TIMES DESC) WHERE ROWNUM < :B2 )) WHERE ROWNUM < :B3 + 1

9ku8ak57mnjzk select handbooklo0_.ID as ID217_, handbooklo0_.PHONE_NUMBER as PHONE2_217_, handbooklo0_.SEND_TAG as SEND3_217_, handbooklo0_.REMARK as REMARK217_, handbooklo0_.RECORD_TIME as RECORD5_217_, handbooklo0_.SEND_TIME as SEND6_217_, handbooklo0_.MODIFY_TIME as MODIFY7_217_ from T_RBT_HANDBOOK_LOG handbooklo0_ where handbooklo0_.PHONE_NUMBER=:1

axu9hf2wu97j7 select account0_.USER_ID as USER1_162_0_, account0_.INTEGRAL as INTEGRAL162_0_, account0_.MONEY as MONEY162_0_, account0_.LAST_UPDATE_TIME as LAST4_162_0_ from T_SNS_ACCOUNTS account0_ where account0_.USER_ID=:1

ay1v7ux00rqs3 select privacy0_.USER_ID as USER1_177_0_, privacy0_.HOME_PAGE as HOME2_177_0_, privacy0_.LEAVE_WORD as LEAVE3_177_0_, privacy0_.INVITE as INVITE177_0_, privacy0_.SEARCH as SEARCH177_0_, privacy0_.VISITOR as VISITOR177_0_, privacy0_.INFO as INFO177_0_, privacy0_.CONTRACT as CONTRACT177_0_, privacy0_.INTEREST as INTEREST177_0_, privacy0_.TONE_SM as TONE10_177_0_ from T_SNS_PRIVACY privacy0_ where privacy0_.USER_ID=:1

cgvjk98hpf04s select rntransfer0_.id as id268_, rntransfer0_.phone_number as phone2_268_, rntransfer0_.last_update_time as last3_268_, rntransfer0_.area as area268_ from t_rbt_rn_transfer rntransfer0_ where rntransfer0_.phone_number=:1

ckxra82ndyduf update T_RBT_RECEIVE_SM set SERVICE_ID=:1, SERVICE_NO=:2, MSG_FORMAT=:3, CONTENT=:4, SRC_TERMINAL_ID=:5, DEST_TERMINAL_ID=:6, RECEIVE_TIME=:7, RETURN_CODE=:8, RETURN_INFO=:9, STATUS=:10, SMSEQ=:11, MODULECODE=:12, OPERATOR=:13, KEYCODE=:14, CSCODE=:15 where MSG_ID=:16

cmqhvqu3u4hd6 select SEQ_SYS_ACCESSLOGS.nextval from dual

cpu7jxxvxu36h BEGIN p_search_tone_keyword_engine ( :1, :2, :3, :4, :5, :6 ) ; END;

cx5cj03xss300 SELECT TONE_NAME_SINGER FROM (SELECT DISTINCT (TONE_NAME_SINGER) FROM (SELECT TONE_NAME_SINGER FROM (SELECT T.TONE_NAME_SINGER FROM T_RBT_ALL_TONE T WHERE T.TONE_NAME NOT LIKE :B3 AND T.TONE_NAME_PINYIN NOT LIKE :B2 AND T.TONE_NAME NOT LIKE :B1 AND T.TONE_NAME_SINGER LIKE :B1 AND T.TONE_VALID_DAY > SYSDATE AND T.UPLOAD_TYPE IN ('1', '9') AND T.STATUS = '1' ORDER BY T.ORDER_TIMES DESC) WHERE ROWNUM < :B4 )) WHERE ROWNUM < :B6 - :B5 + 1

dkya3u8g8r0w4 --lab128 select ts# ts_id, segfile# header_rfn, segblock# header_block, file# rfn, block# bl, length blocks from sys.uet$ union all select ktfbuesegtsn ts_id, ktfbuesegfno header_rfn, ktfbuesegbno header_block, ktfbuefno rfn, ktfbuebno bl, ktfbueblks blocks from x$ktfbue

gc0630hwkjzt9 select count(*) as col_0_0_ from T_RBT_ALL_TONE alltone0_ where 1=1 and (alltone0_.TONE_NAME_SINGER like :1) and (alltone0_.TONE_NAME like :2) and alltone0_.TONE_VALID_DAY>:3 and alltone0_.STATUS=:4 and alltone0_.UPLOAD_TYPE=:5

gfz3yuxt89hg5 SELECT TONE_NAME FROM (SELECT DISTINCT (TONE_NAME) FROM (SELECT TONE_NAME FROM (SELECT T.TONE_NAME FROM T_RBT_ALL_TONE T WHERE T.TONE_NAME NOT LIKE :B3 AND T.TONE_NAME LIKE :B2 AND T.TONE_NAME_PINYIN LIKE :B1 AND T.TONE_VALID_DAY > SYSDATE AND T.UPLOAD_TYPE IN ('1', '9') AND T.STATUS = '1' ORDER BY T.ORDER_TIMES DESC) WHERE ROWNUM < :B4 )) WHERE ROWNUM < :B6 - :B5 + 1

ggy6b3sbus8yx select count(*) as col_0_0_ from T_RBT_ALL_TONE alltone0_ where 1=1 and (alltone0_.SINGER_NAME not like :1) and (alltone0_.SINGER_NAME not like :2) and (alltone0_.SINGER_NAME not like :3) and (alltone0_.SINGER_NAME like :4) and alltone0_.TONE_VALID_DAY>:5 and alltone0_.STATUS=:6 and alltone0_.UPLOAD_TYPE=:7

SQL Id	SQL Text
0gajt9syvr63a	select TOTAL from T_RBT_STAT
0gy17xhghmu6g	select * from ( select ugctone0_.UTID as UTID183_, ugctone0_.PHONE_NUMBER as PHONE2_183_, ugctone0_.TONEID as TONEID183_, ugctone0_.TONECODE as TONECODE183_, ugctone0_.TONENAME as TONENAME183_, ugctone0_.TONENAMELETTER as TONENAME6_183_, ugctone0_.SINGER as SINGER183_, ugctone0_.SINGERSEX as SINGERSEX183_, ugctone0_.SINGERLETTER as SINGERLE9_183_, ugctone0_.UPLOADDATE as UPLOADDATE183_, ugctone0_.STATUS as STATUS183_, ugctone0_.INFO as INFO183_, ugctone0_.STORY as STORY183_, ugctone0_.REJECTTIMES as REJECTT14_183_, ugctone0_.TONEVALIDDAY as TONEVAL15_183_, ugctone0_.CATEGORY as CATEGORY183_, ugctone0_.ORDER_TIMES as ORDER17_183_, ugctone0_.TYPE as TYPE183_, ugctone0_.AUDITION_TIMES as AUDITION19_183_, ugctone0_.PUBLISH_TIMES as PUBLISH20_183_, ugctone0_.POPULARIZE as POPULARIZE183_, ugctone0_.POPULARIZE_STATE as POPULARIZE22_183_, ugctone0_.VISION_STATUS as VISION23_183_, ugctone0_.RECOMMEND_TIMES as RECOMMEND24_183_, ugctone0_.SHARE_TIMES as SHARE25_183_, ugctone0_.UPDATEDATE as UPDATEDATE183_, ugctone0_.CADENCE as CADENCE183_, ugctone0_.SENSIBILITY_EXPRESSION as SENSIBI28_183_, ugctone0_.MUSIC_TYPE as MUSIC29_183_, ugctone0_.LANGUAGE as LANGUAGE183_, ugctone0_.LISTEN_TO_WHO as LISTEN31_183_, ugctone0_.MUSICAL_INSTRUMENTS as MUSICAL32_183_, ugctone0_.SCENE as SCENE183_, ugctone0_.SUBJECT as SUBJECT183_, ugctone0_.TIMBRE as TIMBRE183_, ugctone0_.APPLAY_TIME as APPLAY36_183_, ugctone0_.APPLY_LANGUAGE as APPLY37_183_, ugctone0_.REJECTREASON as REJECTR38_183_, ugctone0_.REJECTDATE as REJECTDATE183_, ugctone0_.APPEAL_REASON as APPEAL40_183_, ugctone0_.APPEAL_DATE as APPEAL41_183_, ugctone0_.APPEAL_ADDRESS as APPEAL42_183_, ugctone0_.APPROVE_TIME as APPROVE43_183_, ugctone0_.HASSEARCHKEY as HASSEAR44_183_, ugctone0_.WAIT_REASON as WAIT45_183_, ugctone0_.WAIT_DATE as WAIT46_183_, ugctone0_.SUPDATE_DATE as SUPDATE47_183_, ugctone0_.CONCERT as CONCERT183_ from T_SNS_UGC_TONE ugctone0_ where 1=1 and ugctone0_.PHONE_NUMBER=:1 and ugctone0_.STATUS=:2 and (ugctone0_.AUDITION_TIMES is not null) order by ugctone0_.AUDITION_TIMES desc ) where rownum <= :3
0kj8y2dx5xz4p	select count(*) as col_0_0_ from T_SNS_NOTIFICATIONS notificati0_ where 1=1 and notificati0_.TYPE=:1 and notificati0_.TO_STATUS=:2
0kr4tvysfgh3t	SELECT SINGER_NAME FROM (SELECT DISTINCT (SINGER_NAME) FROM (SELECT SINGER_NAME FROM (SELECT T.SINGER_NAME FROM T_RBT_ALL_TONE T WHERE T.SINGER_NAME LIKE :B1 AND T.TONE_VALID_DAY > SYSDATE AND T.UPLOAD_TYPE IN ('1', '9') AND T.STATUS = '1' ORDER BY T.ORDER_TIMES DESC) WHERE ROWNUM < :B2 )) WHERE ROWNUM < :B3 + 1
0v7k1jjnrk5v3	SELECT SINGER_NAME FROM (SELECT DISTINCT (SINGER_NAME) FROM (SELECT SINGER_NAME FROM (SELECT T.SINGER_NAME FROM T_RBT_ALL_TONE T WHERE T.SINGER_NAME NOT LIKE :B3 AND T.SINGER_NAME_PINYIN NOT LIKE :B2 AND T.SINGER_NAME LIKE :B1 AND T.TONE_VALID_DAY > SYSDATE AND T.UPLOAD_TYPE IN ('1', '9') AND T.STATUS = '1' ORDER BY T.ORDER_TIMES DESC) WHERE ROWNUM < :B4 )) WHERE ROWNUM < :B6 - :B5 + 1
11y16nd2r3fu9	select * from ( select ugctone0_.UTID as UTID183_, ugctone0_.PHONE_NUMBER as PHONE2_183_, ugctone0_.TONEID as TONEID183_, ugctone0_.TONECODE as TONECODE183_, ugctone0_.TONENAME as TONENAME183_, ugctone0_.TONENAMELETTER as TONENAME6_183_, ugctone0_.SINGER as SINGER183_, ugctone0_.SINGERSEX as SINGERSEX183_, ugctone0_.SINGERLETTER as SINGERLE9_183_, ugctone0_.UPLOADDATE as UPLOADDATE183_, ugctone0_.STATUS as STATUS183_, ugctone0_.INFO as INFO183_, ugctone0_.STORY as STORY183_, ugctone0_.REJECTTIMES as REJECTT14_183_, ugctone0_.TONEVALIDDAY as TONEVAL15_183_, ugctone0_.CATEGORY as CATEGORY183_, ugctone0_.ORDER_TIMES as ORDER17_183_, ugctone0_.TYPE as TYPE183_, ugctone0_.AUDITION_TIMES as AUDITION19_183_, ugctone0_.PUBLISH_TIMES as PUBLISH20_183_, ugctone0_.POPULARIZE as POPULARIZE183_, ugctone0_.POPULARIZE_STATE as POPULARIZE22_183_, ugctone0_.VISION_STATUS as VISION23_183_, ugctone0_.RECOMMEND_TIMES as RECOMMEND24_183_, ugctone0_.SHARE_TIMES as SHARE25_183_, ugctone0_.UPDATEDATE as UPDATEDATE183_, ugctone0_.CADENCE as CADENCE183_, ugctone0_.SENSIBILITY_EXPRESSION as SENSIBI28_183_, ugctone0_.MUSIC_TYPE as MUSIC29_183_, ugctone0_.LANGUAGE as LANGUAGE183_, ugctone0_.LISTEN_TO_WHO as LISTEN31_183_, ugctone0_.MUSICAL_INSTRUMENTS as MUSICAL32_183_, ugctone0_.SCENE as SCENE183_, ugctone0_.SUBJECT as SUBJECT183_, ugctone0_.TIMBRE as TIMBRE183_, ugctone0_.APPLAY_TIME as APPLAY36_183_, ugctone0_.APPLY_LANGUAGE as APPLY37_183_, ugctone0_.REJECTREASON as REJECTR38_183_, ugctone0_.REJECTDATE as REJECTDATE183_, ugctone0_.APPEAL_REASON as APPEAL40_183_, ugctone0_.APPEAL_DATE as APPEAL41_183_, ugctone0_.APPEAL_ADDRESS as APPEAL42_183_, ugctone0_.APPROVE_TIME as APPROVE43_183_, ugctone0_.HASSEARCHKEY as HASSEAR44_183_, ugctone0_.WAIT_REASON as WAIT45_183_, ugctone0_.WAIT_DATE as WAIT46_183_, ugctone0_.SUPDATE_DATE as SUPDATE47_183_, ugctone0_.CONCERT as CONCERT183_ from T_SNS_UGC_TONE ugctone0_ where 1=1 and ugctone0_.STATUS=:1 order by ugctone0_.UPDATEDATE desc ) where rownum <= :2
1a5x7hwwfd1tu	--lab128 select --+rule latch#, sum(gets) gets, sum(misses) misses, sum(sleeps) sleeps, sum(immediate_gets) immediate_gets, sum(immediate_misses) immediate_misses, sum(waits_holding_latch) waits_holding_latch, sum(spin_gets) spin_gets from v$latch_children where misses+immediate_misses>100 group by latch#
1h1yf5kaxn7yg	select ugcmusic0_.UTID as UTID185_0_, ugcmusic0_.PRICE as PRICE185_0_, ugcmusic0_.MUSIC_ADDRESS as MUSIC3_185_0_, ugcmusic0_.FILE_SIZE as FILE4_185_0_ from T_SNS_UGC_MUSIC ugcmusic0_ where ugcmusic0_.UTID=:1
1rbdshj6h2ru1	INSERT INTO T_RBT_USER_BEING (SELECT T.RESOURCE_ID TONE_ID, T.PHONE_NUMBER PHONE_NUMBER, T.DOWNLOAD_TIME DO_TIME, '??' TYPE, SYSDATE CREATE_TIME FROM (SELECT * FROM T_RBT_ORDER_TONE_LOGS R WHERE R.RETURN_CODE = '000000' AND R.RESOURCE_TYPE = 1 ORDER BY R.DOWNLOAD_TIME DESC) T WHERE ROWNUM <= :B1 )
1t5t8j5d3dgnw	select * from ( select ugcauditio0_.TONE_ID as col_0_0_ from T_SNS_UGC_AUDITION_TONE_LOGS ugcauditio0_, T_SNS_UGC_TONE ugctone1_ where ugctone1_.TONEID=ugcauditio0_.TONE_ID and (ugctone1_.PHONE_NUMBER not in ('15159776679' , '15159776680' , '15159776681' , '15159776682' , '15159776683' , '15159776684' , '15159776685' , '15860312530' , '18859112530' , '15960800011' , '11111111111')) and ugcauditio0_.AUDITION_DATE>=:1 and ugcauditio0_.AUDITION_DATE<:2 and ugctone1_.STATUS=:3 group by ugcauditio0_.TONE_ID order by count(ugcauditio0_.ID) desc ) where rownum <= :4
242dkf73atqpf	select * from ( select userinfo0_.USER_ID as USER1_178_, userinfo0_.PHONE_NUMBER as PHONE2_178_, userinfo0_.EMAIL as EMAIL178_, userinfo0_.NICKNAME as NICKNAME178_, userinfo0_.NAME as NAME178_, userinfo0_.SPACE_NAME as SPACE6_178_, userinfo0_.SPACE_INTRO as SPACE7_178_, userinfo0_.SEX as SEX178_, userinfo0_.BIRTHDAY as BIRTHDAY178_, userinfo0_.PASSWORD as PASSWORD178_, userinfo0_.COUNTRY as COUNTRY178_, userinfo0_.PROVINCE as PROVINCE178_, userinfo0_.CITY as CITY178_, userinfo0_.COMPANY_NAME as COMPANY14_178_, userinfo0_.ADDRESS as ADDRESS178_, userinfo0_.TEL as TEL178_, userinfo0_.QQ as QQ178_, userinfo0_.MSN as MSN178_, userinfo0_.TINY_URL as TINY19_178_, userinfo0_.HEAD_URL as HEAD20_178_, userinfo0_.MAIN_URL as MAIN21_178_, userinfo0_.MUSICE_TYPE as MUSICE22_178_, userinfo0_.LIKE_SINGER as LIKE23_178_, userinfo0_.STATUS as STATUS178_, userinfo0_.TYPE as TYPE178_, userinfo0_.RECENT as RECENT178_, userinfo0_.LAST_UPDATE_RECENT_DATE as LAST27_178_, userinfo0_.INTEGRAL as INTEGRAL178_, userinfo0_.ON_LINE as ON29_178_, userinfo0_.CREATE_DATE as CREATE30_178_, userinfo0_.LAST_UPDATE_DATE as LAST31_178_, userinfo0_.REMARK as REMARK178_, userinfo0_.MODULE_CODE as MODULE33_178_, userinfo0_.CADENCE as CADENCE178_, userinfo0_.SENSIBILITY_EXPRESSION as SENSIBI35_178_, userinfo0_.MUSIC_TYPE as MUSIC36_178_, userinfo0_.LANGUAGE as LANGUAGE178_, userinfo0_.LISTEN_TO_WHO as LISTEN38_178_, userinfo0_.MUSICAL_INSTRUMENTS as MUSICAL39_178_, userinfo0_. SCENE as SCENE178_, userinfo0_.SUBJECT as SUBJECT178_, userinfo0_.TIMBRE as TIMBRE178_, userinfo0_.INFO as INFO178_, userinfo0_.ISFIRST as ISFIRST178_, userinfo0_.FEIXIN_URL as FEIXIN45_178_, userinfo0_.ADD_V_USER as ADD46_178_, userinfo0_.ADD_V_CONTENT as ADD47_178_ from T_SNS_USER_INFO userinfo0_ where 1=1 and userinfo0_.PHONE_NUMBER=:1 and userinfo0_.STATUS<>3 ) where rownum <= :2
2cvda584xjrqw	select count(*) as col_0_0_ from T_RBT_ALL_TONE alltone0_ where 1=1 and (alltone0_.TONE_NAME not like :1) and (alltone0_.TONE_NAME_SINGER not like :2) and (alltone0_.TONE_NAME_SINGER not like :3) and (alltone0_.TONE_NAME_SINGER like :4) and (alltone0_.TONE_NAME like :5) and alltone0_.TONE_VALID_DAY>:6 and alltone0_.STATUS=:7 and alltone0_.UPLOAD_TYPE=:8
2ht08a4ctcv8g	select feedaction2_.USER_ID as col_0_0_ from T_SNS_FEED_TARGETS feedtarget0_, T_SNS_FEED_ACTIONS feedaction2_, T_SNS_USER_LAST_FEEDLOG userlastfe1_ where feedtarget0_.FEED_ACTION_ID=feedaction2_.ID and feedtarget0_.USER_ID=userlastfe1_.USER_ID and feedtarget0_.USER_ID=:1 and feedtarget0_.STATUS<>:2 and (feedaction2_.RELATIONS_ID=:3 or feedaction2_.RELATIONS_ID=:4 or feedaction2_.RELATIONS_ID=:5 or feedaction2_.RELATIONS_ID=:6 or feedaction2_.RELATIONS_ID=:7 or feedaction2_.RELATIONS_ID=:8 or feedaction2_.RELATIONS_ID=:9 or feedaction2_.RELATIONS_ID=:10 or feedaction2_.RELATIONS_ID=:11 or feedaction2_.RELATIONS_ID=:12 or feedaction2_.RELATIONS_ID=:13) order by feedaction2_.PUBLISH_DATE desc
360dut0ds5n1d	select tt.content, tt.ct, rownum rn from (select t.content, count(1) as ct from t_rbt_search_log t where t.type=11 group by t.content order by ct desc) tt where rownum < 51
36704j2yztr6n	update T_SNS_UGC_TONE set PHONE_NUMBER=:1, TONEID=:2, TONECODE=:3, TONENAME=:4, TONENAMELETTER=:5, SINGER=:6, SINGERSEX=:7, SINGERLETTER=:8, UPLOADDATE=:9, STATUS=:10, INFO=:11, STORY=:12, REJECTTIMES=:13, TONEVALIDDAY=:14, CATEGORY=:15, ORDER_TIMES=:16, TYPE=:17, AUDITION_TIMES=:18, PUBLISH_TIMES=:19, POPULARIZE=:20, POPULARIZE_STATE=:21, VISION_STATUS=:22, RECOMMEND_TIMES=:23, SHARE_TIMES=:24, UPDATEDATE=:25, CADENCE=:26, SENSIBILITY_EXPRESSION=:27, MUSIC_TYPE=:28, LANGUAGE=:29, LISTEN_TO_WHO=:30, MUSICAL_INSTRUMENTS=:31, SCENE=:32, SUBJECT=:33, TIMBRE=:34, APPLAY_TIME=:35, APPLY_LANGUAGE=:36, REJECTREASON=:37, REJECTDATE=:38, APPEAL_REASON=:39, APPEAL_DATE=:40, APPEAL_ADDRESS=:41, APPROVE_TIME=:42, HASSEARCHKEY=:43, WAIT_REASON=:44, WAIT_DATE=:45, SUPDATE_DATE=:46, CONCERT=:47 where UTID=:48
3byt73wt3hnan	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN p_boss_sync_down_tone_data; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
3gc1c8r2wn9r1	SELECT TONE_NAME FROM (SELECT DISTINCT (TONE_NAME) FROM (SELECT TONE_NAME FROM (SELECT T.TONE_NAME FROM T_RBT_ALL_TONE T WHERE T.TONE_NAME NOT LIKE :B3 AND T.TONE_NAME_PINYIN NOT LIKE :B2 AND T.TONE_NAME LIKE :B1 AND T.TONE_VALID_DAY > SYSDATE AND T.UPLOAD_TYPE IN ('1', '9') AND T.STATUS = '1' ORDER BY T.ORDER_TIMES DESC) WHERE ROWNUM < :B4 )) WHERE ROWNUM < :B6 - :B5 + 1
4219a0a7ba7x1	select tt.content, tt.ct, rownum rn from (select t.content, count(1) as ct from t_rbt_search_log t where (instr(t.content, '\|') = 0) and (instr(t.content, ':') = 0) and (instr(t.content, '?') = 0) and t.type=11 group by t.content order by ct desc) tt where rownum < 51
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4pwjpx607and5	SELECT SYNC.* FROM T_RBT_SM_RING_SYNC SYNC WHERE SYNC.CREATE_DATE > :B3 AND SYNC.START_TIME < :B3 + 1/24 AND SYNC.PHONE_NUMBER = :B2 AND SYNC.RING_ID = :B1 AND SYNC.RING_TYPE = 1 AND (SYNC.EUR_CUP_TYPE <> 1 OR SYNC.EUR_CUP_TYPE IS NULL) AND ROWNUM < 2
5g7j8a21fr14b	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN p_user_last_being; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
62x4mpf6cgj03	select count(*) as col_0_0_ from T_RBT_ALL_TONE alltone0_ where 1=1 and (alltone0_.SINGER_NAME like :1) and alltone0_.TONE_VALID_DAY>:2 and alltone0_.STATUS=:3 and alltone0_.UPLOAD_TYPE=:4
6azf2fn46477k	select * from ( select alltone0_.TONE_ID as TONE1_275_, alltone0_.TONE_CODE as TONE2_275_, alltone0_.TONE_CODE_LONG as TONE3_275_, alltone0_.STATUS as STATUS275_, alltone0_.TONE_NAME as TONE5_275_, alltone0_.TONE_NAME_LETTER as TONE6_275_, alltone0_.TONE_NAME_PINYIN as TONE7_275_, alltone0_.TONE_NAME_SINGER as TONE8_275_, alltone0_.TONE_NAME_SINGER_PINYIN as TONE9_275_, alltone0_.SINGER_NAME as SINGER10_275_, alltone0_.SINGER_SEX as SINGER11_275_, alltone0_.SINGER_NAME_LETTER as SINGER12_275_, alltone0_.SINGER_NAME_PINYIN as SINGER13_275_, alltone0_.LANGUAGE as LANGUAGE275_, alltone0_.CP_CODE as CP15_275_, alltone0_.CP_NAME as CP16_275_, alltone0_.CORP_CODE as CORP17_275_, alltone0_.CORP_NAME as CORP18_275_, alltone0_.PRICE as PRICE275_, alltone0_.UPLOAD_TYPE as UPLOAD20_275_, alltone0_.DIY_USER_PHONE_NUMBER as DIY21_275_, alltone0_.ORDER_TIMES as ORDER22_275_, alltone0_.LISTEN_TIMES as LISTEN23_275_, alltone0_.TONE_VALID_DAY as TONE24_275_, alltone0_.UPDATE_TIME as UPDATE25_275_, alltone0_.UPLOAD_TIME as UPLOAD26_275_, alltone0_.CREATE_TIME as CREATE27_275_ from T_RBT_ALL_TONE alltone0_ where 1=1 and (alltone0_.SINGER_NAME like :1) and alltone0_.TONE_VALID_DAY>:2 and alltone0_.STATUS=:3 and alltone0_.UPLOAD_TYPE=:4 order by alltone0_.ORDER_TIMES desc ) where rownum <= :5
7cddggs1rvtfs	select receiversm0_.MSG_ID as MSG1_46_, receiversm0_.SERVICE_ID as SERVICE2_46_, receiversm0_.SERVICE_NO as SERVICE3_46_, receiversm0_.MSG_FORMAT as MSG4_46_, receiversm0_.CONTENT as CONTENT46_, receiversm0_.SRC_TERMINAL_ID as SRC6_46_, receiversm0_.DEST_TERMINAL_ID as DEST7_46_, receiversm0_.RECEIVE_TIME as RECEIVE8_46_, receiversm0_.RETURN_CODE as RETURN9_46_, receiversm0_.RETURN_INFO as RETURN10_46_, receiversm0_.STATUS as STATUS46_, receiversm0_.SMSEQ as SMSEQ46_, receiversm0_.MODULECODE as MODULECODE46_, receiversm0_.OPERATOR as OPERATOR46_, receiversm0_.KEYCODE as KEYCODE46_, receiversm0_.CSCODE as CSCODE46_ from T_RBT_RECEIVE_SM receiversm0_ where receiversm0_.RECEIVE_TIME<:1 and receiversm0_.STATUS<>:2 and (receiversm0_.CONTENT like 'QL%')
846hr6j8gpa8h	select ugcring0_.UTID as UTID184_0_, ugcring0_.PRICE as PRICE184_0_, ugcring0_.RING_ADDRESS as RING3_184_0_, ugcring0_.FILE_SIZE as FILE4_184_0_, ugcring0_.MODULE_CODE as MODULE5_184_0_, ugcring0_.FAN_SING_NAME as FAN6_184_0_, ugcring0_.FAN_SING_AUTHOR as FAN7_184_0_, ugcring0_.FAN_SINGER as FAN8_184_0_, ugcring0_.IDCARD as IDCARD184_0_, ugcring0_.SING_AUTHOR as SING10_184_0_, ugcring0_.OPERN as OPERN184_0_, ugcring0_.SING_MATERIAL as SING12_184_0_, ugcring0_.FAN_LYRIC_AUTHOR as FAN13_184_0_, ugcring0_.LYRIC_AUTHOR as LYRIC14_184_0_, ugcring0_.OTHER_REFERENCE as OTHER15_184_0_, ugcring0_.OTHER_AUTHOR as OTHER16_184_0_, ugcring0_.COMPANY_NAME as COMPANY17_184_0_, ugcring0_.BACK_MUSIC as BACK18_184_0_, ugcring0_.COPYRIGHT_FILE as COPYRIGHT19_184_0_ from T_SNS_UGC_RING ugcring0_ where ugcring0_.UTID=:1
8mxk2wj1cryt8	SELECT TONE_NAME FROM (SELECT DISTINCT (TONE_NAME) FROM (SELECT TONE_NAME FROM (SELECT T.TONE_NAME FROM T_RBT_ALL_TONE T WHERE T.TONE_NAME LIKE :B1 AND T.TONE_VALID_DAY > SYSDATE AND T.UPLOAD_TYPE IN ('1', '9') AND T.STATUS = '1' ORDER BY T.ORDER_TIMES DESC) WHERE ROWNUM < :B2 )) WHERE ROWNUM < :B3 + 1
9ku8ak57mnjzk	select handbooklo0_.ID as ID217_, handbooklo0_.PHONE_NUMBER as PHONE2_217_, handbooklo0_.SEND_TAG as SEND3_217_, handbooklo0_.REMARK as REMARK217_, handbooklo0_.RECORD_TIME as RECORD5_217_, handbooklo0_.SEND_TIME as SEND6_217_, handbooklo0_.MODIFY_TIME as MODIFY7_217_ from T_RBT_HANDBOOK_LOG handbooklo0_ where handbooklo0_.PHONE_NUMBER=:1
axu9hf2wu97j7	select account0_.USER_ID as USER1_162_0_, account0_.INTEGRAL as INTEGRAL162_0_, account0_.MONEY as MONEY162_0_, account0_.LAST_UPDATE_TIME as LAST4_162_0_ from T_SNS_ACCOUNTS account0_ where account0_.USER_ID=:1
ay1v7ux00rqs3	select privacy0_.USER_ID as USER1_177_0_, privacy0_.HOME_PAGE as HOME2_177_0_, privacy0_.LEAVE_WORD as LEAVE3_177_0_, privacy0_.INVITE as INVITE177_0_, privacy0_.SEARCH as SEARCH177_0_, privacy0_.VISITOR as VISITOR177_0_, privacy0_.INFO as INFO177_0_, privacy0_.CONTRACT as CONTRACT177_0_, privacy0_.INTEREST as INTEREST177_0_, privacy0_.TONE_SM as TONE10_177_0_ from T_SNS_PRIVACY privacy0_ where privacy0_.USER_ID=:1
cgvjk98hpf04s	select rntransfer0_.id as id268_, rntransfer0_.phone_number as phone2_268_, rntransfer0_.last_update_time as last3_268_, rntransfer0_.area as area268_ from t_rbt_rn_transfer rntransfer0_ where rntransfer0_.phone_number=:1
ckxra82ndyduf	update T_RBT_RECEIVE_SM set SERVICE_ID=:1, SERVICE_NO=:2, MSG_FORMAT=:3, CONTENT=:4, SRC_TERMINAL_ID=:5, DEST_TERMINAL_ID=:6, RECEIVE_TIME=:7, RETURN_CODE=:8, RETURN_INFO=:9, STATUS=:10, SMSEQ=:11, MODULECODE=:12, OPERATOR=:13, KEYCODE=:14, CSCODE=:15 where MSG_ID=:16
cmqhvqu3u4hd6	select SEQ_SYS_ACCESSLOGS.nextval from dual
cpu7jxxvxu36h	BEGIN p_search_tone_keyword_engine ( :1, :2, :3, :4, :5, :6 ) ; END;
cx5cj03xss300	SELECT TONE_NAME_SINGER FROM (SELECT DISTINCT (TONE_NAME_SINGER) FROM (SELECT TONE_NAME_SINGER FROM (SELECT T.TONE_NAME_SINGER FROM T_RBT_ALL_TONE T WHERE T.TONE_NAME NOT LIKE :B3 AND T.TONE_NAME_PINYIN NOT LIKE :B2 AND T.TONE_NAME NOT LIKE :B1 AND T.TONE_NAME_SINGER LIKE :B1 AND T.TONE_VALID_DAY > SYSDATE AND T.UPLOAD_TYPE IN ('1', '9') AND T.STATUS = '1' ORDER BY T.ORDER_TIMES DESC) WHERE ROWNUM < :B4 )) WHERE ROWNUM < :B6 - :B5 + 1
dkya3u8g8r0w4	--lab128 select ts# ts_id, segfile# header_rfn, segblock# header_block, file# rfn, block# bl, length blocks from sys.uet$ union all select ktfbuesegtsn ts_id, ktfbuesegfno header_rfn, ktfbuesegbno header_block, ktfbuefno rfn, ktfbuebno bl, ktfbueblks blocks from x$ktfbue
gc0630hwkjzt9	select count(*) as col_0_0_ from T_RBT_ALL_TONE alltone0_ where 1=1 and (alltone0_.TONE_NAME_SINGER like :1) and (alltone0_.TONE_NAME like :2) and alltone0_.TONE_VALID_DAY>:3 and alltone0_.STATUS=:4 and alltone0_.UPLOAD_TYPE=:5
gfz3yuxt89hg5	SELECT TONE_NAME FROM (SELECT DISTINCT (TONE_NAME) FROM (SELECT TONE_NAME FROM (SELECT T.TONE_NAME FROM T_RBT_ALL_TONE T WHERE T.TONE_NAME NOT LIKE :B3 AND T.TONE_NAME LIKE :B2 AND T.TONE_NAME_PINYIN LIKE :B1 AND T.TONE_VALID_DAY > SYSDATE AND T.UPLOAD_TYPE IN ('1', '9') AND T.STATUS = '1' ORDER BY T.ORDER_TIMES DESC) WHERE ROWNUM < :B4 )) WHERE ROWNUM < :B6 - :B5 + 1
ggy6b3sbus8yx	select count(*) as col_0_0_ from T_RBT_ALL_TONE alltone0_ where 1=1 and (alltone0_.SINGER_NAME not like :1) and (alltone0_.SINGER_NAME not like :2) and (alltone0_.SINGER_NAME not like :3) and (alltone0_.SINGER_NAME like :4) and alltone0_.TONE_VALID_DAY>:5 and alltone0_.STATUS=:6 and alltone0_.UPLOAD_TYPE=:7

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	1,377,047	379.64	82.94
CPU used when call started	1,379,482	380.31	83.09
CR blocks created	6,281	1.73	0.38
Cached Commit SCN referenced	8,505	2.34	0.51
Commit SCN cached	2	0.00	0.00
DB time	11,791,232	3,250.74	710.23
DBWR checkpoint buffers written	11,722	3.23	0.71
DBWR checkpoints	1	0.00	0.00
DBWR fusion writes	6	0.00	0.00
DBWR object drop buffers written	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	154	0.04	0.01
DBWR undo block writes	2,249	0.62	0.14
DFO trees parallelized	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
PX remote messages recv'd	0	0.00	0.00
PX remote messages sent	0	0.00	0.00
Parallel operations downgraded to serial	123	0.03	0.01
Parallel operations not downgraded	0	0.00	0.00
RowCR - row contention	7	0.00	0.00
RowCR attempts	363	0.10	0.02
RowCR hits	406	0.11	0.02
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	2	0.00	0.00
SQL*Net roundtrips to/from client	333,840	92.04	20.11
active txn count during cleanout	9,574	2.64	0.58
application wait time	91,328	25.18	5.50
background checkpoints completed	1	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	15,438	4.26	0.93
branch node splits	0	0.00	0.00
buffer is not pinned count	32,371,721	8,924.62	1,949.87
buffer is pinned count	135,188,333	37,270.30	8,142.89
bytes received via SQL*Net from client	108,343,788	29,869.48	6,525.95
bytes sent via SQL*Net to client	139,108,849	38,351.16	8,379.04
calls to get snapshot scn: kcmgss	438,266	120.83	26.40
calls to kcmgas	39,606	10.92	2.39
calls to kcmgcs	652	0.18	0.04
change write time	590	0.16	0.04
cleanout - number of ktugct calls	8,748	2.41	0.53
cleanouts and rollbacks - consistent read gets	3,893	1.07	0.23
cleanouts only - consistent read gets	13	0.00	0.00
cluster key scan block gets	16,300	4.49	0.98
cluster key scans	4,804	1.32	0.29
cluster wait time	1,191	0.33	0.07
commit batch/immediate performed	11	0.00	0.00
commit batch/immediate requested	11	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	8	0.00	0.00
commit cleanout failures: callback failure	45	0.01	0.00
commit cleanout failures: cannot pin	4	0.00	0.00
commit cleanouts	54,372	14.99	3.28
commit cleanouts successfully completed	54,315	14.97	3.27
commit immediate performed	11	0.00	0.00
commit immediate requested	11	0.00	0.00
commit txn count during cleanout	4,651	1.28	0.28
concurrency wait time	892,064	245.93	53.73
consistent changes	13,782	3.80	0.83
consistent gets	248,348,583	68,467.65	14,958.96
consistent gets - examination	571,881	157.66	34.45
consistent gets direct	15	0.00	0.00
consistent gets from cache	248,348,569	68,467.64	14,958.95
current blocks converted for CR	0	0.00	0.00
cursor authentications	499	0.14	0.03
data blocks consistent reads - undo records applied	13,699	3.78	0.83
db block changes	201,775	55.63	12.15
db block gets	266,264	73.41	16.04
db block gets direct	211	0.06	0.01
db block gets from cache	266,053	73.35	16.03
deferred (CURRENT) block cleanout applications	20,424	5.63	1.23
dirty buffers inspected	0	0.00	0.00
enqueue conversions	4,670	1.29	0.28
enqueue releases	234,793	64.73	14.14
enqueue requests	234,926	64.77	14.15
enqueue timeouts	130	0.04	0.01
enqueue waits	2,300	0.63	0.14
exchange deadlocks	0	0.00	0.00
execute count	224,770	61.97	13.54
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	1,562,511	430.77	94.12
free buffer requested	1,548,862	427.01	93.29
gc CPU used by this session	1,313	0.36	0.08
gc blocks lost	0	0.00	0.00
gc cr block build time	0	0.00	0.00
gc cr block flush time	0	0.00	0.00
gc cr block receive time	0	0.00	0.00
gc cr block send time	0	0.00	0.00
gc cr blocks received	0	0.00	0.00
gc cr blocks served	0	0.00	0.00
gc current block flush time	0	0.00	0.00
gc current block pin time	0	0.00	0.00
gc current block receive time	0	0.00	0.00
gc current block send time	0	0.00	0.00
gc current blocks received	0	0.00	0.00
gc current blocks served	0	0.00	0.00
gc local grants	1,542,021	425.12	92.88
gc remote grants	0	0.00	0.00
gcs messages sent	0	0.00	0.00
ges messages sent	0	0.00	0.00
global enqueue get time	83,539	23.03	5.03
global enqueue gets async	12,583	3.47	0.76
global enqueue gets sync	56,627	15.61	3.41
global enqueue releases	58,541	16.14	3.53
heap block compress	381	0.11	0.02
hot buffers moved to head of LRU	10,353	2.85	0.62
immediate (CR) block cleanout applications	3,906	1.08	0.24
immediate (CURRENT) block cleanout applications	7,638	2.11	0.46
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	5,453	1.50	0.33
index fast full scans (full)	218	0.06	0.01
index fetch by key	188,739	52.03	11.37
index scans kdiixs1	113,069	31.17	6.81
leaf node 90-10 splits	107	0.03	0.01
leaf node splits	220	0.06	0.01
lob reads	388	0.11	0.02
lob writes	220	0.06	0.01
lob writes unaligned	220	0.06	0.01
logons cumulative	336	0.09	0.02
messages received	27,565	7.60	1.66
messages sent	27,565	7.60	1.66
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	247,576,932	68,254.91	14,912.48
opened cursors cumulative	190,772	52.59	11.49
parse count (failures)	176	0.05	0.01
parse count (hard)	1,232	0.34	0.07
parse count (total)	183,976	50.72	11.08
parse time cpu	553	0.15	0.03
parse time elapsed	84,917	23.41	5.11
physical read IO requests	343,878	94.80	20.71
physical read bytes	12,773,105,664	3,521,439.35	769,371.50
physical read total IO requests	354,228	97.66	21.34
physical read total bytes	12,985,774,080	3,580,070.27	782,181.31
physical read total multi block requests	84,156	23.20	5.07
physical reads	1,559,218	429.86	93.92
physical reads cache	1,540,842	424.80	92.81
physical reads cache prefetch	1,199,397	330.66	72.24
physical reads direct	18,375	5.07	1.11
physical reads direct (lob)	14	0.00	0.00
physical reads direct temporary tablespace	18,232	5.03	1.10
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	13,406	3.70	0.81
physical write bytes	269,533,184	74,308.06	16,234.98
physical write total IO requests	35,909	9.90	2.16
physical write total bytes	450,179,072	124,110.64	27,115.95
physical write total multi block requests	16,962	4.68	1.02
physical writes	32,902	9.07	1.98
physical writes direct	21,130	5.83	1.27
physical writes direct (lob)	1	0.00	0.00
physical writes direct temporary tablespace	20,843	5.75	1.26
physical writes from cache	11,772	3.25	0.71
physical writes non checkpoint	25,279	6.97	1.52
pinned buffers inspected	9,505	2.62	0.57
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	3,728	1.03	0.22
queries parallelized	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	466,376	128.58	28.09
recursive cpu usage	745,026	205.40	44.88
redo blocks read for recovery	0	0.00	0.00
redo blocks written	48,718	13.43	2.93
redo buffer allocation retries	19	0.01	0.00
redo entries	110,088	30.35	6.63
redo log space requests	76	0.02	0.00
redo log space wait time	7,983	2.20	0.48
redo ordering marks	2,585	0.71	0.16
redo size	43,973,752	12,123.20	2,648.70
redo subscn max counts	3,828	1.06	0.23
redo synch time	929,767	256.33	56.00
redo synch writes	15,941	4.39	0.96
redo wastage	5,117,696	1,410.91	308.26
redo write time	196,534	54.18	11.84
redo writer latching time	156	0.04	0.01
redo writes	10,122	2.79	0.61
rollback changes - undo records applied	44	0.01	0.00
rollbacks only - consistent read gets	2,422	0.67	0.15
rows fetched via callback	84,923	23.41	5.12
session connect time	0	0.00	0.00
session cursor cache hits	159,289	43.91	9.59
session logical reads	248,614,844	68,541.05	14,974.99
session pga memory	326,545,104	90,025.78	19,669.02
session pga memory max	315,397,680	86,952.53	18,997.57
session uga memory	###############	86,445,441.36	18,886,782.48
session uga memory max	1,380,709,608	380,650.19	83,165.26
shared hash latch upgrades - no wait	7,335	2.02	0.44
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	10	0.00	0.00
sorts (memory)	52,986	14.61	3.19
sorts (rows)	379,789,033	104,704.69	22,876.10
sql area evicted	1,775	0.49	0.11
sql area purged	0	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	473	0.13	0.03
table fetch by rowid	83,520,664	23,025.95	5,030.76
table fetch continued row	32,592	8.99	1.96
table scan blocks gotten	187,356,094	51,652.52	11,285.15
table scan rows gotten	5,325,041,478	1,468,069.79	320,746.99
table scans (long tables)	29	0.01	0.00
table scans (short tables)	32,736	9.03	1.97
total number of times SMON posted	77	0.02	0.00
transaction lock background gets	6	0.00	0.00
transaction lock foreground requests	6	0.00	0.00
transaction lock foreground wait time	236	0.07	0.01
transaction rollbacks	11	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	17,610,240	4,855.00	1,060.73
user I/O wait time	3,331,892	918.58	200.69
user calls	493,585	136.08	29.73
user commits	10,863	2.99	0.65
user rollbacks	5,739	1.58	0.35
workarea executions - onepass	20	0.01	0.00
workarea executions - optimal	29,455	8.12	1.77
write clones created in background	1	0.00	0.00
write clones created in foreground	60	0.02	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	2,149,148	2,154,290
opened cursors current	2,406	2,778
workarea memory allocated	44,949	54,132
logons current	292	317

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	0.99

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
RBT	318,192	88	49.80	4.72	4,847	1	131,350	133.62
RBTIDX	16,634	5	84.40	1.00	2,896	1	904	291.19
TEMP	2,378	1	0.00	7.76	5,118	1	0	0.00
SYSAUX	3,359	1	177.87	1.00	612	0	0	0.00
SYSTEM	1,220	0	231.17	1.00	107	0	24	879.17
UNDOTBS2	445	0	114.07	1.00	1	0	0	0.00
UNDOTBS1	3	0	200.00	1.00	423	0	3	36.67
RBTHIS	18	0	0.00	1.00	6	0	0	0.00
RBTHISIDX	9	0	0.00	1.00	3	0	0	0.00
USERS	7	0	132.86	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 Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
RBT	+DG01/portal/datafile/rbt_data01.ora	4,335	1	123.26	14.07	206	0	115	574.43
RBT	+DG01/portal/datafile/rbt_data02.ora	4,313	1	101.76	14.34	244	0	158	569.30
RBT	+DG01/portal/datafile/rbt_data03.ora	4,907	1	114.11	14.08	307	0	116	520.26
RBT	+DG01/portal/datafile/rbt_data04.ora	5,019	1	115.94	13.96	225	0	278	396.87
RBT	+DG01/portal/datafile/rbt_data05.ora	4,287	1	124.34	14.22	177	0	90	766.89
RBT	+DG01/portal/datafile/rbt_data06.ora	4,189	1	98.91	14.43	188	0	96	498.54
RBT	+DG01/portal/datafile/rbt_data07.ora	4,211	1	108.64	14.47	209	0	226	365.97
RBT	+DG01/portal/datafile/rbt_data08.ora	803	0	86.80	11.80	15	0	0	0.00
RBT	+DG01/portal/datafile/rbt_data09.ora	829	0	129.24	13.20	23	0	1,131	539.27
RBT	+DG01/portal/datafile/rbt_data10.ora	828	0	139.44	13.02	18	0	997	590.24
RBT	+DG01/portal/datafile/rbt_data11.ora	706	0	101.86	15.22	8	0	1,091	553.67
RBT	+DG01/portal/datafile/rbt_data12.ora	7,030	2	144.49	5.43	32	0	6,790	207.81
RBT	+DG01/portal/datafile/rbt_data13.ora	13,337	4	41.68	3.72	22	0	6,948	154.50
RBT	+DG01/portal/datafile/rbt_data14.ora	14,146	4	35.18	3.38	40	0	7,876	183.93
RBT	+DG01/portal/datafile/rbt_data15.ora	14,784	4	33.87	4.01	58	0	9,576	210.52
RBT	+DG01/portal/datafile/rbt_data16.ora	45,054	12	59.48	2.41	53	0	9,052	97.20
RBT	+DG01/portal/datafile/rbt_data17.ora	46,215	13	14.39	2.42	47	0	9,361	98.72
RBT	+DG01/portal/datafile/rbt_data18.ora	44,129	12	31.50	2.49	67	0	9,483	97.04
RBT	+DG01/portal/datafile/rbt_data19.ora	31,724	9	18.47	2.23	135	0	5,117	100.61
RBT	+DG01/portal/datafile/rbt_data20.ora	23,693	7	36.07	2.70	157	0	5,425	137.11
RBT	+DG01/portal/datafile/rbt_data21.ora	11,869	3	28.33	4.33	92	0	5,909	170.90
RBT	+DG01/portal/datafile/rbt_data22.ora	10,200	3	29.86	3.86	139	0	5,523	116.85
RBT	+DG01/portal/datafile/rbt_data23.ora	4,522	1	155.19	6.56	73	0	3,945	65.78
RBT	+DG01/portal/datafile/rbt_data24.ora	2,244	1	126.72	13.70	168	0	4,173	76.31
RBT	+DG01/portal/datafile/rbt_data25.ora	2,496	1	84.73	12.82	340	0	5,906	96.69
RBT	+DG01/portal/datafile/rbt_data26.ora	1,576	0	88.86	14.64	167	0	3,437	45.55
RBT	+DG01/portal/datafile/rbt_data27.ora	1,957	1	73.53	14.76	214	0	2,980	26.08
RBT	+DG01/portal/datafile/rbt_data28.ora	1,517	0	129.78	15.16	63	0	3,027	36.79
RBT	+DG01/portal/datafile/rbt_data29.ora	1,383	0	99.52	12.68	72	0	3,023	29.96
RBT	+DG01/portal/datafile/rbt_data30.ora	1,731	0	129.34	13.45	95	0	3,121	79.02
RBT	+DG01/portal/datafile/rbt_data31.ora	1,494	0	143.30	13.12	77	0	3,222	111.89
RBT	+DG01/portal/datafile/rbt_data32.ora	1,195	0	152.58	14.70	70	0	3,120	112.94
RBT	+DG01/portal/datafile/rbt_data33.ora	173	0	206.59	12.05	466	0	1,153	217.59
RBT	+DG01/portal/datafile/rbt_data34.ora	150	0	258.73	13.75	26	0	1,187	308.16
RBT	+DG01/portal/datafile/rbt_data35.ora	142	0	97.75	14.46	24	0	980	123.22
RBT	+DG01/portal/datafile/rbt_data36.ora	148	0	94.05	13.91	25	0	990	135.30
RBT	+DG01/portal/datafile/rbt_data37.ora	135	0	28.00	15.16	13	0	847	46.93
RBT	+DG01/portal/datafile/rbt_data38.ora	148	0	52.09	13.92	294	0	933	34.43
RBT	+DG01/portal/datafile/rbt_data39.ora	137	0	27.52	14.96	22	0	834	25.90
RBT	+DG01/portal/datafile/rbt_data40.ora	149	0	46.17	13.83	113	0	985	37.25
RBT	+DG01/portal/datafile/rbt_data41.ora	147	0	56.39	14.01	49	0	1,006	36.99
RBT	+DG01/portal/datafile/rbt_data42.ora	140	0	37.64	14.66	14	0	1,123	46.62
RBTHIS	+DG01/portal/datafile/rbt_his_data01.ora	3	0	0.00	1.00	1	0	0	0.00
RBTHIS	+DG01/portal/datafile/rbt_his_data02.ora	3	0	0.00	1.00	1	0	0	0.00
RBTHIS	+DG01/portal/datafile/rbt_his_data03.ora	3	0	0.00	1.00	1	0	0	0.00
RBTHIS	+DG01/portal/datafile/rbt_his_data04.ora	3	0	0.00	1.00	1	0	0	0.00
RBTHIS	+DG01/portal/datafile/rbt_his_data05.ora	3	0	0.00	1.00	1	0	0	0.00
RBTHIS	+DG01/portal/datafile/rbt_his_data06.ora	3	0	0.00	1.00	1	0	0	0.00
RBTHISIDX	+DG01/portal/datafile/rbt_his_idx01.ora	3	0	0.00	1.00	1	0	0	0.00
RBTHISIDX	+DG01/portal/datafile/rbt_his_idx02.ora	3	0	0.00	1.00	1	0	0	0.00
RBTHISIDX	+DG01/portal/datafile/rbt_his_idx03.ora	3	0	0.00	1.00	1	0	0	0.00
RBTIDX	+DG01/portal/datafile/rbt_idx01.ora	1,838	1	96.92	1.00	504	0	0	0.00
RBTIDX	+DG01/portal/datafile/rbt_idx02.ora	1,380	0	118.70	1.00	330	0	0	0.00
RBTIDX	+DG01/portal/datafile/rbt_idx03.ora	1,641	0	74.51	1.00	349	0	0	0.00
RBTIDX	+DG01/portal/datafile/rbt_idx04.ora	1,899	1	83.46	1.00	337	0	1	430.00
RBTIDX	+DG01/portal/datafile/rbt_idx05.ora	1,986	1	87.24	1.00	429	0	0	0.00
RBTIDX	+DG01/portal/datafile/rbt_idx06.ora	3,007	1	32.09	1.00	80	0	0	0.00
RBTIDX	+DG01/portal/datafile/rbt_idx07.ora	1,129	0	54.69	1.00	143	0	103	198.16
RBTIDX	+DG01/portal/datafile/rbt_idx08.ora	1,028	0	42.35	1.00	163	0	117	109.91
RBTIDX	+DG01/portal/datafile/rbt_idx09.ora	468	0	104.36	1.00	120	0	93	261.72
RBTIDX	+DG01/portal/datafile/rbt_idx10.ora	344	0	156.22	1.00	79	0	92	364.02
RBTIDX	+DG01/portal/datafile/rbt_idx11.ora	285	0	182.35	1.00	65	0	65	516.46
RBTIDX	+DG01/portal/datafile/rbt_idx12.ora	272	0	210.51	1.00	62	0	45	487.33
RBTIDX	+DG01/portal/datafile/rbt_idx13.ora	284	0	223.66	1.00	63	0	52	418.65
RBTIDX	+DG01/portal/datafile/rbt_idx14.ora	207	0	95.27	1.00	60	0	21	448.57
RBTIDX	+DG01/portal/datafile/rbt_idx15.ora	195	0	83.33	1.00	42	0	28	276.79
RBTIDX	+DG01/portal/datafile/rbt_idx16.ora	207	0	80.05	1.00	34	0	37	287.30
RBTIDX	+DG01/portal/datafile/rbt_idx17.ora	79	0	198.23	1.00	4	0	41	370.24
RBTIDX	+DG01/portal/datafile/rbt_idx18.ora	104	0	236.54	1.00	17	0	63	344.44
RBTIDX	+DG01/portal/datafile/rbt_idx19.ora	150	0	164.60	1.00	9	0	79	243.54
RBTIDX	+DG01/portal/datafile/rbt_idx20.ora	131	0	101.76	1.00	6	0	67	157.01
SYSAUX	+DG01/portal/datafile/sysaux.257.709645715	3,359	1	177.87	1.00	612	0	0	0.00
SYSTEM	+DG01/portal/datafile/system.256.709645715	1,220	0	231.17	1.00	107	0	24	879.17
TEMP	+DG01/portal/tempfile/temp.266.709645779	2,378	1	0.00	7.76	5,118	1	0
UNDOTBS1	+DG01/portal/datafile/undotbs1.258.709645715	3	0	200.00	1.00	423	0	3	36.67
UNDOTBS2	+DG01/portal/datafile/undotbs2.267.709645801	445	0	114.07	1.00	1	0	0	0.00
USERS	+DG01/portal/datafile/users.259.709645715	7	0	132.86	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	891,715	99	246,111,416	1,538,666	11,777	0	0	130,374

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	1	1478	6424	33025	92160	33025
E	0	2	3015	11107	38723	92160	38723

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	736	0.10	88,274	1.43	2,115,153,309
D	1,472	0.20	176,548	1.21	1,786,420,420
D	2,208	0.30	264,822	1.11	1,646,312,367
D	2,944	0.39	353,096	1.08	1,595,620,743
D	3,680	0.49	441,370	1.06	1,569,992,241
D	4,416	0.59	529,644	1.05	1,550,455,709
D	5,152	0.69	617,918	1.03	1,531,524,140
D	5,888	0.79	706,192	1.02	1,513,165,714
D	6,624	0.89	794,466	1.01	1,494,656,799
D	7,360	0.99	882,740	1.00	1,481,016,660
D	7,456	1.00	894,254	1.00	1,479,979,209
D	8,096	1.09	971,014	1.00	1,473,062,826
D	8,832	1.18	1,059,288	0.99	1,467,571,139
D	9,568	1.28	1,147,562	0.99	1,462,769,933
D	10,304	1.38	1,235,836	0.99	1,457,925,246
D	11,040	1.48	1,324,110	0.98	1,451,683,633
D	11,776	1.58	1,412,384	0.98	1,443,173,448
D	12,512	1.68	1,500,658	0.97	1,431,083,354
D	13,248	1.78	1,588,932	0.95	1,409,812,706
D	13,984	1.88	1,677,206	0.91	1,340,662,367
D	14,720	1.97	1,765,480	0.82	1,207,418,096

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
98.32	18,591	317

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	2,048	1,261	1,399.50	44.03	3.15	100.00	0.00	209,710
E	2,048	1,200	1,530.55	52.86	3.45	100.00	0.00	209,710

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	1-Pass Execs
2K	4K	26,297	26,297	0
4K	8K	148	148	0
8K	16K	126	126	0
16K	32K	450	450	0
64K	128K	372	372	0
128K	256K	34	34	0
256K	512K	84	84	0
512K	1024K	755	755	0
1M	2M	544	544	0
2M	4M	56	56	0
4M	8M	5	5	0
8M	16M	46	26	20
16M	32M	520	520	0

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
256	0.13	1,195,647.89	1,386,801.21	46.00	17,123
512	0.25	1,195,647.89	525,696.40	69.00	5,922
1,024	0.50	1,195,647.89	51,301.70	96.00	0
1,536	0.75	1,195,647.89	37,023.63	97.00	0
2,048	1.00	1,195,647.89	37,023.63	97.00	0
2,458	1.20	1,195,647.89	15,178.98	99.00	0
2,867	1.40	1,195,647.89	15,178.98	99.00	0
3,277	1.60	1,195,647.89	15,178.98	99.00	0
3,686	1.80	1,195,647.89	15,178.98	99.00	0
4,096	2.00	1,195,647.89	15,178.98	99.00	0
6,144	3.00	1,195,647.89	15,178.98	99.00	0
8,192	4.00	1,195,647.89	15,178.98	99.00	0
12,288	6.00	1,195,647.89	15,178.98	99.00	0
16,384	8.00	1,195,647.89	15,178.98	99.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
624	0.89	93	5,784	18,129,587	0.99	201,439	2.04	51,599,779
704	1.00	153	7,993	18,232,147	1.00	98,879	1.00	51,637,596
784	1.11	231	11,204	18,331,563	1.01	1	0.00	51,674,322
864	1.23	308	14,684	18,431,813	1.01	1	0.00	51,709,277
944	1.34	386	18,684	18,518,974	1.02	1	0.00	51,741,785
1,024	1.45	465	22,088	18,598,209	1.02	1	0.00	51,771,610
1,104	1.57	544	25,126	18,669,072	1.02	1	0.00	51,798,665
1,184	1.68	621	28,375	18,731,609	1.03	1	0.00	51,822,957
1,264	1.80	700	31,449	18,786,266	1.03	1	0.00	51,844,594
1,344	1.91	779	34,321	18,833,746	1.03	1	0.00	51,863,785
1,424	2.02	858	37,333	18,874,876	1.04	1	0.00	51,880,711

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
2,052	0.25	12,440,633	2,115,164,171
4,104	0.50	8,830,210	1,595,548,904
6,156	0.75	8,384,727	1,531,466,474
8,208	1.00	8,026,733	1,479,963,736
10,260	1.25	7,907,156	1,462,796,157
12,312	1.50	7,793,176	1,443,112,639
14,364	1.75	7,750,640	1,340,699,148
16,416	2.00	7,695,256	1,207,354,416

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

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	130,723	15,840	121
undo header	3	0	37

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)
TX-Transaction (row lock contention)	1,817	1,807	0	1,807	737	407.78
CF-Controlfile Transaction	5,605	5,587	18	12	37	3,052.25
SQ-Sequence Cache	120	120	0	10	26	2,609.00
JS-Job Scheduler (queue lock)	81,651	81,649	2	3	11	3,797.00
TX-Transaction (index contention)	18	18	0	18	10	577.67
US-Undo Segment	8	8	0	3	7	2,441.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	2.26	25,004	4,314	19	33.2833333333333333333333333333333333333/82.9	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
27-Dec 14:03	271	3,459	4,314	19	83	0/0	0/0/0/0/0/0
27-Dec 13:53	610	3,942	3,708	9	73	0/0	0/0/0/0/0/0
27-Dec 13:43	387	3,919	3,102	9	63	0/0	0/0/0/0/0/0
27-Dec 13:33	245	3,585	2,493	11	53	0/0	0/0/0/0/0/0
27-Dec 13:23	175	2,320	1,884	8	42	0/0	0/0/0/0/0/0
27-Dec 13:13	333	4,587	1,276	10	33	0/0	0/0/0/0/0/0
27-Dec 13:03	239	3,192	1,855	8	43	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM allocation	196	0.00		0	0
ASM db client latch	1,618	0.00		0	0
ASM map headers	132	0.00		0	0
ASM map load waiting list	24	0.00		0	0
ASM map operation freelist	762	0.00		0	0
ASM map operation hash table	851,386	0.00	0.00	0	0
ASM network background latch	1,290	0.00		0	0
AWR Alerted Metric Element list	38,317	0.00		0	0
Consistent RBA	10,043	0.00		0	0
FAL request queue	68	0.00		0	0
FAL subheap alocation	68	0.00		0	0
FIB s.o chain latch	68	0.00		0	0
FOB s.o list latch	5,824	0.00		0	0
JS broadcast add buf latch	4,643	0.00		0	0
JS broadcast drop buf latch	4,644	0.00		0	0
JS broadcast load blnc latch	4,534	0.00		0	0
JS mem alloc latch	5	0.00		0	0
JS queue access latch	5	0.00		0	0
JS queue state obj latch	163,298	0.00		0	0
JS slv state obj latch	20	0.00		0	0
KCL gc element parent latch	712,560	0.00	0.19	1	42,418	0.00
KFK SGA context latch	5,080	0.00		0	0
KFMD SGA	1,087	0.00		0	0
KMG MMAN ready and startup request latch	1,097	0.00		0	0
KMG resize request state object freelist	13	0.00		0	0
KSXR large replies	115	0.00		0	0
KTF sga latch	22	0.00		0	1,165	0.00
KWQMN job cache list latch	261	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	127	0.00		0	1,097	0.00
OS process	801	0.00		0	0
OS process allocation	1,638	0.00		0	0
OS process: request allocation	510	0.00		0	0
PL/SQL warning settings	2,709	0.00		0	0
SGA IO buffer pool latch	53	0.00		0	53	0.00
SQL memory manager latch	1	0.00		0	785	0.00
SQL memory manager workarea list latch	62,585	0.00		0	0
Shared B-Tree	125	0.00		0	0
active checkpoint queue latch	1,832	0.00		0	0
active service list	39,553	0.00		0	1,253	0.00
archive control	169	0.00		0	0
archive process latch	930	0.00		0	0
begin backup scn array	12	0.00		0	0
buffer pool	526	0.00		0	0
cache buffer handles	644	0.00		0	0
cache buffers chains	500,375,435	0.00	0.31	2133	3,023,504	0.08
cache buffers lru chain	316,244	0.25	0.00	1	5,764,716	0.22
cache table scan latch	0			0	82,155	0.07
channel handle pool latch	682	0.00		0	0
channel operations parent latch	559,274	0.00	0.00	0	0
checkpoint queue latch	52,371	0.00		0	20,573	0.00
client/application info	3,074	0.00		0	0
compile environment latch	337	0.00		0	0
dml lock allocation	62,163	0.00	0.00	0	0
dummy allocation	658	0.00		0	0
enqueue hash chains	548,217	0.00	0.00	0	17,749	0.00
enqueues	394,471	0.00	0.00	0	0
event group latch	263	0.00		0	0
file cache latch	668	0.00		0	0
gcs partitioned table hash	1,583,006	0.00		0	0
gcs resource freelist	290,174	0.00	0.00	0	0
gcs resource hash	1,824,233	0.01	0.02	0	0
ges caches resource lists	57,464	0.00	0.00	0	25,093	0.00
ges deadlock list	3,720	0.00		0	4	0.00
ges domain table	99,875	0.00		0	0
ges enqueue table freelist	100,117	0.00		0	0
ges group table	141,650	0.00		0	0
ges process hash list	2,102	0.00		0	0
ges process parent latch	235,196	0.00		0	0
ges process table freelist	510	0.00		0	0
ges resource hash list	152,789	0.00	0.00	0	16,211	0.00
ges resource scan list	942	0.00		0	0
ges resource table freelist	25,645	0.00		0	0
ges timeout list	24	0.00		0	90	0.00
global KZLD latch for mem in SGA	252	0.00		0	0
global tx hash mapping	11	0.00		0	0
hash table column usage latch	707	0.00		0	48,605	0.00
hash table modification latch	122	0.00		0	0
job workq parent latch	0			0	150	0.00
job_queue_processes parameter latch	130	0.00		0	0
kks stats	6,709	0.00		0	0
kmcptab latch	1	0.00		0	0
kmcpvec latch	0			0	1	0.00
kokc descriptor allocation latch	890	0.00		0	0
ksuosstats global area	563	0.00		0	0
ktm global data	86	0.00		0	0
kwqbsn:qsga	125	0.00		0	0
lgwr LWN SCN	10,044	0.01	0.00	0	0
library cache	289,675	0.00	0.00	0	16,505	0.00
library cache load lock	2,855	0.00		0	0
library cache lock	185,548	0.00		0	0
library cache lock allocation	4,714	0.00		0	0
library cache pin	96,367	0.00		0	12	0.00
library cache pin allocation	906	0.00		0	0
list of block allocation	848	0.00		0	0
loader state object freelist	86	0.00		0	0
longop free list parent	5,577	0.00		0	2,785	0.04
message pool operations parent latch	651	0.00		0	0
messages	124,635	0.00	0.00	0	0
mostly latch-free SCN	10,043	0.00		0	0
msg queue	40	0.00		0	40	0.00
multiblock read objects	228,378	0.01	0.00	0	0
name-service memory objects	4,736	0.00		0	0
name-service namespace bucket	11,185	0.00		0	0
name-service pending queue	4,736	0.00		0	0
name-service request queue	11,791	0.00		0	0
ncodef allocation latch	60	0.00		0	0
object queue header heap	9,939	0.00		0	506	0.00
object queue header operation	3,110,815	0.00	0.00	0	7,638	0.00
object stats modification	10	0.00		0	0
parallel query alloc buffer	436	0.00		0	0
parallel txn reco latch	4,807	0.00		0	0
parameter list	2,768	0.00		0	0
parameter table allocation management	342	0.00		0	0
post/wait queue	17,216	0.00		0	16,091	0.01
process allocation	9,076	0.01	1.00	0	263	0.00
process group creation	510	0.00		0	0
qmn task queue latch	500	0.20	1.00	0	0
queued dump request	8,639	0.00		0	0
redo allocation	30,160	0.01	0.33	1	107,729	0.01
redo copy	0			0	107,731	0.03
redo writing	33,726	0.01	1.00	2	0
resmgr group change latch	571	0.00		0	0
resmgr:active threads	807	0.00		0	0
resmgr:actses change group	314	0.00		0	0
resmgr:free threads list	646	0.00		0	0
resmgr:schema config	161	0.00		0	0
row cache objects	501,154	0.02	0.91	80	11,818	0.01
segmented array pool	40	0.00		0	0
sequence cache	28,830	0.00		0	0
session allocation	299,574	0.00	0.00	0	0
session idle bit	1,016,232	0.00	0.06	0	0
session state list latch	703	0.00		0	0
session switching	60	0.00		0	0
session timer	1,252	0.00		0	0
shared pool	124,552	0.02	0.05	0	0
shared pool simulator	312,267	0.00		0	0
simulator hash latch	15,927,647	0.00	0.16	44	0
simulator lru latch	182	0.00		0	15,629,803	1.66
slave class	150	0.00		0	0
slave class create	110	1.82	1.00	1	0
sort extent pool	1,678	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	448	0.00		0	0
temp lob duration state obj allocation	11	0.00		0	0
temporary table state object allocation	9	0.00		0	0
threshold alerts latch	310	0.00		0	0
transaction allocation	6,342,349	0.00		0	0
transaction branch allocation	1,259	0.00		0	0
undo global data	113,292	0.00	0.00	0	0
user lock	1,200	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	500,375,435	7,903	2,450	5,456
cache buffers lru chain	316,244	785	1	784
simulator hash latch	15,927,647	411	65	346
gcs resource hash	1,824,233	138	3	135
row cache objects	501,154	102	93	9
KCL gc element parent latch	712,560	32	6	26
shared pool	124,552	21	1	20
session idle bit	1,016,232	18	1	17
redo allocation	30,160	3	1	2
redo writing	33,726	2	2	0
slave class create	110	2	2	0
process allocation	9,076	1	1	0
qmn task queue latch	500	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
KCL gc element parent latch	kclzcl	3	1
KCL gc element parent latch	kclnfndnewm	2	1
KCL gc element parent latch	kclrwrite	2	0
cache buffers chains	kcbgtcr: kslbegin excl	2,016	2,444
cache buffers chains	kcbrls: kslbegin	397	34
cache buffers chains	kcbchg: kslbegin: bufs not pinned	29	15
cache buffers chains	kcbzgb: scan from tail. nowait	28	0
cache buffers chains	kcbzib: multi-block read: nowait	21	0
cache buffers chains	kcbbxsv	8	0
cache buffers chains	kclcls_3	8	0
cache buffers chains	kcbzwb	5	14
cache buffers chains	kcbbic1	4	0
cache buffers chains	kclwcrs_5	1	0
cache buffers lru chain	kcbzgm	1	0
event range base latch	No latch	1	1
gcs resource hash	kjblocalfile_nolock	3	3
process allocation	ksufap: active procs	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	1	0
redo writing	kcrfsr: rba scn pair	1	1
redo writing	kcrfw_post: rba scn pair	1	0
row cache objects	kqrigt	38	37
row cache objects	ksucallcbksafely: kqrhngc	23	0
row cache objects	kqreqd: reget	19	0
row cache objects	kqrbtm: pop parent	9	1
row cache objects	kqrbgl	3	26
row cache objects	kqrbip	1	0
session idle bit	ksupuc: set busy	1	0
shared pool	kghalo	1	0
simulator hash latch	kcbsacc: lookup dba	64	64
simulator hash latch	kcbs_lookup_setid: lookup dba	1	1
slave class create	ksvcreate	1	0
slave class create	ksvsubmit	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 Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received

Segments by Logical Reads

Total Logical Reads: 248,614,844
Captured Segments account for 103.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
RBT	RBT	T_RBT_ALL_TONE	TABLE	214,071,648	86.11
RBT	RBTIDX	IDX_RBT_ALL_TONE_TNAME	INDEX	10,238,208	4.12
RBT	RBTIDX	IDX_SMLOTTERYRING_STARTTIME	INDEX	8,561,728	3.44
RBT	RBTIDX	IDX_RBT_ALL_TONE_TNAME_SINGER	INDEX	7,120,912	2.86
RBT	RBT	T_SNS_UGC_TONE	TABLE	5,146,832	2.07

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 1,559,218
Captured Segments account for 94.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
RBT	RBT	T_RBT_ORDER_TONE_LOGS	TABLE	528,690	33.91
RBT	RBT	T_RBT_RECEIVE_SM	TABLE	470,340	30.17
RBT	RBT	T_RBT_SEARCH_LOG	TABLE	235,751	15.12
RBT	RBT	T_SNS_FEED_TARGETS	TABLE	221,379	14.20
RBT	RBT	T_SNS_UGC_AUDITION_TONE_LOGS	TABLE	10,127	0.65

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
RBT	RBT	T_RBT_USER_SETTING_TONE	DEC2012	TABLE PARTITION	4	25.00
RBT	RBT	IX_LOG_BROWSE_TIME_FP_NEW	P121231	INDEX PARTITION	2	12.50
RBT	RBT	PK_LOGS_FIRST_PAGE_LOGS_NEW		INDEX	2	12.50
RBT	RBT	PK_SERCH_LOG		INDEX	2	12.50
RBT	RBT	T_RBT_USER_HISTORY		TABLE	2	12.50

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	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	SEQ$		TABLE	18	72.00
RBT	RBT	T_RBT_RECEIVE_SM		TABLE	4	16.00
RBT	RBT	IX_LOG_BROWSE_TIME_FP_NEW	P121231	INDEX PARTITION	1	4.00
RBT	RBT	PK_LOGS_FIRST_PAGE_LOGS_NEW		INDEX	1	4.00
RBT	RBT	PK_SERCH_LOG		INDEX	1	4.00

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	GC Buffer Busy	% of Capture
RBT	RBT	T_RBT_SEARCH_LOG		TABLE	444	88.27
RBT	RBT	T_SNS_FEED_TARGETS		TABLE	59	11.73

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Dictionary Cache Stats
Dictionary Cache Stats (RAC)

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	69	0.00	2	1
dc_database_links	508	0.00	0	1
dc_files	532	14.29	0	76
dc_global_oids	953	1.15	0	21
dc_histogram_data	23,704	5.58	0	2,357
dc_histogram_defs	14,372	16.60	0	2,569
dc_object_grants	2	0.00	0	12
dc_object_ids	22,625	2.05	0	766
dc_objects	3,415	10.45	5	514
dc_profiles	328	0.00	0	1
dc_rollback_segments	7,434	0.00	6	255
dc_segments	5,302	18.90	16	992
dc_sequences	10,808	0.17	10,808	32
dc_tablespace_quotas	1	0.00	1	0
dc_tablespaces	13,618	0.00	0	10
dc_usernames	2,229	1.21	0	13
dc_users	20,489	0.12	14	31
outstanding_alerts	124	8.06	0	20

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Releases
dc_awr_control	4	0
dc_files	76	76
dc_global_oids	11	28
dc_histogram_defs	2,386	4,656
dc_object_ids	463	963
dc_objects	363	845
dc_rollback_segments	10	0
dc_segments	1,033	2,060
dc_sequences	15,890	35
dc_tablespace_quotas	2	1
dc_usernames	27	56
dc_users	53	52
outstanding_alerts	242	10

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Library Cache Activity
Library Cache Activity (RAC)

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	1,007	0.50	1,292	1.24	11	0
CLUSTER	36	0.00	81	2.47	2	0
INDEX	45	26.67	151	14.57	10	0
SQL AREA	28,552	1.54	249,386	1.32	1,056	234
TABLE/PROCEDURE	2,105	3.09	38,282	3.16	728	0
TRIGGER	58	0.00	186	0.54	1	0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases	GES Inval Requests
CLUSTER	81	0	2	0
INDEX	151	12	28	12
TABLE/PROCEDURE	4,680	63	751	35

Back to Library Cache Statistics
Back to Top

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	1,175.00		4.00	4.17	31	58	294	294
	Freeable	135.88	0.00	0.69	0.37	2		198	198
	SQL	98.81	94.31	0.36	1.49	8	36	276	213
	PL/SQL	5.72	2.98	0.02	0.02	0	0	292	292
E	Other	1,260.20		3.95	4.05	31	58	319	319
	Freeable	160.06	0.00	0.80	0.50	3		201	201
	SQL	103.42	98.27	0.34	1.47	12	36	301	252
	PL/SQL	7.05	3.61	0.02	0.02	0	0	317	317

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	7,751,073,792	7,818,182,656
Fixed Size	2,069,936
Redo Buffers	14,704,640
Variable Size	838,863,440	771,754,576

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	ASM map operations hashta	0.38	0.38	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.60	14.60	0.00
shared	CCursor	11.24		-100.00
shared	FileOpenBlock	13.02	13.02	0.00
shared	KGH: NO ACCESS	122.42	108.19	-11.63
shared	KQR L PO	9.36		-100.00
shared	db_block_hash_buckets	45.00	45.00	0.00
shared	event statistics per sess	14.65	14.65	0.00
shared	free memory	119.95	112.93	-5.86
shared	gcs resources	180.05	180.05	0.00
shared	gcs shadows	108.38	108.38	0.00
shared	ges big msg buffers	15.20	15.20	0.00
shared	ges enqueues	16.08	16.08	0.00
shared	ges resource		8.37
shared	library cache	17.81	14.99	-15.82
shared	sessions		8.66
shared	sql area	50.14	18.76	-62.59
	buffer_cache	7,392.00	7,456.00	0.87
	fixed_sga	1.97	1.97	0.00
	log_buffer	14.02	14.02	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

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

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
gcs_resources	635,043	928,941	1004492	1004492
gcs_shadows	1,004,492	1,171,375	1004492	1004492

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/opt/oracle/product/admin/portal/adump
audit_trail	DB
background_dump_dest	/opt/oracle/product/admin/portal/bdump
cluster_database	TRUE
cluster_database_instances	2
compatible	10.2.0.3.0
control_files	+DG01/portal/controlfile/current.261.709645773, +DG01/portal/controlfile/current.260.709645773
core_dump_dest	/opt/oracle/product/admin/portal/cdump
db_block_size	8192
db_create_file_dest	+DG01
db_domain
db_file_multiblock_read_count	16
db_name	portal
db_recovery_file_dest	+DG01
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=portalXDB)
instance_number	1
job_queue_processes	10
local_listener
log_archive_dest_1	LOCATION=+DG01/
log_archive_format	%t_%s_%r.dbf
open_cursors	300
pga_aggregate_target	2147483648
processes	1500
remote_listener	LISTENERS_PORTAL
remote_login_passwordfile	EXCLUSIVE
sessions	1655
sga_max_size	8606711808
sga_target	8606711808
thread	1
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/opt/oracle/product/admin/portal/udump

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	0	0.00	0.00
acks for commit broadcast(logical)	0	0.00	0.00
broadcast msgs on commit(actual)	0	0.00	0.00
broadcast msgs on commit(logical)	0	0.00	0.00
broadcast msgs on commit(wasted)	0	0.00	0.00
broadcast on commit wait time(ms)	0	0.00	0.00
broadcast on commit waits	0	0.00	0.00
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
false posts waiting for scn acks	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	0	0.00	0.00
gcs ast xid	0	0.00	0.00
gcs blocked converts	0	0.00	0.00
gcs blocked cr converts	0	0.00	0.00
gcs compatible basts	0	0.00	0.00
gcs compatible cr basts (global)	0	0.00	0.00
gcs compatible cr basts (local)	0	0.00	0.00
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	0	0.00	0.00
gcs dbwr write request msgs	0	0.00	0.00
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	791	0.22	0.05
gcs immediate (null) converts	1,917	0.53	0.12
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	16,828	4.64	1.01
gcs indirect ast	512	0.14	0.03
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	0	0.00	0.00
gcs msgs process time(ms)	0	0.00	0.00
gcs msgs received	0	0.00	0.00
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	0	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs side channel msgs actual	0	0.00	0.00
gcs side channel msgs logical	0	0.00	0.00
gcs stale cr	7,312	2.02	0.44
gcs undo cr	0	0.00	0.00
gcs write notification msgs	0	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	0	0.00	0.00
ges msgs received	0	0.00	0.00
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	0	0.00	0.00
global posts requested	0	0.00	0.00
global posts sent	0	0.00	0.00
implicit batch messages received	0	0.00	0.00
implicit batch messages sent	0	0.00	0.00
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	0	0.00	0.00
messages queue sent actual	0	0.00	0.00
messages queue sent logical	0	0.00	0.00
messages received actual	0	0.00	0.00
messages received logical	0	0.00	0.00
messages sent directly	0	0.00	0.00
messages sent indirectly	0	0.00	0.00
messages sent not implicit batched	0	0.00	0.00
messages sent pbatched	0	0.00	0.00
msgs causing lmd to send msgs	0	0.00	0.00
msgs causing lms(s) to send msgs	0	0.00	0.00
msgs received queue time (ms)	0	0.00	0.00
msgs received queued	0	0.00	0.00
msgs sent queue time (ms)	0	0.00	0.00
msgs sent queue time on ksxp (ms)	0	0.00	0.00
msgs sent queued	0	0.00	0.00
msgs sent queued on ksxp	0	0.00	0.00
process batch messages received	0	0.00	0.00
process batch messages sent	0	0.00	0.00

Global CR Served Stats

Statistic	Total
CR Block Requests	0
CURRENT Block Requests	0
Data Block Requests	0
Undo Block Requests	0
TX Block Requests	0
Current Results	0
Private results	0
Zero Results	0
Disk Read Results	0
Fail Results	0
Fairness Down Converts	0
Fairness Clears	0
Free GC Elements	0
Flushes	0
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	0
Errors	0

Global CURRENT Served Stats

Pins = CURRENT Block Pin Operations
Flushes = Redo Flush before CURRENT Block Served Operations
Writes = CURRENT Block Fusion Write Operations

Statistic	Total	% <1s
Pins	0	0.00
Flushes	0	0.00
Writes	6	100.00

Global Cache Transfer Stats

No data exists for this section of the report.

End of Report

% Blocks changed per Read:	0.08	Recursive Call %:	48.58
Rollback per transaction %:	34.57	Rows per Sort:	7166.37

Buffer Nowait %:	99.95	Redo NoWait %:	99.93
Buffer Hit %:	99.38	In-memory Sort %:	99.98
Library Hit %:	98.43	Soft Parse %:	99.33
Execute to Parse %:	18.15	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	0.65	% Non-Parse CPU:	99.96

Buffer access - local cache %:	99.38
Buffer access - remote cache %:	0.00
Buffer access - disk %:	0.62

Avg global enqueue get time (ms):	12.1
Avg global cache cr block receive time (ms):	0.0
Avg global cache current block receive time (ms):	0.0
Avg global cache cr block build time (ms):
Avg global cache cr block send time (ms):
Global cache log flushes for cr blocks served %:
Avg global cache cr block flush time (ms):
Avg global cache current block pin time (ms):
Avg global cache current block send time (ms):
Global cache log flushes for current blocks served %:
Avg global cache current block flush time (ms):

Avg message sent queue time (ms):
Avg message sent queue time on ksxp (ms):
Avg message received queue time (ms):
Avg GCS message process time (ms):
Avg GES message process time (ms):
% of direct sent messages:
% of indirect sent messages:
% of flow controlled messages: