WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

PSSDEV3 1059063759 PSSDEV3 1 10.2.0.4.0 NO usbdpssdev910

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
PSSDEV3	1059063759	PSSDEV3	1	10.2.0.4.0	NO	usbdpssdev910

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 10941 27-May-11 20:00:38 25 1.8

End Snap: 10944 27-May-11 23:00:44 40 1.9

Elapsed: 180.09 (mins)

DB Time: 188.15 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	10941	27-May-11 20:00:38	25	1.8
End Snap:	10944	27-May-11 23:00:44	40	1.9
Elapsed:		180.09 (mins)
DB Time:		188.15 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 2,848M 2,608M Std Block Size: 16K

Shared Pool Size: 1,104M 1,344M Log Buffer: 33,792K

	Begin	End
Buffer Cache:	2,848M	2,608M	Std Block Size:	16K
Shared Pool Size:	1,104M	1,344M	Log Buffer:	33,792K

Load Profile

Per Second Per Transaction

Redo size: 292,335.14 3,842,854.29

Logical reads: 8,352.63 109,798.39

Block changes: 2,376.62 31,241.58

Physical reads: 13.98 183.84

Physical writes: 11.04 145.14

User calls: 1.46 19.14

Parses: 588.97 7,742.23

Hard parses: 4.47 58.71

Sorts: 26.08 342.86

Logons: 0.21 2.82

Executes: 932.80 12,262.00

Transactions: 0.08

	Per Second	Per Transaction
Redo size:	292,335.14	3,842,854.29
Logical reads:	8,352.63	109,798.39
Block changes:	2,376.62	31,241.58
Physical reads:	13.98	183.84
Physical writes:	11.04	145.14
User calls:	1.46	19.14
Parses:	588.97	7,742.23
Hard parses:	4.47	58.71
Sorts:	26.08	342.86
Logons:	0.21	2.82
Executes:	932.80	12,262.00
Transactions:	0.08

% Blocks changed per Read: 28.45 Recursive Call %: 99.97

Rollback per transaction %: 1.34 Rows per Sort: 61.57

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.76 Soft Parse %: 99.24

Execute to Parse %: 36.86 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 92.13 % Non-Parse CPU: 94.78

Shared Pool Statistics

Begin End

Memory Usage %: 53.67 75.37

% SQL with executions>1: 80.79 72.05

% Memory for SQL w/exec>1: 89.23 64.15

	Begin	End
Memory Usage %:	53.67	75.37
% SQL with executions>1:	80.79	72.05
% Memory for SQL w/exec>1:	89.23	64.15

Top 5 Timed Events

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

CPU time 10,285 91.1

db file sequential read 143,496 704 5 6.2 User I/O

db file parallel write 26,722 254 9 2.2 System I/O

log file parallel write 6,830 103 15 .9 System I/O

control file parallel write 5,592 27 5 .2 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		10,285		91.1
db file sequential read	143,496	704	5	6.2	User I/O
db file parallel write	26,722	254	9	2.2	System I/O
log file parallel write	6,830	103	15	.9	System I/O
control file parallel write	5,592	27	5	.2	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): 11289s
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	11,272.59	99.85
DB CPU	10,285.33	91.11
PL/SQL execution elapsed time	3,646.34	32.30
sequence load elapsed time	1,719.23	15.23
parse time elapsed	753.34	6.67
hard parse elapsed time	162.75	1.44
hard parse (sharing criteria) elapsed time	68.82	0.61
Java execution elapsed time	26.79	0.24
PL/SQL compilation elapsed time	22.68	0.20
hard parse (bind mismatch) elapsed time	7.65	0.07
repeated bind elapsed time	7.53	0.07
connection management call elapsed time	4.01	0.04
failed parse elapsed time	0.11	0.00
DB time	11,289.05
background elapsed time	576.22
background cpu time	268.64

