WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

RESEARCH 2055556290 research 1 10.2.0.1.0 NO researchora

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
RESEARCH	2055556290	research	1	10.2.0.1.0	NO	researchora

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 37384 21-Jan-15 09:00:17 183 30.9

End Snap: 37385 21-Jan-15 10:00:13 136 20.7

Elapsed: 59.95 (mins)

DB Time: 2,902.73 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	37384	21-Jan-15 09:00:17	183	30.9
End Snap:	37385	21-Jan-15 10:00:13	136	20.7
Elapsed:		59.95 (mins)
DB Time:		2,902.73 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 8,400M 8,800M Std Block Size: 8K

Shared Pool Size: 1,152M 752M Log Buffer: 14,392K

	Begin	End
Buffer Cache:	8,400M	8,800M	Std Block Size:	8K
Shared Pool Size:	1,152M	752M	Log Buffer:	14,392K

Load Profile

Per Second Per Transaction

Redo size: 50,708.35 3,864.14

Logical reads: 523,417.09 39,886.09

Block changes: 289.91 22.09

Physical reads: 940.80 71.69

Physical writes: 11.65 0.89

User calls: 194.97 14.86

Parses: 156.45 11.92

Hard parses: 2.35 0.18

Sorts: 26.85 2.05

Logons: 0.25 0.02

Executes: 486.00 37.03

Transactions: 13.12

	Per Second	Per Transaction
Redo size:	50,708.35	3,864.14
Logical reads:	523,417.09	39,886.09
Block changes:	289.91	22.09
Physical reads:	940.80	71.69
Physical writes:	11.65	0.89
User calls:	194.97	14.86
Parses:	156.45	11.92
Hard parses:	2.35	0.18
Sorts:	26.85	2.05
Logons:	0.25	0.02
Executes:	486.00	37.03
Transactions:	13.12

% Blocks changed per Read: 0.06 Recursive Call %: 79.50

Rollback per transaction %: 0.00 Rows per Sort: 403.07

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 99.59

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

Library Hit %: 99.38 Soft Parse %: 98.50

Execute to Parse %: 67.81 Latch Hit %: 99.54

Parse CPU to Parse Elapsd %: 8.03 % Non-Parse CPU: 99.89

Shared Pool Statistics

Begin End

Memory Usage %: 35.67 58.52

% SQL with executions>1: 63.91 46.47

% Memory for SQL w/exec>1: 68.50 72.71

	Begin	End
Memory Usage %:	35.67	58.52
% SQL with executions>1:	63.91	46.47
% Memory for SQL w/exec>1:	68.50	72.71

Top 5 Timed Events

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

latch: cache buffers chains 72,496 45,211 624 26.0 Concurrency

CPU time 28,722 16.5

log file sync 34,152 14,210 416 8.2 Commit

latch free 18,645 13,429 720 7.7 Other

db file sequential read 118,968 5,034 42 2.9 User I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
latch: cache buffers chains	72,496	45,211	624	26.0	Concurrency
CPU time		28,722		16.5
log file sync	34,152	14,210	416	8.2	Commit
latch free	18,645	13,429	720	7.7	Other
db file sequential read	118,968	5,034	42	2.9	User I/O

Main Report

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

Time Model Statistics

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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	160,212.99	91.99
DB CPU	28,721.94	16.49
parse time elapsed	529.30	0.30
hard parse elapsed time	258.15	0.15
PL/SQL execution elapsed time	257.72	0.15
PL/SQL compilation elapsed time	22.38	0.01
sequence load elapsed time	19.14	0.01
connection management call elapsed time	13.86	0.01
hard parse (sharing criteria) elapsed time	2.65	0.00
hard parse (bind mismatch) elapsed time	0.52	0.00
repeated bind elapsed time	0.18	0.00
failed parse elapsed time	0.05	0.00
DB time	174,164.08
background elapsed time	6,686.93
background cpu time	9.63

Back to Wait Events Statistics
Back to Top

Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
Concurrency	76,261	1.57	47,705	626	1.62
Commit	34,152	6.68	14,210	416	0.72
Other	19,041	1.21	13,514	710	0.40
User I/O	589,501	0.05	9,942	17	12.49
System I/O	28,552	0.03	3,499	123	0.60
Configuration	2,213	83.55	1,979	894	0.05
Network	410,824	0.00	49	0	8.70
Application	72	0.00	4	55	0.00

