WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

STUDENT 4107938137 student 1 10.2.0.1.0 NO newstudentora

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
STUDENT	4107938137	student	1	10.2.0.1.0	NO	newstudentora

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 19804 15-Apr-14 18:00:06 54 15.7

End Snap: 19806 15-Apr-14 20:00:09 52 14.4

Elapsed: 120.05 (mins)

DB Time: 118.63 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	19804	15-Apr-14 18:00:06	54	15.7
End Snap:	19806	15-Apr-14 20:00:09	52	14.4
Elapsed:		120.05 (mins)
DB Time:		118.63 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 8,032M 8,032M Std Block Size: 8K

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

	Begin	End
Buffer Cache:	8,032M	8,032M	Std Block Size:	8K
Shared Pool Size:	1,536M	1,536M	Log Buffer:	14,392K

Load Profile

Per Second Per Transaction

Redo size: 3,065.37 5,035.40

Logical reads: 65,114.27 106,961.41

Block changes: 19.98 32.82

Physical reads: 0.00 0.01

Physical writes: 0.75 1.24

User calls: 5.26 8.64

Parses: 3.85 6.32

Hard parses: 0.02 0.03

Sorts: 1.69 2.77

Logons: 0.06 0.10

Executes: 26.27 43.15

Transactions: 0.61

	Per Second	Per Transaction
Redo size:	3,065.37	5,035.40
Logical reads:	65,114.27	106,961.41
Block changes:	19.98	32.82
Physical reads:	0.00	0.01
Physical writes:	0.75	1.24
User calls:	5.26	8.64
Parses:	3.85	6.32
Hard parses:	0.02	0.03
Sorts:	1.69	2.77
Logons:	0.06	0.10
Executes:	26.27	43.15
Transactions:	0.61

% Blocks changed per Read: 0.03 Recursive Call %: 91.20

Rollback per transaction %: 0.00 Rows per Sort: 11.14

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.88 Soft Parse %: 99.50

Execute to Parse %: 85.36 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 89.96 % Non-Parse CPU: 99.97

Shared Pool Statistics

Begin End

Memory Usage %: 84.17 84.39

% SQL with executions>1: 98.91 99.16

% Memory for SQL w/exec>1: 92.57 88.41

	Begin	End
Memory Usage %:	84.17	84.39
% SQL with executions>1:	98.91	99.16
% Memory for SQL w/exec>1:	92.57	88.41

Top 5 Timed Events

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

CPU time 7,108 99.9

control file parallel write 2,490 46 18 .6 System I/O

log file parallel write 4,843 31 6 .4 System I/O

log file sync 1,670 11 7 .2 Commit

os thread startup 109 4 38 .1 Concurrency

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		7,108		99.9
control file parallel write	2,490	46	18	.6	System I/O
log file parallel write	4,843	31	6	.4	System I/O
log file sync	1,670	11	7	.2	Commit
os thread startup	109	4	38	.1	Concurrency

Main Report

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

Time Model Statistics

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