Back to Wait Events Statistics
Back to Top

Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
User I/O	150,175	0.00	733	5	182.69
System I/O	51,948	0.00	388	7	63.20
Configuration	90	0.00	6	64	0.11
Application	28	0.00	3	90	0.03
Concurrency	116	0.00	2	19	0.14
Commit	59	0.00	1	17	0.07
Other	679	0.15	0	1	0.83
Network	7,712	0.00	0	0	9.38

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
db file sequential read	143,496	0.00	704	5	174.57
db file parallel write	26,722	0.00	254	9	32.51
log file parallel write	6,830	0.00	103	15	8.31
control file parallel write	5,592	0.00	27	5	6.80
db file scattered read	630	0.00	18	29	0.77
direct path read	3,726	0.00	9	2	4.53
log file switch completion	90	0.00	6	64	0.11
SQL*Net break/reset to client	28	0.00	3	90	0.03
log file single write	252	0.00	2	7	0.31
direct path write	2,274	0.00	1	1	2.77
control file sequential read	12,300	0.00	1	0	14.96
os thread startup	12	0.00	1	91	0.01
log file sync	59	0.00	1	17	0.07
latch: shared pool	62	0.00	1	14	0.08
log file sequential read	252	0.00	1	3	0.31
library cache load lock	6	0.00	0	30	0.01
latch free	16	0.00	0	11	0.02
direct path write temp	45	0.00	0	3	0.05
library cache lock	1	0.00	0	119	0.00
LGWR wait for redo copy	654	0.15	0	0	0.80
rdbms ipc reply	6	0.00	0	13	0.01
read by other session	1	0.00	0	67	0.00
SQL*Net more data from client	505	0.00	0	0	0.61
buffer exterminate	3	0.00	0	17	0.00
db file parallel read	3	0.00	0	12	0.00
SQL*Net more data to client	488	0.00	0	0	0.59
SQL*Net message to client	6,719	0.00	0	0	8.17
buffer busy waits	33	0.00	0	0	0.04
latch: In memory undo latch	1	0.00	0	0	0.00
latch: cache buffers chains	1	0.00	0	0	0.00
SQL*Net message from client	6,704	0.00	12,248	1827	8.16
jobq slave wait	4,433	51.32	10,893	2457	5.39
virtual circuit status	360	100.00	10,506	29183	0.44
Streams AQ: qmn slave idle wait	385	0.00	10,505	27286	0.47
Streams AQ: qmn coordinator idle wait	781	50.70	10,505	13451	0.95
Streams AQ: waiting for time management or cleanup tasks	3	100.00	1,424	474668	0.00
PL/SQL lock timer	1	100.00	1	977	0.00
SGA: MMAN sleep for component shrink	118	15.25	0	3	0.14
class slave wait	6	0.00	0	0	0.01

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
db file parallel write	26,722	0.00	254	9	32.51
log file parallel write	6,830	0.00	103	15	8.31
control file parallel write	5,592	0.00	27	5	6.80
log file single write	252	0.00	2	7	0.31
db file sequential read	128	0.00	1	10	0.16
direct path read	1,932	0.00	1	1	2.35
os thread startup	12	0.00	1	91	0.01
log file sequential read	252	0.00	1	3	0.31
control file sequential read	7,144	0.00	1	0	8.69
direct path write	1,934	0.00	0	0	2.35
events in waitclass Other	661	0.15	0	0	0.80
latch: shared pool	1	0.00	0	3	0.00
buffer busy waits	1	0.00	0	0	0.00
rdbms ipc message	67,683	88.09	166,075	2454	82.34
Streams AQ: qmn slave idle wait	385	0.00	10,505	27286	0.47
Streams AQ: qmn coordinator idle wait	781	50.70	10,505	13451	0.95
pmon timer	3,588	99.94	10,502	2927	4.36
smon timer	64	50.00	10,024	156623	0.08
Streams AQ: waiting for time management or cleanup tasks	3	100.00	1,424	474668	0.00
SGA: MMAN sleep for component shrink	118	15.25	0	3	0.14

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	41,834
AVG_IDLE_TIME	1,037,887
AVG_IOWAIT_TIME	0
AVG_SYS_TIME	8,360
AVG_USER_TIME	33,122
BUSY_TIME	2,700,642
IDLE_TIME	66,446,275
IOWAIT_TIME	0
SYS_TIME	557,721
USER_TIME	2,142,921
LOAD	2
OS_CPU_WAIT_TIME	507,000
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	0
VM_OUT_BYTES	0
PHYSICAL_MEMORY_BYTES	33,504,100,352
NUM_CPUS	64

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
SYS$USERS	11,282.30	10,279.80	148,491	90,071,358
PSSDEV3	6.80	5.60	469	24,865
PSSDEV3XDB	0.00	0.00	0	0
SYS$BACKGROUND	0.00	0.00	2,134	158,049

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
SYS$USERS	145478	72092	101	115	7198	6
PSSDEV3	469	193	0	0	270	1
SYS$BACKGROUND	4227	965	15	110	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
9,490	9,416	1	9490.29	84.07	0nm1vy3bgnp8n	SQL*Plus	DECLARE l_no varchar2(1); ...
887	885	1,749,508	0.00	7.86	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
668	667	525,927	0.00	5.91	b9u1pv732y83d	SQL*Plus	INSERT INTO AER_TEXT ( AER_ID,...
438	437	275,375	0.00	3.88	3crbmgwrq53dm	SQL*Plus	INSERT INTO AER_INFM_AUTH (INI...
401	40	1	401.39	3.56	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
392	325	1	392.05	3.47	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
383	23	45	8.52	3.40	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
258	257	186,394	0.00	2.29	7xrzbypjrp7h1	SQL*Plus	INSERT INTO DISTRIBUTION_OF_AE...
236	236	202,078	0.00	2.09	7s7h9cz7ppw0v	SQL*Plus	SELECT AES.* FROM AE_SUBMISSIO...
226	226	294,261	0.00	2.00	084wz3ubrq1y4	SQL*Plus	SELECT DISTINCT A.DRUG_NAME FR...
176	174	202,394	0.00	1.56	68t8um5fcykkx	SQL*Plus	SELECT MAX(EC.RECEIVE_DATE) FR...
161	161	194,863	0.00	1.43	9j8wczywupm9w	SQL*Plus	SELECT MIN(EC.RECEIVE_DATE) FR...
138	137	19,184	0.01	1.22	239x52g15rv2h	SQL*Plus	SELECT MADE_BY, STRENGTH, STRE...
129	66	9	14.32	1.14	29wybt473g34b	sqlplus@usbdpssdev910 (TNS V1-V3)	select '##'\|\|owner \|\|'.'\|\|se...
122	119	91,868	0.00	1.08	2atbf714pkw76	SQL*Plus	SELECT MAX(EH.RECEIVE_DATE) FR...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
9,416	9,490	1	9416.18	84.07	0nm1vy3bgnp8n	SQL*Plus	DECLARE l_no varchar2(1); ...
885	887	1,749,508	0.00	7.86	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
667	668	525,927	0.00	5.91	b9u1pv732y83d	SQL*Plus	INSERT INTO AER_TEXT ( AER_ID,...
437	438	275,375	0.00	3.88	3crbmgwrq53dm	SQL*Plus	INSERT INTO AER_INFM_AUTH (INI...
325	392	1	324.72	3.47	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
257	258	186,394	0.00	2.29	7xrzbypjrp7h1	SQL*Plus	INSERT INTO DISTRIBUTION_OF_AE...
236	236	202,078	0.00	2.09	7s7h9cz7ppw0v	SQL*Plus	SELECT AES.* FROM AE_SUBMISSIO...
226	226	294,261	0.00	2.00	084wz3ubrq1y4	SQL*Plus	SELECT DISTINCT A.DRUG_NAME FR...
174	176	202,394	0.00	1.56	68t8um5fcykkx	SQL*Plus	SELECT MAX(EC.RECEIVE_DATE) FR...
161	161	194,863	0.00	1.43	9j8wczywupm9w	SQL*Plus	SELECT MIN(EC.RECEIVE_DATE) FR...
137	138	19,184	0.01	1.22	239x52g15rv2h	SQL*Plus	SELECT MADE_BY, STRENGTH, STRE...
119	122	91,868	0.00	1.08	2atbf714pkw76	SQL*Plus	SELECT MAX(EH.RECEIVE_DATE) FR...
66	129	9	7.30	1.14	29wybt473g34b	sqlplus@usbdpssdev910 (TNS V1-V3)	select '##'\|\|owner \|\|'.'\|\|se...
40	401	1	39.60	3.56	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
23	383	45	0.51	3.40	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...

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: 90,254,275
Captured SQL account for 64.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
87,301,383	1	87,301,383.00	96.73	9416.18	9490.29	0nm1vy3bgnp8n	SQL*Plus	DECLARE l_no varchar2(1); ...
5,311,745	202,394	26.24	5.89	173.60	176.02	68t8um5fcykkx	SQL*Plus	SELECT MAX(EC.RECEIVE_DATE) FR...
5,272,140	1,749,508	3.01	5.84	885.45	887.13	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
4,899,883	194,863	25.15	5.43	161.03	161.03	9j8wczywupm9w	SQL*Plus	SELECT MIN(EC.RECEIVE_DATE) FR...
4,893,593	202,078	24.22	5.42	235.76	235.77	7s7h9cz7ppw0v	SQL*Plus	SELECT AES.* FROM AE_SUBMISSIO...
4,823,778	525,927	9.17	5.34	666.67	667.60	b9u1pv732y83d	SQL*Plus	INSERT INTO AER_TEXT ( AER_ID,...
4,654,513	91,868	50.67	5.16	118.71	121.63	2atbf714pkw76	SQL*Plus	SELECT MAX(EH.RECEIVE_DATE) FR...
2,875,371	275,375	10.44	3.19	436.86	437.59	3crbmgwrq53dm	SQL*Plus	INSERT INTO AER_INFM_AUTH (INI...
2,207,573	294,261	7.50	2.45	225.72	225.72	084wz3ubrq1y4	SQL*Plus	SELECT DISTINCT A.DRUG_NAME FR...
2,164,134	296,782	7.29	2.40	94.93	94.94	5zyjycwa6cnmf	SQL*Plus	UPDATE HIST_VIEW_TS SET VIEW_T...
2,157,263	720,650	2.99	2.39	94.55	94.70	1y6s2gfjv5ugx	SQL*Plus	SELECT ARISG_CODELIST_CODE, AR...
2,056,433	411,274	5.00	2.28	51.67	51.80	gdzxsv8d1tusq	SQL*Plus	SELECT A.TABLE_NAME, B.DBS_FI...
1,736,773	186,394	9.32	1.92	256.92	257.97	7xrzbypjrp7h1	SQL*Plus	INSERT INTO DISTRIBUTION_OF_AE...
1,388,539	198,361	7.00	1.54	112.05	112.05	dd75gqc4fv983	SQL*Plus	SELECT DISTINCT HA_CODE FROM D...
1,382,574	198,485	6.97	1.53	65.51	65.51	fabyyff4p1unz	SQL*Plus	SELECT D.CASE_TYPE FROM DM_AER...
1,270,036	296,782	4.28	1.41	66.88	66.88	2ty6zmr18m8qn	SQL*Plus	SELECT '1' FROM AE_SUBMISSIONS...
942,636	157,104	6.00	1.04	42.20	42.20	a86hv2qw48sq5	SQL*Plus	SELECT D.AERS_AFF_PART_CMP_UNI...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 151,113
Captured SQL account for 133.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
78,872	1	78,872.00	52.19	39.60	401.39	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
78,820	45	1,751.56	52.16	23.03	383.46	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
38,801	1	38,801.00	25.68	9416.18	9490.29	0nm1vy3bgnp8n	SQL*Plus	DECLARE l_no varchar2(1); ...
20,265	9	2,251.67	13.41	65.74	128.84	29wybt473g34b	sqlplus@usbdpssdev910 (TNS V1-V3)	select '##'\|\|owner \|\|'.'\|\|se...
8,955	1	8,955.00	5.93	324.72	392.05	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
5,680	17,076	0.33	3.76	44.46	64.61	4q96ynznd78yf	SQL*Plus	SELECT A.*, B.SEQ_PRODUCT FROM...
2,290	7,492	0.31	1.52	4.68	11.24	2knn5v6amkk38	SQL*Plus	SELECT COUNT(*) FROM AC_SUSPEC...
2,065	4,783	0.43	1.37	4.30	15.35	8ngks5j77t65f	SQL*Plus	SELECT * FROM AE_CASE_DIALOGS ...
1,123	1	1,123.00	0.74	14.15	16.55	06yqffk58rhwc	DBMS_SCHEDULER	select /*+ no_parallel_index(t...
664	202,394	0.00	0.44	173.60	176.02	68t8um5fcykkx	SQL*Plus	SELECT MAX(EC.RECEIVE_DATE) FR...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 10,079,361
Captured SQL account for 71.7% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
1,749,508	1,749,508	1.00	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
720,650	715,858	0.99	1y6s2gfjv5ugx	SQL*Plus	SELECT ARISG_CODELIST_CODE, AR...
525,927	525,927	1.00	b9u1pv732y83d	SQL*Plus	INSERT INTO AER_TEXT ( AER_ID,...
411,274	411,274	1.00	gdzxsv8d1tusq	SQL*Plus	SELECT A.TABLE_NAME, B.DBS_FI...
296,782	14	0.00	2ty6zmr18m8qn	SQL*Plus	SELECT '1' FROM AE_SUBMISSIONS...
296,782	296,782	1.00	5zyjycwa6cnmf	SQL*Plus	UPDATE HIST_VIEW_TS SET VIEW_T...
294,261	4,423	0.02	084wz3ubrq1y4	SQL*Plus	SELECT DISTINCT A.DRUG_NAME FR...
275,375	275,375	1.00	3crbmgwrq53dm	SQL*Plus	INSERT INTO AER_INFM_AUTH (INI...
202,394	202,394	1.00	68t8um5fcykkx	SQL*Plus	SELECT MAX(EC.RECEIVE_DATE) FR...
202,078	201,986	1.00	7s7h9cz7ppw0v	SQL*Plus	SELECT AES.* FROM AE_SUBMISSIO...
198,485	6,837	0.03	fabyyff4p1unz	SQL*Plus	SELECT D.CASE_TYPE FROM DM_AER...
198,361	198,361	1.00	dd75gqc4fv983	SQL*Plus	SELECT DISTINCT HA_CODE FROM D...
194,863	194,863	1.00	9j8wczywupm9w	SQL*Plus	SELECT MIN(EC.RECEIVE_DATE) FR...
186,394	186,394	1.00	7xrzbypjrp7h1	SQL*Plus	INSERT INTO DISTRIBUTION_OF_AE...
157,104	157,104	1.00	a86hv2qw48sq5	SQL*Plus	SELECT D.AERS_AFF_PART_CMP_UNI...
115,284	115,284	1.00	7t0hg27ypbr88	SQL*Plus	SELECT COUNT(*) FROM AER_SOURC...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 6,364,111
Captured SQL account for 66.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
1,749,507	1,749,508	27.49	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
294,261	294,261	4.62	084wz3ubrq1y4	SQL*Plus	SELECT DISTINCT A.DRUG_NAME FR...
202,394	202,394	3.18	68t8um5fcykkx	SQL*Plus	SELECT MAX(EC.RECEIVE_DATE) FR...
198,485	198,485	3.12	fabyyff4p1unz	SQL*Plus	SELECT D.CASE_TYPE FROM DM_AER...
198,361	198,361	3.12	dd75gqc4fv983	SQL*Plus	SELECT DISTINCT HA_CODE FROM D...
194,863	194,863	3.06	9j8wczywupm9w	SQL*Plus	SELECT MIN(EC.RECEIVE_DATE) FR...
157,104	157,104	2.47	a86hv2qw48sq5	SQL*Plus	SELECT D.AERS_AFF_PART_CMP_UNI...
115,284	115,284	1.81	7t0hg27ypbr88	SQL*Plus	SELECT COUNT(*) FROM AER_SOURC...
91,868	91,868	1.44	2atbf714pkw76	SQL*Plus	SELECT MAX(EH.RECEIVE_DATE) FR...
86,323	86,323	1.36	6hbs1v6qxvy7b	SQL*Plus	SELECT LLT_CODE, PT_CODE FROM ...
85,940	85,940	1.35	44yaamz8wzhx8	SQL*Plus	SELECT PT_SOC_CODE FROM L_PREF...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

06yqffk58rhwc select /*+ no_parallel_index(t, "I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST") */ count(*) as nrw, count(distinct sys_op_lbid(4226, 'L', t.rowid)) as nlb, count(distinct hextoraw(sys_op_descend("OBJ#")||sys_op_descend("INTCOL#")||sys_op_descend(SYS_EXTRACT_UTC("SAVTIME")))) as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRI$_OPTSTAT_HISTGRM_HISTORY" t where "OBJ#" is not null or "INTCOL#" is not null or SYS_EXTRACT_UTC("SAVTIME") is not null

084wz3ubrq1y4 SELECT DISTINCT A.DRUG_NAME FROM AE_SUSPECT_DRUGS A, AE_REPORTABILITY B, AE_SUBMISSIONS C WHERE B.CASE_ID = :B2 AND A.CASE_ID = B.CASE_ID AND A.CASE_ID = C.CASE_ID AND A.SUSP_DRG_SEQ_NBR = B.SUSP_DRG_SEQ_NBR AND B.LIC_NBR = C.LIC_NBR AND B.AGENCY=:B1 AND A.DRUG_NAME IS NOT NULL

0nm1vy3bgnp8n DECLARE l_no varchar2(1); l_error varchar2(1000) := null; BEGIN --To Start remigration from the point where it is stopped. DELETE FROM MIGRATABLE_CASES WHERE CASE_ID IN(SELECT aers_case_id FROM migration_status_log WHERE status = 'Y'); COMMIT; l_no := AERS_ARISG_CASE_MIGRATION.FN_MIGRATE_CASE_DATA; EXCEPTION WHEN OTHERS THEN l_error := SQLERRM; DBMS_OUTPUT.PUT_LINE('Error at step: '||AERS_ARISG_CASE_MIGRATION.g_step_no||' for case - '||AERS_ARISG_CASE_MIGRATION.g_source_case_id); DBMS_OUTPUT.PUT_LINE(l_error); END;

1y6s2gfjv5ugx SELECT ARISG_CODELIST_CODE, ARISG_CODELIST_DECODE FROM AERS_ARISG_CODELIST_MAPPING WHERE AERS_CODELIST_NAME = :B3 AND AERS_CODELIST_CODE = :B2 AND ARISG_CODELIST_ID = DECODE(:B1 , NULL, ARISG_CODELIST_ID, :B1 )

239x52g15rv2h SELECT MADE_BY, STRENGTH, STRENGTH_UNIT FROM CDD_DRUG_PRODUCT WHERE UPPER(TRIM(INT_TRADENAME)) = UPPER(TRIM(:B1 )) ORDER BY PRODUCT_ID

29wybt473g34b select '##'||owner ||'.'||segment_name||' '||segment_type || ' has ' || to_char(count(1))||' extents' from dba_extents ext where owner not in ('SYS', 'SYSTEM') and segment_type not in ('TEMPORARY', 'CACHE') group by owner, segment_name, segment_type having count(1) > 500

2atbf714pkw76 SELECT MAX(EH.RECEIVE_DATE) FROM EH_CONTACT_LOG EH WHERE EH.CASE_ID=:B1 AND EH.AE_INFO_RECEIVED='Y'

2knn5v6amkk38 SELECT COUNT(*) FROM AC_SUSPECT_DRUGS WHERE CASE_ID = :B2 AND SUSP_DRG_SEQ_NBR = :B1 AND UPPER(DRUG_NAME) LIKE '%BLIND%'

2ty6zmr18m8qn SELECT '1' FROM AE_SUBMISSIONS AES WHERE AES.COMMENTS IS NOT NULL AND AES.COMMENTS LIKE '%NULL%' AND AES.CASE_ID=:B3 AND AES.SUBM_NBR=:B2 AND AES.SUBM_SEQ_NBR=:B1

3crbmgwrq53dm INSERT INTO AER_INFM_AUTH (INITIAL_AER_ID, SEQ_INFM_AUTH, STATUS_AUTH_FLAG, RECORD_OWNER_UNIT, LOCAL_VERSION_NO, UF_DIST_DATE_REP_SENT_TO_MFR, UF_DIST_DAT_SENT_TO_MFR_PREC, REP_INFM_AUTH, UF_DIST_DATE_REP_SENT_TO_FDA, UF_DIST_DAT_SENT_TO_FDA_PREC, DECISION_DATE, PRODUCT_NAME, AUTHORITY, REPORT_FORMAT, TYPE_OF_REPORT, PRODUCT_SEQ, REPORT_MEDIUM, E2B_MESSAGE_TYPE, E2B_TRANSMISSION_STATUS, DIST_AER_INFO_ID, CONTACT_TYPE, SEQ_DIST_AER, REPORT_FOLLOW_UP_NO, COMMENTS, REPORT_DATE, NULLIFIED, REASON_FOR_NULLIFICATION, REPORTING_STATUS, DATE_INFORMED, DATE_INFORMED_PRECISION, VERSION_NO_AER, AUTHORITY_RESP_DATE, AUTHORITY_RESP_DATE_PRECISION, IDENTIFICATION_NO, RECORD_ID, USER_ID, DATE_CREATED, DATE_MODIFIED, SUBMISSION_UNIT ) VALUES (:B33 , :B32 , '0', :B31 , '0', :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , '1', :B17 , '4', :B16 , :B15 , :B14 , :B3 , :B13 , :B12 , :B11 , :B10 , :B9 , '0', :B8 , :B7 , :B6 , :B5 ||SEQ_RECORD_ID.NEXTVAL, :B4 , :B3 , :B2 , :B1 )

44yaamz8wzhx8 SELECT PT_SOC_CODE FROM L_PREF_TERM WHERE PT_CODE = :B2 AND MEDDRA_VERSION = 'v.'||:B1

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

4q96ynznd78yf SELECT A.*, B.SEQ_PRODUCT FROM AE_REPORTABILITY A, DM_PRODUCT_GLOBAL_AERS B WHERE A.CASE_ID = B.SOURCE_CASE_ID AND A.SUSP_DRG_SEQ_NBR = B.SOURCE_SEQ_NUM AND A.CASE_ID = :B1

5zyjycwa6cnmf UPDATE HIST_VIEW_TS SET VIEW_TS= (SELECT AES.ASOF_TS FROM AE_SUBMISSIONS AES WHERE AES.ASOF_TS IS NOT NULL AND AES.CASE_ID=:B2 AND AES.SUBM_SEQ_NBR=:B1 ) WHERE AUDSID=USERENV('SESSIONID')

68t8um5fcykkx SELECT MAX(EC.RECEIVE_DATE) FROM EH_CONTACT_LOG EC WHERE EC.CASE_ID=:B1 AND EC.RESET_CLOCK_FLAG='Y'

6hbs1v6qxvy7b SELECT LLT_CODE, PT_CODE FROM L_LOW_LEVEL_TERM WHERE TRIM(LOWER(LLT_NAME)) = TRIM(LOWER(:B2 )) AND MEDDRA_VERSION = 'v.'||:B1

6mcpb06rctk0x call dbms_space.auto_space_advisor_job_proc ( )

7s7h9cz7ppw0v SELECT AES.* FROM AE_SUBMISSIONS AES WHERE CASE_ID = :B2 AND AES.AGENCY=:B1 AND AES.SUBM_SEQ_NBR = (SELECT MAX(AES.SUBM_SEQ_NBR) FROM AE_SUBMISSIONS AES WHERE AES.CASE_ID = :B2 AND AES.AGENCY=:B1 AND AES.REPORT_FORM=:B3 ) AND AES.SUBM_NBR = (SELECT MAX(AES.SUBM_NBR) FROM AE_SUBMISSIONS AES WHERE AES.CASE_ID = :B2 AND AES.AGENCY=:B1 AND AES.REPORT_FORM=:B3 )

7t0hg27ypbr88 SELECT COUNT(*) FROM AER_SOURCE WHERE AER_ID = :B2 AND SOURCE = :B1

7xrzbypjrp7h1 INSERT INTO DISTRIBUTION_OF_AER_INFO ( DIST_AER_INFO_ID, AER_ID, INITIAL_AER_ID, AER_NO, VERSION_NO, LOCAL_VERSION_NO, FORMAT_TYPE, E2B_LANGUAGE, E2B_AUTHORITY, FORMAT_PREFERRED_ROUTE, DISTRIBUTION_STATUS, REASON_NOT_TO_BE_DISTRIBUTED, DATE_SUBMITTED, DATE_DISTRIBUTED, FORMAT_LANGUAGE, CONTACT_NAME, E2B_DTD_VERSION, DICTIONARY, FORMAT_COUNTRY, E2B_MESSAGE_TYPE, CIOMS_IGNORE_NOT_RELEVANT_FLAG, BLINDED_REPORT, RECIPIENT_INFORMATION, CONTACT_TYPE, CONTACT_AUTHORITY, SEQ_DIST_AER, CONTACT_STATUS, ROUTE_THROUGH_AGX, FL_DATA_PRIVACY, RECIPIENT_COMPANY_UNIT, RECORD_OWNER_UNIT, RECORD_OWNER_UNIT_SEQ, RECORD_ID, USER_ID, DATE_CREATED, DATE_MODIFIED ) VALUES ( :B22 , :B21 , :B21 , :B20 , '0', '0', :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B13 , '001', :B12 , :B11 , '5', :B10 , :B9 , '2', '2', '1', '4', :B8 , :B5 , '1', '1', '2', :B7 , :B6 , :B5 , :B4 ||SEQ_RECORD_ID.NEXTVAL, :B3 , :B2 , :B1 )

8ngks5j77t65f SELECT * FROM AE_CASE_DIALOGS WHERE CASE_ID = :B1 ORDER BY DIALG_SEQ_NBR

8szmwam7fysa3 insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))

9j8wczywupm9w SELECT MIN(EC.RECEIVE_DATE) FROM EH_CONTACT_LOG EC WHERE EC.CASE_ID=:B1

a86hv2qw48sq5 SELECT D.AERS_AFF_PART_CMP_UNIT FROM DM_AERS_AGENCY_COMP_UNIT_MAP D WHERE D.AERS_COUNTRY_CODE = :B2 AND (D.BAX_ENV1=:B1 OR D.BAX_ENV1 IS NULL)

b6usrg82hwsa3 call dbms_stats.gather_database_stats_job_proc ( )

b9u1pv732y83d INSERT INTO AER_TEXT ( AER_ID, SEQ_TEXT, FIELD_ID, SEQ_TAB, TEXT, LANGUAGE, RECORD_ID, USER_ID, DATE_CREATED, DATE_MODIFIED ) VALUES ( :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 ||SEQ_RECORD_ID.NEXTVAL, :B3 , :B2 , :B1 )

dd75gqc4fv983 SELECT DISTINCT HA_CODE FROM DM_AERS_AGENCY_COMP_UNIT_MAP D WHERE D.AERS_COUNTRY_CODE=:B1

fabyyff4p1unz SELECT D.CASE_TYPE FROM DM_AERS_AGENCY_COMP_UNIT_MAP D WHERE D.BAX_ENV1=:B2 AND D.AERS_COUNTRY_CODE = :B1 AND D.CASE_TYPE IS NOT NULL

gdzxsv8d1tusq SELECT A.TABLE_NAME, B.DBS_FIELD_NAME, B.MAX_LENGTH FROM ARIS_TABLE A, ARIS_TABLE_FIELD B WHERE A.TABLE_ID = B.TABLE_ID AND B.FIELD_ID = :B1

SQL Id	SQL Text
06yqffk58rhwc	select /+ no_parallel_index(t, "I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST") / count(*) as nrw, count(distinct sys_op_lbid(4226, 'L', t.rowid)) as nlb, count(distinct hextoraw(sys_op_descend("OBJ#")\|\|sys_op_descend("INTCOL#")\|\|sys_op_descend(SYS_EXTRACT_UTC("SAVTIME")))) as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRI$_OPTSTAT_HISTGRM_HISTORY" t where "OBJ#" is not null or "INTCOL#" is not null or SYS_EXTRACT_UTC("SAVTIME") is not null
084wz3ubrq1y4	SELECT DISTINCT A.DRUG_NAME FROM AE_SUSPECT_DRUGS A, AE_REPORTABILITY B, AE_SUBMISSIONS C WHERE B.CASE_ID = :B2 AND A.CASE_ID = B.CASE_ID AND A.CASE_ID = C.CASE_ID AND A.SUSP_DRG_SEQ_NBR = B.SUSP_DRG_SEQ_NBR AND B.LIC_NBR = C.LIC_NBR AND B.AGENCY=:B1 AND A.DRUG_NAME IS NOT NULL
0nm1vy3bgnp8n	DECLARE l_no varchar2(1); l_error varchar2(1000) := null; BEGIN --To Start remigration from the point where it is stopped. DELETE FROM MIGRATABLE_CASES WHERE CASE_ID IN(SELECT aers_case_id FROM migration_status_log WHERE status = 'Y'); COMMIT; l_no := AERS_ARISG_CASE_MIGRATION.FN_MIGRATE_CASE_DATA; EXCEPTION WHEN OTHERS THEN l_error := SQLERRM; DBMS_OUTPUT.PUT_LINE('Error at step: '\|\|AERS_ARISG_CASE_MIGRATION.g_step_no\|\|' for case - '\|\|AERS_ARISG_CASE_MIGRATION.g_source_case_id); DBMS_OUTPUT.PUT_LINE(l_error); END;
1y6s2gfjv5ugx	SELECT ARISG_CODELIST_CODE, ARISG_CODELIST_DECODE FROM AERS_ARISG_CODELIST_MAPPING WHERE AERS_CODELIST_NAME = :B3 AND AERS_CODELIST_CODE = :B2 AND ARISG_CODELIST_ID = DECODE(:B1 , NULL, ARISG_CODELIST_ID, :B1 )
239x52g15rv2h	SELECT MADE_BY, STRENGTH, STRENGTH_UNIT FROM CDD_DRUG_PRODUCT WHERE UPPER(TRIM(INT_TRADENAME)) = UPPER(TRIM(:B1 )) ORDER BY PRODUCT_ID
29wybt473g34b	select '##'\|\|owner \|\|'.'\|\|segment_name\|\|' '\|\|segment_type \|\| ' has ' \|\| to_char(count(1))\|\|' extents' from dba_extents ext where owner not in ('SYS', 'SYSTEM') and segment_type not in ('TEMPORARY', 'CACHE') group by owner, segment_name, segment_type having count(1) > 500
2atbf714pkw76	SELECT MAX(EH.RECEIVE_DATE) FROM EH_CONTACT_LOG EH WHERE EH.CASE_ID=:B1 AND EH.AE_INFO_RECEIVED='Y'
2knn5v6amkk38	SELECT COUNT(*) FROM AC_SUSPECT_DRUGS WHERE CASE_ID = :B2 AND SUSP_DRG_SEQ_NBR = :B1 AND UPPER(DRUG_NAME) LIKE '%BLIND%'
2ty6zmr18m8qn	SELECT '1' FROM AE_SUBMISSIONS AES WHERE AES.COMMENTS IS NOT NULL AND AES.COMMENTS LIKE '%NULL%' AND AES.CASE_ID=:B3 AND AES.SUBM_NBR=:B2 AND AES.SUBM_SEQ_NBR=:B1
3crbmgwrq53dm	INSERT INTO AER_INFM_AUTH (INITIAL_AER_ID, SEQ_INFM_AUTH, STATUS_AUTH_FLAG, RECORD_OWNER_UNIT, LOCAL_VERSION_NO, UF_DIST_DATE_REP_SENT_TO_MFR, UF_DIST_DAT_SENT_TO_MFR_PREC, REP_INFM_AUTH, UF_DIST_DATE_REP_SENT_TO_FDA, UF_DIST_DAT_SENT_TO_FDA_PREC, DECISION_DATE, PRODUCT_NAME, AUTHORITY, REPORT_FORMAT, TYPE_OF_REPORT, PRODUCT_SEQ, REPORT_MEDIUM, E2B_MESSAGE_TYPE, E2B_TRANSMISSION_STATUS, DIST_AER_INFO_ID, CONTACT_TYPE, SEQ_DIST_AER, REPORT_FOLLOW_UP_NO, COMMENTS, REPORT_DATE, NULLIFIED, REASON_FOR_NULLIFICATION, REPORTING_STATUS, DATE_INFORMED, DATE_INFORMED_PRECISION, VERSION_NO_AER, AUTHORITY_RESP_DATE, AUTHORITY_RESP_DATE_PRECISION, IDENTIFICATION_NO, RECORD_ID, USER_ID, DATE_CREATED, DATE_MODIFIED, SUBMISSION_UNIT ) VALUES (:B33 , :B32 , '0', :B31 , '0', :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , '1', :B17 , '4', :B16 , :B15 , :B14 , :B3 , :B13 , :B12 , :B11 , :B10 , :B9 , '0', :B8 , :B7 , :B6 , :B5 \|\|SEQ_RECORD_ID.NEXTVAL, :B4 , :B3 , :B2 , :B1 )
44yaamz8wzhx8	SELECT PT_SOC_CODE FROM L_PREF_TERM WHERE PT_CODE = :B2 AND MEDDRA_VERSION = 'v.'\|\|:B1
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4q96ynznd78yf	SELECT A.*, B.SEQ_PRODUCT FROM AE_REPORTABILITY A, DM_PRODUCT_GLOBAL_AERS B WHERE A.CASE_ID = B.SOURCE_CASE_ID AND A.SUSP_DRG_SEQ_NBR = B.SOURCE_SEQ_NUM AND A.CASE_ID = :B1
5zyjycwa6cnmf	UPDATE HIST_VIEW_TS SET VIEW_TS= (SELECT AES.ASOF_TS FROM AE_SUBMISSIONS AES WHERE AES.ASOF_TS IS NOT NULL AND AES.CASE_ID=:B2 AND AES.SUBM_SEQ_NBR=:B1 ) WHERE AUDSID=USERENV('SESSIONID')
68t8um5fcykkx	SELECT MAX(EC.RECEIVE_DATE) FROM EH_CONTACT_LOG EC WHERE EC.CASE_ID=:B1 AND EC.RESET_CLOCK_FLAG='Y'
6hbs1v6qxvy7b	SELECT LLT_CODE, PT_CODE FROM L_LOW_LEVEL_TERM WHERE TRIM(LOWER(LLT_NAME)) = TRIM(LOWER(:B2 )) AND MEDDRA_VERSION = 'v.'\|\|:B1
6mcpb06rctk0x	call dbms_space.auto_space_advisor_job_proc ( )
7s7h9cz7ppw0v	SELECT AES.* FROM AE_SUBMISSIONS AES WHERE CASE_ID = :B2 AND AES.AGENCY=:B1 AND AES.SUBM_SEQ_NBR = (SELECT MAX(AES.SUBM_SEQ_NBR) FROM AE_SUBMISSIONS AES WHERE AES.CASE_ID = :B2 AND AES.AGENCY=:B1 AND AES.REPORT_FORM=:B3 ) AND AES.SUBM_NBR = (SELECT MAX(AES.SUBM_NBR) FROM AE_SUBMISSIONS AES WHERE AES.CASE_ID = :B2 AND AES.AGENCY=:B1 AND AES.REPORT_FORM=:B3 )
7t0hg27ypbr88	SELECT COUNT(*) FROM AER_SOURCE WHERE AER_ID = :B2 AND SOURCE = :B1
7xrzbypjrp7h1	INSERT INTO DISTRIBUTION_OF_AER_INFO ( DIST_AER_INFO_ID, AER_ID, INITIAL_AER_ID, AER_NO, VERSION_NO, LOCAL_VERSION_NO, FORMAT_TYPE, E2B_LANGUAGE, E2B_AUTHORITY, FORMAT_PREFERRED_ROUTE, DISTRIBUTION_STATUS, REASON_NOT_TO_BE_DISTRIBUTED, DATE_SUBMITTED, DATE_DISTRIBUTED, FORMAT_LANGUAGE, CONTACT_NAME, E2B_DTD_VERSION, DICTIONARY, FORMAT_COUNTRY, E2B_MESSAGE_TYPE, CIOMS_IGNORE_NOT_RELEVANT_FLAG, BLINDED_REPORT, RECIPIENT_INFORMATION, CONTACT_TYPE, CONTACT_AUTHORITY, SEQ_DIST_AER, CONTACT_STATUS, ROUTE_THROUGH_AGX, FL_DATA_PRIVACY, RECIPIENT_COMPANY_UNIT, RECORD_OWNER_UNIT, RECORD_OWNER_UNIT_SEQ, RECORD_ID, USER_ID, DATE_CREATED, DATE_MODIFIED ) VALUES ( :B22 , :B21 , :B21 , :B20 , '0', '0', :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B13 , '001', :B12 , :B11 , '5', :B10 , :B9 , '2', '2', '1', '4', :B8 , :B5 , '1', '1', '2', :B7 , :B6 , :B5 , :B4 \|\|SEQ_RECORD_ID.NEXTVAL, :B3 , :B2 , :B1 )
8ngks5j77t65f	SELECT * FROM AE_CASE_DIALOGS WHERE CASE_ID = :B1 ORDER BY DIALG_SEQ_NBR
8szmwam7fysa3	insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
9j8wczywupm9w	SELECT MIN(EC.RECEIVE_DATE) FROM EH_CONTACT_LOG EC WHERE EC.CASE_ID=:B1
a86hv2qw48sq5	SELECT D.AERS_AFF_PART_CMP_UNIT FROM DM_AERS_AGENCY_COMP_UNIT_MAP D WHERE D.AERS_COUNTRY_CODE = :B2 AND (D.BAX_ENV1=:B1 OR D.BAX_ENV1 IS NULL)
b6usrg82hwsa3	call dbms_stats.gather_database_stats_job_proc ( )
b9u1pv732y83d	INSERT INTO AER_TEXT ( AER_ID, SEQ_TEXT, FIELD_ID, SEQ_TAB, TEXT, LANGUAGE, RECORD_ID, USER_ID, DATE_CREATED, DATE_MODIFIED ) VALUES ( :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 \|\|SEQ_RECORD_ID.NEXTVAL, :B3 , :B2 , :B1 )
dd75gqc4fv983	SELECT DISTINCT HA_CODE FROM DM_AERS_AGENCY_COMP_UNIT_MAP D WHERE D.AERS_COUNTRY_CODE=:B1
fabyyff4p1unz	SELECT D.CASE_TYPE FROM DM_AERS_AGENCY_COMP_UNIT_MAP D WHERE D.BAX_ENV1=:B2 AND D.AERS_COUNTRY_CODE = :B1 AND D.CASE_TYPE IS NOT NULL
gdzxsv8d1tusq	SELECT A.TABLE_NAME, B.DBS_FIELD_NAME, B.MAX_LENGTH FROM ARIS_TABLE A, ARIS_TABLE_FIELD B WHERE A.TABLE_ID = B.TABLE_ID AND B.FIELD_ID = :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	1,012,404	93.69	1,231.64
CPU used when call started	968,209	89.60	1,177.87
CR blocks created	3,805	0.35	4.63
Cached Commit SCN referenced	3,953	0.37	4.81
Commit SCN cached	30	0.00	0.04
DB time	2,190,400	202.71	2,664.72
DBWR checkpoint buffers written	110,909	10.26	134.93
DBWR checkpoints	42	0.00	0.05
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	367	0.03	0.45
DBWR undo block writes	59,781	5.53	72.73
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	303	0.03	0.37
IMU Redo allocation size	3,338,444	308.96	4,061.37
IMU commits	366	0.03	0.45
IMU contention	11	0.00	0.01
IMU ktichg flush	17	0.00	0.02
IMU pool not allocated	418	0.04	0.51
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	3,861,008	357.32	4,697.09
IMU- failed to get a private strand	418	0.04	0.51
SMON posted for undo segment shrink	2	0.00	0.00
SQL*Net roundtrips to/from client	6,525	0.60	7.94
active txn count during cleanout	28,403	2.63	34.55
application wait time	253	0.02	0.31
background checkpoints completed	42	0.00	0.05
background checkpoints started	42	0.00	0.05
background timeouts	59,699	5.52	72.63
buffer is not pinned count	19,382,544	1,793.77	23,579.74
buffer is pinned count	163,896,158	15,167.85	199,387.05
bytes received via SQL*Net from client	2,846,020	263.39	3,462.31
bytes sent via SQL*Net to client	4,176,703	386.54	5,081.15
calls to get snapshot scn: kcmgss	23,556,589	2,180.06	28,657.65
calls to kcmgas	1,929,845	178.60	2,347.74
calls to kcmgcs	23,691	2.19	28.82
change write time	75,521	6.99	91.87
cleanout - number of ktugct calls	30,069	2.78	36.58
cleanouts and rollbacks - consistent read gets	575	0.05	0.70
cleanouts only - consistent read gets	602	0.06	0.73
cluster key scan block gets	1,260,718	116.67	1,533.72
cluster key scans	1,111,357	102.85	1,352.02
commit batch/immediate performed	37	0.00	0.05
commit batch/immediate requested	37	0.00	0.05
commit cleanout failures: block lost	144	0.01	0.18
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	582	0.05	0.71
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	1,833,005	169.64	2,229.93
commit cleanouts successfully completed	1,832,279	169.57	2,229.05
commit immediate performed	37	0.00	0.05
commit immediate requested	37	0.00	0.05
commit txn count during cleanout	6,520	0.60	7.93
concurrency wait time	224	0.02	0.27
consistent changes	7,076,359	654.89	8,608.71
consistent gets	51,229,880	4,741.09	62,323.45
consistent gets - examination	22,144,722	2,049.39	26,940.05
consistent gets direct	1,818	0.17	2.21
consistent gets from cache	51,228,062	4,740.93	62,321.24
cursor authentications	897	0.08	1.09
data blocks consistent reads - undo records applied	55,369	5.12	67.36
db block changes	25,680,579	2,376.62	31,241.58
db block gets	39,024,395	3,611.53	47,474.93
db block gets direct	1,956	0.18	2.38
db block gets from cache	39,022,439	3,611.35	47,472.55
deferred (CURRENT) block cleanout applications	1,773,952	164.17	2,158.09
dirty buffers inspected	839	0.08	1.02
enqueue conversions	162,244	15.01	197.38
enqueue releases	3,683,939	340.93	4,481.68
enqueue requests	3,683,939	340.93	4,481.68
enqueue timeouts	0	0.00	0.00
enqueue waits	0	0.00	0.00
execute count	10,079,361	932.80	12,262.00
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	185,661	17.18	225.86
free buffer requested	1,850,573	171.26	2,251.31
heap block compress	5,450	0.50	6.63
hot buffers moved to head of LRU	75,525	6.99	91.88
immediate (CR) block cleanout applications	1,177	0.11	1.43
immediate (CURRENT) block cleanout applications	12,999	1.20	15.81
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	137,568	12.73	167.36
index fast full scans (full)	4	0.00	0.00
index fetch by key	5,214,714	482.60	6,343.93
index scans kdiixs1	8,431,863	780.33	10,257.74
java call heap collected bytes	0	0.00	0.00
java call heap collected count	0	0.00	0.00
java call heap gc count	0	0.00	0.00
java call heap live object count	0	0.00	0.00
java call heap live object count max	0	0.00	0.00
java call heap live size	0	0.00	0.00
java call heap live size max	0	0.00	0.00
java call heap object count	0	0.00	0.00
java call heap object count max	0	0.00	0.00
java call heap total size	0	0.00	0.00
java call heap total size max	0	0.00	0.00
java call heap used size	0	0.00	0.00
java call heap used size max	0	0.00	0.00
leaf node 90-10 splits	3,193	0.30	3.88
leaf node splits	4,718	0.44	5.74
lob reads	724,344	67.03	881.20
lob writes	2,506,339	231.95	3,049.07
lob writes unaligned	2,506,339	231.95	3,049.07
logons cumulative	2,316	0.21	2.82
messages received	35,134	3.25	42.74
messages sent	35,134	3.25	42.74
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	23,794,815	2,202.10	28,947.46
opened cursors cumulative	6,395,898	591.91	7,780.90
parse count (failures)	14	0.00	0.02
parse count (hard)	48,256	4.47	58.71
parse count (total)	6,364,111	588.97	7,742.23
parse time cpu	53,736	4.97	65.37
parse time elapsed	58,325	5.40	70.95
physical read IO requests	147,738	13.67	179.73
physical read bytes	2,475,835,392	229,127.42	3,011,965.20
physical read total IO requests	160,493	14.85	195.25
physical read total bytes	2,679,811,072	248,004.45	3,260,110.79
physical read total multi block requests	674	0.06	0.82
physical reads	151,113	13.98	183.84
physical reads cache	147,376	13.64	179.29
physical reads cache prefetch	3,382	0.31	4.11
physical reads direct	3,737	0.35	4.55
physical reads direct (lob)	1,794	0.17	2.18
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	30,297	2.80	36.86
physical write bytes	1,954,709,504	180,899.56	2,377,992.10
physical write total IO requests	71,946	6.66	87.53
physical write total bytes	12,033,447,936	1,113,641.42	14,639,231.07
physical write total multi block requests	40,941	3.79	49.81
physical writes	119,306	11.04	145.14
physical writes direct	3,888	0.36	4.73
physical writes direct (lob)	1,139	0.11	1.39
physical writes direct temporary tablespace	806	0.07	0.98
physical writes from cache	115,418	10.68	140.41
physical writes non checkpoint	93,779	8.68	114.09
pinned buffers inspected	2	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	2	0.00	0.00
process last non-idle time	12,286	1.14	14.95
recursive calls	46,708,185	4,322.63	56,822.61
recursive cpu usage	719,294	66.57	875.05
redo blocks written	6,382,580	590.68	7,764.70
redo buffer allocation retries	93	0.01	0.11
redo entries	9,412,254	871.06	11,450.43
redo log space requests	98	0.01	0.12
redo log space wait time	590	0.05	0.72
redo ordering marks	63,711	5.90	77.51
redo size	3,158,826,228	292,335.14	3,842,854.29
redo subscn max counts	95,208	8.81	115.82
redo synch time	107	0.01	0.13
redo synch writes	88	0.01	0.11
redo wastage	1,962,580	181.63	2,387.57
redo write time	10,755	1.00	13.08
redo writer latching time	7	0.00	0.01
redo writes	6,829	0.63	8.31
rollback changes - undo records applied	87,166	8.07	106.04
rollbacks only - consistent read gets	2,989	0.28	3.64
rows fetched via callback	2,250,502	208.27	2,737.84
session connect time	10,982	1.02	13.36
session cursor cache hits	1,849,573	171.17	2,250.09
session logical reads	90,254,275	8,352.63	109,798.39
session pga memory	33,534,456	3,103.46	40,796.18
session pga memory max	413,315,576	38,250.50	502,817.00
session uga memory	25,840,610,424	2,391,432.14	31,436,265.72
session uga memory max	812,986,760	75,238.26	989,034.99
shared hash latch upgrades - no wait	391,179	36.20	475.89
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	281,835	26.08	342.86
sorts (rows)	17,352,791	1,605.92	21,110.45
sql area evicted	5,929	0.55	7.21
sql area purged	63	0.01	0.08
summed dirty queue length	2,256	0.21	2.74
switch current to new buffer	688	0.06	0.84
table fetch by rowid	89,792,992	8,309.94	109,237.22
table fetch continued row	2,839	0.26	3.45
table scan blocks gotten	3,928,853	363.60	4,779.63
table scan rows gotten	179,820,462	16,641.57	218,759.69
table scans (long tables)	2	0.00	0.00
table scans (short tables)	804,877	74.49	979.17
total number of times SMON posted	32	0.00	0.04
transaction rollbacks	37	0.00	0.05
transaction tables consistent read rollbacks	3	0.00	0.00
transaction tables consistent reads - undo records applied	2,151	0.20	2.62
undo change vector size	924,365,804	85,545.89	1,124,532.61
user I/O wait time	73,263	6.78	89.13
user calls	15,734	1.46	19.14
user commits	811	0.08	0.99
user rollbacks	11	0.00	0.01
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	233,409	21.60	283.95
write clones created in background	1	0.00	0.00
write clones created in foreground	203	0.02	0.25

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	143,891	149,504
opened cursors current	45	75
logons current	25	40

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)	42	13.99

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
EVNET_DAT	91,011	8	5.50	1.00	890	0	0	0.00
PSS_ARIS_AER_T	8,039	1	5.22	1.04	9,630	1	0	0.00
DM_AERS	15,536	1	1.41	1.00	129	0	0	0.00
UNDOTBS1	87	0	3.79	1.00	9,304	1	33	0.00
XMLDB_TS	6,810	1	1.69	1.00	42	0	0	0.00
PSS_ENCODER	6,441	1	3.90	1.23	42	0	0	0.00
SYSAUX	5,101	0	9.21	1.15	1,114	0	0	0.00
USERS	5,147	0	8.12	1.00	168	0	0	0.00
PSS_CCM	1,756	0	3.67	1.01	3,052	0	0	0.00
PSS_ARIS_AER_I	529	0	4.73	1.00	3,105	0	0	0.00
TOOLS	2,365	0	6.85	1.00	170	0	0	0.00
SYSTEM	529	0	21.04	1.03	1,101	0	1	70.00
PO_CMS	1,072	0	2.52	1.02	42	0	0	0.00
PSS_ARIS_DMO_T	189	0	14.55	1.01	878	0	0	0.00
PSS_ARIS_SYS_T	815	0	6.94	1.00	42	0	0	0.00
PSS_ALERTS	745	0	2.72	1.00	42	0	0	0.00
PSS_ARIS_SYS_I	541	0	7.26	1.00	42	0	0	0.00
PSS_ARIS_AUD_T	297	0	10.47	1.00	42	0	0	0.00
PSS_ARIS_DIC_T	176	0	7.33	1.00	42	0	0	0.00
PSS_ARIS_WF_T	157	0	11.08	1.03	56	0	0	0.00
TEMP	68	0	0.15	11.87	75	0	0	0.00
AUDITDATA	57	0	17.02	1.00	68	0	0	0.00
PSS_ARIS_WF_I	66	0	15.15	1.00	48	0	0	0.00
PSS_ARIS_AUD_I	58	0	9.31	1.00	42	0	0	0.00
PSS_ARIS_DMO_I	43	0	15.81	1.00	42	0	0	0.00
PSS_ARIS_DIC_I	42	0	10.95	1.00	42	0	0	0.00
PSS_CMS	42	0	5.95	1.00	42	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	Buffer Waits	Av Buf Wt(ms)
AUDITDATA	/u1/oradata/PSSDEV3/auditdata.dbf	57	0	17.02	1.00	68	0	0.00
DM_AERS	/u2/oradata/PSSDEV3/dmaers01.dbf	4,580	0	0.84	1.00	42	0	0.00
DM_AERS	/u2/oradata/PSSDEV3/dmaers02.dbf	5,160	0	0.93	1.00	42	0	0.00
DM_AERS	/u2/oradata/PSSDEV3/dmaers03	5,796	1	2.27	1.00	45	0	0.00
EVNET_DAT	/u2/oradata/PSSDEV3/EVNETDAT01.dbf	11,964	1	6.01	1.00	129	0	0.00
EVNET_DAT	/u2/oradata/PSSDEV3/EVNETDAT02.dbf	12,943	1	6.14	1.00	127	0	0.00
EVNET_DAT	/u2/oradata/PSSDEV3/EVNETDAT03.dbf	14,376	1	5.57	1.00	126	0	0.00
EVNET_DAT	/u2/oradata/PSSDEV3/EVNETDAT04.dbf	14,290	1	4.94	1.00	143	0	0.00
EVNET_DAT	/u2/oradata/PSSDEV3/EVNETDAT05.dbf	12,781	1	5.32	1.00	105	0	0.00
EVNET_DAT	/u2/oradata/PSSDEV3/EVNETDAT06.dbf	11,679	1	5.46	1.00	140	0	0.00
EVNET_DAT	/u2/oradata/PSSDEV3/EVNETDAT07.dbf	12,978	1	5.17	1.00	120	0	0.00
PO_CMS	/u2/oradata/PSSDEV3/po_cms01.dbf	1,072	0	2.52	1.02	42	0	0.00
PSS_ALERTS	/u2/oradata/PSSDEV3/PSS_ALERTS1	745	0	2.72	1.00	42	0	0.00
PSS_ARIS_AER_I	/u2/oradata/PSSDEV3/PSS_ARIS_AER_I1	529	0	4.73	1.00	3,105	0	0.00
PSS_ARIS_AER_T	/u3/oradata/PSSDEV3/PSS_ARIS_AER_T1	3,154	0	3.71	1.05	4,807	0	0.00
PSS_ARIS_AER_T	/u3/oradata/PSSDEV3/PSS_ARIS_AER_T2	4,885	0	6.20	1.03	4,823	0	0.00
PSS_ARIS_AUD_I	/u3/oradata/PSSDEV3/PSS_ARIS_AUD_I1	58	0	9.31	1.00	42	0	0.00
PSS_ARIS_AUD_T	/u3/oradata/PSSDEV3/PSS_ARIS_AUD_T1	297	0	10.47	1.00	42	0	0.00
PSS_ARIS_DIC_I	/u4/oradata/PSSDEV3/PSS_ARIS_DIC_I1	42	0	10.95	1.00	42	0	0.00
PSS_ARIS_DIC_T	/u4/oradata/PSSDEV3/PSS_ARIS_DIC_T1	176	0	7.33	1.00	42	0	0.00
PSS_ARIS_DMO_I	/u4/oradata/PSSDEV3/PSS_ARIS_DMO_I1	43	0	15.81	1.00	42	0	0.00
PSS_ARIS_DMO_T	/u4/oradata/PSSDEV3/PSS_ARIS_DMO_T1	42	0	14.29	1.00	205	0	0.00
PSS_ARIS_DMO_T	/u4/oradata/PSSDEV3/PSS_ARIS_DMO_T2	42	0	16.67	1.00	219	0	0.00
PSS_ARIS_DMO_T	/u4/oradata/PSSDEV3/PSS_ARIS_DMO_T3	42	0	15.71	1.00	239	0	0.00
PSS_ARIS_DMO_T	/u4/oradata/PSSDEV3/PSS_ARIS_DMO_T4	63	0	12.54	1.03	215	0	0.00
PSS_ARIS_SYS_I	/u4/oradata/PSSDEV3/PSS_ARIS_SYS_I1	541	0	7.26	1.00	42	0	0.00
PSS_ARIS_SYS_T	/u4/oradata/PSSDEV3/PSS_ARIS_SYS_T1	815	0	6.94	1.00	42	0	0.00
PSS_ARIS_WF_I	/u4/oradata/PSSDEV3/PSS_ARIS_WF_I1	66	0	15.15	1.00	48	0	0.00
PSS_ARIS_WF_T	/u4/oradata/PSSDEV3/PSS_ARIS_WF_T1	157	0	11.08	1.03	56	0	0.00
PSS_CCM	/u4/oradata/PSSDEV3/PSS_CCM01	1,756	0	3.67	1.01	3,052	0	0.00
PSS_CMS	/u2/oradata/PSSDEV3/PSS_CMS1	42	0	5.95	1.00	42	0	0.00
PSS_ENCODER	/u4/oradata/PSSDEV3/PSS_ENCODER1	6,441	1	3.90	1.23	42	0	0.00
SYSAUX	/u1/oradata/PSSDEV3/sysaux01.dbf	5,101	0	9.21	1.15	1,114	0	0.00
SYSTEM	/u1/oradata/PSSDEV3/system01.dbf	469	0	18.81	1.04	1,018	1	70.00
SYSTEM	/u2/oradata/PSSDEV3/system02.dbf	60	0	38.50	1.00	83	0	0.00
TEMP	/u2/oradata/PSSDEV3/temp04.dbf	67	0	0.15	12.03	74	0
TEMP	/u2/oradata/PSSDEV3/temp05.dbf	1	0	0.00	1.00	1	0
TOOLS	/u2/oradata/PSSDEV3/Tools01.dbf	868	0	5.76	1.00	44	0	0.00
TOOLS	/u2/oradata/PSSDEV3/Tools02.dbf	638	0	6.27	1.00	42	0	0.00
TOOLS	/u2/oradata/PSSDEV3/Tools03.dbf	438	0	6.78	1.00	42	0	0.00
TOOLS	/u2/oradata/PSSDEV3/Tools04.dbf	421	0	10.07	1.00	42	0	0.00
UNDOTBS1	/u1/oradata/PSSDEV3/undotbs01.dbf	45	0	1.78	1.00	4,806	33	0.00
UNDOTBS1	/u2/oradata/PSSDEV3/undotbs02.dbf	42	0	5.95	1.00	4,498	0	0.00
USERS	/u1/oradata/PSSDEV3/users01.dbf	1,305	0	7.44	1.00	42	0	0.00
USERS	/u1/oradata/PSSDEV3/users02.dbf	1,378	0	9.32	1.00	42	0	0.00
USERS	/u2/oradata/PSSDEV3/users03.dbf	1,187	0	7.03	1.00	42	0	0.00
USERS	/u2/oradata/PSSDEV3/users04.dbf	1,277	0	8.54	1.00	42	0	0.00
XMLDB_TS	/u2/oradata/PSSDEV3/xmldb_ts.dbf	6,810	1	1.69	1.00	42	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	162,938	100	90,250,344	147,368	115,418	0	0	34

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	23	128	363	34280	368640	34280
E	0	29	1618	116204	368640	368640	842095

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	256	0.10	16,080	2.00	22,444,203
D	512	0.20	32,160	1.83	20,530,210
D	768	0.29	48,240	1.67	18,666,146
D	1,024	0.39	64,320	1.52	17,020,333
D	1,280	0.49	80,400	1.40	15,705,643
D	1,536	0.59	96,480	1.31	14,647,247
D	1,792	0.69	112,560	1.22	13,704,612
D	2,048	0.79	128,640	1.14	12,810,495
D	2,304	0.88	144,720	1.07	11,993,267
D	2,560	0.98	160,800	1.01	11,308,949
D	2,608	1.00	163,815	1.00	11,208,276
D	2,816	1.08	176,880	0.96	10,770,864
D	3,072	1.18	192,960	0.92	10,341,702
D	3,328	1.28	209,040	0.89	9,967,923
D	3,584	1.37	225,120	0.86	9,612,922
D	3,840	1.47	241,200	0.83	9,261,218
D	4,096	1.57	257,280	0.79	8,888,470
D	4,352	1.67	273,360	0.76	8,484,300
D	4,608	1.77	289,440	0.73	8,137,765
D	4,864	1.87	305,520	0.70	7,826,520
D	5,120	1.96	321,600	0.67	7,523,742

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	4,394	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	1,024	900	67.81	0.00	0.00	0.00	0.00	104,850
E	1,024	895	93.01	0.00	0.00	0.00	0.00	104,850

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	227,265	227,265
64K	128K	298	298
128K	256K	60	60
256K	512K	62	62
512K	1024K	5,483	5,483
1M	2M	213	213
2M	4M	24	24
4M	8M	2	2
16M	32M	1	1

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
128	0.13	40,489.82	11,176.74	78.00	1
256	0.25	40,489.82	5,609.16	88.00	0
512	0.50	40,489.82	4,733.36	90.00	0
768	0.75	40,489.82	4,733.36	90.00	0
1,024	1.00	40,489.82	4,520.21	90.00	0
1,229	1.20	40,489.82	4,326.06	90.00	0
1,434	1.40	40,489.82	4,326.06	90.00	0
1,638	1.60	40,489.82	4,326.06	90.00	0
1,843	1.80	40,489.82	4,326.06	90.00	0
2,048	2.00	40,489.82	4,326.06	90.00	0
3,072	3.00	40,489.82	4,326.06	90.00	0
4,096	4.00	40,489.82	4,326.06	90.00	0
6,144	6.00	40,489.82	4,326.06	90.00	0
8,192	8.00	40,489.82	4,326.06	90.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
480	0.36	178	20,179	2,379,098,121	1.00	4,924,633	2398.75	110,201,025
624	0.46	320	33,728	2,381,720,103	1.00	2,302,651	1121.60	110,207,170
768	0.57	463	45,130	2,382,989,065	1.00	1,033,689	503.50	110,211,455
912	0.68	606	58,365	2,383,602,908	1.00	419,846	204.50	110,214,600
1,056	0.79	749	68,610	2,383,856,578	1.00	166,176	80.94	110,216,879
1,200	0.89	892	79,587	2,383,962,527	1.00	60,227	29.34	110,218,403
1,344	1.00	1,035	89,065	2,384,020,701	1.00	2,053	1.00	110,219,457
1,488	1.11	1,178	97,779	2,384,046,441	1.00	1	0.00	110,220,187
1,632	1.21	1,321	104,801	2,384,059,652	1.00	1	0.00	110,220,688
1,776	1.32	1,465	114,346	2,384,066,082	1.00	1	0.00	110,221,023
1,920	1.43	1,609	122,779	2,384,068,899	1.00	1	0.00	110,221,259
2,064	1.54	1,753	131,749	2,384,070,241	1.00	1	0.00	110,221,438
2,208	1.64	1,897	142,049	2,384,071,446	1.00	1	0.00	110,221,602
2,352	1.75	2,041	152,258	2,384,072,863	1.00	1	0.00	110,221,776
2,496	1.86	2,184	159,544	2,384,074,098	1.00	1	0.00	110,221,907
2,640	1.96	2,327	169,147	2,384,075,044	1.00	1	0.00	110,222,024
2,784	2.07	2,467	177,525	2,384,075,894	1.00	1	0.00	110,222,139

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,024	0.25	2,474,622	22,444,527
2,048	0.50	100,389	20,530,157
3,072	0.75	81,286	14,646,945
4,096	1.00	71,360	11,208,253
5,120	1.25	66,750	9,613,319
6,144	1.50	65,723	8,484,648
7,168	1.75	65,723	7,524,100
8,192	2.00	65,724	7,524,100

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

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.25	9	148	5	1.00	2,053	1.00	148
32	0.50	9	148	5	1.00	2,053	1.00	148
48	0.75	9	148	5	1.00	2,053	1.00	148
64	1.00	9	148	5	1.00	2,053	1.00	148
80	1.25	9	148	5	1.00	2,053	1.00	148
96	1.50	9	148	5	1.00	2,053	1.00	148
112	1.75	9	148	5	1.00	2,053	1.00	148
128	2.00	9	148	5	1.00	2,053	1.00	148

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	Avg Time (ms)
data block	1	70
undo header	32	0
undo block	1	0

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	60.81	1,760,546	9,450	6	15/169.5	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
27-May 23:05	1,098	28,822	0	4	15	0/0	0/0/0/0/0/0
27-May 22:55	3,741	112,832	9,450	3	170	0/0	0/0/0/0/0/0
27-May 22:45	3,336	100,924	8,847	3	159	0/0	0/0/0/0/0/0
27-May 22:35	4,005	122,901	8,246	3	150	0/0	0/0/0/0/0/0
27-May 22:25	3,645	108,888	7,643	3	140	0/0	0/0/0/0/0/0
27-May 22:15	3,611	105,682	7,042	5	130	0/0	0/0/0/0/0/0
27-May 22:05	4,475	108,319	6,440	6	120	0/0	0/0/0/0/0/0
27-May 21:55	3,652	111,291	5,838	3	110	0/0	0/0/0/0/0/0
27-May 21:45	3,408	104,356	5,233	3	100	0/0	0/0/0/0/0/0
27-May 21:35	3,423	105,823	4,632	3	90	0/0	0/0/0/0/0/0
27-May 21:25	3,514	105,551	4,030	4	80	0/0	0/0/0/0/0/0
27-May 21:15	3,633	101,560	3,429	3	70	0/0	0/0/0/0/0/0
27-May 21:05	3,721	103,904	2,825	4	60	0/0	0/0/0/0/0/0
27-May 20:55	3,615	103,053	2,225	3	50	0/0	0/0/0/0/0/0
27-May 20:45	3,936	116,807	1,623	3	40	0/0	0/0/0/0/0/0
27-May 20:35	3,789	108,390	1,020	3	30	0/0	0/0/0/0/0/0
27-May 20:25	3,440	110,965	419	3	20	0/0	0/0/0/0/0/0
27-May 20:15	752	386	0	3	15	0/0	0/0/0/0/0/0
27-May 20:05	18	92	0	2	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	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	7,225	0.00		0	0
AWR Alerted Metric Element list	43,336	0.00		0	0
Consistent RBA	6,875	0.00		0	0
FIB s.o chain latch	44	0.00		0	0
FOB s.o list latch	1,233	0.00		0	0
In memory undo latch	227,774	0.00	0.50	0	3,467	0.00
JOX SGA heap latch	1	0.00		0	0
JS Sh mem access	2	0.00		0	0
JS mem alloc latch	26	0.00		0	0
JS queue access latch	26	0.00		0	0
JS queue state obj latch	77,736	0.00		0	0
JS slv state obj latch	29,063	0.00		0	0
KMG MMAN ready and startup request latch	3,721	0.00		0	0
KMG resize request state object freelist	22	0.00		0	0
KTF sga latch	24	0.00		0	3,203	0.00
KWQMN job cache list latch	3	0.00		0	0
KWQP Prop Status	6	0.00		0	0
MQL Tracking Latch	0			0	215	0.00
Memory Management Latch	338	0.00		0	3,721	0.00
OS process	489	0.00		0	0
OS process allocation	3,942	0.00		0	0
OS process: request allocation	293	0.00		0	0
PL/SQL warning settings	2,822	0.00		0	0
SQL memory manager latch	3	0.00		0	3,591	0.00
SQL memory manager workarea list latch	1,513,720	0.00	0.00	0	0
Shared B-Tree	394	0.00		0	0
active checkpoint queue latch	56,025	0.52	0.00	0	0
active service list	29,026	0.00		0	3,588	0.00
archive control	14	0.00		0	0
begin backup scn array	1,140	0.00		0	0
buffer pool	182	0.00		0	0
cache buffer handles	274,189	0.00		0	0
cache buffers chains	205,949,472	0.00	0.01	0	1,487,031	0.00
cache buffers lru chain	3,207,005	0.00	0.00	0	1,946,668	0.00
cache table scan latch	0			0	630	0.00
channel handle pool latch	354	0.00		0	0
channel operations parent latch	51,385	0.00		0	0
checkpoint queue latch	2,840,731	0.00	0.00	0	138,999	0.00
client/application info	875	0.00		0	0
compile environment latch	2,316	0.00		0	0
dictionary lookup	123	0.00		0	0
dml lock allocation	3,539,178	0.00	0.00	0	0
dummy allocation	4,617	0.00		0	0
enqueue hash chains	7,530,137	0.00	0.00	0	114	0.00
enqueues	310,600	0.00	0.00	0	0
event group latch	154	0.00		0	0
file cache latch	2,339	0.00		0	0
global KZLD latch for mem in SGA	34	0.00		0	0
hash table column usage latch	821	0.00		0	207,667	0.00
hash table modification latch	282	0.00		0	0
internal temp table object number allocation latc	6	0.00		0	0
job workq parent latch	0			0	4,324	0.00
job_queue_processes parameter latch	2,337	0.00		0	0
kks stats	17,583	0.01	0.00	0	0
kmcptab latch	1	0.00		0	0
kmcpvec latch	0			0	1	0.00
kokc descriptor allocation latch	30	0.00		0	0
ksuosstats global area	726	0.00		0	0
ktm global data	68	0.00		0	0
kwqbsn:qsga	391	0.00		0	0
lgwr LWN SCN	7,122	0.00		0	0
library cache	96,414,710	0.00	0.00	0	23,433	151.09
library cache load lock	5,013	0.02	0.00	0	425	0.00
library cache lock	71,987,904	0.00	0.00	0	62	0.00
library cache lock allocation	6,171	0.00		0	0
library cache pin	15,021,398	0.00	0.00	0	0
library cache pin allocation	688	0.00		0	0
list of block allocation	6,308	0.00		0	0
loader state object freelist	2,918	0.00		0	0
logminer context allocation	3	0.00		0	0
longop free list parent	28	0.00		0	460	0.00
message pool operations parent latch	64	0.00		0	0
messages	198,382	0.28	0.00	0	0
mostly latch-free SCN	7,180	0.38	0.00	0	0
multiblock read objects	4,882	0.00		0	0
ncodef allocation latch	172	0.00		0	0
object queue header heap	1,559,939	0.00	0.00	0	1,338,579	0.00
object queue header operation	5,599,538	0.00	0.00	0	24,091	0.00
object stats modification	129	0.00		0	0
parallel query alloc buffer	1,440	0.00		0	0
parameter list	693	0.00		0	0
parameter table allocation management	2,327	0.00		0	0
post/wait queue	217	0.00		0	149	0.00
process allocation	293	0.00		0	154	0.00
process group creation	293	0.00		0	0
qmn task queue latch	1,540	0.00		0	0
redo allocation	49,647	0.09	0.00	0	9,412,178	0.01
redo copy	0			0	9,412,293	0.01
redo writing	86,381	0.32	0.00	0	0
resmgr group change latch	285	0.00		0	0
resmgr:active threads	4,610	0.00		0	0
resmgr:actses change group	148	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	4,605	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	3	0.00		0	0
resmgr:vc list latch	1	0.00		0	0
row cache objects	34,168,272	0.00	0.00	0	279	0.00
rules engine rule set statistics	300	0.00		0	0
sequence cache	3,518,633	0.00	0.00	0	0
session allocation	580,628	0.14	0.00	0	0
session idle bit	36,697	0.00		0	0
session state list latch	4,688	0.00		0	0
session switching	174	0.00		0	0
session timer	3,588	0.00		0	0
shared pool	18,041,659	0.01	0.05	1	0
shared pool sim alloc	1,709	0.00		0	0
shared pool simulator	40,602,154	0.00	0.18	0	0
simulator hash latch	4,853,535	0.00		0	0
simulator lru latch	125,043	0.03	0.03	0	4,719,408	0.00
slave class	6	0.00		0	0
slave class create	24	12.50	1.00	0	0
sort extent pool	615	0.00		0	0
state object free list	6	0.00		0	0
statistics aggregation	1,680	0.00		0	0
temp lob duration state obj allocation	4	0.00		0	0
temporary table state object allocation	4	0.00		0	0
threshold alerts latch	1,222	0.00		0	0
transaction allocation	265,652	0.00		0	0
transaction branch allocation	3,588	0.00		0	0
undo global data	5,399,607	0.00	0.00	0	0
user lock	118	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
shared pool	18,041,659	1,218	62	1,156
cache buffers chains	205,949,472	129	1	128
shared pool simulator	40,602,154	65	12	53
simulator lru latch	125,043	32	1	31
slave class create	24	3	3	0
In memory undo latch	227,774	2	1	1

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
In memory undo latch	ktiFlush: child	1	0
cache buffers chains	kcbbxsv	1	0
shared pool	kgh_next_free	27	1
shared pool	kgh: sim resz update	12	0
shared pool	kghalo	10	4
shared pool	kghfrunp: alloc: wait	4	0
shared pool	kghupr1	4	126
shared pool	kgh: quiesce extents	3	0
shared pool	kgh: add extent to quiesced list	2	0
shared pool simulator	kglsim_upd_newhp	10	0
shared pool simulator	kglsim_unpin_simhp	2	4
simulator lru latch	kcbs_free_granule_sim_buffers	1	0
slave class create	ksvcreate	3	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: 90,254,275
Captured Segments account for 56.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
PSS_AERS	DM_AERS	PK_EA_CONTACT_LOG	INDEX	12,887,056	14.28
PSS_ARISG	PSS_ARIS_AER_T	DM_AERS_AGENCY_COMP_UNIT_MAP	TABLE	4,185,936	4.64
PSS_AERS	DM_AERS	PK_AE_SUBMISSIONS_AE_SUB	INDEX	4,156,112	4.60
PSS_AERS	EVNET_DAT	AE_SUBMISSIONS	TABLE	3,748,096	4.15
PSS_ARISG	PSS_ARIS_AER_T	PK_AER	INDEX	2,146,208	2.38

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 151,113
Captured Segments account for 57.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
PSS_AERS	EVNET_DAT	AE_CASE_DIALOGS	TABLE	9,158	6.06
PSS_AERS	EVNET_DAT	AE_CASE_LG	TABLE	8,746	5.79
PSS_AERS	EVNET_DAT	AE_REPORTABILITY	TABLE	8,576	5.68
PSS_AERS	EVNET_DAT	AE_SUBMISSIONS	TABLE	8,187	5.42
PSS_PORTAL30	USERS	WWDOC_DOCUMENT$_ADT	TABLE	4,979	3.29

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
PSS_ARISG	PSS_ARIS_AER_I	IDX_UPP_RECOWNUNIT_AER_INAU	INDEX	18	28.57
PSS_ARISG	PSS_ARIS_AER_T	PK_AER_INFM_AUTH	INDEX	10	15.87
PSS_ARISG	PSS_ARIS_AER_T	UK_AER_TEXT	INDEX	8	12.70
PSS_ARISG	PSS_ARIS_AER_T	PK_DIST_OF_AER_INFO	INDEX	6	9.52
SYS	SYSAUX	I_WRI$_OPTSTAT_H_ST	INDEX	4	6.35

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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	195	0.00	6	1
dc_constraints	240	33.33	240	3
dc_database_links	182	0.00	0	1
dc_files	644	0.00	0	46
dc_global_oids	212	1.42	0	158
dc_histogram_data	69,841	3.47	2,442	4,546
dc_histogram_defs	43,899	11.40	2,838	8,639
dc_object_grants	128	3.13	0	279
dc_object_ids	649,584	0.07	105	2,014
dc_objects	100,000	0.71	182	3,610
dc_profiles	68	1.47	0	3
dc_rollback_segments	9,761	0.00	0	132
dc_segments	315,289	0.22	1,284	1,889
dc_sequences	1,749,523	0.00	1,749,523	10
dc_table_scns	19	100.00	0	0
dc_tablespace_quotas	1,266	0.08	263	16
dc_tablespaces	898,090	0.00	0	28
dc_usernames	80,168	0.01	0	109
dc_users	7,284,413	0.00	0	130
outstanding_alerts	504	0.00	0	27

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	149	2.68	274	4.74	8	0
CLUSTER	178	0.00	529	0.38	2	0
INDEX	335	51.94	1,826	20.04	40	0
SQL AREA	66,688	8.73	33,094,906	0.30	1,279	455
TABLE/PROCEDURE	38,421	0.57	10,580,497	0.02	1,219	0
TRIGGER	388	1.29	413	3.87	11	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	43.04		1.59	4.10	22	26	27	27
	Freeable	24.06	0.00	1.72	1.77	5		14	14
	SQL	0.49	0.27	0.04	0.04	0	91	12	11
	PL/SQL	0.29	0.13	0.01	0.03	0	1	25	25
E	Other	52.38		1.25	3.30	22	26	42	42
	Freeable	39.31	0.00	1.36	1.25	5		29	29
	SQL	0.75	0.45	0.03	0.03	0	91	28	26
	PL/SQL	0.71	0.50	0.02	0.03	0	0	40	40

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	2,986,344,448	2,734,686,208
Fixed Size	2,144,432
Redo Buffers	34,603,008
Variable Size	1,271,875,408	1,523,533,648

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	55.68	55.68	0.00
java	joxlod exec hp	8.18	8.18	0.00
large	PX msg pool	0.25	0.25	0.00
large	free memory	15.75	15.75	0.00
shared	ASH buffers	68.00	68.00	0.00
shared	CCursor	59.32	243.59	310.67
shared	Cursor Stats	15.20		-100.00
shared	KGH: NO ACCESS	418.34	434.31	3.82
shared	PCursor	40.73	90.03	121.02
shared	free memory	511.48	331.04	-35.28
shared	kglsim object batch	17.87	21.73	21.59
shared	library cache	48.53	70.07	44.38
shared	sql area	199.53	189.82	-4.86
shared	sql area:KOKA		171.86
streams	free memory	16.00	16.00	0.00
	buffer_cache	2,848.00	2,608.00	-8.43
	fixed_sga	2.05	2.05	0.00
	log_buffer	33.00	33.00	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	121,705	0	0
QMON Slaves	52,780	0	0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/app/oracle/admin/PSSDEV3/adump
audit_sys_operations	TRUE
audit_trail	DB
background_dump_dest	/u01/app/oracle/admin/PSSDEV3/bdump
compatible	10.2.0.3.0
control_files	/u1/oradata/PSSDEV3/control01.ctl, /u2/oradata/PSSDEV3/control02.ctl, /u3/oradata/PSSDEV3/control03.ctl
core_dump_dest	/u01/app/oracle/admin/PSSDEV3/cdump
db_block_size	16384
db_cache_size	838860800
db_domain
db_file_multiblock_read_count	16
db_name	PSSDEV3
dispatchers	(PROTOCOL=TCP) (SERVICE=PSSDEV3XDB)
job_queue_processes	10
log_archive_dest_1	LOCATION=/u5/oradata/PSSDEV3/archive
log_archive_format	PSSDEV3_%s_%t_%r.arc
nls_length_semantics	char
open_cursors	600
optimizer_index_caching	75
optimizer_index_cost_adj	25
optimizer_mode	ALL_ROWS
parallel_max_servers	5
pga_aggregate_target	1073741824
processes	300
remote_dependencies_mode	SIGNATURE
remote_login_passwordfile	EXCLUSIVE
sessions	335
sga_max_size	4294967296
sga_target	4294967296
shared_pool_size	419430400
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/u01/app/oracle/admin/PSSDEV3/udump

End of Report =

% Blocks changed per Read:	28.45	Recursive Call %:	99.97
Rollback per transaction %:	1.34	Rows per Sort:	61.57

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.84	In-memory Sort %:	100.00
Library Hit %:	99.76	Soft Parse %:	99.24
Execute to Parse %:	36.86	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	92.13	% Non-Parse CPU:	94.78