Back to Wait Events Statistics
Back to Top

Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
latch: cache buffers chains	72,496	0.00	45,211	624	1.54
log file sync	34,152	6.68	14,210	416	0.72
latch free	18,645	0.00	13,429	720	0.40
db file sequential read	118,968	0.00	5,034	42	2.52
log file parallel write	14,445	0.00	2,648	183	0.31
read by other session	14,199	1.90	2,454	173	0.30
db file scattered read	449,408	0.00	2,453	5	9.52
log file switch (checkpoint incomplete)	1,648	92.78	1,571	953	0.03
buffer busy waits	1,421	84.03	1,261	887	0.03
latch: library cache	2,154	0.00	1,186	551	0.05
control file parallel write	1,405	0.00	839	597	0.03
log file switch completion	539	59.37	403	748	0.01
LNS wait on SENDREQ	220	0.00	41	187	0.00
enq: JD - contention	9	88.89	25	2751	0.00
ARCH wait on c/f tx acquire 2	22	100.00	23	1035	0.00
enq: CF - contention	15	33.33	21	1420	0.00
latch: library cache pin	39	0.00	14	357	0.00
LNS ASYNC control file txn	9	100.00	9	997	0.00
latch: shared pool	51	0.00	8	159	0.00
LGWR wait for redo copy	268	73.13	7	27	0.01
latch: library cache lock	29	0.00	7	248	0.00
os thread startup	8	50.00	7	837	0.00
enq: TX - index contention	56	0.00	6	112	0.00
ARCH wait on SENDREQ	58	0.00	5	89	0.00
enq: SQ - contention	26	0.00	5	179	0.00
library cache load lock	4	0.00	4	1094	0.00
SQL*Net break/reset to client	72	0.00	4	55	0.00
rdbms ipc reply	43	0.00	3	66	0.00
latch: enqueue hash chains	12	0.00	3	218	0.00
latch: cache buffers lru chain	16	0.00	2	151	0.00
SQL*Net more data from client	783	0.00	2	2	0.02
log file sequential read	202	0.00	1	6	0.00
Log archive I/O	189	0.00	1	6	0.00
SQL*Net more data to client	47,480	0.00	1	0	1.01
SQL*Net message to client	362,283	0.00	1	0	7.68
row cache lock	1	0.00	1	676	0.00
latch: row cache objects	1	0.00	0	386	0.00
latch: redo allocation	3	0.00	0	91	0.00
control file sequential read	12,294	0.00	0	0	0.26
log file single write	8	0.00	0	22	0.00
latch: object queue header operation	2	0.00	0	61	0.00
wait list latch free	6	0.00	0	12	0.00
direct path read	6,718	0.00	0	0	0.14
cursor: mutex S	1	0.00	0	5	0.00
direct path write	208	0.00	0	0	0.00
SQL*Net message from client	362,275	0.00	311,293	859	7.68
jobq slave wait	8,607	93.80	24,990	2904	0.18
virtual circuit status	116	100.00	3,489	30081	0.00
Streams AQ: qmn coordinator idle wait	246	50.00	3,458	14056	0.01
Streams AQ: qmn slave idle wait	123	0.00	3,454	28085	0.00
LNS ASYNC end of log	3,332	100.00	3,411	1024	0.07
Streams AQ: waiting for time management or cleanup tasks	8	50.00	3,366	420800	0.00
class slave wait	2	100.00	15	7465	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	14,433	0.00	2,646	183	0.31
control file parallel write	1,404	0.00	838	597	0.03
events in waitclass Other	372	61.83	81	217	0.01
LNS wait on SENDREQ	220	0.00	41	187	0.00
buffer busy waits	35	65.71	25	725	0.00
LNS ASYNC control file txn	9	100.00	9	997	0.00
log file switch (checkpoint incomplete)	7	85.71	7	978	0.00
os thread startup	8	50.00	7	837	0.00
latch: cache buffers chains	8	0.00	5	652	0.00
ARCH wait on SENDREQ	58	0.00	5	89	0.00
latch: library cache	2	0.00	2	1041	0.00
log file sequential read	202	0.00	1	6	0.00
Log archive I/O	189	0.00	1	6	0.00
latch: shared pool	3	0.00	1	238	0.00
control file sequential read	11,523	0.00	0	0	0.24
log file single write	8	0.00	0	22	0.00
db file scattered read	2	0.00	0	28	0.00
direct path read	192	0.00	0	0	0.00
direct path write	192	0.00	0	0	0.00
db file sequential read	190	0.00	-6	-33	0.00
rdbms ipc message	18,996	46.95	29,933	1576	0.40
pmon timer	1,518	99.01	3,486	2296	0.03
Streams AQ: qmn coordinator idle wait	246	50.00	3,458	14056	0.01
Streams AQ: qmn slave idle wait	123	0.00	3,454	28085	0.00
smon timer	16	62.50	3,435	214678	0.00
LNS ASYNC end of log	3,330	100.00	3,409	1024	0.07
Streams AQ: waiting for time management or cleanup tasks	8	50.00	3,366	420800	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	2,814,372
IDLE_TIME	19,894
NICE_TIME	155
SYS_TIME	24,803
USER_TIME	2,789,414
LOAD	16
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	488,816
NUM_CPUS	8
NUM_CPU_SOCKETS	2

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
research.bj.mycos.org	150,601.20	26,493.90	2,850,611	1,533,231,672
SYS$USERS	25,032.30	2,406.90	533,167	357,282,417
SYS$BACKGROUND	0.00	0.00	834	47,501
researchXDB	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
research.bj.mycos.org	498901	551858	70157	4473292	391218	282
SYS$USERS	89543	437300	6099	296495	17707	3
SYS$BACKGROUND	1065	5194	57	4047	278	4631

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
43,248	9,263	42,671	1.01	24.83	6mcx478k6hjgw	w3wp.exe	begin Pack_Question_HalfYear20...
31,583	3,853	11,306	2.79	18.13	gky1rjtvqz204	w3wp.exe	begin Pack_Question_HalfYear20...
28,451	7,376	62,107	0.46	16.34	6c263jxsf4n3v	w3wp.exe	SELECT COUNT(1) FROM EMAIL T W...
22,927	4,107	43,649	0.53	13.16	9mhydycsxzwbu	w3wp.exe	SELECT T.SKILLMAJOR, T.UNIVER...
18,124	5,204	46,235	0.39	10.41	8978nm09rf81x	w3wp.exe	begin Pack_Question_HalfYear20...
17,645	3,906	18,064	0.98	10.13	6t6y6a8uf7h81	w3wp.exe	begin Pack_Question_HalfYear20...
16,921	2,038	11,364	1.49	9.72	06pzqkj5qdmkm	w3wp.exe	SELECT T.SKILLUSERID, T.GRADE ...
13,826	4,119	39,540	0.35	7.94	83444u5pdds28	w3wp.exe	SELECT T.PAGEID FROM TURLSAVE ...
12,669	1,825	11,377	1.11	7.27	4nzwak1v8atr1	w3wp.exe	SELECT COUNT(*) FROM EMAIL T W...
9,448	1,739	18,439	0.51	5.42	gp7mhv9ttvjx9	w3wp.exe	SELECT T.UNIVERSITY, T.SKILLM...
6,466	1,431	8,845	0.73	3.71	2x694qcar906x	w3wp.exe	begin Pack_Question_HalfYear20...
4,573	1,555	16,631	0.27	2.63	10x7rsw0vqnjc	w3wp.exe	SELECT T.GRADE FROM EMAIL T WH...
3,454	728	1	3453.91	1.98	gyjk5c75k457q		DECLARE job BINARY_INTEGER := ...
3,190	621	2,695	1.18	1.83	5r2mcvsf8c09r	w3wp.exe	SELECT NVL(T.SC_SIGN, '-1') FR...
3,001	86	1	3001.27	1.72	6khtujxhkp15r		DECLARE job BINARY_INTEGER := ...
2,472	367	1,409	1.75	1.42	dxuqr5nua83uh	w3wp.exe	begin Pack_Question_HalfYear20...
2,138	15	4	534.39	1.23	9gv1w0bca02tv	w3wp.exe	select a.universityname ѧУ��, ...
1,924	2	11,379	0.17	1.10	4c3kmcpszc3v9	w3wp.exe	INSERT INTO LOGININFO2 (ACLASS...
1,819	20	1	1819.03	1.04	gv24rbfjd8dt6		DECLARE job BINARY_INTEGER := ...

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
9,263	43,248	42,671	0.22	24.83	6mcx478k6hjgw	w3wp.exe	begin Pack_Question_HalfYear20...
7,376	28,451	62,107	0.12	16.34	6c263jxsf4n3v	w3wp.exe	SELECT COUNT(1) FROM EMAIL T W...
5,204	18,124	46,235	0.11	10.41	8978nm09rf81x	w3wp.exe	begin Pack_Question_HalfYear20...
4,119	13,826	39,540	0.10	7.94	83444u5pdds28	w3wp.exe	SELECT T.PAGEID FROM TURLSAVE ...
4,107	22,927	43,649	0.09	13.16	9mhydycsxzwbu	w3wp.exe	SELECT T.SKILLMAJOR, T.UNIVER...
3,906	17,645	18,064	0.22	10.13	6t6y6a8uf7h81	w3wp.exe	begin Pack_Question_HalfYear20...
3,853	31,583	11,306	0.34	18.13	gky1rjtvqz204	w3wp.exe	begin Pack_Question_HalfYear20...
2,038	16,921	11,364	0.18	9.72	06pzqkj5qdmkm	w3wp.exe	SELECT T.SKILLUSERID, T.GRADE ...
1,825	12,669	11,377	0.16	7.27	4nzwak1v8atr1	w3wp.exe	SELECT COUNT(*) FROM EMAIL T W...
1,739	9,448	18,439	0.09	5.42	gp7mhv9ttvjx9	w3wp.exe	SELECT T.UNIVERSITY, T.SKILLM...
1,555	4,573	16,631	0.09	2.63	10x7rsw0vqnjc	w3wp.exe	SELECT T.GRADE FROM EMAIL T WH...
1,431	6,466	8,845	0.16	3.71	2x694qcar906x	w3wp.exe	begin Pack_Question_HalfYear20...
728	3,454	1	727.55	1.98	gyjk5c75k457q		DECLARE job BINARY_INTEGER := ...
621	3,190	2,695	0.23	1.83	5r2mcvsf8c09r	w3wp.exe	SELECT NVL(T.SC_SIGN, '-1') FR...
367	2,472	1,409	0.26	1.42	dxuqr5nua83uh	w3wp.exe	begin Pack_Question_HalfYear20...
86	3,001	1	86.17	1.72	6khtujxhkp15r		DECLARE job BINARY_INTEGER := ...
20	1,819	1	19.85	1.04	gv24rbfjd8dt6		DECLARE job BINARY_INTEGER := ...
15	2,138	4	3.87	1.23	9gv1w0bca02tv	w3wp.exe	select a.universityname ѧУ��, ...
2	1,924	11,379	0.00	1.10	4c3kmcpszc3v9	w3wp.exe	INSERT INTO LOGININFO2 (ACLASS...

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: 1,882,623,447
Captured SQL account for 84.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
469,914,352	11,306	41,563.27	24.96	3853.29	31583.01	gky1rjtvqz204	w3wp.exe	begin Pack_Question_HalfYear20...
317,219,190	42,671	7,434.07	16.85	9263.17	43247.87	6mcx478k6hjgw	w3wp.exe	begin Pack_Question_HalfYear20...
283,647,936	62,107	4,567.08	15.07	7375.66	28451.38	6c263jxsf4n3v	w3wp.exe	SELECT COUNT(1) FROM EMAIL T W...
236,395,183	11,364	20,802.11	12.56	2038.21	16921.02	06pzqkj5qdmkm	w3wp.exe	SELECT T.SKILLUSERID, T.GRADE ...
236,194,801	11,377	20,760.73	12.55	1824.94	12669.01	4nzwak1v8atr1	w3wp.exe	SELECT COUNT(*) FROM EMAIL T W...
216,250,840	46,235	4,677.21	11.49	5204.36	18123.90	8978nm09rf81x	w3wp.exe	begin Pack_Question_HalfYear20...
165,819,057	39,540	4,193.70	8.81	4118.88	13826.09	83444u5pdds28	w3wp.exe	SELECT T.PAGEID FROM TURLSAVE ...
144,831,237	4,707	30,769.33	7.69	327.05	1368.49	8ap25t1xf9tcd	ServerWindowsForms.exe	begin proc_syn.write_syn(p_ser...
144,796,739	4,707	30,762.00	7.69	320.02	1282.82	97dups5qvw37s	ServerWindowsForms.exe	SELECT COUNT(*) FROM NEEDSYN W...
133,565,221	18,064	7,394.00	7.09	3906.13	17644.97	6t6y6a8uf7h81	w3wp.exe	begin Pack_Question_HalfYear20...
120,504,291	43,649	2,760.76	6.40	4106.86	22927.14	9mhydycsxzwbu	w3wp.exe	SELECT T.SKILLMAJOR, T.UNIVER...
69,743,726	1	69,743,726.00	3.70	727.55	3453.91	gyjk5c75k457q		DECLARE job BINARY_INTEGER := ...
66,742,905	8,845	7,545.83	3.55	1431.05	6466.49	2x694qcar906x	w3wp.exe	begin Pack_Question_HalfYear20...
56,057,078	2,695	20,800.40	2.98	621.07	3190.11	5r2mcvsf8c09r	w3wp.exe	SELECT NVL(T.SC_SIGN, '-1') FR...
50,953,376	18,439	2,763.35	2.71	1738.87	9448.34	gp7mhv9ttvjx9	w3wp.exe	SELECT T.UNIVERSITY, T.SKILLM...
46,263,312	583	79,353.88	2.46	192.99	1013.82	c2wum8uptj4p7	w3wp.exe	SELECT T.* FROM (SELECT ELT.ID...
45,624,911	16,631	2,743.37	2.42	1555.22	4573.25	10x7rsw0vqnjc	w3wp.exe	SELECT T.GRADE FROM EMAIL T WH...
44,311,509	1,409	31,448.91	2.35	366.67	2472.20	dxuqr5nua83uh	w3wp.exe	begin Pack_Question_HalfYear20...
36,830,999	2,706	13,610.86	1.96	173.34	800.01	2xr7zr9py13cy	ServerWindowsForms.exe	begin proc_syn.update_syn2(p_s...
36,828,293	2,706	13,609.86	1.96	172.73	795.01	81txbgd33bpb9	ServerWindowsForms.exe	UPDATE NEEDSYN2 SET RESULT = :...
33,305,202	1	33,305,202.00	1.77	234.85	857.40	c4k92q6huqh39	PL/SQL Developer	select * from resultmultiexpan...
20,821,558	4,890	4,257.99	1.11	101.56	668.72	3zy11982rmffj	MailMonitor.exe	SELECT COUNT(*) FROM EMAIL_CHE...
20,454,737	2,439	8,386.53	1.09	100.89	449.73	1ph4fbq6dqx29	MailMonitor.exe	begin PROC_email.handle_email_...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 3,383,869
Captured SQL account for 3.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
474,424	1	474,424.00	14.02	86.17	3001.27	6khtujxhkp15r		DECLARE job BINARY_INTEGER := ...
68,591	4	17,147.75	2.03	3.57	1220.97	cbutzrjdc7695	w3wp.exe	begin PROC_smanager.remove_ANS...
65,030	4	16,257.50	1.92	2.71	1131.35	56dtpxd4da6ar	w3wp.exe	DELETE FROM LOGININFO2 F WHERE...
44,621	4	11,155.25	1.32	15.49	2137.57	9gv1w0bca02tv	w3wp.exe	select a.universityname ѧУ��, ...
43,266	1	43,266.00	1.28	19.85	1819.03	gv24rbfjd8dt6		DECLARE job BINARY_INTEGER := ...
13,965	8,435	1.66	0.41	38.36	630.19	4h3s21tkvmjc7	w3wp.exe	SELECT T.* FROM ( SELECT ELT.I...
2,926	1	2,926.00	0.09	234.85	857.40	c4k92q6huqh39	PL/SQL Developer	select * from resultmultiexpan...
1,227	9,344	0.13	0.04	18.14	379.67	6a87wwu0s5c4n	w3wp.exe	begin Pack_Question_HalfYear20...
816	1,409	0.58	0.02	366.67	2472.20	dxuqr5nua83uh	w3wp.exe	begin Pack_Question_HalfYear20...
680	8,845	0.08	0.02	1431.05	6466.49	2x694qcar906x	w3wp.exe	begin Pack_Question_HalfYear20...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,748,051
Captured SQL account for 46.0% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
62,107	62,021	1.00	0.12	0.46	6c263jxsf4n3v	w3wp.exe	SELECT COUNT(1) FROM EMAIL T W...
61,764	61,744	1.00	0.00	0.00	6801khqm015n7	w3wp.exe	SELECT STARTTIME FROM UNIVERSI...
60,806	60,802	1.00	0.00	0.00	958hcz6bpfwr2	w3wp.exe	SELECT T.Q_TYPE FROM QUESTION ...
56,270	56,270	1.00	0.00	0.01	91qp5nzbj4dx4	w3wp.exe	SELECT T.MODULE FROM UNIVERSIT...
46,235	46,232	1.00	0.11	0.39	8978nm09rf81x	w3wp.exe	begin Pack_Question_HalfYear20...
46,075	46,089	1.00	0.00	0.01	40qdy6x6nj3w3	w3wp.exe	SELECT ID, NAME, ACLASS, IS...
43,649	43,685	1.00	0.09	0.53	9mhydycsxzwbu	w3wp.exe	SELECT T.SKILLMAJOR, T.UNIVER...
42,946	150,563	3.51	0.00	0.00	4w4jqn6ynu2t6	w3wp.exe	SELECT ID, CODE, NAME, VALU...
42,671	42,670	1.00	0.22	1.01	6mcx478k6hjgw	w3wp.exe	begin Pack_Question_HalfYear20...
39,540	39,540	1.00	0.10	0.35	83444u5pdds28	w3wp.exe	SELECT T.PAGEID FROM TURLSAVE ...
18,439	18,449	1.00	0.09	0.51	gp7mhv9ttvjx9	w3wp.exe	SELECT T.UNIVERSITY, T.SKILLM...
18,081	69,746	3.86	0.00	0.02	a9b61nv1wt9sp	w3wp.exe	SELECT ID, NAME, TYPEID, IS...
18,064	18,064	1.00	0.22	0.98	6t6y6a8uf7h81	w3wp.exe	begin Pack_Question_HalfYear20...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 562,709
Captured SQL account for 67.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
46,361	46,235	8.24	8978nm09rf81x	w3wp.exe	begin Pack_Question_HalfYear20...
46,071	46,075	8.19	40qdy6x6nj3w3	w3wp.exe	SELECT ID, NAME, ACLASS, IS...
42,940	42,946	7.63	4w4jqn6ynu2t6	w3wp.exe	SELECT ID, CODE, NAME, VALU...
42,669	42,671	7.58	6mcx478k6hjgw	w3wp.exe	begin Pack_Question_HalfYear20...
18,083	18,081	3.21	a9b61nv1wt9sp	w3wp.exe	SELECT ID, NAME, TYPEID, IS...
18,054	18,064	3.21	6t6y6a8uf7h81	w3wp.exe	begin Pack_Question_HalfYear20...
15,000	15,000	2.67	1cjy8v3c0agny		select sys_nc_oid$ from xdb.xd...
11,293	11,306	2.01	gky1rjtvqz204	w3wp.exe	begin Pack_Question_HalfYear20...
9,343	9,344	1.66	6a87wwu0s5c4n	w3wp.exe	begin Pack_Question_HalfYear20...
9,018	9,018	1.60	8jsnj7pdcky1t	w3wp.exe	begin PACK_ZAIXIAN_HALF2014.ge...
8,849	8,845	1.57	2x694qcar906x	w3wp.exe	begin Pack_Question_HalfYear20...
8,435	8,435	1.50	4h3s21tkvmjc7	w3wp.exe	SELECT T.* FROM ( SELECT ELT.I...
7,841	7,843	1.39	0wvbawcd0jmyp	w3wp.exe	SELECT T.ID, T.NAME, T.ISDIS...
7,840	7,840	1.39	d52frq5714gv6	w3wp.exe	begin Pack_Question_HalfYear20...
7,650	7,650	1.36	0t1wsfnfgqr99	w3wp.exe	begin Pack_Question_HalfYear20...

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
23	110	8v3x66a81q0f4	EmailAllocater.exe	begin PACK_CI_DATA.todo_data(p...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

06pzqkj5qdmkm SELECT T.SKILLUSERID, T.GRADE FROM EMAIL T WHERE (T.EMAIL = :B2 OR T.STUDENTNO=:B2 ) AND ACLASS = :B1

0t1wsfnfgqr99 begin Pack_Question_HalfYear2014.get_province(p_entry=>:p_entry, p_aclass=>:p_aclass, p_grade=>:p_grade, p_out=>:p_out); end;

0wvbawcd0jmyp SELECT T.ID, T.NAME, T.ISDISPLAY, T.URL, T.DESCRIPTION, T.PROGRESS, T.INNERJS, T.ACLASS FROM PAGE T WHERE T.ACLASS = :B1

10x7rsw0vqnjc SELECT T.GRADE FROM EMAIL T WHERE T.ACLASS=:B2 AND T.SKILLUSERID=:B1

1cjy8v3c0agny select sys_nc_oid$ from xdb.xdb$resource where rowid = :1

1ph4fbq6dqx29 begin PROC_email.handle_email_check_detail(p_emailid=>:p_emailid, p_aclass=>:p_aclass, p_themes=>:p_themes, p_sendno=>:p_sendno, p_from=>:p_from, p_to=>:p_to, p_subject=>:p_subject, p_box=>:p_box, p_indate=>:p_indate, p_out=>:p_out); end;

2x694qcar906x begin Pack_Question_HalfYear2014.write_answer(p_aclass=>:p_aclass, p_serialno=>:p_serialno, p_answer=>:p_answer, p_submit=>:p_submit, p_page_id=>:p_page_id, p_next_page=>:p_next_page, p_out=>:p_out); end;

2xr7zr9py13cy begin proc_syn.update_syn2(p_serialno=>:p_serialno, p_result=>:p_result, p_sqlcode=>:p_sqlcode, p_sqlerrtext=>:p_sqlerrtext, p_status=>:p_status); end;

3zy11982rmffj SELECT COUNT(*) FROM EMAIL_CHECK_DETAIL WHERE MSG_SENDNO = :B1

40qdy6x6nj3w3 SELECT ID, NAME, ACLASS, ISDISPLAY, URL, DESCRIPTION, PROGRESS, INNERJS FROM PAGE T WHERE T.ID = :B2 AND T.ACLASS = :B1

4c3kmcpszc3v9 INSERT INTO LOGININFO2 (ACLASS, SERIALNO, SIP, INDATE, SIGN, V_E, V_OS, UNIVERSITY, PAGE, PWD, MACADDRESS, GRADE) VALUES (:B11 , :B10 , :B9 , SYSDATE, :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

4h3s21tkvmjc7 SELECT T.* FROM ( SELECT ELT.ID ID, ELT.ACLASS, ELT.SERIALNO, ELT.UNIVERSITYCD UNICODE, ELT.DEPARTMENTNAME DEPARTMENT, ELT.MAJORCD MAJORCODE, ELT.GRADE GRADE, ELT.PROVINCECD PROVINCE, ELT.EDU_LEVEL LEVELS, TO_CHAR(ELT.RESEARCHYEAR, 'yyyy') YEARS, ELT.QUESTIONCD QID, ELT.ANSWER ANSWERS, ELT.ANSWER_TIME, '' OPERATION, ELT.ZSFS ZSFS, ELT.SYKJ SYKJ, ELT.QUESTIONTYP QUESTIONTYP, ELT.MEMO FROM ETLTABLE_HALF2014 ELT WHERE ELT.ACLASS=:B3 AND ELT.UNIVERSITYCD=:B2 AND ELT.ID>:B1 ORDER BY ID ASC) T WHERE ROWNUM<=:B4

4nzwak1v8atr1 SELECT COUNT(*) FROM EMAIL T WHERE (T.EMAIL = :B2 OR T.STUDENTNO=:B2 ) AND T.ACLASS = :B1

4w4jqn6ynu2t6 SELECT ID, CODE, NAME, VALUE, TYPEID, ISDISPLAY, ISMUTEX, CHILDQUES, HASITEMCODE, TITLE FROM QUESTION_ITEMS T WHERE T.QUESTIONID = :B4 AND T.ACLASS = :B3 AND T.ISVALID = '1' AND T.UNIVERSITY = '0' AND T.MAJORTYPE IS NULL AND T.MAJORCODE IS NULL AND (T.SLEVELS = :B2 OR T.SLEVELS IS NULL) AND (T.ISBEFORE='1' OR (T.ISBEFORE='0' AND T.CREATETIME<:B1 )) ORDER BY TO_NUMBER(T.IDORDER)

56dtpxd4da6ar DELETE FROM LOGININFO2 F WHERE F.SERIALNO = :B1

5r2mcvsf8c09r SELECT NVL(T.SC_SIGN, '-1') FROM EMAIL T WHERE T.SKILLUSERID=:B1

6801khqm015n7 SELECT STARTTIME FROM UNIVERSITY_CONFIG WHERE ACLASS=:B2 AND UNIVERSITY_CODE=:B1

6a87wwu0s5c4n begin Pack_Question_HalfYear2014.get_answer(p_aclass=>:p_aclass, p_userid=>:p_userid, p_question=>:p_question, p_out=>:p_out); end;

6c263jxsf4n3v SELECT COUNT(1) FROM EMAIL T WHERE T.ACLASS = :B2 AND T.SKILLUSERID = :B1

6khtujxhkp15r DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN --old proc_stat.state_area; proc_stat.insert_answered(to_char(sysdate, 'yyyymmdd')); proc_stat.update_serialno_os(to_char(sysdate, 'yyyymmdd')); proc_stat.protocol_2013; proc_stat.protocol_medical; proc_stat.protocol_medical_all; proc_stat.protocol_2014_m3; proc_stat.protocol_2014_mas; proc_stat.protocol_3year_2010; proc_stat.protocol_3year_2011_xy; proc_stat.protocol_2014_doc; proc_stat.protocol_3year_2011_305; --new proc_stat_data.add_info_university(to_char(sysdate, 'yyyymmdd')); proc_stat_data.add_info_serialno(to_char(sysdate, 'yyyymmdd')); proc_stat_data.update_serialno_os; proc_stat_data.state_main_data(to_char(sysdate, 'yyyymmdd')); proc_stat_data.protocol_3year_2011(to_char(sysdate, 'yyyymmdd')); proc_stat_data.protocol_state(to_char(sysdate, 'yyyymmdd')); commit; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

6mcx478k6hjgw begin Pack_Question_HalfYear2014.GetItemsByQuestion(P_QUESTION_ID=>:P_QUESTION_ID, P_ACLASS=>:P_ACLASS, P_USERID=>:P_USERID, P_OUT=>:P_OUT); end;

6t6y6a8uf7h81 begin Pack_Question_HalfYear2014.GetQuestionsByPage(P_PAGE_ID=>:P_PAGE_ID, P_ACLASS=>:P_ACLASS, P_USERID=>:P_USERID, P_OUT=>:P_OUT); end;

81txbgd33bpb9 UPDATE NEEDSYN2 SET RESULT = :B5 , SQLCODE = :B4 , SQLERRTEXT = :B3 , ENDDATE = SYSDATE, STATUS = :B2 WHERE SERIALNO = :B1

83444u5pdds28 SELECT T.PAGEID FROM TURLSAVE T WHERE T.USERID = :B1 AND T.GRADE IN ( SELECT F.GRADE FROM EMAIL F WHERE F.ACLASS=:B2 AND F.SKILLUSERID=:B1 )

8978nm09rf81x begin Pack_Question_HalfYear2014.NextPage(P_ID=>:P_ID, P_USERID=>:P_USERID, P_TYPE=>:P_TYPE, P_ACLASS=>:P_ACLASS, P_OUT=>:P_OUT); end;

8ap25t1xf9tcd begin proc_syn.write_syn(p_serialno=>:p_serialno, p_syntext=>:p_syntext, p_syntime=>:p_syntime, p_syncode=>:p_syncode); end;

8jsnj7pdcky1t begin PACK_ZAIXIAN_HALF2014.get_Answer(P_ACLASS=>:P_ACLASS, P_UNICODE=>:P_UNICODE, TOTAL=>:TOTAL, ANSSEQ=>:ANSSEQ, P_OUT=>:P_OUT); end;

8v3x66a81q0f4 begin PACK_CI_DATA.todo_data(p_aclass=>:p_aclass, p_grade=>:p_grade, p_serialno=>:p_serialno, p_questionid=>:p_questionid, p_questionid2=>:p_questionid2, p_questiontyp=>:p_questiontyp, p_answer=>:p_answer, p_answer2=>:p_answer2, p_answertime=>:p_answertime, p_university=>:p_university, p_college=>:p_college, p_skillmajor=>:p_skillmajor, p_levels=>:p_levels, p_zsfs=>:p_zsfs, p_sykj=>:p_sykj, p_memo=>:p_memo, p_province=>:p_province, p_out=>:p_out); end;

91qp5nzbj4dx4 SELECT T.MODULE FROM UNIVERSITY_CONFIG T WHERE T.ACLASS = :B1 AND T.UNIVERSITY_CODE IN (SELECT F.UNIVERSITY FROM QUSER F WHERE F.ACLASS = :B1 AND F.ID = :B2 )

958hcz6bpfwr2 SELECT T.Q_TYPE FROM QUESTION T WHERE T.ACLASS = :B2 AND T.ID = :B1

97dups5qvw37s SELECT COUNT(*) FROM NEEDSYN WHERE SERIALNO = :B1

9gv1w0bca02tv select a.universityname ѧУ��, a.senddate �׷��, a.send_days ��, a.sendcount ��ʹ��, calrate(a.answer_all, a.email_all) ��У��, calrate(a.answer_all, a.email_all-nvl(a.email_wrong, 0)-nvl(a.email_refused, 0)) ��鲿��, nvl(b.total, 0) ʣ��QQ��, get_minus_rate_date(a.university, '2014_xy', 7) ǰ��, get_minus_rate_date(a.university, '2014_xy', 6) ǰ��, get_minus_rate_date(a.university, '2014_xy', 5) ǰ��, get_minus_rate_date(a.university, '2014_xy', 4) ǰ��, get_minus_rate_date(a.university, '2014_xy', 3) ǰ��, get_minus_rate_date(a.university, '2014_xy', 2) ǰ��, get_minus_rate_date(a.university, '2014_xy', 1) ǰһ�� from state.protocol_state a, ( select d.serialno, c.unit_id, count(*) total from quser a, email b, unit_serialno c, protocol_university_unit d where a.serialno=b.skilluserid and a.serialno=c.serialno and c.unit_id = d.unit_id and a.email like '%qq.com%' and a.state='1' and a.overflag='0' and b.sc_sign is null and a.aclass=205 and d.aclass=205 and d.startdate is not null and lockdate is null group by d.serialno, c.unit_id )b where a.state_day = replace(to_char(sysdate-1, 'yyyy-mm-dd'), '-', '') and a.unit_id=b.unit_id and a.state_id='2014_xy' order by a.send_days desc

9mhydycsxzwbu SELECT T.SKILLMAJOR, T.UNIVERSITY, T.GRADE, T.SLEVELS FROM EMAIL T WHERE T.ACLASS = :B2 AND T.SKILLUSERID = :B1

a9b61nv1wt9sp SELECT ID, NAME, TYPEID, ISDISPLAY, MUSTANSWER, Q_TYPE, Q_FIELD, ISCHILD, PROC, SAVECHILD FROM QUESTION T WHERE T.PAGEID = TRUNC(:B5 ) AND T.ACLASS = :B4 AND T.ISVALID = '1' AND T.GRADETYPE = :B3 AND (T.SLEVELS = :B2 OR T.SLEVELS IS NULL) AND (T.ISBEFORE='1' OR (T.ISBEFORE='0' AND T.CREATETIME<:B1 )) ORDER BY T.IDORDER

c2wum8uptj4p7 SELECT T.* FROM (SELECT ELT.ID ID, ELT.ACLASS, ELT.SERIALNO, ELT.UNIVERSITYCD UNICODE, ELT.DEPARTMENTNAME DEPARTMENT, ELT.MAJORCD MAJORCODE, ELT.GRADE GRADE, ELT.PROVINCECD PROVINCE, ELT.EDU_LEVEL LEVELS, TO_CHAR(ELT.RESEARCHYEAR, 'yyyy') YEARS, ELT.QUESTIONCD QID, ELT.ANSWER ANSWERS, ELT.ANSWER_TIME, '' OPERATION, ELT.ZSFS ZSFS, ELT.SYKJ SYKJ, ELT.QUESTIONTYP QUESTIONTYP, ELT.MEMO FROM ETLTABLE_HALF2014 ELT WHERE ELT.ACLASS=:B2 AND ELT.UNIVERSITYCD=:B1 ORDER BY ID ASC) T WHERE ROWNUM<=:B3

c4k92q6huqh39 select * from resultmultiexpand where aclass='205' and parent='405' and serialno not in(select t.serialno from resultonly t, resultonly s where t.aclass='205' and t.question='2000' and t.answer in('1', '2', '8', 'b') and t.aclass=s.aclass and s.question='210' and s.answer in('1', '2')) and answer is not null

cbutzrjdc7695 begin PROC_smanager.remove_ANS(p_aclass=>:p_aclass, p_serialno=>:p_serialno, p_out=>:p_out); end;

d52frq5714gv6 begin Pack_Question_HalfYear2014.GetPage(P_ID=>:P_ID, P_ACLASS=>:P_ACLASS, P_OUT=>:P_OUT); end;

dxuqr5nua83uh begin Pack_Question_HalfYear2014.Login(P_ACLASS=>:P_ACLASS, P_EMAIL=>:P_EMAIL, P_PWD=>:P_PWD, P_SIP=>:P_SIP, P_SFROM=>:P_SFROM, P_E=>:P_E, P_OS=>:P_OS, P_UNIVERSITY=>:P_UNIVERSITY, P_PAGE=>:P_PAGE, P_GRADE=>:P_GRADE, P_EXT=>:P_EXT, P_OUT=>:P_OUT); end;

gky1rjtvqz204 begin Pack_Question_HalfYear2014.open_web(p_aclass=>:p_aclass, p_passwd=>:p_passwd, p_email=>:p_email, p_university=>:p_university, p_ip=>:p_ip, p_sfrom=>:p_sfrom, p_e=>:p_e, p_os=>:p_os, p_page=>:p_page, p_url=>:p_url, p_mac=>:p_mac, p_ext=>:p_ext, p_out=>:p_out); end;

gp7mhv9ttvjx9 SELECT T.UNIVERSITY, T.SKILLMAJOR, T.GRADE, T.SLEVELS FROM EMAIL T WHERE T.ACLASS = :B2 AND T.SKILLUSERID = :B1

gv24rbfjd8dt6 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN proc_stat.protocol_3year_2010; proc_stat.protocol_3year_2011; proc_stat.protocol_2011_11417; proc_stat.protocol_3year_2011nb; proc_stat.protocol_2012; proc_stat.protocol_2013; proc_stat.protocol_mid_2012; proc_stat.protocol_mid_2013; proc_stat.protocol_gdsh; proc_stat.protocol_course_detail; proc_stat.protocol_dt261; proc_stat.protocol_dt361; proc_stat.protocol_gd; proc_stat.protocol_gd_2013; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

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

SQL Id	SQL Text
06pzqkj5qdmkm	SELECT T.SKILLUSERID, T.GRADE FROM EMAIL T WHERE (T.EMAIL = :B2 OR T.STUDENTNO=:B2 ) AND ACLASS = :B1
0t1wsfnfgqr99	begin Pack_Question_HalfYear2014.get_province(p_entry=>:p_entry, p_aclass=>:p_aclass, p_grade=>:p_grade, p_out=>:p_out); end;
0wvbawcd0jmyp	SELECT T.ID, T.NAME, T.ISDISPLAY, T.URL, T.DESCRIPTION, T.PROGRESS, T.INNERJS, T.ACLASS FROM PAGE T WHERE T.ACLASS = :B1
10x7rsw0vqnjc	SELECT T.GRADE FROM EMAIL T WHERE T.ACLASS=:B2 AND T.SKILLUSERID=:B1
1cjy8v3c0agny	select sys_nc_oid$ from xdb.xdb$resource where rowid = :1
1ph4fbq6dqx29	begin PROC_email.handle_email_check_detail(p_emailid=>:p_emailid, p_aclass=>:p_aclass, p_themes=>:p_themes, p_sendno=>:p_sendno, p_from=>:p_from, p_to=>:p_to, p_subject=>:p_subject, p_box=>:p_box, p_indate=>:p_indate, p_out=>:p_out); end;
2x694qcar906x	begin Pack_Question_HalfYear2014.write_answer(p_aclass=>:p_aclass, p_serialno=>:p_serialno, p_answer=>:p_answer, p_submit=>:p_submit, p_page_id=>:p_page_id, p_next_page=>:p_next_page, p_out=>:p_out); end;
2xr7zr9py13cy	begin proc_syn.update_syn2(p_serialno=>:p_serialno, p_result=>:p_result, p_sqlcode=>:p_sqlcode, p_sqlerrtext=>:p_sqlerrtext, p_status=>:p_status); end;
3zy11982rmffj	SELECT COUNT(*) FROM EMAIL_CHECK_DETAIL WHERE MSG_SENDNO = :B1
40qdy6x6nj3w3	SELECT ID, NAME, ACLASS, ISDISPLAY, URL, DESCRIPTION, PROGRESS, INNERJS FROM PAGE T WHERE T.ID = :B2 AND T.ACLASS = :B1
4c3kmcpszc3v9	INSERT INTO LOGININFO2 (ACLASS, SERIALNO, SIP, INDATE, SIGN, V_E, V_OS, UNIVERSITY, PAGE, PWD, MACADDRESS, GRADE) VALUES (:B11 , :B10 , :B9 , SYSDATE, :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
4h3s21tkvmjc7	SELECT T.* FROM ( SELECT ELT.ID ID, ELT.ACLASS, ELT.SERIALNO, ELT.UNIVERSITYCD UNICODE, ELT.DEPARTMENTNAME DEPARTMENT, ELT.MAJORCD MAJORCODE, ELT.GRADE GRADE, ELT.PROVINCECD PROVINCE, ELT.EDU_LEVEL LEVELS, TO_CHAR(ELT.RESEARCHYEAR, 'yyyy') YEARS, ELT.QUESTIONCD QID, ELT.ANSWER ANSWERS, ELT.ANSWER_TIME, '' OPERATION, ELT.ZSFS ZSFS, ELT.SYKJ SYKJ, ELT.QUESTIONTYP QUESTIONTYP, ELT.MEMO FROM ETLTABLE_HALF2014 ELT WHERE ELT.ACLASS=:B3 AND ELT.UNIVERSITYCD=:B2 AND ELT.ID>:B1 ORDER BY ID ASC) T WHERE ROWNUM<=:B4
4nzwak1v8atr1	SELECT COUNT(*) FROM EMAIL T WHERE (T.EMAIL = :B2 OR T.STUDENTNO=:B2 ) AND T.ACLASS = :B1
4w4jqn6ynu2t6	SELECT ID, CODE, NAME, VALUE, TYPEID, ISDISPLAY, ISMUTEX, CHILDQUES, HASITEMCODE, TITLE FROM QUESTION_ITEMS T WHERE T.QUESTIONID = :B4 AND T.ACLASS = :B3 AND T.ISVALID = '1' AND T.UNIVERSITY = '0' AND T.MAJORTYPE IS NULL AND T.MAJORCODE IS NULL AND (T.SLEVELS = :B2 OR T.SLEVELS IS NULL) AND (T.ISBEFORE='1' OR (T.ISBEFORE='0' AND T.CREATETIME<:B1 )) ORDER BY TO_NUMBER(T.IDORDER)
56dtpxd4da6ar	DELETE FROM LOGININFO2 F WHERE F.SERIALNO = :B1
5r2mcvsf8c09r	SELECT NVL(T.SC_SIGN, '-1') FROM EMAIL T WHERE T.SKILLUSERID=:B1
6801khqm015n7	SELECT STARTTIME FROM UNIVERSITY_CONFIG WHERE ACLASS=:B2 AND UNIVERSITY_CODE=:B1
6a87wwu0s5c4n	begin Pack_Question_HalfYear2014.get_answer(p_aclass=>:p_aclass, p_userid=>:p_userid, p_question=>:p_question, p_out=>:p_out); end;
6c263jxsf4n3v	SELECT COUNT(1) FROM EMAIL T WHERE T.ACLASS = :B2 AND T.SKILLUSERID = :B1
6khtujxhkp15r	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN --old proc_stat.state_area; proc_stat.insert_answered(to_char(sysdate, 'yyyymmdd')); proc_stat.update_serialno_os(to_char(sysdate, 'yyyymmdd')); proc_stat.protocol_2013; proc_stat.protocol_medical; proc_stat.protocol_medical_all; proc_stat.protocol_2014_m3; proc_stat.protocol_2014_mas; proc_stat.protocol_3year_2010; proc_stat.protocol_3year_2011_xy; proc_stat.protocol_2014_doc; proc_stat.protocol_3year_2011_305; --new proc_stat_data.add_info_university(to_char(sysdate, 'yyyymmdd')); proc_stat_data.add_info_serialno(to_char(sysdate, 'yyyymmdd')); proc_stat_data.update_serialno_os; proc_stat_data.state_main_data(to_char(sysdate, 'yyyymmdd')); proc_stat_data.protocol_3year_2011(to_char(sysdate, 'yyyymmdd')); proc_stat_data.protocol_state(to_char(sysdate, 'yyyymmdd')); commit; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6mcx478k6hjgw	begin Pack_Question_HalfYear2014.GetItemsByQuestion(P_QUESTION_ID=>:P_QUESTION_ID, P_ACLASS=>:P_ACLASS, P_USERID=>:P_USERID, P_OUT=>:P_OUT); end;
6t6y6a8uf7h81	begin Pack_Question_HalfYear2014.GetQuestionsByPage(P_PAGE_ID=>:P_PAGE_ID, P_ACLASS=>:P_ACLASS, P_USERID=>:P_USERID, P_OUT=>:P_OUT); end;
81txbgd33bpb9	UPDATE NEEDSYN2 SET RESULT = :B5 , SQLCODE = :B4 , SQLERRTEXT = :B3 , ENDDATE = SYSDATE, STATUS = :B2 WHERE SERIALNO = :B1
83444u5pdds28	SELECT T.PAGEID FROM TURLSAVE T WHERE T.USERID = :B1 AND T.GRADE IN ( SELECT F.GRADE FROM EMAIL F WHERE F.ACLASS=:B2 AND F.SKILLUSERID=:B1 )
8978nm09rf81x	begin Pack_Question_HalfYear2014.NextPage(P_ID=>:P_ID, P_USERID=>:P_USERID, P_TYPE=>:P_TYPE, P_ACLASS=>:P_ACLASS, P_OUT=>:P_OUT); end;
8ap25t1xf9tcd	begin proc_syn.write_syn(p_serialno=>:p_serialno, p_syntext=>:p_syntext, p_syntime=>:p_syntime, p_syncode=>:p_syncode); end;
8jsnj7pdcky1t	begin PACK_ZAIXIAN_HALF2014.get_Answer(P_ACLASS=>:P_ACLASS, P_UNICODE=>:P_UNICODE, TOTAL=>:TOTAL, ANSSEQ=>:ANSSEQ, P_OUT=>:P_OUT); end;
8v3x66a81q0f4	begin PACK_CI_DATA.todo_data(p_aclass=>:p_aclass, p_grade=>:p_grade, p_serialno=>:p_serialno, p_questionid=>:p_questionid, p_questionid2=>:p_questionid2, p_questiontyp=>:p_questiontyp, p_answer=>:p_answer, p_answer2=>:p_answer2, p_answertime=>:p_answertime, p_university=>:p_university, p_college=>:p_college, p_skillmajor=>:p_skillmajor, p_levels=>:p_levels, p_zsfs=>:p_zsfs, p_sykj=>:p_sykj, p_memo=>:p_memo, p_province=>:p_province, p_out=>:p_out); end;
91qp5nzbj4dx4	SELECT T.MODULE FROM UNIVERSITY_CONFIG T WHERE T.ACLASS = :B1 AND T.UNIVERSITY_CODE IN (SELECT F.UNIVERSITY FROM QUSER F WHERE F.ACLASS = :B1 AND F.ID = :B2 )
958hcz6bpfwr2	SELECT T.Q_TYPE FROM QUESTION T WHERE T.ACLASS = :B2 AND T.ID = :B1
97dups5qvw37s	SELECT COUNT(*) FROM NEEDSYN WHERE SERIALNO = :B1
9gv1w0bca02tv	select a.universityname ѧУ��, a.senddate �׷��, a.send_days ��, a.sendcount ��ʹ��, calrate(a.answer_all, a.email_all) ��У��, calrate(a.answer_all, a.email_all-nvl(a.email_wrong, 0)-nvl(a.email_refused, 0)) ��鲿��, nvl(b.total, 0) ʣ��QQ��, get_minus_rate_date(a.university, '2014_xy', 7) ǰ��, get_minus_rate_date(a.university, '2014_xy', 6) ǰ��, get_minus_rate_date(a.university, '2014_xy', 5) ǰ��, get_minus_rate_date(a.university, '2014_xy', 4) ǰ��, get_minus_rate_date(a.university, '2014_xy', 3) ǰ��, get_minus_rate_date(a.university, '2014_xy', 2) ǰ��, get_minus_rate_date(a.university, '2014_xy', 1) ǰһ�� from state.protocol_state a, ( select d.serialno, c.unit_id, count(*) total from quser a, email b, unit_serialno c, protocol_university_unit d where a.serialno=b.skilluserid and a.serialno=c.serialno and c.unit_id = d.unit_id and a.email like '%qq.com%' and a.state='1' and a.overflag='0' and b.sc_sign is null and a.aclass=205 and d.aclass=205 and d.startdate is not null and lockdate is null group by d.serialno, c.unit_id )b where a.state_day = replace(to_char(sysdate-1, 'yyyy-mm-dd'), '-', '') and a.unit_id=b.unit_id and a.state_id='2014_xy' order by a.send_days desc
9mhydycsxzwbu	SELECT T.SKILLMAJOR, T.UNIVERSITY, T.GRADE, T.SLEVELS FROM EMAIL T WHERE T.ACLASS = :B2 AND T.SKILLUSERID = :B1
a9b61nv1wt9sp	SELECT ID, NAME, TYPEID, ISDISPLAY, MUSTANSWER, Q_TYPE, Q_FIELD, ISCHILD, PROC, SAVECHILD FROM QUESTION T WHERE T.PAGEID = TRUNC(:B5 ) AND T.ACLASS = :B4 AND T.ISVALID = '1' AND T.GRADETYPE = :B3 AND (T.SLEVELS = :B2 OR T.SLEVELS IS NULL) AND (T.ISBEFORE='1' OR (T.ISBEFORE='0' AND T.CREATETIME<:B1 )) ORDER BY T.IDORDER
c2wum8uptj4p7	SELECT T.* FROM (SELECT ELT.ID ID, ELT.ACLASS, ELT.SERIALNO, ELT.UNIVERSITYCD UNICODE, ELT.DEPARTMENTNAME DEPARTMENT, ELT.MAJORCD MAJORCODE, ELT.GRADE GRADE, ELT.PROVINCECD PROVINCE, ELT.EDU_LEVEL LEVELS, TO_CHAR(ELT.RESEARCHYEAR, 'yyyy') YEARS, ELT.QUESTIONCD QID, ELT.ANSWER ANSWERS, ELT.ANSWER_TIME, '' OPERATION, ELT.ZSFS ZSFS, ELT.SYKJ SYKJ, ELT.QUESTIONTYP QUESTIONTYP, ELT.MEMO FROM ETLTABLE_HALF2014 ELT WHERE ELT.ACLASS=:B2 AND ELT.UNIVERSITYCD=:B1 ORDER BY ID ASC) T WHERE ROWNUM<=:B3
c4k92q6huqh39	select * from resultmultiexpand where aclass='205' and parent='405' and serialno not in(select t.serialno from resultonly t, resultonly s where t.aclass='205' and t.question='2000' and t.answer in('1', '2', '8', 'b') and t.aclass=s.aclass and s.question='210' and s.answer in('1', '2')) and answer is not null
cbutzrjdc7695	begin PROC_smanager.remove_ANS(p_aclass=>:p_aclass, p_serialno=>:p_serialno, p_out=>:p_out); end;
d52frq5714gv6	begin Pack_Question_HalfYear2014.GetPage(P_ID=>:P_ID, P_ACLASS=>:P_ACLASS, P_OUT=>:P_OUT); end;
dxuqr5nua83uh	begin Pack_Question_HalfYear2014.Login(P_ACLASS=>:P_ACLASS, P_EMAIL=>:P_EMAIL, P_PWD=>:P_PWD, P_SIP=>:P_SIP, P_SFROM=>:P_SFROM, P_E=>:P_E, P_OS=>:P_OS, P_UNIVERSITY=>:P_UNIVERSITY, P_PAGE=>:P_PAGE, P_GRADE=>:P_GRADE, P_EXT=>:P_EXT, P_OUT=>:P_OUT); end;
gky1rjtvqz204	begin Pack_Question_HalfYear2014.open_web(p_aclass=>:p_aclass, p_passwd=>:p_passwd, p_email=>:p_email, p_university=>:p_university, p_ip=>:p_ip, p_sfrom=>:p_sfrom, p_e=>:p_e, p_os=>:p_os, p_page=>:p_page, p_url=>:p_url, p_mac=>:p_mac, p_ext=>:p_ext, p_out=>:p_out); end;
gp7mhv9ttvjx9	SELECT T.UNIVERSITY, T.SKILLMAJOR, T.GRADE, T.SLEVELS FROM EMAIL T WHERE T.ACLASS = :B2 AND T.SKILLUSERID = :B1
gv24rbfjd8dt6	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN proc_stat.protocol_3year_2010; proc_stat.protocol_3year_2011; proc_stat.protocol_2011_11417; proc_stat.protocol_3year_2011nb; proc_stat.protocol_2012; proc_stat.protocol_2013; proc_stat.protocol_mid_2012; proc_stat.protocol_mid_2013; proc_stat.protocol_gdsh; proc_stat.protocol_course_detail; proc_stat.protocol_dt261; proc_stat.protocol_dt361; proc_stat.protocol_gd; proc_stat.protocol_gd_2013; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
gyjk5c75k457q	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PROC_ANSWER_STAT; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	2,791,676	776.16	59.15
CPU used when call started	2,696,357	749.66	57.13
CR blocks created	28,447	7.91	0.60
Cached Commit SCN referenced	13,340	3.71	0.28
Commit SCN cached	2	0.00	0.00
DB time	19,403,604	5,394.69	411.09
DBWR checkpoint buffers written	38,455	10.69	0.81
DBWR checkpoints	4	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR thread checkpoint buffers written	10,343	2.88	0.22
DBWR transaction table writes	385	0.11	0.01
DBWR undo block writes	13,619	3.79	0.29
SMON posted for undo segment shrink	4	0.00	0.00
SQL*Net roundtrips to/from client	359,537	99.96	7.62
SQL*Net roundtrips to/from dblink	0	0.00	0.00
active txn count during cleanout	24,852	6.91	0.53
application wait time	398	0.11	0.01
background checkpoints completed	6	0.00	0.00
background checkpoints started	4	0.00	0.00
background timeouts	9,668	2.69	0.20
branch node splits	2	0.00	0.00
buffer is not pinned count	53,716,215	14,934.47	1,138.06
buffer is pinned count	299,257,520	83,201.18	6,340.20
bytes received via SQL*Net from client	115,070,495	31,992.52	2,437.93
bytes received via SQL*Net from dblink	0	0.00	0.00
bytes sent via SQL*Net to client	255,901,047	71,146.98	5,421.63
bytes sent via SQL*Net to dblink	0	0.00	0.00
calls to get snapshot scn: kcmgss	4,571,359	1,270.95	96.85
calls to kcmgas	110,410	30.70	2.34
calls to kcmgcs	5,296	1.47	0.11
change write time	2,019	0.56	0.04
cleanout - number of ktugct calls	23,819	6.62	0.50
cleanouts and rollbacks - consistent read gets	16,896	4.70	0.36
cleanouts only - consistent read gets	301	0.08	0.01
cluster key scan block gets	9,769	2.72	0.21
cluster key scans	2,752	0.77	0.06
commit batch/immediate performed	4	0.00	0.00
commit batch/immediate requested	4	0.00	0.00
commit cleanout failures: block lost	2	0.00	0.00
commit cleanout failures: buffer being written	21	0.01	0.00
commit cleanout failures: callback failure	134	0.04	0.00
commit cleanout failures: cannot pin	39	0.01	0.00
commit cleanouts	187,824	52.22	3.98
commit cleanouts successfully completed	187,628	52.17	3.98
commit immediate performed	4	0.00	0.00
commit immediate requested	4	0.00	0.00
commit txn count during cleanout	776	0.22	0.02
concurrency wait time	4,743,188	1,318.73	100.49
consistent changes	56,733	15.77	1.20
consistent gets	1,881,760,955	523,177.29	39,867.82
consistent gets - examination	17,191,563	4,779.69	364.23
consistent gets direct	6,500	1.81	0.14
consistent gets from cache	1,881,754,456	523,175.49	39,867.68
current blocks converted for CR	1	0.00	0.00
cursor authentications	1,572	0.44	0.03
data blocks consistent reads - undo records applied	56,552	15.72	1.20
db block changes	1,042,735	289.91	22.09
db block gets	862,486	239.79	18.27
db block gets direct	385	0.11	0.01
db block gets from cache	862,101	239.69	18.26
deferred (CURRENT) block cleanout applications	102,549	28.51	2.17
dirty buffers inspected	2,582	0.72	0.05
enqueue conversions	1,636	0.45	0.03
enqueue releases	246,949	68.66	5.23
enqueue requests	247,053	68.69	5.23
enqueue timeouts	117	0.03	0.00
enqueue waits	87	0.02	0.00
exchange deadlocks	0	0.00	0.00
execute count	1,748,051	486.00	37.03
free buffer inspected	3,866,793	1,075.07	81.92
free buffer requested	3,439,196	956.18	72.86
heap block compress	9,396	2.61	0.20
hot buffers moved to head of LRU	778,822	216.53	16.50
immediate (CR) block cleanout applications	17,197	4.78	0.36
immediate (CURRENT) block cleanout applications	2,348	0.65	0.05
index fast full scans (full)	63,856	17.75	1.35
index fetch by key	7,812,111	2,171.97	165.51
index scans kdiixs1	2,123,377	590.35	44.99
leaf node 90-10 splits	142	0.04	0.00
leaf node splits	501	0.14	0.01
lob reads	7,238	2.01	0.15
lob writes	124	0.03	0.00
lob writes unaligned	124	0.03	0.00
logons cumulative	897	0.25	0.02
messages received	15,962	4.44	0.34
messages sent	15,960	4.44	0.34
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	1,859,411,019	516,963.45	39,394.30
opened cursors cumulative	561,372	156.08	11.89
parse count (failures)	19	0.01	0.00
parse count (hard)	8,435	2.35	0.18
parse count (total)	562,709	156.45	11.92
parse time cpu	3,188	0.89	0.07
parse time elapsed	39,713	11.04	0.84
physical read IO requests	574,990	159.86	12.18
physical read bytes	27,720,654,848	7,707,045.45	587,302.01
physical read total IO requests	590,894	164.28	12.52
physical read total bytes	28,297,122,816	7,867,318.18	599,515.31
physical read total multi block requests	452,849	125.90	9.59
physical reads	3,383,869	940.80	71.69
physical reads cache	3,377,177	938.94	71.55
physical reads cache prefetch	2,808,879	780.94	59.51
physical reads direct	6,692	1.86	0.14
physical reads direct (lob)	6,500	1.81	0.14
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	27,813	7.73	0.59
physical write bytes	343,179,264	95,412.54	7,270.75
physical write total IO requests	42,324	11.77	0.90
physical write total bytes	778,833,920	216,535.59	16,500.72
physical write total multi block requests	19,527	5.43	0.41
physical writes	41,892	11.65	0.89
physical writes direct	577	0.16	0.01
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	41,315	11.49	0.88
physical writes non checkpoint	28,983	8.06	0.61
pinned buffers inspected	1,652	0.46	0.04
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	10	0.00	0.00
process last non-idle time	3,582	1.00	0.08
recursive calls	2,719,126	755.99	57.61
recursive cpu usage	2,670,982	742.60	56.59
redo blocks written	374,884	104.23	7.94
redo buffer allocation retries	219	0.06	0.00
redo entries	536,091	149.05	11.36
redo log space requests	2,191	0.61	0.05
redo log space wait time	202,152	56.20	4.28
redo ordering marks	7,829	2.18	0.17
redo size	182,387,472	50,708.35	3,864.14
redo synch time	1,446,122	402.06	30.64
redo synch writes	32,822	9.13	0.70
redo wastage	3,328,200	925.32	70.51
redo write time	269,646	74.97	5.71
redo writer latching time	711	0.20	0.02
redo writes	14,388	4.00	0.30
rollback changes - undo records applied	12	0.00	0.00
rollbacks only - consistent read gets	11,373	3.16	0.24
rows fetched via callback	5,606,436	1,558.73	118.78
session connect time	0	0.00	0.00
session cursor cache hits	223,282	62.08	4.73
session logical reads	1,882,623,447	523,417.09	39,886.09
session pga memory	449,460,424	124,961.40	9,522.47
session pga memory max	7,250,852,040	2,015,920.86	153,619.75
session uga memory	###############	640,038,892.01	48,773,051.83
session uga memory max	1,418,703,624	394,435.61	30,057.28
shared hash latch upgrades - no wait	2,190,615	609.05	46.41
sorts (disk)	0	0.00	0.00
sorts (memory)	96,582	26.85	2.05
sorts (rows)	38,928,941	10,823.23	824.77
sql area purged	0	0.00	0.00
summed dirty queue length	5,654	1.57	0.12
switch current to new buffer	21,911	6.09	0.46
table fetch by rowid	170,016,463	47,268.89	3,602.04
table fetch continued row	25,718	7.15	0.54
table scan blocks gotten	1,189,026,910	330,579.65	25,191.25
table scan rows gotten	90,765,194,837	25,235,027.32	1,922,991.42
table scans (long tables)	50	0.01	0.00
table scans (short tables)	379,639	105.55	8.04
total number of times SMON posted	6	0.00	0.00
transaction rollbacks	4	0.00	0.00
undo change vector size	60,166,672	16,727.86	1,274.72
user I/O wait time	990,553	275.40	20.99
user calls	701,281	194.97	14.86
user commits	47,200	13.12	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	78,965	21.95	1.67
write clones created in background	35	0.01	0.00
write clones created in foreground	1,748	0.49	0.04

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	37,163	47,954
opened cursors current	5,663	2,815
logons current	183	136

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

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SKILLS_DATA	465,351	129	8.90	5.93	1,353	0	8,417	196.16
XYSURVERYTBS	48,244	13	48.36	3.45	7,407	2	6,228	310.42
EMAIL_WORK	51,249	14	5.06	7.95	299	0	0	0.00
UNDOTBS1	232	0	3.10	1.00	7,997	2	45	615.11
STATE_DATA	5,975	2	50.44	6.91	287	0	779	174.89
XYMAINTTBS	655	0	117.15	3.05	4,529	1	2	130.00
APPS_DATA	214	0	52.80	1.34	3,599	1	0	0.00
SYSTEM	1,465	0	135.45	1.08	265	0	66	465.00
SYSAUX	512	0	85.53	1.01	574	0	0	0.00
DEVELOPE	53	0	184.72	1.00	812	0	0	0.00
USERS	22	0	190.45	1.00	589	0	90	290.22
EMPLY	556	0	131.64	4.31	25	0	0	0.00
PUBCODE_DATA	281	0	23.99	1.58	6	0	0	0.00
EMPLYSEND	199	0	143.02	6.72	11	0	0	0.00
MYCOSSURVERYDATATB	8	0	86.25	1.00	6	0	0	0.00
BSKILL	6	0	0.00	1.00	6	0	0	0.00
DAOCHUTBS	6	0	0.00	1.00	6	0	0	0.00
DIAOCHAOBUTB	6	0	0.00	1.00	6	0	0	0.00
HALFENTER	6	0	0.00	1.00	6	0	0	0.00
HALFENTERSEND	6	0	0.00	1.00	6	0	0	0.00
IMPORTUSER	6	0	0.00	1.00	6	0	0	0.00
MAILCHECK_WORK	6	0	0.00	1.00	6	0	0	0.00
SENDMAILOPENTB	6	0	0.00	1.00	6	0	0	0.00
TEMP	0	0	0.00		6	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)
APPS_DATA	/u01/oracle/oradata/research/apps_data.dbf	214	0	52.80	1.34	3,599	1	0	0.00
BSKILL	/u01/oracle/oradata/research/bskill.dbf	6	0	0.00	1.00	6	0	0	0.00
DAOCHUTBS	/u01/oracle/oradata/research/daochu01.dbf	6	0	0.00	1.00	6	0	0	0.00
DEVELOPE	/u01/oracle/oradata/research/DEVELOPE.DBF	21	0	119.05	1.00	280	0	0	0.00
DEVELOPE	/u01/oracle/oradata/research/develope.dbf	10	0	214.00	1.00	225	0	0	0.00
DEVELOPE	/u01/oracle/oradata/research/develope01.dbf	10	0	217.00	1.00	162	0	0	0.00
DEVELOPE	/u01/oracle/oradata/research/develope02.dbf	12	0	248.33	1.00	145	0	0	0.00
DIAOCHAOBUTB	/u01/oracle/oradata/research/diaochabutb01.dbf	6	0	0.00	1.00	6	0	0	0.00
EMAIL_WORK	/u01/oracle/oradata/research/email_work.dbf	17,584	5	5.27	7.93	216	0	0	0.00
EMAIL_WORK	/u01/oracle/oradata/research/email_work01.dbf	26,408	7	3.90	7.98	18	0	0	0.00
EMAIL_WORK	/u01/oracle/oradata/research/email_work02.dbf	7,257	2	8.77	7.89	65	0	0	0.00
EMPLY	/u01/oracle/oradata/research/emply.dbf	556	0	131.64	4.31	25	0	0	0.00
EMPLYSEND	/u01/oracle/oradata/research/emplysend.dbf	199	0	143.02	6.72	11	0	0	0.00
HALFENTER	/u01/oracle/oradata/research/halfenter.dbf	6	0	0.00	1.00	6	0	0	0.00
HALFENTERSEND	/u01/oracle/oradata/research/halfentersend.dbf	6	0	0.00	1.00	6	0	0	0.00
IMPORTUSER	/u01/oracle/oradata/research/importuser.dbf	6	0	0.00	1.00	6	0	0	0.00
MAILCHECK_WORK	/u01/oracle/oradata/research/mailcheck_work.dbf	6	0	0.00	1.00	6	0	0	0.00
MYCOSSURVERYDATATB	/u01/oracle/oradata/research/mycossurverydata01.dbf	8	0	86.25	1.00	6	0	0	0.00
PUBCODE_DATA	/u01/oracle/oradata/research/pubcode_data.dbf	281	0	23.99	1.58	6	0	0	0.00
SENDMAILOPENTB	/u01/oracle/oradata/research/sendmailopen01.dbf	6	0	0.00	1.00	6	0	0	0.00
SKILLS_DATA	/u01/oracle/oradata/research/skills_data.dbf	81,369	23	24.92	5.44	1,033	0	2,869	181.86
SKILLS_DATA	/u01/oracle/oradata/research/skills_data01.dbf	132,144	37	11.07	5.79	15	0	4,724	199.13
SKILLS_DATA	/u01/oracle/oradata/research/skills_data02	251,838	70	2.59	6.17	305	0	824	228.98
STATE_DATA	/u01/oracle/oradata/research/state_data01.dbf	4,873	1	49.14	6.71	280	0	443	186.70
STATE_DATA	/u01/oracle/oradata/research/state_data02.dbf	1,102	0	56.23	7.81	7	0	336	159.32
SYSAUX	/u01/oracle/oradata/research/sysaux01.dbf	391	0	100.84	1.02	511	0	0	0.00
SYSAUX	/u01/oracle/oradata/research/sysaux02.dbf	121	0	36.03	1.00	63	0	0	0.00
SYSTEM	/u01/oracle/oradata/research/system01.dbf	1,465	0	135.45	1.08	265	0	66	465.00
TEMP	/u01/oracle/oradata/research/temp03.dbf	0	0			6	0	0
UNDOTBS1	/u01/oracle/oradata/research/undotbs01.dbf	232	0	3.10	1.00	7,997	2	45	615.11
USERS	/u01/oracle/oradata/research/users01.dbf	22	0	190.45	1.00	589	0	90	290.22
XYMAINTTBS	/u01/oracle/oradata/research/xymaint01.dbf	655	0	117.15	3.05	4,529	1	2	130.00
XYSURVERYTBS	/u01/oracle/oradata/research/xysurvery01.dbf	48,244	13	48.36	3.45	7,407	2	6,228	310.42

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	1,091,200	100	1,877,284,368	3,377,378	50,063	0	0	15,594

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	27	14111	228718	184320	184320	449350
E	0	14	2592	27952	184320	184320	243273

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	880	0.10	109,120	25.20	197,924,224
D	1,760	0.20	218,240	7.17	56,284,198
D	2,640	0.30	327,360	2.48	19,440,884
D	3,520	0.40	436,480	1.34	10,515,202
D	4,400	0.50	545,600	1.11	8,679,090
D	5,280	0.60	654,720	1.05	8,245,961
D	6,160	0.70	763,840	1.03	8,055,222
D	7,040	0.80	872,960	1.01	7,940,161
D	7,920	0.90	982,080	1.00	7,870,209
D	8,800	1.00	1,091,200	1.00	7,853,120
D	9,680	1.10	1,200,320	1.00	7,837,534
D	10,560	1.20	1,309,440	1.00	7,831,289
D	11,440	1.30	1,418,560	1.00	7,823,070
D	12,320	1.40	1,527,680	1.00	7,819,795
D	13,200	1.50	1,636,800	1.00	7,819,787
D	14,080	1.60	1,745,920	1.00	7,819,379
D	14,960	1.70	1,855,040	1.00	7,815,057
D	15,840	1.80	1,964,160	0.99	7,796,359
D	16,720	1.90	2,073,280	0.99	7,748,855
D	17,600	2.00	2,182,400	0.98	7,677,313

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	4,806	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	3,201	2,627	580.02	0.48	0.08	100.00	0.00	327,780
E	3,201	2,698	450.71	0.00	0.00	0.00	0.00	327,780

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	77,052	77,052
64K	128K	26	26
128K	256K	18	18
256K	512K	379	379
512K	1024K	782	782
1M	2M	517	517
2M	4M	180	180
4M	8M	47	47
8M	16M	17	17
16M	32M	45	45
32M	64M	3	3
64M	128M	13	13

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 %
400	0.13	16,872.25	5,565.66	75.00
800	0.25	16,872.25	1,445.36	92.00
1,601	0.50	16,872.25	1,445.36	92.00
2,401	0.75	16,872.25	1,445.36	92.00
3,201	1.00	16,872.25	729.33	96.00
3,841	1.20	16,872.25	729.33	96.00
4,481	1.40	16,872.25	729.33	96.00
5,122	1.60	16,872.25	729.33	96.00
5,762	1.80	16,872.25	729.33	96.00
6,402	2.00	16,872.25	729.33	96.00
9,603	3.00	16,872.25	729.33	96.00
12,804	4.00	16,872.25	729.33	96.00
19,206	6.00	16,872.25	729.33	96.00
25,608	8.00	16,872.25	729.33	96.00

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
352	0.47	88	10,610	57,670	1.00	1,009	1.09	3,898,886
432	0.57	166	17,330	57,724	1.00	955	1.03	3,902,204
512	0.68	245	22,767	57,744	1.00	935	1.01	3,903,842
592	0.79	324	27,865	57,749	1.00	930	1.00	3,904,425
672	0.89	378	31,437	57,752	1.00	927	1.00	3,904,654
752	1.00	398	32,775	57,753	1.00	926	1.00	3,904,730
832	1.11	398	32,775	57,753	1.00	926	1.00	3,904,756
912	1.21	398	32,775	57,753	1.00	926	1.00	3,904,763
992	1.32	398	32,775	57,753	1.00	926	1.00	3,904,764
1,072	1.43	398	32,775	57,753	1.00	926	1.00	3,904,766
1,152	1.53	398	32,775	57,753	1.00	926	1.00	3,904,768
1,232	1.64	398	32,775	57,753	1.00	926	1.00	3,904,768
1,312	1.74	398	32,775	57,753	1.00	926	1.00	3,904,768
1,392	1.85	398	32,775	57,753	1.00	926	1.00	3,904,768
1,472	1.96	398	32,775	57,753	1.00	926	1.00	3,904,768
1,552	2.06	398	32,775	57,753	1.00	926	1.00	3,904,768

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,404	0.25	906,190	56,486,717
4,808	0.50	316,982	8,683,740
7,212	0.75	307,843	7,940,070
9,616	1.00	306,735	7,852,903
12,020	1.25	306,372	7,823,062
14,424	1.50	306,344	7,819,136
16,828	1.75	305,456	7,747,674
19,232	2.00	304,567	7,676,213

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	15,567	3,774	242
undo header	38	26	685
undo block	7	2	234
segment header	2	0	75
1st level bmb	3	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
JD-Job Queue Date	1,235	1,235	0	1	25	25,340.00
CF-Controlfile Transaction	4,211	4,172	39	8	22	2,722.50
TX-Transaction (index contention)	52	52	0	52	6	123.08
SQ-Sequence Cache	1,396	1,396	0	26	5	183.08

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	10.56	60,138	3,135	77	17.2/65.3	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
21-Jan 10:09	1,006	8,140	1,263	7	34	0/0	0/0/0/0/0/0
21-Jan 09:59	1,861	7,095	881	9	28	0/0	0/0/0/0/0/0
21-Jan 09:49	1,259	6,361	250	9	17	0/0	0/0/0/0/0/0
21-Jan 09:39	1,135	7,529	3,135	51	65	0/0	0/0/0/0/0/0
21-Jan 09:29	1,275	10,204	2,530	47	55	0/0	0/0/0/0/0/0
21-Jan 09:19	1,569	11,649	1,923	52	45	0/0	0/0/0/0/0/0
21-Jan 09:09	2,455	9,160	1,318	77	35	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
AWR Alerted Metric Element list	28,548	0.00		0	0
Consistent RBA	14,431	0.00		0	0
FAL request queue	78	0.00		0	0
FAL subheap alocation	78	0.00		0	0
FIB s.o chain latch	90	0.00		0	0
FOB s.o list latch	1,429	0.00		0	0
JS mem alloc latch	4	0.00		0	2	0.00
JS queue access latch	4	0.00		0	0
JS queue state obj latch	25,342	0.00		0	0
JS slv state obj latch	10	0.00		0	0
KGX	0			0	658,211	0.04
KMG MMAN ready and startup request latch	1,170	0.00		0	0
KMG resize request state object freelist	20	0.00		0	0
KTF sga latch	60,008	0.00		0	1,194	0.00
KWQMN job cache list latch	30	0.00		0	0
KWQP Prop Status	2	0.00		0	0
LGWR NS Write	546	0.00		0	0
MQL Tracking Latch	0			0	71	0.00
Memory Management Latch	200	0.00		0	1,170	0.00
OS process	1,158	0.00		0	0
OS process allocation	1,894	0.00		0	0
OS process: request allocation	709	0.00		0	0
PL/SQL warning settings	197,325	0.15	0.00	0	0
SGA IO buffer pool latch	1,905	0.00		0	2,980	0.00
SQL memory manager latch	1	0.00		0	902	0.00
SQL memory manager workarea list latch	68,686	0.00		0	0
Shared B-Tree	126	0.00		0	0
active checkpoint queue latch	1,739	0.00		0	0
active service list	11,369	0.13	0.00	0	1,517	0.00
alert log latch	4	0.00		0	1	0.00
archive control	194	0.00		0	0
archive process latch	981	0.20	1.00	0	0
begin backup scn array	32	0.00		0	0
buffer pool	35	0.00		0	0
cache buffer handles	3,485	0.00		0	0
cache buffers chains	3,765,296,464	0.43	0.00	45187	7,176,447	0.61
cache buffers lru chain	182,503	0.05	0.19	2	13,060,143	0.05
cache table scan latch	0			0	447,830	0.35
cas latch	17,235	0.17	0.00	0	0
channel handle pool latch	711	0.00		0	0
channel operations parent latch	15,434	0.00		0	0
checkpoint queue latch	134,296	0.00		0	32,895	0.00
client/application info	5,607	0.00		0	0
commit callback allocation	38	0.00		0	0
compile environment latch	4,008	0.12	0.00	0	0
dictionary lookup	1	0.00		0	0
dml lock allocation	287,181	0.08	0.02	0	0
dummy allocation	1,841	0.76	0.00	0	0
enqueue hash chains	497,026	0.03	0.08	3	20,211	0.01
enqueues	107,569	0.02	0.04	0	0
event group latch	331	0.00		0	0
file cache latch	308	0.00		0	0
global KZLD latch for mem in SGA	327	0.00		0	0
global tx hash mapping	24	0.00		0	0
hash table column usage latch	579	0.00		0	355,041	0.00
hash table modification latch	132	0.00		0	1	0.00
job workq parent latch	0			0	826	0.00
job_queue_processes parameter latch	198	0.00		0	0
kks stats	28,185	0.00		0	0
ksuosstats global area	240	0.00		0	0
ktm global data	24	0.00		0	0
kwqbsn:qsga	125	0.00		0	0
lgwr LWN SCN	14,446	0.00		0	0
library cache	6,386,403	0.16	0.21	1186	9,816	0.13
library cache load lock	2,260	0.00		0	5	0.00
library cache lock	1,713,042	0.05	0.03	7	0
library cache lock allocation	14,138	0.01	0.00	0	0
library cache pin	5,355,147	0.08	0.01	14	0
library cache pin allocation	21,306	0.02	0.00	0	0
list of block allocation	3,198	0.47	0.00	0	0
loader state object freelist	13,134	0.00		0	0
logminer context allocation	1	0.00		0	0
longop free list parent	3,200	0.00		0	218	0.00
message pool operations parent latch	2	0.00		0	0
messages	63,059	0.02	0.00	0	0
mostly latch-free SCN	125,259	0.02	0.00	0	0
multiblock read objects	1,045,481	0.00	0.00	0	1	0.00
ncodef allocation latch	85	0.00		0	0
object queue header heap	580	0.00		0	762	0.00
object queue header operation	6,897,122	0.00	0.08	0	0
object stats modification	78	0.00		0	2	0.00
parallel query alloc buffer	440	0.00		0	0
parameter list	3,167	0.00		0	0
parameter table allocation management	990	1.72	0.00	0	0
post/wait queue	43,621	0.00	0.00	0	36,292	0.00
process allocation	709	0.00		0	331	0.00
process group creation	709	0.00		0	0
qmn task queue latch	492	0.00		0	0
redo allocation	44,903	0.04	0.18	0	537,253	0.06
redo copy	0			0	537,385	0.09
redo on-disk SCN	48,107	0.00		0	0
redo writing	48,475	0.01	0.00	0	0
resmgr group change latch	1,123	1.07	0.00	0	0
resmgr:actses active list	1,836	0.00		0	0
resmgr:actses change group	862	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	1,833	1.09	0.00	0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	1	0.00		0	0
rm cas latch	7,249	0.03	0.00	0	0
row cache objects	1,683,358	0.01	0.01	0	60	0.00
rules engine aggregate statistics	14	0.00		0	0
rules engine rule set statistics	128	0.00		0	0
sequence cache	84,882	0.16	0.00	0	0
session allocation	173,275	0.03	0.00	0	0
session idle bit	1,411,074	0.01	0.00	0	0
session state list latch	1,587	1.70	0.00	0	0
session switching	85	0.00		0	0
session timer	1,517	0.00		0	0
shared pool	436,170	0.05	0.25	8	0
simulator hash latch	119,066,287	0.01	0.01	0	0
simulator lru latch	117,747,120	1.70	0.01	13321	212,320	0.12
slave class	4	0.00		0	0
slave class create	16	6.25	1.00	2	0
sort extent pool	137	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	140	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
temporary table state object allocation	1	0.00		0	0
threshold alerts latch	691	0.00		0	0
trace latch	18	0.00		0	0
transaction allocation	13,838	0.01	0.00	0	0
transaction branch allocation	107	0.00		0	0
undo global data	277,727	0.01	0.00	0	0
user lock	2,481	1.05	0.04	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	3,765,296,464	16,313,083	72,422	16,240,724
simulator lru latch	117,747,120	1,998,737	18,430	1,980,419
simulator hash latch	119,066,287	12,585	107	12,478
library cache	6,386,403	10,466	2,157	8,321
library cache pin	5,355,147	4,439	39	4,400
library cache lock	1,713,042	842	29	813
dml lock allocation	287,181	222	4	219
shared pool	436,170	212	52	163
enqueue hash chains	497,026	152	12	140
row cache objects	1,683,358	92	1	91
cache buffers lru chain	182,503	83	16	67
enqueues	107,569	26	1	25
object queue header operation	6,897,122	26	2	24
user lock	2,481	26	1	25
redo allocation	44,903	17	3	14
archive process latch	981	2	2	0
slave class create	16	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
archive process latch	kcrrsarc	2	0
cache buffers chains	kcbrls: kslbegin	59,262	106
cache buffers chains	kcbgtcr: kslbegin excl	12,578	72,087
cache buffers chains	kcbgtcr: fast path	317	198
cache buffers chains	kcbzgb: scan from tail. nowait	118	0
cache buffers chains	kcbzib: multi-block read: nowait	69	0
cache buffers chains	kcbnlc	16	1
cache buffers chains	kcbchg: kslbegin: call CR func	9	1
cache buffers chains	kcbgcur: kslbegin	8	3
cache buffers chains	kcbzib: finish free bufs	8	8
cache buffers chains	kcbchg: kslbegin: bufs not pinned	7	5
cache buffers chains	kcbbic2	4	1
cache buffers chains	kcbbxsv	4	3
cache buffers chains	kcbgtcr	4	0
cache buffers chains	kcbgtcr: kslbegin shared	4	0
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	3	0
cache buffers chains	kcbzpnd: dump buffers	3	0
cache buffers chains	kcbbic1	2	3
cache buffers chains	kcbget: exchange rls	2	0
cache buffers chains	kcbget: pin buffer	2	7
cache buffers chains	kcbw_activate_granule	2	0
cache buffers lru chain	kcbzgws	16	0
cost function	kzulrl	1	1
dml lock allocation	ktaiam	2	4
dml lock allocation	ktaidm	2	0
enqueue hash chains	ksqrcl	7	3
enqueue hash chains	ksqgtl3	4	9
enqueue hash chains	ksucallcbksafely: ksqhngcbk1	1	0
enqueues	ksqgtl2	1	0
library cache	kglpndl: child: before processing	1,125	611
library cache	kglpnc: child	257	806
library cache	kglpin: child: heap processing	224	216
library cache	kglpndl: child: after processing	168	0
library cache	kglpnp: child	111	272
library cache	kglobpn: child:	28	24
library cache	kglhdgc: child:	26	178
library cache	kglrtl	11	0
library cache	kglhdgn: child:	5	13
library cache	kgldte: child 0	4	1
library cache	kgldti: 2child	3	1
library cache	kglini: child	3	0
library cache	kglobld	3	0
library cache	kglpin	3	1
library cache	kglukp: child	3	0
library cache	kgldtld: 2child	2	0
library cache	kglic	2	0
library cache	kglati	1	0
library cache lock	kgllkdl: child: no lock handle	27	29
library cache lock	kgllkal: child: multiinstance	22	21
library cache lock	kgllkdl: child: cleanup	7	8
library cache pin	kglpndl	25	16
library cache pin	kglpnp: child	7	8
library cache pin	kglpnc: child	5	8
library cache pin	kglpnal: child: alloc space	2	7
object queue header operation	kcbw_link_q	1	0
object queue header operation	kcbw_unlink_q	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	3	0
row cache objects	kqrso	1	0
shared pool	kghfrunp: clatch: nowait	134	0
shared pool	kghalo	29	24
shared pool	kghfrunp: clatch: wait	17	6
shared pool	kghupr1	13	20
shared pool	kghfrunp: alloc: cursor dur	8	0
shared pool	kgh: add extent to reserved list	1	0
shared pool	kghalp	1	4
simulator hash latch	kcbsacc: lookup dba	99	106
simulator hash latch	kcbs_lookup_setid: lookup dba	5	1
simulator hash latch	kcbsacc: insert dba	2	0
simulator hash latch	kcbsacc: remove dba	1	0
simulator lru latch	kcbs_simulate: simulate set	18,407	18,418
simulator lru latch	kcbs_resize_pool : interpolation	7	0
simulator lru latch	kcbs_grow_pool	6	0
simulator lru latch	kcbs_lookup_setid	3	0
simulator lru latch	kcbssck	3	0
simulator lru latch	kcbs_simbufseq	1	7
slave class create	ksvcreate	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 1,882,623,447
Captured Segments account for 99.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
XYSURVERY	XYSURVERYTBS	UK_TQSKILLUSERID	INDEX	628,186,800	33.37
XYSURVERY	XYSURVERYTBS	EMAIL	TABLE	588,115,568	31.24
DEVELOPER	DEVELOPE	NEEDSYN	TABLE	145,072,688	7.71
XYSURVERY	XYSURVERYTBS	RESULTONLY	TABLE	122,225,584	6.49
XYSURVERY	XYSURVERYTBS	TURLSAVE	TABLE	73,992,944	3.93

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 3,383,869
Captured Segments account for 96.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SKILLS	SKILLS_DATA	LOGININFO2	TABLE	2,626,003	77.60
NEWEMAILUSER	EMAIL_WORK	MAILSENDED_STATE	TABLE	397,736	11.75
XYSURVERY	XYSURVERYTBS	LOGININFO2	TABLE	65,044	1.92
XYSURVERY	XYSURVERYTBS	RESULTMULTIEXPAND	TABLE	62,332	1.84
SKILLS	SKILLS_DATA	EMAIL	TABLE	54,196	1.60

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
XYSURVERY	USERS	PK_SET_SYN_ACTION		INDEX	51	98.08
XYSURVERY	XYSURVERYTBS	P_LOGININFO		INDEX	1	1.92

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
XYSURVERY	XYSURVERYTBS	LOGININFO2	TABLE	1,108	80.52
XYSURVERY	USERS	PK_SET_SYN_ACTION	INDEX	90	6.54
XYSURVERY	XYSURVERYTBS	RESULTONLY	TABLE	74	5.38
SYS	SYSTEM	JOB$	TABLE	63	4.58
XYSURVERY	XYSURVERYTBS	RESULTEDIT	TABLE	18	1.31

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	69	0.00	2	1
dc_constraints	2	100.00	2	2
dc_global_oids	45,277	0.00	0	142
dc_histogram_data	99,098	0.62	0	7,135
dc_histogram_defs	40,081	2.57	0	6,489
dc_object_grants	2,008	0.05	0	125
dc_object_ids	77,289	0.08	1	1,833
dc_objects	20,029	1.00	8	1,847
dc_profiles	864	0.00	0	1
dc_rollback_segments	3,056	0.00	0	97
dc_segments	19,368	0.39	36	1,903
dc_sequences	1,577	0.06	1,577	19
dc_tablespace_quotas	7	28.57	3	5
dc_tablespaces	122,832	0.00	0	28
dc_usernames	6,826	0.04	0	26
dc_users	193,746	0.00	0	73
outstanding_alerts	321	1.87	14	50

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	1,368	0.44	248,540	0.00	4	0
CLUSTER	103	0.00	177	0.00	0	0
INDEX	20	0.00	55	18.18	10	0
JAVA RESOURCE	5	60.00	12	25.00	0	0
JAVA SOURCE	5	60.00	12	25.00	0	0
SQL AREA	9,258	79.68	2,081,933	0.75	1,035	14
TABLE/PROCEDURE	3,990	4.09	372,261	0.30	503	0
TRIGGER	27	11.11	184	1.63	0	0

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	451.35		2.44	7.43	76	76	185	185
	Freeable	63.19	0.00	0.55	0.41	3		114	114
	PL/SQL	52.29	5.21	0.29	0.23	1	1	183	183
	SQL	14.81	6.29	0.09	0.06	0	140	174	164
E	Other	346.44		2.51	8.17	76	76	138	138
	Freeable	72.13	0.00	0.78	0.82	8		92	92
	PL/SQL	24.52	3.01	0.18	0.21	1	7	136	136
	SQL	7.72	3.12	0.06	0.05	0	110	127	116

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	8,808,038,400	9,227,468,800
Fixed Size	2,037,344
Redo Buffers	14,737,408
Variable Size	1,258,293,664	838,863,264

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	ASH buffers	15.50	15.50	0.00
shared	CCursor	25.10	31.57	25.79
shared	FileOpenBlock		6.99
shared	PCursor	16.84	23.29	38.28
shared	PL/SQL MPCODE		7.36
shared	XDB Schema Cac		8.46
shared	db_block_hash_buckets	33.63	33.63	0.00
shared	event statistics per sess		7.72
shared	free memory	741.13	311.97	-57.91
shared	library cache	26.47	37.74	42.57
shared	private strands	12.22	12.22	0.00
shared	row cache		7.13
shared	sql area	92.39	82.26	-10.96
streams	free memory	16.00	16.00	0.00
	buffer_cache	8,400.00	8,800.00	4.76
	fixed_sga	1.94	1.94	0.00
	log_buffer	14.05	14.05	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

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

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Slaves	34,782	679,458	0
QMON Coordinator	18,330	0	0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
_kgl_large_heap_warning_threshold	8388608
audit_file_dest	/u01/oracle/admin/research/adump
background_dump_dest	/u01/oracle/admin/research/bdump
compatible	10.2.0.1.0
control_file_record_keep_time	10
control_files	/u01/oracle/oradata/research/control01.ctl, /u01/oracle/oradata/research/control02.ctl, /u01/oracle/oradata/research/control03.ctl
core_dump_dest	/u01/oracle/admin/research/cdump
db_block_size	8192
db_domain	bj.mycos.org
db_file_multiblock_read_count	8
db_name	research
db_recovery_file_dest
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=researchXDB)
fal_client	research
fal_server	orcl
job_queue_processes	10
log_archive_config	DG_CONFIG=(research, orcl)
log_archive_dest_1	LOCATION=/rman/archivelog/ VALID_FOR=(ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=research
log_archive_dest_2	SERVICE=orcl LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=orcl
log_archive_dest_state_1	ENABLE
log_archive_dest_state_2	ENABLE
open_cursors	300
pga_aggregate_target	3356491776
processes	800
remote_login_passwordfile	EXCLUSIVE
sga_target	10083106816
shadow_core_dump	partial	PARTIAL
standby_file_management	AUTO
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/u01/oracle/admin/research/udump

End of Report

% Blocks changed per Read:	0.06	Recursive Call %:	79.50
Rollback per transaction %:	0.00	Rows per Sort:	403.07

Buffer Nowait %:	100.00	Redo NoWait %:	99.59
Buffer Hit %:	99.82	In-memory Sort %:	100.00
Library Hit %:	99.38	Soft Parse %:	98.50
Execute to Parse %:	67.81	Latch Hit %:	99.54
Parse CPU to Parse Elapsd %:	8.03	% Non-Parse CPU:	99.89