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: 37059 07-Jan-15 15:00:20 235 15.0

End Snap: 37062 07-Jan-15 18:00:55 239 16.9

Elapsed: 180.58 (mins)

DB Time: 3,862.11 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	37059	07-Jan-15 15:00:20	235	15.0
End Snap:	37062	07-Jan-15 18:00:55	239	16.9
Elapsed:		180.58 (mins)
DB Time:		3,862.11 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 7,664M 7,664M Std Block Size: 8K

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

	Begin	End
Buffer Cache:	7,664M	7,664M	Std Block Size:	8K
Shared Pool Size:	1,856M	1,856M	Log Buffer:	14,392K

Load Profile

Per Second Per Transaction

Redo size: 51,047.98 4,164.81

Logical reads: 756,035.69 61,682.05

Block changes: 274.25 22.38

Physical reads: 777.54 63.44

Physical writes: 12.70 1.04

User calls: 1,121.46 91.50

Parses: 562.33 45.88

Hard parses: 4.59 0.37

Sorts: 343.38 28.02

Logons: 0.24 0.02

Executes: 2,775.80 226.47

Transactions: 12.26

	Per Second	Per Transaction
Redo size:	51,047.98	4,164.81
Logical reads:	756,035.69	61,682.05
Block changes:	274.25	22.38
Physical reads:	777.54	63.44
Physical writes:	12.70	1.04
User calls:	1,121.46	91.50
Parses:	562.33	45.88
Hard parses:	4.59	0.37
Sorts:	343.38	28.02
Logons:	0.24	0.02
Executes:	2,775.80	226.47
Transactions:	12.26

% Blocks changed per Read: 0.04 Recursive Call %: 80.80

Rollback per transaction %: 0.00 Rows per Sort: 4.43

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 99.97

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

Library Hit %: 99.76 Soft Parse %: 99.18

Execute to Parse %: 79.74 Latch Hit %: 99.53

Parse CPU to Parse Elapsd %: 26.84 % Non-Parse CPU: 99.67

Shared Pool Statistics

Begin End

Memory Usage %: 94.19 96.20

% SQL with executions>1: 67.73 68.81

% Memory for SQL w/exec>1: 72.90 73.57

	Begin	End
Memory Usage %:	94.19	96.20
% SQL with executions>1:	67.73	68.81
% Memory for SQL w/exec>1:	72.90	73.57

Top 5 Timed Events

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

CPU time 90,982 39.3

latch: cache buffers chains 164,840 28,648 174 12.4 Concurrency

log file sync 140,843 22,278 158 9.6 Commit

latch free 141,610 18,232 129 7.9 Other