Statistic Name	Time (s)	% of DB Time
DB CPU	7,108.25	99.87
sql execute elapsed time	7,105.96	99.83
PL/SQL execution elapsed time	4.73	0.07
parse time elapsed	2.66	0.04
connection management call elapsed time	1.11	0.02
hard parse elapsed time	0.29	0.00
hard parse (sharing criteria) elapsed time	0.05	0.00
repeated bind elapsed time	0.04	0.00
sequence load elapsed time	0.02	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
DB time	7,117.72
background elapsed time	112.98
background cpu time	12.23

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	Total Wait Time (s)	Avg wait (ms)	Waits /txn
System I/O	11,775	77	7	2.69
Commit	1,670	11	7	0.38
Concurrency	109	4	38	0.02
Network	24,227	3	0	5.52
Other	40	0	1	0.01
User I/O	46	0	0	0.01

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
control file parallel write	2,490	0.00	46	18	0.57
log file parallel write	4,843	0.00	31	6	1.10
log file sync	1,670	0.00	11	7	0.38
os thread startup	109	0.00	4	38	0.02
ARCH wait on ATTACH	24	0.00	2	85	0.01
SQL*Net more data from client	230	0.00	0	2	0.05
Log archive I/O	47	0.00	0	2	0.01
control file sequential read	4,353	0.00	0	0	0.99
latch free	17	0.00	0	2	0.00
SQL*Net message to client	23,136	0.00	0	0	5.28
log file sequential read	42	0.00	0	0	0.01
SQL*Net more data to client	813	0.00	0	0	0.19
rdbms ipc reply	4	0.00	0	0	0.00
db file scattered read	4	0.00	0	0	0.00
LGWR wait for redo copy	19	0.00	0	0	0.00
db file sequential read	18	0.00	0	0	0.00
ARCH wait on DETACH	24	0.00	0	0	0.01
direct path read	8	0.00	0	0	0.00
direct path write	16	0.00	0	0	0.00
SQL*Net message from client	23,138	0.00	170,509	7369	5.28
pipe get	1,444	100.00	7,027	4867	0.33
Streams AQ: qmn slave idle wait	256	0.00	7,014	27399	0.06
Streams AQ: qmn coordinator idle wait	525	51.24	7,014	13360	0.12
virtual circuit status	240	100.00	7,012	29218	0.05
Streams AQ: waiting for time management or cleanup tasks	6	66.67	6,568	1094638	0.00
jobq slave wait	2,230	99.51	6,520	2924	0.51
class slave wait	4	100.00	20	4884	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
control file parallel write	2,490	0.00	46	18	0.57
log file parallel write	4,842	0.00	31	6	1.10
os thread startup	109	0.00	4	38	0.02
ARCH wait on ATTACH	24	0.00	2	85	0.01
Log archive I/O	44	0.00	0	2	0.01
control file sequential read	2,983	0.00	0	0	0.68
log file sequential read	38	0.00	0	0	0.01
events in waitclass Other	22	0.00	0	0	0.01
ARCH wait on DETACH	24	0.00	0	0	0.01
direct path read	8	0.00	0	0	0.00
direct path write	8	0.00	0	0	0.00
rdbms ipc message	27,624	83.81	75,832	2745	6.30
pmon timer	2,763	100.00	7,030	2544	0.63
Streams AQ: qmn slave idle wait	256	0.00	7,014	27399	0.06
Streams AQ: qmn coordinator idle wait	525	51.24	7,014	13360	0.12
Streams AQ: waiting for time management or cleanup tasks	6	66.67	6,568	1094638	0.00
smon timer	26	84.62	6,503	250104	0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	730,346
IDLE_TIME	5,019,300
NICE_TIME	298
SYS_TIME	6,441
USER_TIME	723,607
LOAD	1
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	372,884
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
student	7,114.10	7,105.50	0	468,967,902
SYS$USERS	3.60	2.80	0	29,062
SYS$BACKGROUND	0.00	0.00	34	32,030
studentXDB	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	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
student	0	0	0	22998	3
SYS$USERS	0	0	0	28	0
SYS$BACKGROUND	46	109	411	48	204

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
7,032	7,032	0		98.80	2q3991nqwurnd	PL/SQL Developer	begin -- Call the procedure ...
3,998	3,998	5,320	0.75	56.17	bgp4xu7byunxr	PL/SQL Developer	SELECT * FROM RESULTCHEKEDIT T...
1,773	1,773	2,368	0.75	24.91	av0axdy3r9r2a	PL/SQL Developer	SELECT * FROM RESULTMULTIEXPAN...
651	651	592	1.10	9.15	azb5s332zr8xb	PL/SQL Developer	SELECT DISTINCT PARENT FROM RE...
388	388	592	0.66	5.45	45tu0zutztvpr	PL/SQL Developer	SELECT DISTINCT PARENT FROM RE...
149	149	592	0.25	2.10	92u176shfdhmx	PL/SQL Developer	SELECT * FROM RESULTONLY T WHE...
70	70	592	0.12	0.99	dhkcgqj5hz5g5	PL/SQL Developer	SELECT * FROM RESULTEDIT T WHE...
18	18	308	0.06	0.25	dxx3xnh9qtww7	w3wp.exe	begin apps.PROC_NEWSTUDENT_201...
7	7	392	0.02	0.10	gwkgp280h7tgq	w3wp.exe	SELECT COUNT(ID) FROM SKILLS.N...
6	6	981	0.01	0.08	g9h2mnyftsf3u	w3wp.exe	begin apps.PROC_NEWSTUDENT_201...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
7,032	7,032	0		98.80	2q3991nqwurnd	PL/SQL Developer	begin -- Call the procedure ...
3,998	3,998	5,320	0.75	56.17	bgp4xu7byunxr	PL/SQL Developer	SELECT * FROM RESULTCHEKEDIT T...
1,773	1,773	2,368	0.75	24.91	av0axdy3r9r2a	PL/SQL Developer	SELECT * FROM RESULTMULTIEXPAN...
651	651	592	1.10	9.15	azb5s332zr8xb	PL/SQL Developer	SELECT DISTINCT PARENT FROM RE...
388	388	592	0.66	5.45	45tu0zutztvpr	PL/SQL Developer	SELECT DISTINCT PARENT FROM RE...
149	149	592	0.25	2.10	92u176shfdhmx	PL/SQL Developer	SELECT * FROM RESULTONLY T WHE...
70	70	592	0.12	0.99	dhkcgqj5hz5g5	PL/SQL Developer	SELECT * FROM RESULTEDIT T WHE...
18	18	308	0.06	0.25	dxx3xnh9qtww7	w3wp.exe	begin apps.PROC_NEWSTUDENT_201...
7	7	392	0.02	0.10	gwkgp280h7tgq	w3wp.exe	SELECT COUNT(ID) FROM SKILLS.N...
6	6	981	0.01	0.08	g9h2mnyftsf3u	w3wp.exe	begin apps.PROC_NEWSTUDENT_201...

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: 469,025,800
Captured SQL account for 99.7% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
464,495,596	0		99.03	7032.39	7032.39	2q3991nqwurnd	PL/SQL Developer	begin -- Call the procedure ...
308,800,303	5,320	58,045.17	65.84	3998.14	3998.14	bgp4xu7byunxr	PL/SQL Developer	SELECT * FROM RESULTCHEKEDIT T...
90,359,352	2,368	38,158.51	19.27	1773.15	1773.15	av0axdy3r9r2a	PL/SQL Developer	SELECT * FROM RESULTMULTIEXPAN...
34,367,932	592	58,053.94	7.33	651.15	651.15	azb5s332zr8xb	PL/SQL Developer	SELECT DISTINCT PARENT FROM RE...
22,589,908	592	38,158.63	4.82	387.82	387.82	45tu0zutztvpr	PL/SQL Developer	SELECT DISTINCT PARENT FROM RE...
6,599,556	592	11,147.90	1.41	149.31	149.31	92u176shfdhmx	PL/SQL Developer	SELECT * FROM RESULTONLY T WHE...
2,155,711	308	6,999.06	0.46	17.64	17.64	dxx3xnh9qtww7	w3wp.exe	begin apps.PROC_NEWSTUDENT_201...
1,722,246	592	2,909.20	0.37	70.26	70.26	dhkcgqj5hz5g5	PL/SQL Developer	SELECT * FROM RESULTEDIT T WHE...
961,968	392	2,454.00	0.21	6.98	6.99	gwkgp280h7tgq	w3wp.exe	SELECT COUNT(ID) FROM SKILLS.N...
755,833	308	2,454.00	0.16	5.71	5.72	b72ym499zsnhb	w3wp.exe	SELECT NU.LOGINTIME, NU.REFUSE...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

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

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
15	1	15.00	44.12	0.40	0.40	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
0	6	0.00	0.00	0.00	0.00	062savj8zgzut		UPDATE sys.wri$_adv_parameters...
0	2	0.00	0.00	0.00	0.00	0cn2wm9d7zq8d		SELECT decode(value, 'FATAL', ...
0	242	0.00	0.00	0.01	0.01	0h2dybf5yuz5r		SELECT T.WARNING_OPERATOR, T....
0	1,203	0.00	0.00	0.18	0.18	0h6b2sajwb74n		select privilege#, level from ...
0	2,472	0.00	0.00	0.11	0.11	0hw1tk43th8yy	w3wp.exe	SELECT COUNT(*) FROM RESULTEDI...
0	351	0.00	0.00	0.16	0.16	0k8522rmdzg4k		select privilege# from sysauth...
0	84	0.00	0.00	1.53	1.53	0puwrdcyazd5s	w3wp.exe	SELECT NU.LOGINTIME, NU.REFUSE...
0	231	0.00	0.00	0.10	0.10	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
0	4	0.00	0.00	0.00	0.00	10xj8nynmpqtq		SELECT dbin.db_name, dbin.ins...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 189,225
Captured SQL account for 59.3% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
17,288	32,523	1.88	0.00	0.00	8dhp6ca10704j	w3wp.exe	SELECT PT.PAGE_ID, PT.PAGE_PRO...
17,288	32,523	1.88	0.00	0.00	cr2rxgacjjm4x	w3wp.exe	SELECT PT.PAGE_PRO_NUM FROM SK...
13,711	13,711	1.00	0.00	0.00	5306q1rzn89tb	w3wp.exe	SELECT DOTYPE FROM QUESTION_OT...
12,703	12,703	1.00	0.00	0.00	57cbzkqnyh0my	w3wp.exe	SELECT COUNT(ID) FROM SKILLS.C...
6,546	6,546	1.00	0.00	0.00	1nh7cpm33h6p2	w3wp.exe	SELECT COUNT(*) FROM RESULTONL...
5,320	34,287	6.44	0.75	0.75	bgp4xu7byunxr	PL/SQL Developer	SELECT * FROM RESULTCHEKEDIT T...
3,844	3,844	1.00	0.00	0.00	9nth4bdpspjyt	PL/SQL Developer	INSERT INTO ETLTABLE VALUES(:B...
3,429	3,429	1.00	0.00	0.00	1c4rvf955xwjq	w3wp.exe	SELECT COUNT(*) FROM SKILLS.TU...
2,809	2,809	1.00	0.00	0.00	92um05jskydfh	w3wp.exe	SELECT UNI.PRO_PART_ID FROM SK...
2,809	2,809	1.00	0.00	0.00	fa3n2uyn3m7zt	w3wp.exe	SELECT COUNT(*) FROM SKILLS.TU...
2,472	2,472	1.00	0.00	0.00	0hw1tk43th8yy	w3wp.exe	SELECT COUNT(*) FROM RESULTEDI...
2,368	17,760	7.50	0.75	0.75	av0axdy3r9r2a	PL/SQL Developer	SELECT * FROM RESULTMULTIEXPAN...
2,167	2,167	1.00	0.00	0.00	8nwgb34kkbc59	w3wp.exe	begin apps.PROC_NEWSTUDENT_201...
2,153	2,153	1.00	0.00	0.00	aruk9xcf5psqy	w3wp.exe	begin PROC_NEWSTUDENT_2014.get...
2,082	2,082	1.00	0.00	0.00	c67jxnc2vcm45	w3wp.exe	SELECT NU.UNI_CODE FROM SKILLS...
2,026	2,026	1.00	0.00	0.00	as124qk811g8n	w3wp.exe	select count(*) from skills.ch...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 27,712
Captured SQL account for 67.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
2,167	2,167	7.82	8nwgb34kkbc59	w3wp.exe	begin apps.PROC_NEWSTUDENT_201...
2,153	2,153	7.77	aruk9xcf5psqy	w3wp.exe	begin PROC_NEWSTUDENT_2014.get...
2,026	2,026	7.31	as124qk811g8n	w3wp.exe	select count(*) from skills.ch...
1,821	1,821	6.57	7rwj1j2br5ahq	w3wp.exe	select * from skills.checkcont...
1,203	1,203	4.34	0h6b2sajwb74n		select privilege#, level from ...
981	981	3.54	g9h2mnyftsf3u	w3wp.exe	begin apps.PROC_NEWSTUDENT_201...
933	933	3.37	3ugdva6yf8d9q	w3wp.exe	begin apps.PROC_NEWSTUDENT_201...
656	656	2.37	6rnumzxhvqw7y	w3wp.exe	begin proc_newstudent_2013.get...
351	351	1.27	0k8522rmdzg4k		select privilege# from sysauth...
309	3,429	1.12	1c4rvf955xwjq	w3wp.exe	SELECT COUNT(*) FROM SKILLS.TU...
308	308	1.11	dxx3xnh9qtww7	w3wp.exe	begin apps.PROC_NEWSTUDENT_201...

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 Text
21,642,568		1.34	2zwjrv2186835	SQL Text Not Available
20,477,400		1.27	bnd9vzzsu2b59	SQL Text Not Available
8,518,313	2	0.53	31a13pnjps7j3	SELECT source, (case w...
4,138,336	4	0.26	10xj8nynmpqtq	SELECT dbin.db_name, dbin.ins...
1,787,426	5	0.11	63fyqfhnd7u5k	select OBJOID, CLSOID, RUNT...
1,397,157	2	0.09	14566d856s6hs	SELECT owner# FROM sys.wri$_ad...
1,305,568	2	0.08	gdn3ysuyssf82	SELECT advisor_id FROM sys.wri...
1,250,588	2	0.08	298ppdduqr7wm	SELECT status FROM sys.wri$_ad...
1,121,486	2	0.07	bkdusjx00dsmc	select i.obj#, i.ts#, i.file#,...

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 Text
1,319		2zwjrv2186835	SQL Text Not Available
1,248		bnd9vzzsu2b59	SQL Text Not Available
88	4	10xj8nynmpqtq	SELECT dbin.db_name, dbin.ins...
80	2	14566d856s6hs	SELECT owner# FROM sys.wri$_ad...
75	2	31a13pnjps7j3	SELECT source, (case w...
75	2	gdn3ysuyssf82	SELECT advisor_id FROM sys.wri...
74	2	298ppdduqr7wm	SELECT status FROM sys.wri$_ad...
63	2	akh9zqqkx3wj7	select 1, max(id) from sys.wr...
63	2	akh9zqqkx3wj7	select 1, max(id) from sys.wr...
63	2	akh9zqqkx3wj7	select 1, max(id) from sys.wr...
51	2	0cn2wm9d7zq8d	SELECT decode(value, 'FATAL', ...
51	2	bhvyz9bgyrhb2	SELECT name, datatype, value, ...
38	218	18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFOR...
24	8	7ng34ruy5awxq	select i.obj#, i.ts#, i.file#,...
24	8	7ng34ruy5awxq	select i.obj#, i.ts#, i.file#,...
24	2	g47k1ypcbftbg	insert into wrh$_service_name ...
23	2	fdxrh8tzyw0yw	SELECT snap_id , SERVICE_NAME...
22	6	062savj8zgzut	UPDATE sys.wri$_adv_parameters...
22	2	bkdusjx00dsmc	select i.obj#, i.ts#, i.file#,...
21	2	1tn90bbpyjshq	UPDATE wrh$_tempfile tfh SET ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

062savj8zgzut UPDATE sys.wri$_adv_parameters SET datatype = :1, value = :2, flags = :3, description = :4 WHERE task_id = :5 AND name = :6

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'

0h2dybf5yuz5r SELECT T.WARNING_OPERATOR, T.WARNING_THRESHOLD, T.CRITICAL_OPERATOR, T.CRITICAL_THRESHOLD, T.NUM_OCCURENCES, T.NUM_WARNINGS, T.NUM_CRITICALS, T.MESSAGE, T.MESSAGE_NLSID FROM MGMT_METRIC_THRESHOLDS T WHERE T.TARGET_GUID = :B3 AND T.METRIC_GUID = :B2 AND T.COLL_NAME = :B1 AND T.KEY_VALUE = ' '

0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

0hw1tk43th8yy SELECT COUNT(*) FROM RESULTEDIT WHERE SERIALNO=:B3 AND QUESTION=:B1 AND ACLASS=:B2

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

0puwrdcyazd5s SELECT NU.LOGINTIME, NU.REFUSED, NU.ID, NU.UNI_CODE, NU.UNI_NAME, NU.STAN_MAJOR_CODE, NU.MAJOR_NAME, NU.LEVELS, NU.DEPARTMENT, NU.NOTE FROM SKILLS.NEWSTUDENT_USER2013 NU WHERE NU.ACLASS = :B3 AND NU.STUNUMBER = :B2 AND NU.UNI_CODE=:B1

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

10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time

14566d856s6hs SELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1

18naypzfmabd6 INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))

1c4rvf955xwjq SELECT COUNT(*) FROM SKILLS.TURLSAVE WHERE ACLASS=:B2 AND SERIALNO=:B1

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

1tn90bbpyjshq UPDATE wrh$_tempfile tfh SET (snap_id, filename, tsname) = (SELECT :lah_snap_id, tf.name name, ts.name tsname FROM v$tempfile tf, ts$ ts WHERE tf.ts# = ts.ts# AND tfh.file# = tf.file# AND tfh.creation_change# = tf.creation_change#) WHERE (file#, creation_change#) IN (SELECT tf.tfnum, to_number(tf.tfcrc_scn) creation_change# FROM x$kcctf tf WHERE tf.tfdup != 0) AND dbid = :dbid AND snap_id < :snap_id

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

2q3991nqwurnd begin -- Call the procedure proc_etl_2012(in_aclass => :in_aclass, in_unicode => :in_unicode); end;

2zwjrv2186835 ** SQL Text Not Available **

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

3ugdva6yf8d9q begin apps.PROC_NEWSTUDENT_2014.super_get(p_serialno=>:p_serialno, p_aclass=>:p_aclass, p_question_num=>:p_question_num, p_out=>:p_out); end;

45tu0zutztvpr SELECT DISTINCT PARENT FROM RESULTMULTIEXPAND T WHERE T.ACLASS=:B2 AND T.SERIALNO=:B1

5306q1rzn89tb SELECT DOTYPE FROM QUESTION_OTHER WHERE SERIALNO=:B1 AND SIGN='1' AND ACLASS=:B2

57cbzkqnyh0my SELECT COUNT(ID) FROM SKILLS.CHECKCONTENT2014 WHERE ACLASS=:B2 AND QUESTION_CODE=:B1 AND SIGN=1

63fyqfhnd7u5k select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a where bitand(a.job_status, 515) = 1 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 fr om sys.scheduler$_window d where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID

6rnumzxhvqw7y begin proc_newstudent_2013.geturlid(p_serialno=>:p_serialno, p_aclass=>:p_aclass, p_uni_code=>:p_uni_code, p_urlid=>:p_urlid, 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#

7rwj1j2br5ahq select * from skills.checkcontent2014 where aclass=:aclass and question_code=:question_code and sign=1 and isdefault=0 order by idorder asc

8dhp6ca10704j SELECT PT.PAGE_ID, PT.PAGE_PRO_NUM FROM SKILLS.HT_NS_PRO_PART PT WHERE ACLASS=:B2 AND PRO_PART_ID=:B1

8nwgb34kkbc59 begin apps.PROC_NEWSTUDENT_2014.checkurl(p_inurl=>:p_inurl, p_aclass=>:p_aclass, p_serialno=>:p_serialno, p_url=>:p_url); end;

92u176shfdhmx SELECT * FROM RESULTONLY T WHERE T.ACLASS=:B2 AND T.SERIALNO=:B1

92um05jskydfh SELECT UNI.PRO_PART_ID FROM SKILLS.HT_NS_UNIVERSTY UNI WHERE UNI.ACLASS=:B2 AND UNI.UNI_CODE=:B1

9nth4bdpspjyt INSERT INTO ETLTABLE VALUES(:B9 , :B1 , :B2 , :B3 , NULL, :B4 , TO_DATE('2012', 'yyyy'), :B5 , :B6 , :B8 , :B7 )

akh9zqqkx3wj7 select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1

aruk9xcf5psqy begin PROC_NEWSTUDENT_2014.geturlid(p_serialno=>:p_serialno, p_aclass=>:p_aclass, p_uni_code=>:p_uni_code, p_urlid=>:p_urlid, p_out=>:p_out); end;

as124qk811g8n select count(*) from skills.checkcontent2014 where aclass=:aclass and question_code=:question_code and sign=1 and university_code=:university_code and isdefault=1

av0axdy3r9r2a SELECT * FROM RESULTMULTIEXPAND T WHERE T.ACLASS=:B3 AND T.PARENT=:B2 AND T.SERIALNO=:B1

azb5s332zr8xb SELECT DISTINCT PARENT FROM RESULTCHEKEDIT T WHERE T.ACLASS=:B2 AND T.SERIALNO=:B1

b72ym499zsnhb SELECT NU.LOGINTIME, NU.REFUSED, NU.ID, NU.UNI_CODE, NU.UNI_NAME, NU.STAN_MAJOR_CODE, NU.MAJOR_NAME, NU.LEVELS, NU.DEPARTMENT, NU.NOTE, NU.ZSKJ, NU.STUDENT_NAME FROM SKILLS.NEWSTUDENT_USER2013 NU WHERE NU.ACLASS = :B3 AND NU.STUNUMBER = :B2 AND NU.UNI_CODE=:B1

bgp4xu7byunxr SELECT * FROM RESULTCHEKEDIT T WHERE T.ACLASS=:B3 AND T.PARENT=:B2 AND T.SERIALNO=:B1

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

bkdusjx00dsmc 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, spare2, spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)) from ind$ i, (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.bo#=:1 order by i.obj#

bnd9vzzsu2b59 ** SQL Text Not Available **

c67jxnc2vcm45 SELECT NU.UNI_CODE FROM SKILLS.NEWSTUDENT_USER2013 NU WHERE NU.ID=:B2 AND ACLASS=:B1

cr2rxgacjjm4x SELECT PT.PAGE_PRO_NUM FROM SKILLS.HT_NS_PRO_PART PT WHERE ACLASS=:B2 AND PRO_PART_ID=:B1

d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;

dhkcgqj5hz5g5 SELECT * FROM RESULTEDIT T WHERE T.ACLASS=:B2 AND T.SERIALNO=:B1

dxx3xnh9qtww7 begin apps.PROC_NEWSTUDENT_2014.login(p_numbercode=>:p_numbercode, p_univisitycode=>:p_univisitycode, p_aclass=>:p_aclass, p_ip=>:p_ip, p_browser=>:p_browser, p_agent=>:p_agent, p_page=>:p_page, p_entry=>:p_entry, p_out=>:p_out); end;

fa3n2uyn3m7zt SELECT COUNT(*) FROM SKILLS.TURLSAVE T WHERE T.ACLASS=:B2 AND SERIALNO=:B1

fdxrh8tzyw0yw SELECT snap_id , SERVICE_NAME_HASH FROM (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.snap_id , t1.NAME_HASH SERVICE_NAME_HASH FROM V$SERVICES t1, WRH$_SERVICE_NAME t2 WHERE t2.dbid(+) = :dbid AND t2.SERVICE_NAME_HASH(+) = t1.NAME_HASH) WHERE nvl(snap_id, 0) < :snap_id

g47k1ypcbftbg insert into wrh$_service_name (snap_id, dbid, service_name_hash, service_name) select :lah_snap_id, :dbid, t2.name_hash, t2.name from x$kewrattrnew t1, v$services t2 where t1.num1_kewrattr = t2.name_hash

g9h2mnyftsf3u begin apps.PROC_NEWSTUDENT_2014.WriteAnswer(p_aclass=>:p_aclass, p_serialno=>:p_serialno, p_answer=>:p_answer, p_submit=>:p_submit, p_page_id=>:p_page_id, p_state=>:p_state, p_process=>:p_process, p_qnumber=>:p_qnumber, p_out=>:p_out); end;

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

gwkgp280h7tgq SELECT COUNT(ID) FROM SKILLS.NEWSTUDENT_USER2013 WHERE STUNUMBER=:B3 AND UNI_CODE=:B2 AND ACLASS=:B1

SQL Id	SQL Text
062savj8zgzut	UPDATE sys.wri$_adv_parameters SET datatype = :1, value = :2, flags = :3, description = :4 WHERE task_id = :5 AND name = :6
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'
0h2dybf5yuz5r	SELECT T.WARNING_OPERATOR, T.WARNING_THRESHOLD, T.CRITICAL_OPERATOR, T.CRITICAL_THRESHOLD, T.NUM_OCCURENCES, T.NUM_WARNINGS, T.NUM_CRITICALS, T.MESSAGE, T.MESSAGE_NLSID FROM MGMT_METRIC_THRESHOLDS T WHERE T.TARGET_GUID = :B3 AND T.METRIC_GUID = :B2 AND T.COLL_NAME = :B1 AND T.KEY_VALUE = ' '
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0hw1tk43th8yy	SELECT COUNT(*) FROM RESULTEDIT WHERE SERIALNO=:B3 AND QUESTION=:B1 AND ACLASS=:B2
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0puwrdcyazd5s	SELECT NU.LOGINTIME, NU.REFUSED, NU.ID, NU.UNI_CODE, NU.UNI_NAME, NU.STAN_MAJOR_CODE, NU.MAJOR_NAME, NU.LEVELS, NU.DEPARTMENT, NU.NOTE FROM SKILLS.NEWSTUDENT_USER2013 NU WHERE NU.ACLASS = :B3 AND NU.STUNUMBER = :B2 AND NU.UNI_CODE=:B1
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
10xj8nynmpqtq	SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
14566d856s6hs	SELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1c4rvf955xwjq	SELECT COUNT(*) FROM SKILLS.TURLSAVE WHERE ACLASS=:B2 AND SERIALNO=:B1
1nh7cpm33h6p2	SELECT COUNT(*) FROM RESULTONLY WHERE SERIALNO=:B3 AND QUESTION=:B1 AND ACLASS=:B2
1tn90bbpyjshq	UPDATE wrh$_tempfile tfh SET (snap_id, filename, tsname) = (SELECT :lah_snap_id, tf.name name, ts.name tsname FROM v$tempfile tf, ts$ ts WHERE tf.ts# = ts.ts# AND tfh.file# = tf.file# AND tfh.creation_change# = tf.creation_change#) WHERE (file#, creation_change#) IN (SELECT tf.tfnum, to_number(tf.tfcrc_scn) creation_change# FROM x$kcctf tf WHERE tf.tfdup != 0) AND dbid = :dbid AND snap_id < :snap_id
298ppdduqr7wm	SELECT status FROM sys.wri$_adv_tasks WHERE id = :1
2q3991nqwurnd	begin -- Call the procedure proc_etl_2012(in_aclass => :in_aclass, in_unicode => :in_unicode); end;
2zwjrv2186835	SQL Text Not Available
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
3ugdva6yf8d9q	begin apps.PROC_NEWSTUDENT_2014.super_get(p_serialno=>:p_serialno, p_aclass=>:p_aclass, p_question_num=>:p_question_num, p_out=>:p_out); end;
45tu0zutztvpr	SELECT DISTINCT PARENT FROM RESULTMULTIEXPAND T WHERE T.ACLASS=:B2 AND T.SERIALNO=:B1
5306q1rzn89tb	SELECT DOTYPE FROM QUESTION_OTHER WHERE SERIALNO=:B1 AND SIGN='1' AND ACLASS=:B2
57cbzkqnyh0my	SELECT COUNT(ID) FROM SKILLS.CHECKCONTENT2014 WHERE ACLASS=:B2 AND QUESTION_CODE=:B1 AND SIGN=1
63fyqfhnd7u5k	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a where bitand(a.job_status, 515) = 1 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 fr om sys.scheduler$_window d where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
6rnumzxhvqw7y	begin proc_newstudent_2013.geturlid(p_serialno=>:p_serialno, p_aclass=>:p_aclass, p_uni_code=>:p_uni_code, p_urlid=>:p_urlid, 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#
7rwj1j2br5ahq	select * from skills.checkcontent2014 where aclass=:aclass and question_code=:question_code and sign=1 and isdefault=0 order by idorder asc
8dhp6ca10704j	SELECT PT.PAGE_ID, PT.PAGE_PRO_NUM FROM SKILLS.HT_NS_PRO_PART PT WHERE ACLASS=:B2 AND PRO_PART_ID=:B1
8nwgb34kkbc59	begin apps.PROC_NEWSTUDENT_2014.checkurl(p_inurl=>:p_inurl, p_aclass=>:p_aclass, p_serialno=>:p_serialno, p_url=>:p_url); end;
92u176shfdhmx	SELECT * FROM RESULTONLY T WHERE T.ACLASS=:B2 AND T.SERIALNO=:B1
92um05jskydfh	SELECT UNI.PRO_PART_ID FROM SKILLS.HT_NS_UNIVERSTY UNI WHERE UNI.ACLASS=:B2 AND UNI.UNI_CODE=:B1
9nth4bdpspjyt	INSERT INTO ETLTABLE VALUES(:B9 , :B1 , :B2 , :B3 , NULL, :B4 , TO_DATE('2012', 'yyyy'), :B5 , :B6 , :B8 , :B7 )
akh9zqqkx3wj7	select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1
aruk9xcf5psqy	begin PROC_NEWSTUDENT_2014.geturlid(p_serialno=>:p_serialno, p_aclass=>:p_aclass, p_uni_code=>:p_uni_code, p_urlid=>:p_urlid, p_out=>:p_out); end;
as124qk811g8n	select count(*) from skills.checkcontent2014 where aclass=:aclass and question_code=:question_code and sign=1 and university_code=:university_code and isdefault=1
av0axdy3r9r2a	SELECT * FROM RESULTMULTIEXPAND T WHERE T.ACLASS=:B3 AND T.PARENT=:B2 AND T.SERIALNO=:B1
azb5s332zr8xb	SELECT DISTINCT PARENT FROM RESULTCHEKEDIT T WHERE T.ACLASS=:B2 AND T.SERIALNO=:B1
b72ym499zsnhb	SELECT NU.LOGINTIME, NU.REFUSED, NU.ID, NU.UNI_CODE, NU.UNI_NAME, NU.STAN_MAJOR_CODE, NU.MAJOR_NAME, NU.LEVELS, NU.DEPARTMENT, NU.NOTE, NU.ZSKJ, NU.STUDENT_NAME FROM SKILLS.NEWSTUDENT_USER2013 NU WHERE NU.ACLASS = :B3 AND NU.STUNUMBER = :B2 AND NU.UNI_CODE=:B1
bgp4xu7byunxr	SELECT * FROM RESULTCHEKEDIT T WHERE T.ACLASS=:B3 AND T.PARENT=:B2 AND T.SERIALNO=:B1
bhvyz9bgyrhb2	SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1
bkdusjx00dsmc	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, spare2, spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)) from ind$ i, (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.bo#=:1 order by i.obj#
bnd9vzzsu2b59	SQL Text Not Available
c67jxnc2vcm45	SELECT NU.UNI_CODE FROM SKILLS.NEWSTUDENT_USER2013 NU WHERE NU.ID=:B2 AND ACLASS=:B1
cr2rxgacjjm4x	SELECT PT.PAGE_PRO_NUM FROM SKILLS.HT_NS_PRO_PART PT WHERE ACLASS=:B2 AND PRO_PART_ID=:B1
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dhkcgqj5hz5g5	SELECT * FROM RESULTEDIT T WHERE T.ACLASS=:B2 AND T.SERIALNO=:B1
dxx3xnh9qtww7	begin apps.PROC_NEWSTUDENT_2014.login(p_numbercode=>:p_numbercode, p_univisitycode=>:p_univisitycode, p_aclass=>:p_aclass, p_ip=>:p_ip, p_browser=>:p_browser, p_agent=>:p_agent, p_page=>:p_page, p_entry=>:p_entry, p_out=>:p_out); end;
fa3n2uyn3m7zt	SELECT COUNT(*) FROM SKILLS.TURLSAVE T WHERE T.ACLASS=:B2 AND SERIALNO=:B1
fdxrh8tzyw0yw	SELECT snap_id , SERVICE_NAME_HASH FROM (SELECT /+ ordered use_nl(t2) index(t2) / t2.snap_id , t1.NAME_HASH SERVICE_NAME_HASH FROM V$SERVICES t1, WRH$_SERVICE_NAME t2 WHERE t2.dbid(+) = :dbid AND t2.SERVICE_NAME_HASH(+) = t1.NAME_HASH) WHERE nvl(snap_id, 0) < :snap_id
g47k1ypcbftbg	insert into wrh$_service_name (snap_id, dbid, service_name_hash, service_name) select :lah_snap_id, :dbid, t2.name_hash, t2.name from x$kewrattrnew t1, v$services t2 where t1.num1_kewrattr = t2.name_hash
g9h2mnyftsf3u	begin apps.PROC_NEWSTUDENT_2014.WriteAnswer(p_aclass=>:p_aclass, p_serialno=>:p_serialno, p_answer=>:p_answer, p_submit=>:p_submit, p_page_id=>:p_page_id, p_state=>:p_state, p_process=>:p_process, p_qnumber=>:p_qnumber, p_out=>:p_out); end;
gdn3ysuyssf82	SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gwkgp280h7tgq	SELECT COUNT(ID) FROM SKILLS.NEWSTUDENT_USER2013 WHERE STUNUMBER=:B3 AND UNI_CODE=:B2 AND ACLASS=:B1

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	727,628	101.02	165.94
CPU used when call started	7,198	1.00	1.64
CR blocks created	645	0.09	0.15
Cached Commit SCN referenced	306	0.04	0.07
Commit SCN cached	2	0.00	0.00
DB time	1,034,638	143.64	235.95
DBWR checkpoint buffers written	5,406	0.75	1.23
DBWR checkpoints	0	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	225	0.03	0.05
DBWR undo block writes	1,121	0.16	0.26
IMU CR rollbacks	170	0.02	0.04
IMU Flushes	1,552	0.22	0.35
IMU Redo allocation size	8,563,356	1,188.84	1,952.87
IMU commits	2,834	0.39	0.65
IMU contention	17	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	48	0.01	0.01
IMU undo allocation size	27,670,464	3,841.46	6,310.25
IMU- failed to get a private strand	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
SMON posted for undo segment shrink	2	0.00	0.00
SQL*Net roundtrips to/from client	22,441	3.12	5.12
active txn count during cleanout	283	0.04	0.06
application wait time	0	0.00	0.00
background checkpoints completed	1	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	23,165	3.22	5.28
branch node splits	0	0.00	0.00
buffer is not pinned count	82,865	11.50	18.90
buffer is pinned count	50,155	6.96	11.44
bytes received via SQL*Net from client	6,488,980	900.86	1,479.81
bytes sent via SQL*Net to client	8,934,328	1,240.34	2,037.48
calls to get snapshot scn: kcmgss	427,000	59.28	97.38
calls to kcmgas	5,896	0.82	1.34
calls to kcmgcs	991	0.14	0.23
change write time	56	0.01	0.01
cleanout - number of ktugct calls	348	0.05	0.08
cleanouts and rollbacks - consistent read gets	35	0.00	0.01
cleanouts only - consistent read gets	67	0.01	0.02
cluster key scan block gets	7,594	1.05	1.73
cluster key scans	169	0.02	0.04
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	48	0.01	0.01
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	12,272	1.70	2.80
commit cleanouts successfully completed	12,224	1.70	2.79
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	158	0.02	0.04
concurrency wait time	412	0.06	0.09
consistent changes	9,037	1.25	2.06
consistent gets	468,904,427	65,097.42	106,933.73
consistent gets - examination	174,634	24.24	39.83
consistent gets direct	0	0.00	0.00
consistent gets from cache	468,904,426	65,097.42	106,933.73
cursor authentications	70	0.01	0.02
data blocks consistent reads - undo records applied	9,007	1.25	2.05
db block changes	143,901	19.98	32.82
db block gets	121,361	16.85	27.68
db block gets direct	22	0.00	0.01
db block gets from cache	121,339	16.85	27.67
deferred (CURRENT) block cleanout applications	7,756	1.08	1.77
enqueue conversions	3,836	0.53	0.87
enqueue releases	74,766	10.38	17.05
enqueue requests	74,764	10.38	17.05
enqueue timeouts	2	0.00	0.00
enqueue waits	0	0.00	0.00
execute count	189,225	26.27	43.15
free buffer inspected	0	0.00	0.00
free buffer requested	1,724	0.24	0.39
heap block compress	77	0.01	0.02
immediate (CR) block cleanout applications	102	0.01	0.02
immediate (CURRENT) block cleanout applications	577	0.08	0.13
index fast full scans (full)	6	0.00	0.00
index fetch by key	57,006	7.91	13.00
index scans kdiixs1	18,447	2.56	4.21
leaf node 90-10 splits	22	0.00	0.01
leaf node splits	109	0.02	0.02
lob reads	20	0.00	0.00
lob writes	151	0.02	0.03
lob writes unaligned	151	0.02	0.03
logons cumulative	456	0.06	0.10
messages received	8,232	1.14	1.88
messages sent	8,232	1.14	1.88
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	468,432,702	65,031.94	106,826.16
opened cursors cumulative	27,694	3.84	6.32
parse count (failures)	0	0.00	0.00
parse count (hard)	138	0.02	0.03
parse count (total)	27,712	3.85	6.32
parse time cpu	233	0.03	0.05
parse time elapsed	259	0.04	0.06
physical read IO requests	14	0.00	0.00
physical read bytes	278,528	38.67	63.52
physical read total IO requests	4,408	0.61	1.01
physical read total bytes	72,182,272	10,020.98	16,461.18
physical read total multi block requests	5	0.00	0.00
physical reads	34	0.00	0.01
physical reads cache	26	0.00	0.01
physical reads cache prefetch	20	0.00	0.00
physical reads direct	8	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	20	0.00	0.00
physical write IO requests	3,695	0.51	0.84
physical write bytes	44,531,712	6,182.28	10,155.46
physical write total IO requests	16,007	2.22	3.65
physical write total bytes	191,331,328	26,562.29	43,633.14
physical write total multi block requests	5,086	0.71	1.16
physical writes	5,436	0.75	1.24
physical writes direct	30	0.00	0.01
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	5,406	0.75	1.23
physical writes non checkpoint	983	0.14	0.22
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks flushed out before use	6	0.00	0.00
process last non-idle time	7,249	1.01	1.65
recursive calls	392,890	54.54	89.60
recursive cpu usage	723,994	100.51	165.11
redo blocks written	46,817	6.50	10.68
redo buffer allocation retries	0	0.00	0.00
redo entries	33,455	4.64	7.63
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	266	0.04	0.06
redo size	22,080,228	3,065.37	5,035.40
redo synch time	1,135	0.16	0.26
redo synch writes	3,548	0.49	0.81
redo wastage	1,212,476	168.33	276.51
redo write time	3,168	0.44	0.72
redo writer latching time	0	0.00	0.00
redo writes	4,841	0.67	1.10
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	602	0.08	0.14
rows fetched via callback	32,052	4.45	7.31
session connect time	3,832	0.53	0.87
session cursor cache hits	15,138	2.10	3.45
session logical reads	469,025,800	65,114.27	106,961.41
session pga memory	156,502,320	21,727.02	35,690.38
session pga memory max	167,577,904	23,264.63	38,216.17
session uga memory	###############	69,168,572.44	113,621,297.42
session uga memory max	232,136,712	32,227.25	52,938.82
shared hash latch upgrades - no wait	18,942	2.63	4.32
sorts (memory)	12,156	1.69	2.77
sorts (rows)	135,430	18.80	30.88
sql area purged	0	0.00	0.00
switch current to new buffer	79	0.01	0.02
table fetch by rowid	57,768	8.02	13.17
table fetch continued row	0	0.00	0.00
table scan blocks gotten	466,695,505	64,790.76	106,429.99
table scan rows gotten	###############	21,318,797.39	35,019,797.78
table scans (long tables)	0	0.00	0.00
table scans (short tables)	76,403	10.61	17.42
total number of times SMON posted	4	0.00	0.00
transaction rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	6,488,452	900.78	1,479.69
user I/O wait time	0	0.00	0.00
user calls	37,903	5.26	8.64
user commits	4,385	0.61	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	9,412	1.31	2.15
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	2,298,033	2,302,214
opened cursors current	849	750
workarea memory allocated	0	1,811
logons current	54	52

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Blks/Rd	Writes
SKILLS_DATA	1	1.00	2,150
SYSAUX	7	3.86	757
UNDOTBS1	2	1.00	474
SYSTEM	1	1.00	190
APPS_DATA	1	1.00	122
PUBCODE_DATA	1	1.00	1
USERS	1	1.00	1

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Blks/Rd	Writes
APPS_DATA	/u01/oracle/oradata/student/apps_data.dbf	1	1.00	122
PUBCODE_DATA	/u01/oracle/oradata/student/pubcode_data.dbf	1	1.00	1
SKILLS_DATA	/u01/oracle/oradata/student/skills_data.dbf	1	1.00	2,150
SYSAUX	/u01/oracle/oradata/student/sysaux01.dbf	7	3.86	757
SYSTEM	/u01/oracle/oradata/student/system01.dbf	1	1.00	190
UNDOTBS1	/u01/oracle/oradata/student/undotbs01.dbf	1	1.00	408
UNDOTBS1	/u01/oracle/oradata/student/undotbs02.dbf	1	1.00	66
USERS	/u01/oracle/oradata/student/users01.dbf	1	1.00	1

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	995,968	100	469,016,443	26	5,406	0	0	0

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	11	355	3176	13931	184320	13931
E	0	11	338	1834	8589	184320	8589

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	800	0.10	99,200	188.37	65,393,302
D	1,600	0.20	198,400	2.30	798,775
D	2,400	0.30	297,600	1.02	355,050
D	3,200	0.40	396,800	1.00	347,711
D	4,000	0.50	496,000	1.00	347,150
D	4,800	0.60	595,200	1.00	347,150
D	5,600	0.70	694,400	1.00	347,150
D	6,400	0.80	793,600	1.00	347,150
D	7,200	0.90	892,800	1.00	347,150
D	8,000	1.00	992,000	1.00	347,150
D	8,032	1.00	995,968	1.00	347,150
D	8,800	1.10	1,091,200	1.00	347,150
D	9,600	1.20	1,190,400	1.00	347,150
D	10,400	1.29	1,289,600	1.00	347,150
D	11,200	1.39	1,388,800	1.00	347,150
D	12,000	1.49	1,488,000	1.00	347,150
D	12,800	1.59	1,587,200	1.00	347,150
D	13,600	1.69	1,686,400	1.00	347,150
D	14,400	1.79	1,785,600	1.00	347,150
D	15,200	1.89	1,884,800	1.00	347,150
D	16,000	1.99	1,984,000	1.00	347,150

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	64	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,576	452.50	0.00	0.00	0.00	0.00	327,780
E	3,201	2,579	433.55	1.77	0.41	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	9,351	9,351
64K	128K	10	10
512K	1024K	39	39
1M	2M	12	12

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	76,133.90	152.50	100.00	26
800	0.25	76,133.90	141.57	100.00	0
1,601	0.50	76,133.90	141.57	100.00	0
2,401	0.75	76,133.90	141.57	100.00	0
3,201	1.00	76,133.90	141.57	100.00	0
3,841	1.20	76,133.90	0.00	100.00	0
4,481	1.40	76,133.90	0.00	100.00	0
5,122	1.60	76,133.90	0.00	100.00	0
5,762	1.80	76,133.90	0.00	100.00	0
6,402	2.00	76,133.90	0.00	100.00	0
9,603	3.00	76,133.90	0.00	100.00	0
12,804	4.00	76,133.90	0.00	100.00	0
19,206	6.00	76,133.90	0.00	100.00	0
25,608	8.00	76,133.90	0.00	100.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
576	0.38	179	20,154	279,580	1.00	2,954	1.75	71,550,430
736	0.48	326	30,459	280,652	1.00	1,882	1.11	72,021,130
896	0.58	485	40,787	280,781	1.00	1,753	1.04	72,079,107
1,056	0.69	644	50,194	280,811	1.00	1,723	1.02	72,094,540
1,216	0.79	803	59,769	280,827	1.00	1,707	1.01	72,103,215
1,376	0.90	962	69,624	280,834	1.00	1,700	1.00	72,106,661
1,536	1.00	1,121	78,001	280,842	1.00	1,692	1.00	72,109,847
1,696	1.10	1,280	88,197	280,846	1.00	1,688	1.00	72,111,364
1,856	1.21	1,439	107,511	280,847	1.00	1,687	1.00	72,112,066
2,016	1.31	1,598	117,800	280,851	1.00	1,683	0.99	72,112,810
2,176	1.42	1,757	126,529	280,852	1.00	1,682	0.99	72,113,467
2,336	1.52	1,916	135,263	280,852	1.00	1,682	0.99	72,113,878
2,496	1.63	2,075	146,023	280,853	1.00	1,681	0.99	72,114,190
2,656	1.73	2,234	156,302	280,853	1.00	1,681	0.99	72,114,454
2,816	1.83	2,393	164,651	280,853	1.00	1,681	0.99	72,114,626
2,976	1.94	2,552	174,897	280,853	1.00	1,681	0.99	72,114,807
3,136	2.04	2,711	183,859	280,853	1.00	1,681	0.99	72,114,953

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	55,328	798,792
4,808	0.50	54,845	355,065
7,212	0.75	54,840	347,150
9,616	1.00	54,840	347,150
12,020	1.25	54,840	347,150
14,424	1.50	54,840	347,150
16,828	1.75	54,840	347,150
19,232	2.00	54,840	347,150

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

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	1.03	5,399	76	4	15/15	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
15-Apr 20:04	109	414	76	3	15	0/0	0/0/0/0/0/0
15-Apr 19:54	30	335	0	2	15	0/0	0/0/0/0/0/0
15-Apr 19:44	62	362	75	4	15	0/0	0/0/0/0/0/0
15-Apr 19:34	53	387	75	3	15	0/0	0/0/0/0/0/0
15-Apr 19:24	78	373	0	3	15	0/0	0/0/0/0/0/0
15-Apr 19:14	69	485	73	3	15	0/0	0/0/0/0/0/0
15-Apr 19:04	112	432	74	4	15	0/0	0/0/0/0/0/0
15-Apr 18:54	53	352	74	3	15	0/0	0/0/0/0/0/0
15-Apr 18:44	49	344	74	2	15	0/0	0/0/0/0/0/0
15-Apr 18:34	68	381	75	3	15	0/0	0/0/0/0/0/0
15-Apr 18:24	75	406	75	3	15	0/0	0/0/0/0/0/0
15-Apr 18:14	114	578	73	3	15	0/0	0/0/0/0/0/0
15-Apr 18:04	157	550	72	4	15	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
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	NoWait Requests	Pct NoWait Miss
AWR Alerted Metric Element list	29,331	0.00		0
Consistent RBA	4,841	0.00		0
FAL request queue	146	0.00		0
FAL subheap alocation	146	0.00		0
FIB s.o chain latch	50	0.00		0
FOB s.o list latch	228	0.00		0
In memory undo latch	62,195	0.01	0.00	6,218	0.00
JS mem alloc latch	9	0.00		0
JS queue access latch	9	0.00		0
JS queue state obj latch	52,106	0.00		0
JS slv state obj latch	340	0.00		0
KGX	0			90,974	0.00
KMG MMAN ready and startup request latch	2,400	0.00		0
KTF sga latch	14	0.00		1,811	0.00
KWQMN job cache list latch	10	0.00		0
LGWR NS Write	144	0.00		0
MQL Tracking Latch	0			144	0.00
Memory Management Latch	0			2,400	0.00
OS process	1,680	0.00		0
OS process allocation	3,519	0.00		0
OS process: request allocation	682	0.00		0
PL/SQL warning settings	8,433	0.00		0
SGA IO buffer pool latch	3	0.00		3	0.00
SQL memory manager latch	2	0.00		2,384	0.00
SQL memory manager workarea list latch	163,727	0.00		0
Shared B-Tree	256	0.00		0
active checkpoint queue latch	6,084	0.00		0
active service list	16,796	0.00		2,763	0.00
alert log latch	48	0.00		0
archive control	361	0.00		0
archive process latch	2,528	0.00		0
begin backup scn array	5	0.00		0
cache buffer handles	692	0.00		0
cache buffers chains	938,296,449	0.00	0.00	1,825	0.00
cache buffers lru chain	16,411	0.00		2,392	0.00
cas latch	4,680	0.00		0
channel handle pool latch	684	0.00		0
channel operations parent latch	34,856	0.00		0
checkpoint queue latch	241,928	0.00		5,007	0.00
client/application info	4,078	0.00		0
commit callback allocation	4	0.00		0
compile environment latch	3,262	0.00		0
dml lock allocation	18,698	0.00		0
dummy allocation	914	0.00		0
enqueue hash chains	153,360	0.00		26	0.00
enqueues	123,908	0.00		0
event group latch	340	0.00		0
file cache latch	231	0.00		0
global KZLD latch for mem in SGA	230	0.00		0
hash table column usage latch	93	0.00		2,436	0.00
hash table modification latch	130	0.00		0
job workq parent latch	0			232	0.00
job_queue_processes parameter latch	236	0.00		0
kks stats	258	0.00		0
kmcptab latch	1	0.00		0
kmcpvec latch	0			1	0.00
ksuosstats global area	484	0.00		0
ktm global data	30	0.00		0
kwqbsn:qsga	256	0.00		0
lgwr LWN SCN	5,048	0.00		0
library cache	571,610	0.00	0.00	288	0.00
library cache load lock	82	0.00		0
library cache lock	97,991	0.00		0
library cache lock allocation	5,341	0.00		0
library cache pin	479,959	0.00	0.00	0
library cache pin allocation	2,130	0.00		0
list of block allocation	583	0.00		0
loader state object freelist	16	0.00		0
message pool operations parent latch	6	0.00		0
messages	67,755	0.00	0.00	0
mostly latch-free SCN	10,967	0.00		0
multiblock read objects	8	0.00		0
ncodef allocation latch	131	0.00		0
object queue header heap	0			6	0.00
object queue header operation	42,185	0.00	0.00	0
object stats modification	5	0.00		0
parallel query alloc buffer	952	0.00		0
parameter list	2,448	0.00		0
parameter table allocation management	463	0.00		0
post/wait queue	2,866	0.00		1,670	0.00
process allocation	682	0.00		340	0.00
process group creation	682	0.00		0
qmn task queue latch	1,024	0.00		0
redo allocation	27,373	0.00	0.00	33,408	0.00
redo copy	0			33,408	0.06
redo on-disk SCN	19,251	0.00		0
redo writing	25,621	0.00		0
resmgr group change latch	826	0.00		0
resmgr:actses active list	908	0.00		0
resmgr:actses change group	347	0.00		0
resmgr:free threads list	906	0.00		0
resmgr:schema config	2	0.00		0
rm cas latch	2,998	0.00		0
row cache objects	61,120	0.00		0
sequence cache	1,056	0.00		0
session allocation	22,542	0.00		0
session idle bit	78,618	0.00		0
session state list latch	483	0.00		0
session switching	131	0.00		0
session timer	2,763	0.00		0
shared pool	24,226	0.00		0
simulator hash latch	29,291,728	0.00	0.00	0
simulator lru latch	29,291,569	0.00	0.02	88	0.00
slave class	4	0.00		0
slave class create	16	12.50	1.00	0
sort extent pool	223	0.00		0
state object free list	4	0.00		0
statistics aggregation	224	0.00		0
temporary table state object allocation	1	0.00		0
threshold alerts latch	669	0.00		0
transaction allocation	586	0.00		0
transaction branch allocation	131	0.00		0
undo global data	35,590	0.00		0
user lock	1,156	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets	Sleep1	Sleep2	Sleep3
simulator lru latch	29,291,569	992	15	977	0	0	0
slave class create	16	2	2	0	0	0	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	NoWait Misses	Sleeps	Waiter Sleeps
simulator lru latch	kcbs_simulate: simulate set	0	15	15
slave class create	ksvcreate	0	2	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 469,025,800
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SKILLS	SKILLS_DATA	RESULTCHEKEDIT	TABLE	343,246,112	73.18
SKILLS	SKILLS_DATA	RESULTMULTIEXPAND	TABLE	112,950,304	24.08
SKILLS	SKILLS_DATA	RESULTONLY	TABLE	6,605,712	1.41
SKILLS	SKILLS_DATA	NEWSTUDENT_USER2013	TABLE	3,127,312	0.67
SKILLS	SKILLS_DATA	PK_RESULTEDIT	INDEX	1,732,800	0.37

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 34
Captured Segments account for 76.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	8137_19796	TABLE PARTITION	26	76.47

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

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	130	0.00	4	1
dc_global_oids	106	0.00	0	160
dc_histogram_data	8,763	0.05	0	27,516
dc_histogram_defs	3,510	0.46	0	5,904
dc_object_ids	1,633	0.00	0	2,028
dc_objects	760	0.13	14	1,986
dc_profiles	351	0.00	0	1
dc_rollback_segments	1,347	0.00	0	22
dc_segments	560	0.00	22	1,643
dc_sequences	21	0.00	21	11
dc_tablespace_quotas	9	0.00	9	2
dc_tablespaces	2,815	0.00	0	12
dc_usernames	501	0.00	0	30
dc_users	6,892	0.00	0	80
outstanding_alerts	264	0.00	0	18

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	1,102	0.00	9,498	0.00	0
CLUSTER	1	0.00	2	0.00	0
INDEX	11	0.00	56	0.00	0
PIPE	4	0.00	4	0.00	0
SQL AREA	93	100.00	215,852	0.11	36
TABLE/PROCEDURE	144	3.47	12,250	0.33	14
TRIGGER	22	0.00	352	0.00	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	431.36		7.70	33.20	244	244	56	56
	Freeable	14.94	0.00	0.68	0.42	2		22	22
	PL/SQL	4.36	1.02	0.08	0.08	0	1	54	54
	SQL	1.95	0.83	0.04	0.04	0	2	46	43
E	Other	416.15		7.71	33.69	244	244	54	54
	Freeable	10.06	0.00	0.56	0.37	1		18	18
	PL/SQL	4.07	0.99	0.08	0.08	0	1	52	52
	SQL	3.31	2.33	0.08	0.25	2	2	44	41

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	8,422,162,432
Fixed Size	2,037,344
Redo Buffers	14,737,408
Variable Size	1,644,169,632

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	ASH buffers	15.50	15.50	0.00
shared	CCursor	111.13	111.00	-0.11
shared	CURSOR STATS	15.23	15.23	0.00
shared	PCursor	82.27	82.16	-0.14
shared	db_block_hash_buckets	33.63	33.63	0.00
shared	free memory	243.13	239.72	-1.40
shared	kglsim heap	13.69	13.69	0.00
shared	kglsim object batch	21.19	21.19	0.00
shared	library cache	72.44	72.57	0.18
shared	sql area	568.57	572.04	0.61
	buffer_cache	8,032.00	8,032.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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

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/student/adump
background_dump_dest	/u01/oracle/admin/student/bdump
compatible	10.2.0.1.0
control_files	/u01/oracle/oradata/student/control01.ctl, /u01/oracle/oradata/student/control02.ctl, /u01/oracle/oradata/student/control03.ctl
core_dump_dest	/u01/oracle/admin/student/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	8
db_name	student
db_recovery_file_dest
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=studentXDB)
fal_client	student
fal_server	student_st
job_queue_processes	10
log_archive_config	DG_CONFIG=(student, student_st)
log_archive_dest_1	LOCATION=/rman/archivelog/ VALID_FOR=(ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=student
log_archive_dest_2	SERVICE=student_st LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=student_st
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/student/udump

End of Report

% Blocks changed per Read:	0.03	Recursive Call %:	91.20
Rollback per transaction %:	0.00	Rows per Sort:	11.14

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.88	Soft Parse %:	99.50
Execute to Parse %:	85.36	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	89.96	% Non-Parse CPU:	99.97