log file parallel write 97,683 6,480 66 2.8 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		90,982		39.3
latch: cache buffers chains	164,840	28,648	174	12.4	Concurrency
log file sync	140,843	22,278	158	9.6	Commit
latch free	141,610	18,232	129	7.9	Other
log file parallel write	97,683	6,480	66	2.8	System 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): 231726.5s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	208,985.53	90.19
DB CPU	90,982.20	39.26
PL/SQL execution elapsed time	1,401.52	0.60
parse time elapsed	1,119.13	0.48
sequence load elapsed time	193.29	0.08
hard parse elapsed time	87.38	0.04
connection management call elapsed time	25.44	0.01
hard parse (sharing criteria) elapsed time	9.40	0.00
PL/SQL compilation elapsed time	1.92	0.00
failed parse elapsed time	1.80	0.00
hard parse (bind mismatch) elapsed time	0.72	0.00
repeated bind elapsed time	0.37	0.00
DB time	231,726.50
background elapsed time	12,395.05
background cpu time	35.97

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	198,391	0.01	30,992	156	1.49
Commit	140,843	0.42	22,278	158	1.06
Other	142,297	0.14	18,293	129	1.07
System I/O	118,990	0.02	7,655	64	0.90
User I/O	1,629,646	0.00	1,001	1	12.27
Application	8,517	0.85	496	58	0.06
Configuration	1,563	16.31	306	196	0.01
Network	6,653,370	0.00	124	0	50.10

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	164,840	0.00	28,648	174	1.24
log file sync	140,843	0.42	22,278	158	1.06
latch free	141,610	0.00	18,232	129	1.07
log file parallel write	97,683	0.00	6,480	66	0.74
latch: library cache	28,064	0.00	2,008	72	0.21
control file parallel write	4,932	0.00	1,142	232	0.04
db file sequential read	118,600	0.00	791	7	0.89
SQL*Net break/reset to client	8,396	0.00	271	32	0.06
db file scattered read	1,011,280	0.00	194	0	7.62
enq: TX - row lock contention	63	100.00	186	2959	0.00
log file switch completion	390	19.74	175	448	0.00
latch: shared pool	3,776	0.00	134	35	0.03
enq: SQ - contention	991	0.00	130	132	0.01
latch: library cache pin	807	0.00	121	150	0.01
LNS wait on SENDREQ	678	0.00	68	100	0.01
buffer busy waits	817	0.61	64	78	0.01
enq: RO - fast object reuse	58	15.52	39	668	0.00
LNS ASYNC control file txn	28	100.00	28	1015	0.00
SQL*Net more data to client	140,765	0.00	28	0	1.06
enq: CF - contention	14	7.14	18	1275	0.00
ARCH wait on c/f tx acquire 2	15	100.00	15	1022	0.00
local write wait	143	1.40	15	107	0.00
ARCH wait on SENDREQ	179	0.00	15	83	0.00
latch: session allocation	13	0.00	10	746	0.00
os thread startup	31	19.35	10	313	0.00
SQL*Net more data from client	26,685	0.00	7	0	0.20
latch: library cache lock	44	0.00	7	157	0.00
LGWR wait for redo copy	371	49.60	6	16	0.00
SQL*Net message to client	6,484,753	0.00	5	0	48.83
latch: cache buffers lru chain	58	0.00	3	54	0.00
control file sequential read	15,044	0.00	2	0	0.11
rdbms ipc reply	81	0.00	2	22	0.00
latch: undo global data	10	0.00	2	162	0.00
reliable message	51	0.00	2	30	0.00
Log archive I/O	622	0.00	1	2	0.00
latch: enqueue hash chains	23	0.00	1	64	0.00
log file sequential read	655	0.00	1	2	0.00
wait list latch free	26	0.00	1	40	0.00
direct path read	498,881	0.00	1	0	3.76
undo segment extension	178	100.00	1	3	0.00
latch: messages	3	0.00	1	187	0.00
log file single write	26	0.00	1	20	0.00
read by other session	38	0.00	0	12	0.00
latch: object queue header operation	4	0.00	0	111	0.00
latch: redo allocation	14	0.00	0	30	0.00
buffer deadlock	4	100.00	0	91	0.00
latch: row cache objects	4	0.00	0	44	0.00
cursor: mutex S	3	0.00	0	9	0.00
enq: TX - index contention	5	0.00	0	3	0.00
db file parallel read	1	0.00	0	0	0.00
direct path write	688	0.00	0	0	0.01
latch: redo writing	4	0.00	0	0	0.00
SQL*Net message to dblink	310	0.00	0	0	0.00
direct path read temp	5	0.00	0	0	0.00
direct path write temp	10	0.00	0	0	0.00
SQL*Net message from client	6,484,747	0.00	1,558,964	240	48.83
jobq slave wait	30,040	94.12	87,296	2906	0.23
Streams AQ: qmn slave idle wait	762	0.00	10,591	13899	0.01
Streams AQ: qmn coordinator idle wait	1,150	33.65	10,591	9209	0.01
virtual circuit status	358	100.00	10,533	29421	0.00
LNS ASYNC end of log	10,436	100.00	10,443	1001	0.08
Streams AQ: waiting for time management or cleanup tasks	3	100.00	2,875	958279	0.00
pipe get	1,317	5.01	303	230	0.01
class slave wait	3	100.00	15	4990	0.00
SQL*Net message from dblink	310	0.00	0	1	0.00
single-task message	3	0.00	0	58	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	97,683	0.00	6,480	66	0.74
control file parallel write	4,932	0.00	1,142	232	0.04
LNS wait on SENDREQ	679	0.00	68	100	0.01
events in waitclass Other	563	35.52	48	85	0.00
LNS ASYNC control file txn	28	100.00	28	1015	0.00
ARCH wait on SENDREQ	179	0.00	15	83	0.00
os thread startup	31	19.35	10	313	0.00
db file sequential read	266	0.00	4	14	0.00
latch: cache buffers chains	12	0.00	3	216	0.00
control file sequential read	11,838	0.00	2	0	0.09
Log archive I/O	622	0.00	1	2	0.00
log file sequential read	655	0.00	1	2	0.00
latch: library cache	14	0.00	1	62	0.00
latch: shared pool	25	0.00	1	21	0.00
log file single write	26	0.00	1	20	0.00
log file sync	2	0.00	0	74	0.00
db file scattered read	353	0.00	0	0	0.00
direct path read	448	0.00	0	0	0.00
buffer busy waits	5	0.00	0	0	0.00
direct path write	448	0.00	0	0	0.00
latch: redo writing	4	0.00	0	0	0.00
rdbms ipc message	103,437	28.99	102,350	989	0.78
Streams AQ: qmn slave idle wait	762	0.00	10,591	13899	0.01
Streams AQ: qmn coordinator idle wait	1,150	33.65	10,591	9209	0.01
pmon timer	4,530	100.00	10,579	2335	0.03
LNS ASYNC end of log	10,436	100.00	10,443	1001	0.08
smon timer	154	10.39	10,276	66728	0.00
Streams AQ: waiting for time management or cleanup tasks	3	100.00	2,875	958279	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	8,557,731
IDLE_TIME	89,394
NICE_TIME	470
SYS_TIME	93,726
USER_TIME	8,463,535
LOAD	36
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	215,416
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	167,064.30	70,416.30	4,389,539	5,516,292,048
SYS$USERS	64,508.70	20,502.80	4,029,273	2,669,436,674
SYS$BACKGROUND	0.00	0.00	5,306	116,982
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	668377	82901	145830	2483015	1952222	3033
SYS$USERS	956910	14498	52458	614676	4695458	870
SYS$BACKGROUND	4360	2716	97	1436	857	8268

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
44,957	22,163	52,906	0.85	19.40	bv9ujsxxgx961	oracleresarch@neworabak (TNS V1-V3)	SELECT "ACLASS", "SERIALNO", "...
28,041	13,702	88,367	0.32	12.10	6mcx478k6hjgw	w3wp.exe	begin Pack_Question_HalfYear20...
26,054	8,495	28,741	0.91	11.24	gky1rjtvqz204	w3wp.exe	begin Pack_Question_HalfYear20...
21,463	11,786	132,814	0.16	9.26	6c263jxsf4n3v	w3wp.exe	SELECT COUNT(1) FROM EMAIL T W...
15,348	4,535	28,983	0.53	6.62	06pzqkj5qdmkm	w3wp.exe	SELECT T.SKILLUSERID, T.GRADE ...
14,237	8,280	105,992	0.13	6.14	8978nm09rf81x	w3wp.exe	begin Pack_Question_HalfYear20...
13,369	5,765	91,403	0.15	5.77	9mhydycsxzwbu	w3wp.exe	SELECT T.SKILLMAJOR, T.UNIVER...
12,439	6,188	40,129	0.31	5.37	6t6y6a8uf7h81	w3wp.exe	begin Pack_Question_HalfYear20...
10,677	3,989	29,007	0.37	4.61	4nzwak1v8atr1	w3wp.exe	SELECT COUNT(*) FROM EMAIL T W...
10,528	3,898	18	584.90	4.54	gyjk5c75k457q		DECLARE job BINARY_INTEGER := ...
10,301	6,361	89,535	0.12	4.45	83444u5pdds28	w3wp.exe	SELECT T.PAGEID FROM TURLSAVE ...
7,617	2,550	301	25.31	3.29	cga2j12pg1bh1	EmailAllocater.exe	begin PROC_email.allocate_mail...
6,014	2,607	41,323	0.15	2.60	gp7mhv9ttvjx9	w3wp.exe	SELECT T.UNIVERSITY, T.SKILLM...
5,765	1,888	35	164.73	2.49	1xqrcfdf4t7bw		DECLARE job BINARY_INTEGER := ...
5,613	1,849	4,845	1.16	2.42	647pp5y0mjdz6	PL/SQL Developer	UPDATE SET_SYN_ACTION_END SET ...
4,990	2,534	22,002	0.23	2.15	2x694qcar906x	w3wp.exe	begin Pack_Question_HalfYear20...
4,115	2,144	12,687	0.32	1.78	4h3s21tkvmjc7	w3wp.exe	SELECT T.* FROM ( SELECT ELT.I...
3,907	2,577	41,196	0.09	1.69	10x7rsw0vqnjc	w3wp.exe	SELECT T.GRADE FROM EMAIL T WH...
3,743	1,398	7,047	0.53	1.62	5r2mcvsf8c09r	w3wp.exe	SELECT NVL(T.SC_SIGN, '-1') FR...
3,511	1,987	9,280	0.38	1.52	69pc36hdyk23y	ServerWindowsForms.exe	begin proc_syn.update_syn(p_se...
2,833	964	3,445,650	0.00	1.22	1zj9ygyzw3zv0	EmailAllocater.exe	SELECT COUNT(*) FROM MAILTOSEN...
2,526	832	3,445,651	0.00	1.09	6v78h3hb0h7zd	EmailAllocater.exe	SELECT COUNT(*) FROM MAILTOSEN...
2,433	173	2,019,935	0.00	1.05	0250arukquk45	SendEmail.exe	SELECT ACTION FROM CLIENTS WHE...

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
22,163	44,957	52,906	0.42	19.40	bv9ujsxxgx961	oracleresarch@neworabak (TNS V1-V3)	SELECT "ACLASS", "SERIALNO", "...
13,702	28,041	88,367	0.16	12.10	6mcx478k6hjgw	w3wp.exe	begin Pack_Question_HalfYear20...
11,786	21,463	132,814	0.09	9.26	6c263jxsf4n3v	w3wp.exe	SELECT COUNT(1) FROM EMAIL T W...
8,495	26,054	28,741	0.30	11.24	gky1rjtvqz204	w3wp.exe	begin Pack_Question_HalfYear20...
8,280	14,237	105,992	0.08	6.14	8978nm09rf81x	w3wp.exe	begin Pack_Question_HalfYear20...
6,361	10,301	89,535	0.07	4.45	83444u5pdds28	w3wp.exe	SELECT T.PAGEID FROM TURLSAVE ...
6,188	12,439	40,129	0.15	5.37	6t6y6a8uf7h81	w3wp.exe	begin Pack_Question_HalfYear20...
5,765	13,369	91,403	0.06	5.77	9mhydycsxzwbu	w3wp.exe	SELECT T.SKILLMAJOR, T.UNIVER...
4,535	15,348	28,983	0.16	6.62	06pzqkj5qdmkm	w3wp.exe	SELECT T.SKILLUSERID, T.GRADE ...
3,989	10,677	29,007	0.14	4.61	4nzwak1v8atr1	w3wp.exe	SELECT COUNT(*) FROM EMAIL T W...
3,898	10,528	18	216.57	4.54	gyjk5c75k457q		DECLARE job BINARY_INTEGER := ...
2,607	6,014	41,323	0.06	2.60	gp7mhv9ttvjx9	w3wp.exe	SELECT T.UNIVERSITY, T.SKILLM...
2,577	3,907	41,196	0.06	1.69	10x7rsw0vqnjc	w3wp.exe	SELECT T.GRADE FROM EMAIL T WH...
2,550	7,617	301	8.47	3.29	cga2j12pg1bh1	EmailAllocater.exe	begin PROC_email.allocate_mail...
2,534	4,990	22,002	0.12	2.15	2x694qcar906x	w3wp.exe	begin Pack_Question_HalfYear20...
2,144	4,115	12,687	0.17	1.78	4h3s21tkvmjc7	w3wp.exe	SELECT T.* FROM ( SELECT ELT.I...
1,987	3,511	9,280	0.21	1.52	69pc36hdyk23y	ServerWindowsForms.exe	begin proc_syn.update_syn(p_se...
1,888	5,765	35	53.94	2.49	1xqrcfdf4t7bw		DECLARE job BINARY_INTEGER := ...
1,849	5,613	4,845	0.38	2.42	647pp5y0mjdz6	PL/SQL Developer	UPDATE SET_SYN_ACTION_END SET ...
1,398	3,743	7,047	0.20	1.62	5r2mcvsf8c09r	w3wp.exe	SELECT NVL(T.SC_SIGN, '-1') FR...
964	2,833	3,445,650	0.00	1.22	1zj9ygyzw3zv0	EmailAllocater.exe	SELECT COUNT(*) FROM MAILTOSEN...
832	2,526	3,445,651	0.00	1.09	6v78h3hb0h7zd	EmailAllocater.exe	SELECT COUNT(*) FROM MAILTOSEN...
173	2,433	2,019,935	0.00	1.05	0250arukquk45	SendEmail.exe	SELECT ACTION FROM CLIENTS WHE...

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: 8,191,438,010
Captured SQL account for 83.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,250,505,344	52,906	42,537.81	27.47	22162.51	44957.42	bv9ujsxxgx961	oracleresarch@neworabak (TNS V1-V3)	SELECT "ACLASS", "SERIALNO", "...
937,051,363	28,741	32,603.30	11.44	8495.12	26053.50	gky1rjtvqz204	w3wp.exe	begin Pack_Question_HalfYear20...
735,107,332	301	2,442,217.05	8.97	2550.10	7616.96	cga2j12pg1bh1	EmailAllocater.exe	begin PROC_email.allocate_mail...
571,031,939	9,280	61,533.61	6.97	1986.58	3511.33	69pc36hdyk23y	ServerWindowsForms.exe	begin proc_syn.update_syn(p_se...
486,103,366	88,367	5,500.96	5.93	13702.30	28040.67	6mcx478k6hjgw	w3wp.exe	begin Pack_Question_HalfYear20...
478,164,254	132,814	3,600.25	5.84	11785.99	21463.24	6c263jxsf4n3v	w3wp.exe	SELECT COUNT(1) FROM EMAIL T W...
472,494,537	29,007	16,288.98	5.77	3989.15	10677.00	4nzwak1v8atr1	w3wp.exe	SELECT COUNT(*) FROM EMAIL T W...
472,055,357	28,983	16,287.32	5.76	4535.12	15347.86	06pzqkj5qdmkm	w3wp.exe	SELECT T.SKILLUSERID, T.GRADE ...
351,949,670	105,992	3,320.53	4.30	8280.27	14237.26	8978nm09rf81x	w3wp.exe	begin Pack_Question_HalfYear20...
346,170,500	3,445,650	100.47	4.23	963.87	2832.68	1zj9ygyzw3zv0	EmailAllocater.exe	SELECT COUNT(*) FROM MAILTOSEN...
341,119,449	3,445,651	99.00	4.16	832.43	2526.34	6v78h3hb0h7zd	EmailAllocater.exe	SELECT COUNT(*) FROM MAILTOSEN...
339,015,371	18	18,834,187.28	4.14	3898.25	10528.15	gyjk5c75k457q		DECLARE job BINARY_INTEGER := ...
335,304,723	12,687	26,429.00	4.09	2143.73	4114.97	4h3s21tkvmjc7	w3wp.exe	SELECT T.* FROM ( SELECT ELT.I...
289,331,088	35	8,266,602.51	3.53	1887.98	5765.44	1xqrcfdf4t7bw		DECLARE job BINARY_INTEGER := ...
284,669,128	4,845	58,755.24	3.48	1849.02	5613.49	647pp5y0mjdz6	PL/SQL Developer	UPDATE SET_SYN_ACTION_END SET ...
259,352,643	89,535	2,896.66	3.17	6361.01	10300.81	83444u5pdds28	w3wp.exe	SELECT T.PAGEID FROM TURLSAVE ...
252,182,036	8,197	30,765.16	3.08	939.91	1591.11	67ju68y8rj3qw	ServerWindowsForms.exe	DELETE FROM NEEDSYN WHERE SYNC...
243,550,088	7,915	30,770.70	2.97	767.10	1631.64	8ap25t1xf9tcd	ServerWindowsForms.exe	begin proc_syn.write_syn(p_ser...
243,492,172	7,915	30,763.38	2.97	740.37	1569.50	97dups5qvw37s	ServerWindowsForms.exe	SELECT COUNT(*) FROM NEEDSYN W...
219,486,048	40,129	5,469.51	2.68	6188.18	12438.94	6t6y6a8uf7h81	w3wp.exe	begin Pack_Question_HalfYear20...
190,372,762	6,188	30,764.83	2.32	610.42	847.60	c4pvqv2xrwua4	ServerWindowsForms.exe	UPDATE NEEDSYN SET SYNCODE = R...
167,279,742	91,403	1,830.13	2.04	5764.85	13368.50	9mhydycsxzwbu	w3wp.exe	SELECT T.SKILLMAJOR, T.UNIVER...
135,448,625	5,125	26,429.00	1.65	839.29	1588.47	c2wum8uptj4p7	w3wp.exe	SELECT T.* FROM (SELECT ELT.ID...
123,471,784	22,002	5,611.84	1.51	2533.93	4989.68	2x694qcar906x	w3wp.exe	begin Pack_Question_HalfYear20...
114,982,337	7,047	16,316.49	1.40	1397.63	3743.48	5r2mcvsf8c09r	w3wp.exe	SELECT NVL(T.SC_SIGN, '-1') FR...
113,591,854	10,017	11,339.91	1.39	597.43	1200.84	2xr7zr9py13cy	ServerWindowsForms.exe	begin proc_syn.update_syn2(p_s...
82,230,679	9,883	8,320.42	1.00	1111.53	1754.34	5gddjqrq4xg93	oracleresarch@neworabak (TNS V1-V3)	SELECT "ACLASS", "SERIALNO", "...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 8,424,407
Captured SQL account for 0.1% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
35,642	1	35,642.00	0.42	171.62	1008.68	7knsghsxxbmd0	receiveemail.exe	begin PROC_email.handle_return...
5,730	43,847	0.13	0.07	13.00	31.90	0cnvmf7njg4vz	ReceiveEmail.exe	SELECT MSG_UID, MSG_FROM, MSG_...
2,484	22,857	0.11	0.03	45.75	170.07	6a87wwu0s5c4n	w3wp.exe	begin Pack_Question_HalfYear20...
1,643	22,002	0.07	0.02	2533.93	4989.68	2x694qcar906x	w3wp.exe	begin Pack_Question_HalfYear20...
1,550	35	44.29	0.02	1887.98	5765.44	1xqrcfdf4t7bw		DECLARE job BINARY_INTEGER := ...
1,449	12,469	0.12	0.02	38.05	90.46	c8dq4529a0jdg	w3wp.exe	begin PROC_Manager.insertToEma...
996	6	166.00	0.01	0.63	2.11	4udf9pf45z5rx		DECLARE job BINARY_INTEGER := ...
531	3	177.00	0.01	0.06	0.34	0dwr2vd6vbqzs		SELECT count(*) over () as tot...
469	2,849	0.16	0.01	0.41	4.60	du080384mmds1	w3wp.exe	SELECT COUNT(1) FROM EMAIL T W...
92	28,966	0.00	0.00	3.83	59.70	38j1jzph1tsvd	w3wp.exe	INSERT INTO SET_SYN_ACTION(ACL...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 30,075,059
Captured SQL account for 43.4% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
3,445,651	3,445,651	1.00	0.00	0.00	6v78h3hb0h7zd	EmailAllocater.exe	SELECT COUNT(*) FROM MAILTOSEN...
3,445,650	3,445,652	1.00	0.00	0.00	1zj9ygyzw3zv0	EmailAllocater.exe	SELECT COUNT(*) FROM MAILTOSEN...
2,019,935	2,020,187	1.00	0.00	0.00	0250arukquk45	SendEmail.exe	SELECT ACTION FROM CLIENTS WHE...
2,016,094	2,015,596	1.00	0.00	0.00	81z4v26r11v45	SendEmail.exe	begin PROC_email.get_clients_A...
296,306	296,032	1.00	0.00	0.00	gacp7c4xpvj1c	oracleresarch@neworabak (TNS V1-V3)	select SEQ_ZAIXIAN_ANSWER.next...
137,826	3,445,651	25.00	0.00	0.00	g1s142jhnczuv	EmailAllocater.exe	SELECT SMTPGROUP, FOCUSSIGN, S...
132,814	132,660	1.00	0.09	0.16	6c263jxsf4n3v	w3wp.exe	SELECT COUNT(1) FROM EMAIL T W...
131,764	131,761	1.00	0.00	0.00	6801khqm015n7	w3wp.exe	SELECT STARTTIME FROM UNIVERSI...
105,992	106,005	1.00	0.08	0.13	8978nm09rf81x	w3wp.exe	begin Pack_Question_HalfYear20...
105,626	105,640	1.00	0.00	0.00	40qdy6x6nj3w3	w3wp.exe	SELECT ID, NAME, ACLASS, IS...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 6,092,701
Captured SQL account for 90.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
2,020,085	2,016,094	33.16	81z4v26r11v45	SendEmail.exe	begin PROC_email.get_clients_A...
2,016,526	2,019,935	33.10	0250arukquk45	SendEmail.exe	SELECT ACTION FROM CLIENTS WHE...
296,308	296,306	4.86	gacp7c4xpvj1c	oracleresarch@neworabak (TNS V1-V3)	select SEQ_ZAIXIAN_ANSWER.next...
137,826	137,826	2.26	g1s142jhnczuv	EmailAllocater.exe	SELECT SMTPGROUP, FOCUSSIGN, S...
106,017	105,992	1.74	8978nm09rf81x	w3wp.exe	begin Pack_Question_HalfYear20...
105,640	105,626	1.73	40qdy6x6nj3w3	w3wp.exe	SELECT ID, NAME, ACLASS, IS...
88,714	88,690	1.46	4w4jqn6ynu2t6	w3wp.exe	SELECT ID, CODE, NAME, VALU...
88,414	88,367	1.45	6mcx478k6hjgw	w3wp.exe	begin Pack_Question_HalfYear20...
52,914	52,906	0.87	bv9ujsxxgx961	oracleresarch@neworabak (TNS V1-V3)	SELECT "ACLASS", "SERIALNO", "...
51,361	51,361	0.84	56rsx9pc8srk8	ReceiveEmail.exe	SELECT LOWER(T.ERRCODE), T.ACT...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,189,993	3	0.06	31a13pnjps7j3		SELECT source, (case w...
1,164,904	23	0.06	1ujjr5f7n32g1	PL/SQL Developer	select * from sys.all_tables w...
1,145,027	10	0.06	c8khjbn635s3c	plsqldev.exe	select s.synonym_name object_n...
1,108,113	25	0.06	7aw21806wpgzp	plsqldev.exe	select null from all_synonyms ...

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
318	202	fyzz7ty3zwh2m	ReceiveEmail.exe	SELECT SMTP, POP3HOST, POP3POR...
293	2	2zwjrv2186835	Oracle Enterprise Manager.rollup	DELETE FROM MGMT_METRICS_RAW W...
249	2	bnd9vzzsu2b59	Oracle Enterprise Manager.rollup	DELETE FROM MGMT_METRICS_1HOUR...
197	3	298ppdduqr7wm		SELECT status FROM sys.wri$_ad...
189	3	gdn3ysuyssf82		SELECT advisor_id FROM sys.wri...
172	724	bh6jawk5uqdc9		SELECT COUNT(*) FROM MAILBATCH...
164	6	4udf9pf45z5rx		DECLARE job BINARY_INTEGER := ...
155	43,847	0cnvmf7njg4vz	ReceiveEmail.exe	SELECT MSG_UID, MSG_FROM, MSG_...
133	3	31a13pnjps7j3		SELECT source, (case w...
118	2,019,935	0250arukquk45	SendEmail.exe	SELECT ACTION FROM CLIENTS WHE...
106	3	b5yyh2vc9g8tm		SELECT sx.id, sum(decode(e.sn...
101	2,453	a9vx5gzbw1axs	w3wp.exe	INSERT INTO SET_SYN_ACTION(ACL...
87	28,966	38j1jzph1tsvd	w3wp.exe	INSERT INTO SET_SYN_ACTION(ACL...
74	3	0cn2wm9d7zq8d		SELECT decode(value, 'FATAL', ...
63	3	bhvyz9bgyrhb2		SELECT name, datatype, value, ...
37	323	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
34	532	5gv7jr99s9g29	w3wp.exe	SELECT NVL(ANSWER, '') FROM R...
30	16	3k2d2bx9aa3jf	PL/SQL Developer	select * from sys.all_queue_ta...
28	1,479	7x681r9v629f7	w3wp.exe	SELECT COUNT(*) FROM RESULTONL...
26	16	3mf07mp2t5kg9	PL/SQL Developer	select * from sys.all_indexes ...
25	18	21sh40mz4cdkx	PL/SQL Developer	select text from sys.all_sourc...
24	1	b4h1szgwqg328	PL/SQL Developer	select tablespace_name, to_ch...
23	21	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
21	3,445,650	1zj9ygyzw3zv0	EmailAllocater.exe	SELECT COUNT(*) FROM MAILTOSEN...
21	3,445,650	1zj9ygyzw3zv0	EmailAllocater.exe	SELECT COUNT(*) FROM MAILTOSEN...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0250arukquk45 SELECT ACTION FROM CLIENTS WHERE SID = :B1

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

0cn2wm9d7zq8d SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'

0cnvmf7njg4vz SELECT MSG_UID, MSG_FROM, MSG_TO, MSG_SUBJECT, MSG_BODY, RECEIVE_DATE, REJECT_CODE, EMAIL_ADDR, NOTE, ACTION, RESULT, MSG_DATE FROM MAILRECEIVED WHERE MSG_UID = :B1

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

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

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

1ujjr5f7n32g1 select * from sys.all_tables where owner = :object_owner and table_name = :object_name

1xqrcfdf4t7bw DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN proc_syn.handle_syn_action; proc_syn.handle_finish_page; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

1zj9ygyzw3zv0 SELECT COUNT(*) FROM MAILTOSEND A, SMTPGROUP B WHERE A.SMTP=B.SMTPGROUP AND A.EMAILSERVER = :B2 AND B.SMTP=:B1 AND A.SIGN='1'

21sh40mz4cdkx select text from sys.all_source where owner = :owner and name = :name and type = :type order by line

298ppdduqr7wm SELECT status FROM sys.wri$_adv_tasks WHERE id = :1

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;

2zwjrv2186835 DELETE FROM MGMT_METRICS_RAW WHERE ROWID = :B1

31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC

38j1jzph1tsvd INSERT INTO SET_SYN_ACTION(ACLASS, ACTION, SERIALNO, ARGS, ID) VALUES(:B11 , 'entry', :B10 , 'Ver002:'||:B9 ||'|'||:B8 ||'|'||:B7 ||'|'||:B6 ||'|'||:B5 ||'|'||:B4 ||'|'||:B3 ||'|'||:B2 ||'|'||:B1 , SEQ_SET_SYN_ACTION.NEXTVAL)

3k2d2bx9aa3jf select * from sys.all_queue_tables where queue_table = :object_name and owner = :object_owner

3mf07mp2t5kg9 select * from sys.all_indexes where table_name = :object_name and table_owner = :object_owner order by index_name

40qdy6x6nj3w3 SELECT ID, NAME, ACLASS, ISDISPLAY, URL, DESCRIPTION, PROGRESS, INNERJS FROM PAGE T WHERE T.ID = :B2 AND T.ACLASS = :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

4udf9pf45z5rx DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN begin update emailstatus set lasthour = to_char(sysdate, 'hh'), hoursend = 0 where type = 'smtp'; if to_char(sysdate, 'hh24')='00' then update emailstatus set lastday = to_char(sysdate, 'dd'), daysend = 0 where type = 'smtp'; end if; commit; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

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)

56rsx9pc8srk8 SELECT LOWER(T.ERRCODE), T.ACTION FROM POP3ERRCODE T

5gddjqrq4xg93 SELECT "ACLASS", "SERIALNO", "PARENT", "ANSWER", "SELFEDIT", "SAVETYPE" FROM "RESULTCHEKEDIT" "A1" WHERE "ACLASS"=205 AND "SAVETYPE"=1 AND TO_NUMBER("SERIALNO")=:1 AND TO_NUMBER("PARENT")=:2 AND "ANSWER" IS NOT NULL

5gv7jr99s9g29 SELECT NVL(ANSWER, '') FROM RESULTONLY WHERE SERIALNO = :B3 AND QUESTION = :B1 AND ACLASS = :B2

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

647pp5y0mjdz6 UPDATE SET_SYN_ACTION_END SET ENDDATE=SYSDATE, RESULT='0', ERRTEXT=NULL WHERE ID=:B1

67ju68y8rj3qw DELETE FROM NEEDSYN WHERE SYNCODE IS NULL OR SYNCODE ='SV'

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

69pc36hdyk23y begin proc_syn.update_syn(p_serialno=>:p_serialno, p_incode=>:p_incode); end;

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

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;

6v78h3hb0h7zd SELECT COUNT(*) FROM MAILTOSEND WHERE SMTP = :B1 AND SIGN = '1'

7aw21806wpgzp select null from all_synonyms where 1=0

7knsghsxxbmd0 begin PROC_email.handle_return_emails(p_out=>:p_out); end;

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

7x681r9v629f7 SELECT COUNT(*) FROM RESULTONLY WHERE SERIALNO = :B3 AND QUESTION = :B1 AND ACLASS = :B2

81z4v26r11v45 begin PROC_email.get_clients_Action(P_SID=>:P_SID, P_OUT=>:P_OUT); end;

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;

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

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

a9vx5gzbw1axs INSERT INTO SET_SYN_ACTION(ACLASS, ACTION, SERIALNO, ARGS, ID) VALUES(:B11 , 'login', :B10 , 'Ver002:'||:B9 ||'|'||:B8 ||'|'||:B7 ||'|'||:B6 ||'|'||:B5 ||'|'||:B4 ||'|'||:B3 ||'|'||:B2 ||'|'||:B1 , SEQ_SET_SYN_ACTION.NEXTVAL)

b4h1szgwqg328 select tablespace_name, to_char(pct_free) pct_free, to_char(pct_used) pct_used, to_char(ini_trans) ini_trans, to_char(max_trans) max_trans, to_char(initial_extent) initial_extent, to_char(next_extent) next_extent, to_char(pct_increase) pct_increase, to_char(min_extents) min_extents, to_char(max_extents) max_extents, cluster_name from sys.all_tables where owner = :object_owner and table_name = :object_name

b5yyh2vc9g8tm SELECT sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id between :bid and :eid AND s.status = 0 AND x.ver_type = :exists_type ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = :inst_num AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.id

bh6jawk5uqdc9 SELECT COUNT(*) FROM MAILBATCH WHERE FINISHEDSIGN='0' AND SENDDATE <SYSDATE

bhvyz9bgyrhb2 SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1

bnd9vzzsu2b59 DELETE FROM MGMT_METRICS_1HOUR WHERE ROWID = :B1

bv9ujsxxgx961 SELECT "ACLASS", "SERIALNO", "PARENT", "ANSWER", "SAVETYPE" FROM "RESULTMULTIEXPAND" "A1" WHERE "PARENT"=:1 AND "ACLASS"=205 AND "SAVETYPE"=1 AND TO_NUMBER("SERIALNO")=:2 AND "ANSWER" IS NOT NULL

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

c4pvqv2xrwua4 UPDATE NEEDSYN SET SYNCODE = REPLACE(SYNCODE, :B2 , '') WHERE SERIALNO = :B1

c8dq4529a0jdg begin PROC_Manager.insertToEmail(p_key=>:p_key, p_value=>:p_value, p_parm=>:p_parm, p_name=>:p_name, p_aclass=>:p_aclass, p_majorNo=>:p_majorNo, p_universityName=>:p_universityName); end;

c8khjbn635s3c select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

cga2j12pg1bh1 begin PROC_email.allocate_mails(p_out=>:p_out); end;

du080384mmds1 SELECT COUNT(1) FROM EMAIL T WHERE T.ACLASS=:B3 AND T.GRADE=:B2 AND T.EMAIL=:B1

fyzz7ty3zwh2m SELECT SMTP, POP3HOST, POP3PORT, POP3SSL, SENDUSER FROM SMTPS WHERE SMTP = :B1 ORDER BY SMTP

g1s142jhnczuv SELECT SMTPGROUP, FOCUSSIGN, SMTP FROM SMTPGROUP WHERE SIGN = '1' AND AUTO_ADD = 'Yes' AND SMTPGROUP IN (SELECT SMTPGROUP FROM SMTPGROUPPLAN WHERE PID = :B1 )

gacp7c4xpvj1c select SEQ_ZAIXIAN_ANSWER.nextval from dual

gdn3ysuyssf82 SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1

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

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
0250arukquk45	SELECT ACTION FROM CLIENTS WHERE SID = :B1
06pzqkj5qdmkm	SELECT T.SKILLUSERID, T.GRADE FROM EMAIL T WHERE (T.EMAIL = :B2 OR T.STUDENTNO=:B2 ) AND ACLASS = :B1
0cn2wm9d7zq8d	SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0cnvmf7njg4vz	SELECT MSG_UID, MSG_FROM, MSG_TO, MSG_SUBJECT, MSG_BODY, RECEIVE_DATE, REJECT_CODE, EMAIL_ADDR, NOTE, ACTION, RESULT, MSG_DATE FROM MAILRECEIVED WHERE MSG_UID = :B1
0dwr2vd6vbqzs	SELECT count() over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash., evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe., nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap. FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count() as cnt FROM (SELECT t1. FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
10x7rsw0vqnjc	SELECT T.GRADE FROM EMAIL T WHERE T.ACLASS=:B2 AND T.SKILLUSERID=:B1
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1ujjr5f7n32g1	select * from sys.all_tables where owner = :object_owner and table_name = :object_name
1xqrcfdf4t7bw	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN proc_syn.handle_syn_action; proc_syn.handle_finish_page; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
1zj9ygyzw3zv0	SELECT COUNT(*) FROM MAILTOSEND A, SMTPGROUP B WHERE A.SMTP=B.SMTPGROUP AND A.EMAILSERVER = :B2 AND B.SMTP=:B1 AND A.SIGN='1'
21sh40mz4cdkx	select text from sys.all_source where owner = :owner and name = :name and type = :type order by line
298ppdduqr7wm	SELECT status FROM sys.wri$_adv_tasks WHERE id = :1
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;
2zwjrv2186835	DELETE FROM MGMT_METRICS_RAW WHERE ROWID = :B1
31a13pnjps7j3	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
38j1jzph1tsvd	INSERT INTO SET_SYN_ACTION(ACLASS, ACTION, SERIALNO, ARGS, ID) VALUES(:B11 , 'entry', :B10 , 'Ver002:'\|\|:B9 \|\|'\|'\|\|:B8 \|\|'\|'\|\|:B7 \|\|'\|'\|\|:B6 \|\|'\|'\|\|:B5 \|\|'\|'\|\|:B4 \|\|'\|'\|\|:B3 \|\|'\|'\|\|:B2 \|\|'\|'\|\|:B1 , SEQ_SET_SYN_ACTION.NEXTVAL)
3k2d2bx9aa3jf	select * from sys.all_queue_tables where queue_table = :object_name and owner = :object_owner
3mf07mp2t5kg9	select * from sys.all_indexes where table_name = :object_name and table_owner = :object_owner order by index_name
40qdy6x6nj3w3	SELECT ID, NAME, ACLASS, ISDISPLAY, URL, DESCRIPTION, PROGRESS, INNERJS FROM PAGE T WHERE T.ID = :B2 AND T.ACLASS = :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
4udf9pf45z5rx	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN begin update emailstatus set lasthour = to_char(sysdate, 'hh'), hoursend = 0 where type = 'smtp'; if to_char(sysdate, 'hh24')='00' then update emailstatus set lastday = to_char(sysdate, 'dd'), daysend = 0 where type = 'smtp'; end if; commit; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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)
56rsx9pc8srk8	SELECT LOWER(T.ERRCODE), T.ACTION FROM POP3ERRCODE T
5gddjqrq4xg93	SELECT "ACLASS", "SERIALNO", "PARENT", "ANSWER", "SELFEDIT", "SAVETYPE" FROM "RESULTCHEKEDIT" "A1" WHERE "ACLASS"=205 AND "SAVETYPE"=1 AND TO_NUMBER("SERIALNO")=:1 AND TO_NUMBER("PARENT")=:2 AND "ANSWER" IS NOT NULL
5gv7jr99s9g29	SELECT NVL(ANSWER, '') FROM RESULTONLY WHERE SERIALNO = :B3 AND QUESTION = :B1 AND ACLASS = :B2
5r2mcvsf8c09r	SELECT NVL(T.SC_SIGN, '-1') FROM EMAIL T WHERE T.SKILLUSERID=:B1
647pp5y0mjdz6	UPDATE SET_SYN_ACTION_END SET ENDDATE=SYSDATE, RESULT='0', ERRTEXT=NULL WHERE ID=:B1
67ju68y8rj3qw	DELETE FROM NEEDSYN WHERE SYNCODE IS NULL OR SYNCODE ='SV'
6801khqm015n7	SELECT STARTTIME FROM UNIVERSITY_CONFIG WHERE ACLASS=:B2 AND UNIVERSITY_CODE=:B1
69pc36hdyk23y	begin proc_syn.update_syn(p_serialno=>:p_serialno, p_incode=>:p_incode); end;
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
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;
6v78h3hb0h7zd	SELECT COUNT(*) FROM MAILTOSEND WHERE SMTP = :B1 AND SIGN = '1'
7aw21806wpgzp	select null from all_synonyms where 1=0
7knsghsxxbmd0	begin PROC_email.handle_return_emails(p_out=>:p_out); end;
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7x681r9v629f7	SELECT COUNT(*) FROM RESULTONLY WHERE SERIALNO = :B3 AND QUESTION = :B1 AND ACLASS = :B2
81z4v26r11v45	begin PROC_email.get_clients_Action(P_SID=>:P_SID, P_OUT=>:P_OUT); end;
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;
97dups5qvw37s	SELECT COUNT(*) FROM NEEDSYN WHERE SERIALNO = :B1
9mhydycsxzwbu	SELECT T.SKILLMAJOR, T.UNIVERSITY, T.GRADE, T.SLEVELS FROM EMAIL T WHERE T.ACLASS = :B2 AND T.SKILLUSERID = :B1
a9vx5gzbw1axs	INSERT INTO SET_SYN_ACTION(ACLASS, ACTION, SERIALNO, ARGS, ID) VALUES(:B11 , 'login', :B10 , 'Ver002:'\|\|:B9 \|\|'\|'\|\|:B8 \|\|'\|'\|\|:B7 \|\|'\|'\|\|:B6 \|\|'\|'\|\|:B5 \|\|'\|'\|\|:B4 \|\|'\|'\|\|:B3 \|\|'\|'\|\|:B2 \|\|'\|'\|\|:B1 , SEQ_SET_SYN_ACTION.NEXTVAL)
b4h1szgwqg328	select tablespace_name, to_char(pct_free) pct_free, to_char(pct_used) pct_used, to_char(ini_trans) ini_trans, to_char(max_trans) max_trans, to_char(initial_extent) initial_extent, to_char(next_extent) next_extent, to_char(pct_increase) pct_increase, to_char(min_extents) min_extents, to_char(max_extents) max_extents, cluster_name from sys.all_tables where owner = :object_owner and table_name = :object_name
b5yyh2vc9g8tm	SELECT sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id between :bid and :eid AND s.status = 0 AND x.ver_type = :exists_type ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = :inst_num AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.id
bh6jawk5uqdc9	SELECT COUNT(*) FROM MAILBATCH WHERE FINISHEDSIGN='0' AND SENDDATE <SYSDATE
bhvyz9bgyrhb2	SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1
bnd9vzzsu2b59	DELETE FROM MGMT_METRICS_1HOUR WHERE ROWID = :B1
bv9ujsxxgx961	SELECT "ACLASS", "SERIALNO", "PARENT", "ANSWER", "SAVETYPE" FROM "RESULTMULTIEXPAND" "A1" WHERE "PARENT"=:1 AND "ACLASS"=205 AND "SAVETYPE"=1 AND TO_NUMBER("SERIALNO")=:2 AND "ANSWER" IS NOT NULL
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
c4pvqv2xrwua4	UPDATE NEEDSYN SET SYNCODE = REPLACE(SYNCODE, :B2 , '') WHERE SERIALNO = :B1
c8dq4529a0jdg	begin PROC_Manager.insertToEmail(p_key=>:p_key, p_value=>:p_value, p_parm=>:p_parm, p_name=>:p_name, p_aclass=>:p_aclass, p_majorNo=>:p_majorNo, p_universityName=>:p_universityName); end;
c8khjbn635s3c	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
cga2j12pg1bh1	begin PROC_email.allocate_mails(p_out=>:p_out); end;
du080384mmds1	SELECT COUNT(1) FROM EMAIL T WHERE T.ACLASS=:B3 AND T.GRADE=:B2 AND T.EMAIL=:B1
fyzz7ty3zwh2m	SELECT SMTP, POP3HOST, POP3PORT, POP3SSL, SENDUSER FROM SMTPS WHERE SMTP = :B1 ORDER BY SMTP
g1s142jhnczuv	SELECT SMTPGROUP, FOCUSSIGN, SMTP FROM SMTPGROUP WHERE SIGN = '1' AND AUTO_ADD = 'Yes' AND SMTPGROUP IN (SELECT SMTPGROUP FROM SMTPGROUPPLAN WHERE PID = :B1 )
gacp7c4xpvj1c	select SEQ_ZAIXIAN_ANSWER.nextval from dual
gdn3ysuyssf82	SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
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
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	8,528,231	787.12	64.22
CPU used when call started	7,906,614	729.75	59.54
CR blocks created	123,750	11.42	0.93
Cached Commit SCN referenced	33,533	3.09	0.25
Commit SCN cached	5	0.00	0.00
DB time	30,953,418	2,856.87	233.08
DBWR checkpoint buffers written	124,438	11.49	0.94
DBWR checkpoints	64	0.01	0.00
DBWR object drop buffers written	162	0.01	0.00
DBWR revisited being-written buffer	97	0.01	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	1,417	0.13	0.01
DBWR undo block writes	26,360	2.43	0.20
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	0	0.00	0.00
IMU Redo allocation size	0	0.00	0.00
IMU commits	0	0.00	0.00
IMU contention	0	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	0	0.00	0.00
IMU- failed to get a private strand	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
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	24	0.00	0.00
SQL*Net roundtrips to/from client	6,486,436	598.67	48.84
SQL*Net roundtrips to/from dblink	310	0.03	0.00
active txn count during cleanout	69,652	6.43	0.52
application wait time	50,466	4.66	0.38
background checkpoints completed	14	0.00	0.00
background checkpoints started	13	0.00	0.00
background timeouts	32,462	3.00	0.24
branch node splits	5	0.00	0.00
buffer is not pinned count	108,074,562	9,974.83	813.81
buffer is pinned count	358,759,597	33,112.02	2,701.48
bytes received via SQL*Net from client	1,521,952,575	140,469.90	11,460.40
bytes received via SQL*Net from dblink	153,715	14.19	1.16
bytes sent via SQL*Net to client	1,982,457,345	182,972.57	14,928.03
bytes sent via SQL*Net to dblink	55,208	5.10	0.42
calls to get snapshot scn: kcmgss	87,769,564	8,100.77	660.91
calls to kcmgas	414,718	38.28	3.12
calls to kcmgcs	18,695	1.73	0.14
change write time	3,623	0.33	0.03
cleanout - number of ktugct calls	70,481	6.51	0.53
cleanouts and rollbacks - consistent read gets	56,712	5.23	0.43
cleanouts only - consistent read gets	1,138	0.11	0.01
cluster key scan block gets	42,612	3.93	0.32
cluster key scans	11,222	1.04	0.08
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	12	0.00	0.00
commit batch/immediate requested	12	0.00	0.00
commit cleanout failures: block lost	97	0.01	0.00
commit cleanout failures: buffer being written	44	0.00	0.00
commit cleanout failures: callback failure	379	0.03	0.00
commit cleanout failures: cannot pin	195	0.02	0.00
commit cleanouts	507,763	46.86	3.82
commit cleanouts successfully completed	507,048	46.80	3.82
commit immediate performed	12	0.00	0.00
commit immediate requested	12	0.00	0.00
commit txn count during cleanout	3,024	0.28	0.02
concurrency wait time	3,100,544	286.17	23.35
consistent changes	4,699,969	433.79	35.39
consistent gets	8,188,861,327	755,797.87	61,662.65
consistent gets - examination	45,923,400	4,238.54	345.81
consistent gets direct	498,930	46.05	3.76
consistent gets from cache	8,188,362,396	755,751.82	61,658.89
current blocks converted for CR	0	0.00	0.00
cursor authentications	3,490	0.32	0.03
data blocks consistent reads - undo records applied	4,699,225	433.72	35.39
db block changes	2,971,428	274.25	22.38
db block gets	2,576,732	237.82	19.40
db block gets direct	709	0.07	0.01
db block gets from cache	2,576,023	237.76	19.40
deferred (CURRENT) block cleanout applications	294,771	27.21	2.22
dirty buffers inspected	9,409	0.87	0.07
doubling up with imu segment	0	0.00	0.00
enqueue conversions	746,821	68.93	5.62
enqueue deadlocks	0	0.00	0.00
enqueue releases	2,480,584	228.95	18.68
enqueue requests	2,480,803	228.97	18.68
enqueue timeouts	194	0.02	0.00
enqueue waits	1,057	0.10	0.01
exchange deadlocks	4	0.00	0.00
execute count	30,075,059	2,775.80	226.47
free buffer inspected	8,548,123	788.96	64.37
free buffer requested	8,174,580	754.48	61.56
heap block compress	32,412	2.99	0.24
hot buffers moved to head of LRU	2,624,218	242.20	19.76
immediate (CR) block cleanout applications	57,850	5.34	0.44
immediate (CURRENT) block cleanout applications	15,551	1.44	0.12
index fast full scans (full)	133,016	12.28	1.00
index fetch by key	32,241,992	2,975.80	242.78
index scans kdiixs1	4,163,006	384.23	31.35
leaf node 90-10 splits	297	0.03	0.00
leaf node splits	1,731	0.16	0.01
lob reads	464,890	42.91	3.50
lob writes	1,197	0.11	0.01
lob writes unaligned	1,140	0.11	0.01
logons cumulative	2,552	0.24	0.02
messages received	101,199	9.34	0.76
messages sent	101,199	9.34	0.76
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	8,078,932,880	745,651.93	60,834.88
opened cursors cumulative	6,072,510	560.47	45.73
parse count (failures)	4,057	0.37	0.03
parse count (hard)	49,712	4.59	0.37
parse count (total)	6,092,701	562.33	45.88
parse time cpu	29,886	2.76	0.23
parse time elapsed	111,341	10.28	0.84
physical read IO requests	1,628,980	150.35	12.27
physical read bytes	69,012,742,144	6,369,589.31	519,670.35
physical read total IO requests	1,655,442	152.79	12.47
physical read total bytes	70,451,508,224	6,502,381.44	530,504.35
physical read total multi block requests	1,022,479	94.37	7.70
physical reads	8,424,407	777.54	63.44
physical reads cache	7,925,080	731.45	59.68
physical reads cache prefetch	6,795,434	627.19	51.17
physical reads direct	499,327	46.09	3.76
physical reads direct (lob)	498,813	46.04	3.76
physical reads direct temporary tablespace	5	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	93,786	8.66	0.71
physical write bytes	1,127,251,968	104,040.67	8,488.28
physical write total IO requests	186,864	17.25	1.41
physical write total bytes	2,541,821,440	234,599.56	19,140.08
physical write total multi block requests	108,242	9.99	0.82
physical writes	137,604	12.70	1.04
physical writes direct	1,157	0.11	0.01
physical writes direct (lob)	104	0.01	0.00
physical writes direct temporary tablespace	5	0.00	0.00
physical writes from cache	136,447	12.59	1.03
physical writes non checkpoint	63,783	5.89	0.48
pinned buffers inspected	105	0.01	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	5	0.00	0.00
process last non-idle time	10,849	1.00	0.08
recursive calls	51,119,944	4,718.16	384.94
recursive cpu usage	5,654,277	521.87	42.58
redo blocks written	1,163,371	107.37	8.76
redo buffer allocation retries	196	0.02	0.00
redo entries	1,547,123	142.79	11.65
redo log space requests	395	0.04	0.00
redo log space wait time	17,893	1.65	0.13
redo ordering marks	23,581	2.18	0.18
redo size	553,090,820	51,047.98	4,164.81
redo synch time	2,282,531	210.67	17.19
redo synch writes	143,823	13.27	1.08
redo wastage	23,229,436	2,143.98	174.92
redo write time	664,480	61.33	5.00
redo writer latching time	601	0.06	0.00
redo writes	97,724	9.02	0.74
rollback changes - undo records applied	8,066	0.74	0.06
rollbacks only - consistent read gets	67,728	6.25	0.51
rows fetched via callback	10,994,214	1,014.72	82.79
session connect time	0	0.00	0.00
session cursor cache hits	3,019,096	278.65	22.73
session logical reads	8,191,438,010	756,035.69	61,682.05
session pga memory	1,460,023,344	134,754.09	10,994.07
session pga memory max	9,373,218,832	865,109.15	70,580.94
session uga memory	###############	570,041,120.04	46,507,467.60
session uga memory max	2,360,282,944	217,844.31	17,773.08
shared hash latch upgrades - no wait	4,228,709	390.29	31.84
sorts (disk)	0	0.00	0.00
sorts (memory)	3,720,452	343.38	28.02
sorts (rows)	16,485,864	1,521.58	124.14
sql area purged	4,128	0.38	0.03
summed dirty queue length	18,886	1.74	0.14
switch current to new buffer	91,451	8.44	0.69
table fetch by rowid	209,509,277	19,336.84	1,577.62
table fetch continued row	210,216	19.40	1.58
table scan blocks gotten	7,020,125,460	647,928.41	52,861.99
table scan rows gotten	###############	75,194,643.51	6,134,842.42
table scans (cache partitions)	0	0.00	0.00
table scans (direct read)	0	0.00	0.00
table scans (long tables)	450	0.04	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	18,324,136	1,691.24	137.98
total number of times SMON posted	139	0.01	0.00
transaction rollbacks	12	0.00	0.00
transaction tables consistent read rollbacks	3	0.00	0.00
transaction tables consistent reads - undo records applied	31	0.00	0.00
undo change vector size	184,176,692	16,998.74	1,386.86
user I/O wait time	100,602	9.29	0.76
user calls	12,150,697	1,121.46	91.50
user commits	132,798	12.26	1.00
user rollbacks	3	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	3,806,495	351.32	28.66
write clones created in background	146	0.01	0.00
write clones created in foreground	3,692	0.34	0.03

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	50,491,617	50,520,250
opened cursors current	3,531	4,041
workarea memory allocated	10,293	9,130
logons current	235	239

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

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)
EMAIL_WORK	1,043,544	96	0.09	4.55	2,258	0	1	300.00
SKILLS_DATA	538,854	50	1.02	6.61	12,722	1	39	12.82
XYSURVERYTBS	21,762	2	7.65	1.45	28,392	3	111	123.78
XYMAINTTBS	7,173	1	12.90	1.52	13,479	1	0	0.00
HALFENTERSEND	5,911	1	2.28	6.13	10,455	1	0	0.00
UNDOTBS1	26	0	0.00	1.00	9,642	1	163	43.13
DEVELOPE	102	0	12.55	1.08	7,136	1	0	0.00
SYSAUX	3,464	0	7.34	1.06	1,543	0	0	0.00
SYSTEM	2,513	0	8.07	1.60	919	0	302	71.92
APPS_DATA	339	0	10.74	3.13	2,407	0	0	0.00
USERS	138	0	12.68	1.00	2,520	0	239	94.10
PUBCODE_DATA	2,228	0	4.69	5.53	139	0	0	0.00
DIAOCHAOBUTB	559	0	0.00	1.48	1,332	0	0	0.00
DAOCHUTBS	1,263	0	0.06	7.76	14	0	0	0.00
STATE_DATA	514	0	18.37	1.04	121	0	0	0.00
EMPLY	195	0	8.46	4.50	299	0	0	0.00
MAILCHECK_WORK	21	0	16.67	1.00	298	0	0	0.00
BSKILL	14	0	0.00	1.00	14	0	0	0.00
EMPLYSEND	14	0	0.00	1.00	14	0	0	0.00
HALFENTER	14	0	0.00	1.00	14	0	0	0.00
IMPORTUSER	14	0	0.00	1.00	14	0	0	0.00
MYCOSSURVERYDATATB	14	0	0.00	1.00	14	0	0	0.00
SENDMAILOPENTB	14	0	0.00	1.00	14	0	0	0.00
TEMP	7	0	0.00	1.00	9	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	339	0	10.74	3.13	2,407	0	0	0.00
BSKILL	/u01/oracle/oradata/research/bskill.dbf	14	0	0.00	1.00	14	0	0	0.00
DAOCHUTBS	/u01/oracle/oradata/research/daochu01.dbf	1,263	0	0.06	7.76	14	0	0	0.00
DEVELOPE	/u01/oracle/oradata/research/DEVELOPE.DBF	59	0	21.69	1.14	3,062	0	0	0.00
DEVELOPE	/u01/oracle/oradata/research/develope.dbf	15	0	0.00	1.00	1,236	0	0	0.00
DEVELOPE	/u01/oracle/oradata/research/develope01.dbf	14	0	0.00	1.00	1,111	0	0	0.00
DEVELOPE	/u01/oracle/oradata/research/develope02.dbf	14	0	0.00	1.00	1,727	0	0	0.00
DIAOCHAOBUTB	/u01/oracle/oradata/research/diaochabutb01.dbf	559	0	0.00	1.48	1,332	0	0	0.00
EMAIL_WORK	/u01/oracle/oradata/research/email_work.dbf	198,099	18	0.14	7.67	1,291	0	0	0.00
EMAIL_WORK	/u01/oracle/oradata/research/email_work01.dbf	561,514	52	0.10	4.55	532	0	1	300.00
EMAIL_WORK	/u01/oracle/oradata/research/email_work02.dbf	283,931	26	0.05	2.39	435	0	0	0.00
EMPLY	/u01/oracle/oradata/research/emply.dbf	195	0	8.46	4.50	299	0	0	0.00
EMPLYSEND	/u01/oracle/oradata/research/emplysend.dbf	14	0	0.00	1.00	14	0	0	0.00
HALFENTER	/u01/oracle/oradata/research/halfenter.dbf	14	0	0.00	1.00	14	0	0	0.00
HALFENTERSEND	/u01/oracle/oradata/research/halfentersend.dbf	5,911	1	2.28	6.13	10,455	1	0	0.00
IMPORTUSER	/u01/oracle/oradata/research/importuser.dbf	14	0	0.00	1.00	14	0	0	0.00
MAILCHECK_WORK	/u01/oracle/oradata/research/mailcheck_work.dbf	21	0	16.67	1.00	298	0	0	0.00
MYCOSSURVERYDATATB	/u01/oracle/oradata/research/mycossurverydata01.dbf	14	0	0.00	1.00	14	0	0	0.00
PUBCODE_DATA	/u01/oracle/oradata/research/pubcode_data.dbf	2,228	0	4.69	5.53	139	0	0	0.00
SENDMAILOPENTB	/u01/oracle/oradata/research/sendmailopen01.dbf	14	0	0.00	1.00	14	0	0	0.00
SKILLS_DATA	/u01/oracle/oradata/research/skills_data.dbf	126,688	12	1.28	5.45	11,485	1	1	40.00
SKILLS_DATA	/u01/oracle/oradata/research/skills_data01.dbf	191,953	18	1.21	7.14	257	0	33	12.12
SKILLS_DATA	/u01/oracle/oradata/research/skills_data02	220,213	20	0.70	6.80	980	0	5	12.00
STATE_DATA	/u01/oracle/oradata/research/state_data01.dbf	500	0	18.88	1.04	107	0	0	0.00
STATE_DATA	/u01/oracle/oradata/research/state_data02.dbf	14	0	0.00	1.00	14	0	0	0.00
SYSAUX	/u01/oracle/oradata/research/sysaux01.dbf	2,930	0	7.63	1.07	1,369	0	0	0.00
SYSAUX	/u01/oracle/oradata/research/sysaux02.dbf	534	0	5.69	1.00	174	0	0	0.00
SYSTEM	/u01/oracle/oradata/research/system01.dbf	2,513	0	8.07	1.60	919	0	302	71.92
TEMP	/u01/oracle/oradata/research/temp03.dbf	7	0	0.00	1.00	9	0	0
UNDOTBS1	/u01/oracle/oradata/research/undotbs01.dbf	26	0	0.00	1.00	9,642	1	163	43.13
USERS	/u01/oracle/oradata/research/users01.dbf	138	0	12.68	1.00	2,520	0	239	94.10
XYMAINTTBS	/u01/oracle/oradata/research/xymaint01.dbf	7,173	1	12.90	1.52	13,479	1	0	0.00
XYSURVERYTBS	/u01/oracle/oradata/research/xysurvery01.dbf	21,762	2	7.65	1.45	28,392	3	111	123.78

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	950,336	100	8,116,996,245	7,924,140	136,427	0	0	857

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	13	2110	29462	148207	184320	148207
E	0	14	2103	34878	173998	184320	173998

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	752	0.10	93,248	6.30	24,381,674,518
D	1,504	0.20	186,496	2.16	8,346,324,473
D	2,256	0.29	279,744	1.26	4,881,563,453
D	3,008	0.39	372,992	1.06	4,106,440,876
D	3,760	0.49	466,240	1.02	3,931,748,233
D	4,512	0.59	559,488	1.01	3,890,665,541
D	5,264	0.69	652,736	1.00	3,879,261,399
D	6,016	0.79	745,984	1.00	3,874,282,462
D	6,768	0.88	839,232	1.00	3,871,622,596
D	7,520	0.98	932,480	1.00	3,870,018,425
D	7,664	1.00	950,336	1.00	3,869,752,391
D	8,272	1.08	1,025,728	1.00	3,868,873,941
D	9,024	1.18	1,118,976	1.00	3,867,893,828
D	9,776	1.28	1,212,224	1.00	3,867,133,469
D	10,528	1.37	1,305,472	1.00	3,866,620,630
D	11,280	1.47	1,398,720	1.00	3,866,273,871
D	12,032	1.57	1,491,968	1.00	3,866,073,775
D	12,784	1.67	1,585,216	1.00	3,865,937,810
D	13,536	1.77	1,678,464	1.00	3,865,754,947
D	14,288	1.86	1,771,712	1.00	3,864,436,855
D	15,040	1.96	1,864,960	0.99	3,842,520,552

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	132,860	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,600	620.68	3.90	0.63	100.00	0.00	327,780
E	3,201	2,587	641.39	3.39	0.53	100.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	3,663,596	3,663,596
64K	128K	121	121
128K	256K	298	298
256K	512K	126	126
512K	1024K	141,071	141,071
1M	2M	456	456
2M	4M	259	259
4M	8M	2	2
8M	16M	15	15
16M	32M	7	7
32M	64M	6	6

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
400	0.13	120,653,817.50	1,986,097.33	98.00	10,417
800	0.25	120,653,817.50	1,157,668.45	99.00	1,697
1,601	0.50	120,653,817.50	796,573.13	99.00	0
2,401	0.75	120,653,817.50	796,517.83	99.00	0
3,201	1.00	120,653,817.50	578,886.26	100.00	0
3,841	1.20	120,653,817.50	550,988.28	100.00	0
4,481	1.40	120,653,817.50	550,988.28	100.00	0
5,122	1.60	120,653,817.50	550,988.28	100.00	0
5,762	1.80	120,653,817.50	550,988.28	100.00	0
6,402	2.00	120,653,817.50	550,988.28	100.00	0
9,603	3.00	120,653,817.50	550,988.28	100.00	0
12,804	4.00	120,653,817.50	550,988.28	100.00	0
19,206	6.00	120,653,817.50	550,988.28	100.00	0
25,608	8.00	120,653,817.50	550,988.28	100.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
320	0.17	219	24,863	2,208,367,158	1.00	790,570	1.10	3,857,460,864
512	0.28	404	38,789	2,208,409,563	1.00	748,165	1.04	3,860,447,886
704	0.38	595	53,634	2,208,422,565	1.00	735,163	1.02	1,871,408,776
896	0.48	786	68,005	2,208,428,278	1.00	729,450	1.02	3,720,964,309
1,088	0.59	977	82,747	2,208,431,736	1.00	725,992	1.01	1,871,740,708
1,280	0.69	1,168	97,187	2,208,434,447	1.00	723,281	1.01	3,861,534,884
1,472	0.79	1,359	112,057	2,208,436,629	1.00	721,099	1.00	3,861,644,440
1,664	0.90	1,550	126,226	2,208,438,249	1.00	719,479	1.00	3,861,729,511
1,856	1.00	1,741	141,310	2,208,439,400	1.00	718,328	1.00	3,861,797,383
2,048	1.10	1,932	157,587	2,208,440,321	1.00	717,407	1.00	3,861,871,660
2,240	1.21	2,123	175,157	2,208,441,079	1.00	716,649	1.00	3,861,928,833
2,432	1.31	2,313	192,371	2,208,441,740	1.00	715,988	1.00	3,861,979,034
2,624	1.41	2,504	210,841	2,208,442,313	1.00	715,415	1.00	3,862,016,554
2,816	1.52	2,695	229,114	2,208,442,824	1.00	714,904	1.00	1,872,264,450
3,008	1.62	2,886	245,289	2,208,443,343	1.00	714,385	0.99	3,323,788,774
3,200	1.72	3,077	265,352	2,208,443,949	1.00	713,779	0.99	3,862,087,069
3,392	1.83	3,268	281,904	2,208,444,608	1.00	713,120	0.99	3,862,109,450
3,584	1.93	3,459	297,689	2,208,445,341	1.00	712,387	0.99	3,862,129,834
3,776	2.03	3,776	325,537	2,208,446,237	1.00	711,491	0.99	3,862,184,361

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	62,814,014	8,346,281,998
4,808	0.50	55,205,369	3,890,649,073
7,212	0.75	55,111,714	3,874,396,113
9,616	1.00	55,095,169	3,869,752,410
12,020	1.25	55,089,677	3,868,978,460
14,424	1.50	55,084,183	3,866,656,608
16,828	1.75	55,045,618	3,842,664,143
19,232	2.00	55,045,628	3,842,664,143

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	0.50	0	0	0	0
32	1.00	0	0	0	0
48	1.50	0	0	0	0
64	2.00	0	0	0	0
80	2.50	0	0	0	0
96	3.00	0	0	0	0
112	3.50	0	0	0	0
128	4.00	0	0	0	0
144	4.50	0	0	0	0
160	5.00	0	0	0	0
176	5.50	0	0	0	0
192	6.00	0	0	0	0
208	6.50	0	0	0	0
224	7.00	0	0	0	0
240	7.50	0	0	0	0
256	8.00	0	0	0	0
272	8.50	0	0	0	0
288	9.00	0	0	0	0
304	9.50	0	0	0	0
320	10.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)	JP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
16	0.50	12	192	5	1.00	718,328	1.00	192
32	1.00	12	192	5	1.00	718,328	1.00	192
48	1.50	12	192	5	1.00	718,328	1.00	192
64	2.00	12	192	5	1.00	718,328	1.00	192

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	691	59	85
undo block	132	6	47
undo header	25	1	31
1st level bmb	2	0	195
file header block	6	0	0
segment header	1	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)
SQ-Sequence Cache	19,165	19,165	0	990	133	134.83
RO-Multiple Object Reuse (fast object reuse)	459	459	0	49	40	810.61
CF-Controlfile Transaction	6,464	6,416	48	13	18	1,406.15
TX-Transaction (index contention)	5	5	0	5	0	4.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	24.73	172,572	3,158	34	15/66.6833333333333333333333333333333333333	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
07-Jan 17:53	1,474	8,743	750	9	26	0/0	0/0/0/0/0/0
07-Jan 17:43	855	10,519	200	7	16	0/0	0/0/0/0/0/0
07-Jan 17:33	839	4,804	195	7	16	0/0	0/0/0/0/0/0
07-Jan 17:23	667	5,623	281	7	18	0/0	0/0/0/0/0/0
07-Jan 17:13	976	5,387	15	8	15	0/0	0/0/0/0/0/0
07-Jan 17:03	1,455	11,569	346	7	19	0/0	0/0/0/0/0/0
07-Jan 16:53	2,059	8,673	1,096	9	31	0/0	0/0/0/0/0/0
07-Jan 16:43	2,064	11,236	493	17	21	0/0	0/0/0/0/0/0
07-Jan 16:33	1,381	12,934	879	11	28	0/0	0/0/0/0/0/0
07-Jan 16:23	980	8,573	27	14	15	0/0	0/0/0/0/0/0
07-Jan 16:13	1,568	8,831	470	11	21	0/0	0/0/0/0/0/0
07-Jan 16:03	2,071	12,625	492	34	22	0/0	0/0/0/0/0/0
07-Jan 15:53	1,408	12,794	1,653	8	42	0/0	0/0/0/0/0/0
07-Jan 15:43	1,248	8,844	156	9	17	0/0	0/0/0/0/0/0
07-Jan 15:33	1,705	11,764	657	10	25	0/0	0/0/0/0/0/0
07-Jan 15:23	1,865	10,217	37	21	15	0/0	0/0/0/0/0/0
07-Jan 15:13	1,114	10,244	117	9	16	0/0	0/0/0/0/0/0
07-Jan 15:03	1,003	9,192	3,158	10	67	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	96,985	0.00		0	0
Consistent RBA	97,723	0.00		0	0
FAL request queue	242	0.00		0	0
FAL subheap alocation	242	0.00		0	0
FIB s.o chain latch	156	0.00		0	0
FOB s.o list latch	3,453	0.00		0	0
JS mem alloc latch	14	0.00		0	0
JS queue access latch	14	0.00		0	0
JS queue state obj latch	77,934	0.00		0	0
JS slv state obj latch	81	0.00		0	0
KGX	0			0	6,742,388	0.06
KMG MMAN ready and startup request latch	3,582	0.00		0	0
KTF sga latch	70,025	0.00		0	3,639	0.00
KWQMN job cache list latch	9	0.00		0	0
KWQP Prop Status	6	0.00		0	0
LGWR NS Write	1,691	0.00		0	0
MQL Tracking Latch	0			0	214	0.00
Memory Management Latch	0			0	3,582	0.00
OS process	3,195	0.00		0	0
OS process allocation	5,720	0.00		0	0
OS process: request allocation	2,037	0.00		0	0
PL/SQL warning settings	2,589,227	0.12	0.00	0	0
SGA IO buffer pool latch	5,901	0.00		0	8,795	0.00
SQL memory manager latch	3	0.00		0	3,214	0.00
SQL memory manager workarea list latch	622,475	0.00	0.50	0	0
Shared B-Tree	396	0.00		0	0
active checkpoint queue latch	5,676	0.00		0	0
active service list	33,909	0.21	0.00	0	4,531	0.00
alert log latch	13	0.00		0	0
archive control	607	0.00		0	0
archive process latch	3,456	0.09	1.00	0	0
begin backup scn array	139	0.00		0	0
cache buffer handles	11,415	0.00		0	0
cache buffers chains	16,355,383,037	0.43	0.00	28658	15,513,278	1.54
cache buffers lru chain	599,748	0.07	0.14	3	83,891,231	0.19
cache table scan latch	0			0	997,885	1.34
cas latch	60,278	0.11	0.00	0	0
channel handle pool latch	2,261	0.00		0	0
channel operations parent latch	52,771	0.00		0	0
checkpoint queue latch	523,314	0.00	0.00	0	135,059	0.00
client/application info	16,012	0.00		0	0
commit callback allocation	28	0.00		0	0
compile environment latch	346,353	0.48	0.00	0	0
dictionary lookup	63	0.00		0	0
dml lock allocation	780,714	0.07	0.02	1	0
dummy allocation	5,098	1.04	0.00	0	0
enqueue hash chains	5,708,226	0.06	0.01	1	21,207	0.01
enqueues	4,141,285	0.67	0.00	4	0
event group latch	1,022	0.00		0	0
file cache latch	1,241	0.00		0	0
global KZLD latch for mem in SGA	997	0.00		0	0
global tx hash mapping	2,335,062	0.01	0.00	0	0
hash table column usage latch	1,020	0.00		0	235,715	0.00
hash table modification latch	458	0.00		0	0
job workq parent latch	0			0	2,343	0.26
job_queue_processes parameter latch	620	0.00		0	0
kks stats	177,554	0.06	0.25	2	0
kmcptab latch	1	0.00		0	0
kmcpvec latch	0			0	1	0.00
ksuosstats global area	728	0.00		0	0
ktm global data	203	0.00		0	0
kwqbsn:qsga	393	0.00		0	0
lgwr LWN SCN	97,727	0.00		0	0
library cache	91,274,775	0.35	0.09	2008	183,208	0.24
library cache load lock	2,462	0.00		0	0
library cache lock	15,617,572	0.24	0.00	7	0
library cache lock allocation	29,571	0.01	0.00	0	0
library cache pin	81,018,000	0.09	0.01	121	0
library cache pin allocation	47,551	0.00	0.00	0	0
list of block allocation	10,872	0.26	0.00	0	0
loader state object freelist	910,308	0.00		0	0
logminer context allocation	3	0.00		0	0
longop free list parent	2,461	0.00		0	128	0.00
message pool operations parent latch	381	0.00		0	0
messages	355,514	0.01	0.06	1	0
mostly latch-free SCN	1,203,126	0.32	0.00	1	0
multiblock read objects	2,085,186	0.05	0.00	1	0
ncodef allocation latch	216	0.00		0	0
object queue header heap	2,812	0.00		0	4,233	0.00
object queue header operation	16,602,440	0.00	0.04	0	0
object stats modification	112	0.00		0	0
parallel query alloc buffer	1,364	0.00		0	0
parameter list	8,330	0.00		0	0
parameter table allocation management	2,836	3.70	0.06	0	0
post/wait queue	231,243	0.00	0.00	0	141,268	0.01
process allocation	2,037	0.10	1.00	2	1,022	0.00
process group creation	2,037	0.00		0	0
qmn task queue latch	2,697	0.00		0	0
redo allocation	297,590	0.02	0.25	0	1,546,556	0.06
redo copy	0			0	1,546,946	0.05
redo on-disk SCN	315,326	0.00		0	0
redo writing	306,880	0.01	0.20	0	0
resmgr group change latch	3,213	0.44	0.00	0	0
resmgr:actses active list	5,085	0.00		0	0
resmgr:actses change group	2,434	0.00		0	0
resmgr:free threads list	5,082	1.65	0.00	0	0
resmgr:schema config	3	0.00		0	0
rm cas latch	19,656	0.05	0.00	0	0
row cache objects	4,988,143	0.01	0.01	0	214	0.00
rules engine aggregate statistics	6	0.00		0	0
rules engine rule set statistics	312	0.00		0	0
sequence cache	1,158,122	0.62	0.00	0	0
session allocation	806,879	0.97	0.00	10	0
session idle bit	24,638,693	0.02	0.00	1	0
session state list latch	3,739	2.35	0.00	0	0
session switching	216	0.00		0	0
session timer	4,532	0.00		0	0
shared pool	2,367,200	0.43	0.37	134	0
simulator hash latch	529,530,599	0.02	0.01	1	0
simulator lru latch	519,825,940	2.59	0.01	18223	498,676	0.10
slave class	8	0.00		0	0
slave class create	32	6.25	1.00	0	0
sort extent pool	681	0.00		0	0
state object free list	6	0.00		0	0
statistics aggregation	420	0.00		0	0
temp lob duration state obj allocation	38	0.00		0	0
temporary table state object allocation	11	0.00		0	0
threshold alerts latch	2,470	0.00		0	0
transaction allocation	168,935	0.01	0.00	0	0
transaction branch allocation	2,027,185	0.45	0.00	0	0
undo global data	5,442,066	0.25	0.00	2	0
user lock	6,844	1.88	0.11	1	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	16,355,383,037	69,685,395	164,934	69,520,835
simulator lru latch	519,825,940	13,461,992	140,389	13,322,891
library cache	91,274,775	315,452	28,065	287,686
simulator hash latch	529,530,599	116,377	1,082	115,296
library cache pin	81,018,000	72,435	807	71,629
library cache lock	15,617,572	37,139	44	37,095
enqueues	4,141,285	27,543	70	27,473
undo global data	5,442,066	13,807	10	13,797
shared pool	2,367,200	10,249	3,776	6,987
transaction branch allocation	2,027,185	9,192	4	9,188
session allocation	806,879	7,843	13	7,830
sequence cache	1,158,122	7,171	6	7,165
session idle bit	24,638,693	4,209	14	4,195
mostly latch-free SCN	1,203,126	3,886	5	3,881
enqueue hash chains	5,708,226	3,262	23	3,239
PL/SQL warning settings	2,589,227	3,232	3	3,229
multiblock read objects	2,085,186	1,136	5	1,131
dml lock allocation	780,714	575	12	563
row cache objects	4,988,143	449	4	445
cache buffers lru chain	599,748	419	58	361
user lock	6,844	129	14	116
kks stats	177,554	112	28	84
parameter table allocation management	2,836	105	6	99
object queue header operation	16,602,440	95	4	91
redo allocation	297,590	55	14	41
messages	355,514	50	3	47
redo writing	306,880	20	4	16
archive process latch	3,456	3	3	0
SQL memory manager workarea list latch	622,475	2	1	1
process allocation	2,037	2	2	0
slave class create	32	2	2	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
PL/SQL warning settings	kqlpPlsGetWarningHandle	3	3
SQL memory manager workarea list latch	qesmmIRegisterWorkArea	1	0
archive process latch	kcrrsarc	3	0
cache buffers chains	kcbrls: kslbegin	124,531	1,218
cache buffers chains	kcbgtcr: kslbegin excl	39,092	163,392
cache buffers chains	kcbgtcr: fast path	677	269
cache buffers chains	kcbzgb: scan from tail. nowait	307	0
cache buffers chains	kcbzib: multi-block read: nowait	114	0
cache buffers chains	kcbnlc	43	5
cache buffers chains	kcbchg: kslbegin: call CR func	38	4
cache buffers chains	kcbchg: kslbegin: bufs not pinned	36	38
cache buffers chains	kcbgcur: kslbegin	35	18
cache buffers chains	kcbbic2	27	0
cache buffers chains	kcbbic1	18	3
cache buffers chains	kcbbxsv	10	8
cache buffers chains	kcbnew: new latch again	7	0
cache buffers chains	kcbzib: finish free bufs	7	2
cache buffers chains	kcbcge	3	0
cache buffers chains	kcbget: exchange rls	3	0
cache buffers chains	kcbget: pin buffer	3	3
cache buffers chains	kcbgtcr: kslbegin shared	3	0
cache buffers chains	kcbnew_1	2	0
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	2	0
cache buffers chains	kcbgtcr	1	0
cache buffers chains	kcbzwb	1	0
cache buffers lru chain	kcbzgws	38	0
cache buffers lru chain	kcbzar: KSLNBEGIN	18	0
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	1	0
cache buffers lru chain	kcbkubc	1	3
cost function	kzulgt: find user res	10	12
cost function	kzulrl	4	2
dml lock allocation	ktaidm	7	2
dml lock allocation	ktaiam	5	10
enqueue hash chains	ksqrcl	12	3
enqueue hash chains	ksqgtl3	7	20
enqueue hash chains	ksqcnl	4	0
enqueues	ksqdel	34	7
enqueues	ksqgel: create enqueue	28	63
enqueues	ksqies	8	0
kks stats	kks stats alloc/free	28	28
library cache	kglpndl: child: before processing	11,257	6,195
library cache	kglpin: child: heap processing	2,494	4,411
library cache	kglpnp: child	2,037	5,978
library cache	kglpnc: child	1,769	6,835
library cache	kglpndl: child: after processing	1,451	11
library cache	kglobpn: child:	423	450
library cache	kglhdgc: child:	401	3,184
library cache	kglukp: child	358	82
library cache	kgldte: child 0	346	328
library cache	kglrtl	298	0
library cache	kgldti: 2child	104	12
library cache	kglobld	103	16
library cache	kglpin	92	3
library cache	kglhdgn: child:	48	108
library cache	kglic	8	0
library cache	kglhdiv: child	6	0
library cache	kglati	2	0
library cache	kglhfr: child	2	0
library cache	kglivl: child	1	0
library cache	kglupd: child	1	0
library cache lock	kgllkdl: child: no lock handle	655	261
library cache lock	kgllkal: child: multiinstance	25	16
library cache lock	kgllkdl: child: cleanup	19	28
library cache pin	kglpndl	528	122
library cache pin	kglpnc: child	112	119
library cache pin	kglpnal: child: alloc space	85	258
library cache pin	kglpnp: child	81	307
library cache pin	kgldnp: child	1	1
messages	ksarcv	2	0
messages	ksarcv: after wait	1	3
mostly latch-free SCN	kcs03	4	3
mostly latch-free SCN	kcs02	1	2
multiblock read objects	kcbzib: mbr get	4	2
multiblock read objects	kcbzib: normal mbr free	1	3
object queue header operation	kcbo_switch_cq	3	2
object queue header operation	kcbw_link_q	1	0
parameter table allocation management	ksp_param_table_free	6	6
process allocation	ksucrp	2	0
redo allocation	kcrfw_redo_gen: redo allocation 1	14	0
redo writing	kcrfsr: rba scn pair	4	0
row cache objects	kqreqd: reget	3	0
row cache objects	kqrso	1	0
sequence cache	kdnnxt: cached seq	4	0
sequence cache	kdnss	1	6
sequence cache	kdnssd	1	0
session allocation	ksuxds: not user session	10	1
session allocation	ksucri	2	11
session allocation	ksucrp	1	0
session idle bit	ksupuc: clear busy	7	4
session idle bit	ksupuc: set busy	7	10
shared pool	kghfrunp: clatch: nowait	5,679	0
shared pool	kghalo	1,864	1,854
shared pool	kghfrunp: alloc: cursor dur	794	2
shared pool	kghfrunp: clatch: wait	530	190
shared pool	kghupr1	487	494
shared pool	kghfre	462	1,411
shared pool	kghalp	121	12
shared pool	kghfrunp: alloc: session dur	30	0
shared pool	kghfrh	16	0
shared pool	kghfree_extents: scan	2	3
simulator hash latch	kcbsacc: lookup dba	1,053	1,075
simulator hash latch	kcbs_lookup_setid: lookup dba	13	2
simulator hash latch	kcbsacc: insert dba	8	0
simulator hash latch	kcbsacc: remove dba	8	5
simulator lru latch	kcbs_simulate: simulate set	140,343	140,303
simulator lru latch	kcbs_simbufseq	33	88
simulator lru latch	kcbs_lookup_setid	14	0
slave class create	ksvcreate	2	0
transaction branch allocation	ksupuc	2	2
transaction branch allocation	ktcbba	2	2
undo global data	kturimugur: child	7	1
undo global data	ktudba: KSLBEGIN	3	7

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: 8,191,438,010
Captured Segments account for 98.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
XYSURVERY	XYSURVERYTBS	RESULTMULTIEXPAND	TABLE	2,229,352,624	27.22
XYSURVERY	XYSURVERYTBS	EMAIL	TABLE	1,145,318,608	13.98
XYSURVERY	XYSURVERYTBS	UK_TQSKILLUSERID	INDEX	969,281,808	11.83
DEVELOPER	DEVELOPE	NEEDSYN	TABLE	830,724,352	10.14
EMPLYSEND	EMAIL_WORK	MAILTOSEND	TABLE	688,385,248	8.40

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 8,424,407
Captured Segments account for 90.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
NEWEMAILUSER	EMAIL_WORK	MAILRECEIVED	TABLE	3,482,047	41.33
SKILLS	SKILLS_DATA	LOGININFO2	TABLE	3,237,625	38.43
NEWEMAILUSER	EMAIL_WORK	MAILSENDED_STATE	TABLE	776,972	9.22
SKILLS	SKILLS_DATA	EMAIL_EXTENDS	TABLE	45,933	0.55
SKILLS	SKILLS_DATA	PROTOCOL_UNIVERSITY_SERIALNO	TABLE	31,520	0.37

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	Obj. Type	Row Lock Waits	% of Capture
XYSURVERY	USERS	PK_SET_SYN_ACTION	INDEX	5	55.56
XYSURVERY	USERS	SET_ANSWER_STATS	TABLE	2	22.22
XYSURVERY	XYSURVERYTBS	PGRADID	INDEX	1	11.11
XYSURVERY	XYSURVERYTBS	P_ACLASS_ID	INDEX	1	11.11

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	JOB$	TABLE	259	39.60
XYSURVERY	USERS	PK_SET_SYN_ACTION	INDEX	236	36.09
XYSURVERY	XYSURVERYTBS	LOGININFO2	TABLE	45	6.88
SYS	SYSTEM	SEQ$	TABLE	40	6.12
XYSURVERY	XYSURVERYTBS	UK_TQSKILLUSERID	INDEX	23	3.52

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	200	0.00	6	1
dc_constraints	12	50.00	12	74
dc_database_links	382	0.00	0	19
dc_global_oids	53,100	0.00	0	350
dc_histogram_data	690,402	0.00	0	14,679
dc_histogram_defs	169,146	0.03	0	26,202
dc_object_grants	1,084	0.00	0	868
dc_object_ids	190,815	0.05	4	4,293
dc_objects	149,509	0.02	98	7,896
dc_profiles	2,439	0.00	0	1
dc_rollback_segments	6,379	0.00	0	62
dc_segments	100,723	0.00	460	5,017
dc_sequences	33,880	0.00	33,880	91
dc_tablespace_quotas	390	0.00	16	32
dc_tablespaces	239,787	0.00	0	38
dc_usernames	13,332	0.01	0	229
dc_users	441,530	0.00	0	120
global database name	1	0.00	0	1
outstanding_alerts	1,137	0.26	6	55

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	2,909	0.00	2,699,381	0.00	7	0
CLUSTER	173	0.00	308	0.32	1	0
INDEX	7	0.00	54	1.85	1	0
JAVA RESOURCE	5	80.00	9	55.56	1	0
JAVA SOURCE	5	80.00	9	44.44	0	0
PIPE	2,584	0.31	3,835	0.21	0	0
SQL AREA	44,938	97.78	34,237,687	0.28	5,612	363
TABLE/PROCEDURE	7,819	0.40	3,737,835	0.04	1,102	0
TRIGGER	186	2.15	931	0.75	3	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	487.50		2.06	7.36	76	76	237	237
	Freeable	87.38	0.00	0.73	0.38	3		119	119
	PL/SQL	31.31	5.04	0.13	0.19	1	11	235	235
	SQL	14.66	9.37	0.06	0.23	3	220	226	215
E	Other	500.78		2.08	7.30	76	76	241	241
	Freeable	84.00	0.00	0.67	0.38	3		125	125
	PL/SQL	35.62	5.37	0.15	0.20	1	10	239	239
	SQL	15.18	8.92	0.07	0.21	3	220	231	218

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	8,036,286,464
Fixed Size	2,037,344
Redo Buffers	14,737,408
Variable Size	2,030,045,600

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	25.88	25.88	0.00
java	joxlod exec hp	6.00	6.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	CCursor	145.78	146.03	0.17
shared	KQR M PO	17.93	17.94	0.09
shared	PCursor	105.24	107.84	2.47
shared	PL/SQL DIANA	51.03	44.65	-12.51
shared	db_block_hash_buckets	33.63	33.63	0.00
shared	free memory	107.75	70.54	-34.53
shared	kglsim heap	28.99	28.99	0.00
shared	kglsim object batch	59.07	59.07	0.00
shared	library cache	431.94	415.03	-3.91
shared	sql area	441.76	507.08	14.79
streams	free memory	31.98	31.98	0.00
	buffer_cache	7,664.00	7,664.00	0.00
	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 Coordinator	73,815	0	0
QMON Slaves	37,451	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	6	0	0	0	0

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
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.04	Recursive Call %:	80.80
Rollback per transaction %:	0.00	Rows per Sort:	4.43

Buffer Nowait %:	100.00	Redo NoWait %:	99.97
Buffer Hit %:	99.91	In-memory Sort %:	100.00
Library Hit %:	99.76	Soft Parse %:	99.18
Execute to Parse %:	79.74	Latch Hit %:	99.53
Parse CPU to Parse Elapsd %:	26.84	% Non-Parse CPU:	99.67