WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

MINFO 4214485585 minfo 1 12-Jul-13 11:07 10.2.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
MINFO	4214485585	minfo	1	12-Jul-13 11:07	10.2.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

minfo79 4 2 .00

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
minfo79		4		2	.00

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 17414 19-Jul-13 16:00:31 167 4.4

End Snap: 17415 19-Jul-13 18:00:29 145 5.0

Elapsed: 119.98 (mins)

DB Time: 3,088.02 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	17414	19-Jul-13 16:00:31	167	4.4
End Snap:	17415	19-Jul-13 18:00:29	145	5.0
Elapsed:		119.98 (mins)
DB Time:		3,088.02 (mins)

Report Summary

Cache Sizes

Begin End

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

Shared Pool Size: 124M 124M Log Buffer: 7,000K

	Begin	End
Buffer Cache:	400M	400M	Std Block Size:	8K
Shared Pool Size:	124M	124M	Log Buffer:	7,000K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 25.7 7.8 0.09 0.01

DB CPU(s): 3.2 1.0 0.01 0.00

Redo size: 146,756.7 44,320.3

Logical reads: 68,731.6 20,756.9

Block changes: 1,109.9 335.2

Physical reads: 35,309.5 10,663.4

Physical writes: 98.6 29.8

User calls: 2,313.6 698.7

Parses: 174.6 52.7

Hard parses: 29.7 9.0

W/A MB processed: 0.4 0.1

Logons: 1.7 0.5

Executes: 275.4 83.2

Rollbacks: 0.0 0.0

Transactions: 3.3

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	25.7	7.8	0.09	0.01
DB CPU(s):	3.2	1.0	0.01	0.00
Redo size:	146,756.7	44,320.3
Logical reads:	68,731.6	20,756.9
Block changes:	1,109.9	335.2
Physical reads:	35,309.5	10,663.4
Physical writes:	98.6	29.8
User calls:	2,313.6	698.7
Parses:	174.6	52.7
Hard parses:	29.7	9.0
W/A MB processed:	0.4	0.1
Logons:	1.7	0.5
Executes:	275.4	83.2
Rollbacks:	0.0	0.0
Transactions:	3.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.91 Redo NoWait %: 99.92

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

Library Hit %: 89.92 Soft Parse %: 82.98

Execute to Parse %: 36.59 Latch Hit %: 99.84

Parse CPU to Parse Elapsd %: 26.75 % Non-Parse CPU: 92.65

Shared Pool Statistics

Begin End

Memory Usage %: 98.71 95.56

% SQL with executions>1: 55.06 81.30

% Memory for SQL w/exec>1: 88.45 97.70

	Begin	End
Memory Usage %:	98.71	95.56
% SQL with executions>1:	55.06	81.30
% Memory for SQL w/exec>1:	88.45	97.70

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
db file sequential read	32,186,747	70,129	2	37.85	User I/O
db file scattered read	16,527,779	26,408	2	14.25	User I/O
read by other session	457,248	24,937	55	13.46	User I/O
DB CPU		23,321		12.59
enq: TX - row lock contention	2,552	7,597	2977	4.10	Application

Host CPU (CPUs: 4 Cores: Sockets: 2)

Load Average Begin Load Average End %User %System %WIO %Idle

29.52 24.55 75.4 24.0 0.6

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
29.52	24.55	75.4	24.0		0.6

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)

86.2 86.7 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
86.2	86.7	0.0

Begin End

Host Mem (MB): .1 .1

SGA use (MB): 540.0 540.0

PGA use (MB): 267.1 293.4

% Host Mem used for SGA+PGA: 6.6E+05 6.9E+05

	Begin	End
Host Mem (MB):	.1	.1
SGA use (MB):	540.0	540.0
PGA use (MB):	267.1	293.4
% Host Mem used for SGA+PGA:	6.6E+05	6.9E+05

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
Shared Server Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	173,501.73	93.64
DB CPU	23,321.30	12.59
parse time elapsed	7,673.84	4.14
hard parse elapsed time	5,181.26	2.80
sequence load elapsed time	1,055.33	0.57
connection management call elapsed time	964.03	0.52
PL/SQL compilation elapsed time	519.68	0.28
PL/SQL execution elapsed time	155.75	0.08
hard parse (sharing criteria) elapsed time	146.97	0.08
hard parse (bind mismatch) elapsed time	10.02	0.01
failed parse elapsed time	3.25	0.00
repeated bind elapsed time	2.03	0.00
DB time	185,281.08
background elapsed time	8,238.31
background cpu time	118.40

Back to Wait Events Statistics
Back to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different
ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic	Value	End Value
BUSY_TIME	2,702,305
IDLE_TIME	16,956
NICE_TIME	245
SYS_TIME	652,794
USER_TIME	2,049,266
LOAD	30	25
PHYSICAL_MEMORY_BYTES	127,852	127,072
NUM_CPUS	4
NUM_CPU_SOCKETS	2

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
19-Jul 16:00:31	29.52
19-Jul 18:00:29	24.55	99.38	75.36	24.01	0.62	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 91.9% of Total DB time 185,281.08 (s)
Total FG Wait Time: 147,012.57 (s) DB CPU time: 23,321.30 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
User I/O	49,713,685	0	121,482	2	65.57
DB CPU			23,321		12.59
Concurrency	217,226	0	8,995	41	4.85
Application	4,622	55	7,622	1649	4.11
Commit	25,166	1	3,639	145	1.96
Other	92,725	1	3,309	36	1.79
Network	19,468,530	0	1,121	0	0.60
Configuration	1,392	64	885	636	0.48
System I/O	2,035	0	20	10	0.01

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

s - second, ms - millisecond - 1000th of a second
Only events with Total Wait Time (s) >= .001 are shown
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
db file sequential read	32,186,747	0	70,129	2	1,350.29	37.85
db file scattered read	16,527,779	0	26,408	2	693.37	14.25
read by other session	457,248	0	24,937	55	19.18	13.46
enq: TX - row lock contention	2,552	100	7,597	2977	0.11	4.10
latch: cache buffers chains	130,515	0	6,794	52	5.48	3.67
log file sync	25,166	1	3,639	145	1.06	1.96
latch free	34,778	0	1,633	47	1.46	0.88
latch: library cache	20,525	0	1,111	54	0.86	0.60
latch: cache buffers lru chain	55,509	0	1,104	20	2.33	0.60
SQL*Net more data to client	2,920,088	0	997	0	122.50	0.54
buffer exterminate	497	100	487	979	0.02	0.26
log file switch (checkpoint incomplete)	659	67	482	731	0.03	0.26
row cache lock	49,946	0	295	6	2.10	0.16
latch: shared pool	10,802	0	210	19	0.45	0.11
buffer busy waits	2,327	7	196	84	0.10	0.11
log file switch (private strand flush incomplete)	230	77	195	847	0.01	0.11
library cache pin	981	0	166	169	0.04	0.09
log file switch completion	285	36	155	542	0.01	0.08
enq: TX - index contention	1,269	0	111	87	0.05	0.06
SQL*Net message to client	16,063,079	0	73	0	673.87	0.04
SQL*Net more data from client	485,363	0	51	0	20.36	0.03
library cache load lock	162	1	44	273	0.01	0.02
enq: SQ - contention	23	52	43	1869	0.00	0.02
latch: library cache lock	179	0	35	198	0.01	0.02
SQL*Net break/reset to client	2,070	0	25	12	0.09	0.01
enq: CF - contention	17	12	24	1398	0.00	0.01
buffer deadlock	38	92	19	509	0.00	0.01
control file sequential read	2,032	0	19	9	0.09	0.01
latch: row cache objects	338	0	18	53	0.01	0.01
free buffer waits	192	83	11	58	0.01	0.01
LGWR wait for redo copy	1,122	52	11	9	0.05	0.01
latch: session allocation	79	0	9	109	0.00	0.00
latch: object queue header operation	515	0	7	15	0.02	0.00
latch: library cache pin	131	0	7	53	0.01	0.00
rdbms ipc reply	4	75	7	1710	0.00	0.00
cursor: mutex S	28	0	5	165	0.00	0.00
direct path read	395,513	0	4	0	16.59	0.00
direct path read temp	126,472	0	4	0	5.31	0.00
kksfbc child completion	56	93	3	54	0.00	0.00
latch: enqueue hash chains	49	0	3	56	0.00	0.00
cursor: mutex X	15	0	2	110	0.00	0.00
latch: In memory undo latch	8	0	1	143	0.00	0.00
enq: US - contention	3	0	1	362	0.00	0.00
latch: redo allocation	21	0	1	45	0.00	0.00
latch: undo global data	19	0	1	35	0.00	0.00
log file parallel write	3	0	1	195	0.00	0.00
enq: JS - queue lock	1	0	0	304	0.00	0.00
direct path write temp	19,758	0	0	0	0.83	0.00
enq: HW - contention	3	0	0	85	0.00	0.00
wait list latch free	10	0	0	19	0.00	0.00
latch: messages	2	0	0	62	0.00	0.00
latch: object queue header heap	2	0	0	11	0.00	0.00
latch: checkpoint queue latch	2	0	0	10	0.00	0.00
SGA: allocation forcing component growth	1	0	0	17	0.00	0.00
SQL*Net message from client	16,063,090	0	707,351	44	673.87
dispatcher timer	120	100	7,026	58553	0.01
Streams AQ: waiting for messages in the queue	1,435	100	7,000	4878	0.06
virtual circuit status	239	100	6,980	29206	0.01
wait for unread message on broadcast channel	7,012	100	6,891	983	0.29
jobq slave wait	2,004	96	5,782	2885	0.08
class slave wait	1	100	5	4883	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)
Only events with Total Wait Time (s) >= .001 are shown
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
log file parallel write	26,983	0	2,822	105	1.13	34.25
db file sequential read	11,911	0	860	72	0.50	10.44
control file parallel write	2,959	0	597	202	0.12	7.25
events in waitclass Other	1,899	31	59	31	0.08	0.72
db file scattered read	296	0	40	136	0.01	0.49
os thread startup	59	29	27	456	0.00	0.33
control file sequential read	4,654	0	16	3	0.20	0.20
latch: cache buffers chains	318	0	14	46	0.01	0.18
latch: library cache	159	0	8	51	0.01	0.10
latch: shared pool	177	0	4	20	0.01	0.04
log file single write	46	0	3	72	0.00	0.04
log file switch (checkpoint incomplete)	2	50	1	611	0.00	0.01
log file sequential read	46	0	1	23	0.00	0.01
log file switch completion	3	0	1	239	0.00	0.01
buffer busy waits	5	0	1	125	0.00	0.01
Data file init write	14	0	0	16	0.00	0.00
read by other session	1	0	0	59	0.00	0.00
latch: library cache pin	1	0	0	2	0.00	0.00
direct path read	207	0	0	0	0.01	0.00
rdbms ipc message	47,999	43	54,991	1146	2.01
Streams AQ: waiting for time management or cleanup tasks	9	56	8,407	934144	0.00
pmon timer	4,549	99	7,043	1548	0.19
Streams AQ: qmn slave idle wait	257	0	7,027	27343	0.01
Streams AQ: qmn coordinator idle wait	524	51	7,027	13410	0.02
smon timer	34	53	6,344	186576	0.00
SGA: MMAN sleep for component shrink	622	96	9	15	0.03

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
minfo	175,750	22,718	253,506	491,151
SYS$USERS	9,237	622	814	3,682
SYS$BACKGROUND	0	0	24	151
minfoXDB	0	0	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 seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
minfo	49574248	117008	214757	8868	6048351	51
SYS$USERS	163991	4339	2089	104	13361605	1051
SYS$BACKGROUND	21275	1038	947	69	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 User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
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
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 58.6% of Total DB Time (s): 185,281
Captured PL/SQL account for 17.8% of Total DB Time (s): 185,281

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
17,401.70	2	8,700.85	9.39	1.25	26.93	7cwax5ja3px2f	w3wp.exe	Begin KA_PERLIST_PRO(:v0); End...
17,182.26	3	5,727.42	9.27	1.29	25.27	a9tw7k3t4w1tf	w3wp.exe	DELETE FROM KA_PHONELISTDATA A...
14,134.08	0		7.63	0.21	99.47	7m5pa24sqkymg	windowsservice1.exe	SELECT distinct cellphonenumbe...
6,860.45	186	36.88	3.70	7.78	85.10	6ky8sy37jxwj3	GatewayService.exe	select * from(select mtid, mtt...
6,733.64	36	187.05	3.63	1.19	97.70	039q4phv4kn06	w3wp.exe	begin KA_movetopool_pro; end;
6,606.89	438	15.08	3.57	6.05	86.91	8mq0fd0973kga	GatewayService.exe	select * from(select mtid, mtt...
6,494.32	36	180.40	3.51	1.16	97.77	5475bk0vk65g1	w3wp.exe	SELECT ID, TELNUM, MSGCONTENT,...
6,423.09	471	13.64	3.47	4.75	89.03	3nhnpk09bqjvb	GatewayService.exe	select * from(select mtid, mtt...
5,514.58	304	18.14	2.98	46.48	37.88	1muhv8tf83ubf	w3wp.exe	begin m_momutual_pro; end;
4,973.53	2,070	2.40	2.68	10.65	75.79	dmapqnhh3y0rr	GatewayService.exe	select * from(select * from mt...
4,965.07	2,073	2.40	2.68	10.70	75.97	bj0ps0v1d8rz0	GatewayService.exe	select * from(select * from mt...
4,160.35	7	594.34	2.25	11.17	59.26	g8u5mwrmgduz6	w3wp.exe	insert into Ka_PhonelistData (...
3,614.84	3,464	1.04	1.95	57.10	30.58	1219g9d5xkj5k	GatewayService.exe	select * from (select mtid , m...
3,560.56	3,536	1.01	1.92	46.43	27.17	15v8nnr6xdwzt	GatewayService.exe	select * from(select mtid, mtt...
3,306.56	2,721	1.22	1.78	55.58	33.49	8ztar1sumtc48	GatewayService.exe	begin GetSmsMo(MO_CS=>:MO_CS, ...
3,275.93	2,722	1.20	1.77	55.88	33.38	g94998wamfgyy	GatewayService.exe	UPDATE MOSMSPOOL SET MOSTATUS=...
2,907.45	23	126.41	1.57	1.66	98.13	cv6dvb45t88ds	GatewayService.exe	select * from(select mtid, mtt...
2,710.24	1	2,710.24	1.46	2.49	64.46	437tknshytsgw	exp@minfo79 (TNS V1-V3)	SELECT /*+NESTED_TABLE_GET_REF...
1,925.43	5,162	0.37	1.04	43.76	23.26	7sptz77m9g11h	GatewayService.exe	select * from(select mtid, mtt...

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 - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 69.5% of Total CPU Time (s): 23,321
Captured PL/SQL account for 20.1% of Total CPU Time (s): 23,321

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,563.00	304	8.43	10.99	5,514.58	46.48	37.88	1muhv8tf83ubf	w3wp.exe	begin m_momutual_pro; end;
2,064.09	3,464	0.60	8.85	3,614.84	57.10	30.58	1219g9d5xkj5k	GatewayService.exe	select * from (select mtid , m...
1,837.62	2,721	0.68	7.88	3,306.56	55.58	33.49	8ztar1sumtc48	GatewayService.exe	begin GetSmsMo(MO_CS=>:MO_CS, ...
1,830.57	2,722	0.67	7.85	3,275.93	55.88	33.38	g94998wamfgyy	GatewayService.exe	UPDATE MOSMSPOOL SET MOSTATUS=...
1,653.18	3,536	0.47	7.09	3,560.56	46.43	27.17	15v8nnr6xdwzt	GatewayService.exe	select * from(select mtid, mtt...
842.57	5,162	0.16	3.61	1,925.43	43.76	23.26	7sptz77m9g11h	GatewayService.exe	select * from(select mtid, mtt...
834.11	5,349	0.16	3.58	1,739.78	47.94	12.72	acmbnggz3s3sq	GatewayService.exe	select * from(select mtid, mtt...
813.63	5,531	0.15	3.49	1,547.30	52.58	7.08	gxvcgmwzuw076	GatewayService.exe	select * from(select mtid, mtt...
762.81	52,258	0.01	3.27	1,114.93	68.42	0.14	fmfsxc8bkp7jt	w3wp.exe	select QUEUEID, CELLPHONE, BUS...
534.05	186	2.87	2.29	6,860.45	7.78	85.10	6ky8sy37jxwj3	GatewayService.exe	select * from(select mtid, mtt...
531.13	2,073	0.26	2.28	4,965.07	10.70	75.97	bj0ps0v1d8rz0	GatewayService.exe	select * from(select * from mt...
529.92	2,070	0.26	2.27	4,973.53	10.65	75.79	dmapqnhh3y0rr	GatewayService.exe	select * from(select * from mt...
479.09	7,240	0.07	2.05	845.93	56.63	34.55	acxbsus2u3vyp	w3wp.exe	Select * from adwap_page where...
464.61	7	66.37	1.99	4,160.35	11.17	59.26	g8u5mwrmgduz6	w3wp.exe	insert into Ka_PhonelistData (...
400.03	438	0.91	1.72	6,606.89	6.05	86.91	8mq0fd0973kga	GatewayService.exe	select * from(select mtid, mtt...
304.83	471	0.65	1.31	6,423.09	4.75	89.03	3nhnpk09bqjvb	GatewayService.exe	select * from(select mtid, mtt...
304.11	399	0.76	1.30	376.55	80.76	29.71	3vafxbbtnsmr4	GatewayService.exe	SELECT * FROM MOSMSPOOL WHERE ...
272.73	304	0.90	1.17	617.72	44.15	47.24	gdpbn3z7r88jr	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
267.09	304	0.88	1.15	494.83	53.97	35.87	8jpppj79wmxyn	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
257.37	304	0.85	1.10	563.66	45.66	36.24	2kvfbnkhck0n9	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
256.60	304	0.84	1.10	494.94	51.84	37.07	15grg1furvscg	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
252.91	304	0.83	1.08	549.47	46.03	36.36	9acck5jxvqtwp	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
251.98	304	0.83	1.08	515.62	48.87	37.53	9n8fbbaddhxk5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
251.15	303	0.83	1.08	564.22	44.51	36.87	ccuxk4ndnnwty	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
250.97	303	0.83	1.08	557.06	45.05	35.67	g8cnhk1k96nn8	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
250.39	303	0.83	1.07	570.37	43.90	37.12	98dmu012znzf5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
248.21	304	0.82	1.06	562.52	44.12	36.98	5z5q40njkk2bv	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
242.36	6,638	0.04	1.04	449.23	53.95	9.13	dcgmphux367vq	GatewayService.exe	select * from(select mtid, mtt...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 56.1% of Total User I/O Wait Time (s): 122,382
Captured PL/SQL account for 11.8% of Total User I/O Wait Time (s): 122,382

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
14,059.08	0		11.49	14,134.08	0.21	99.47	7m5pa24sqkymg	windowsservice1.exe	SELECT distinct cellphonenumbe...
6,578.50	36	182.74	5.38	6,733.64	1.19	97.70	039q4phv4kn06	w3wp.exe	begin KA_movetopool_pro; end;
6,349.81	36	176.38	5.19	6,494.32	1.16	97.77	5475bk0vk65g1	w3wp.exe	SELECT ID, TELNUM, MSGCONTENT,...
5,838.40	186	31.39	4.77	6,860.45	7.78	85.10	6ky8sy37jxwj3	GatewayService.exe	select * from(select mtid, mtt...
5,742.23	438	13.11	4.69	6,606.89	6.05	86.91	8mq0fd0973kga	GatewayService.exe	select * from(select mtid, mtt...
5,718.29	471	12.14	4.67	6,423.09	4.75	89.03	3nhnpk09bqjvb	GatewayService.exe	select * from(select mtid, mtt...
4,686.98	2	2,343.49	3.83	17,401.70	1.25	26.93	7cwax5ja3px2f	w3wp.exe	Begin KA_PERLIST_PRO(:v0); End...
4,341.77	3	1,447.26	3.55	17,182.26	1.29	25.27	a9tw7k3t4w1tf	w3wp.exe	DELETE FROM KA_PHONELISTDATA A...
3,771.86	2,073	1.82	3.08	4,965.07	10.70	75.97	bj0ps0v1d8rz0	GatewayService.exe	select * from(select * from mt...
3,769.48	2,070	1.82	3.08	4,973.53	10.65	75.79	dmapqnhh3y0rr	GatewayService.exe	select * from(select * from mt...
2,853.01	23	124.04	2.33	2,907.45	1.66	98.13	cv6dvb45t88ds	GatewayService.exe	select * from(select mtid, mtt...
2,465.50	7	352.21	2.01	4,160.35	11.17	59.26	g8u5mwrmgduz6	w3wp.exe	insert into Ka_PhonelistData (...
2,088.79	304	6.87	1.71	5,514.58	46.48	37.88	1muhv8tf83ubf	w3wp.exe	begin m_momutual_pro; end;
1,747.02	1	1,747.02	1.43	2,710.24	2.49	64.46	437tknshytsgw	exp@minfo79 (TNS V1-V3)	SELECT /*+NESTED_TABLE_GET_REF...

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 as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 494,780,946
Captured SQL account for 73.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
62,932,507	304	207,014.83	12.72	5,514.58	46.5	37.9	1muhv8tf83ubf	w3wp.exe	begin m_momutual_pro; end;
40,542,656	3,464	11,704.00	8.19	3,614.84	57.1	30.6	1219g9d5xkj5k	GatewayService.exe	select * from (select mtid , m...
38,993,507	2,721	14,330.58	7.88	3,306.56	55.6	33.5	8ztar1sumtc48	GatewayService.exe	begin GetSmsMo(MO_CS=>:MO_CS, ...
38,988,525	2,722	14,323.48	7.88	3,275.93	55.9	33.4	g94998wamfgyy	GatewayService.exe	UPDATE MOSMSPOOL SET MOSTATUS=...
38,903,261	3,536	11,002.05	7.86	3,560.56	46.4	27.2	15v8nnr6xdwzt	GatewayService.exe	select * from(select mtid, mtt...
23,829,203	5,349	4,454.89	4.82	1,739.78	47.9	12.7	acmbnggz3s3sq	GatewayService.exe	select * from(select mtid, mtt...
22,323,773	2,073	10,768.82	4.51	4,965.07	10.7	76	bj0ps0v1d8rz0	GatewayService.exe	select * from(select * from mt...
22,283,959	2,070	10,765.20	4.50	4,973.53	10.7	75.8	dmapqnhh3y0rr	GatewayService.exe	select * from(select * from mt...
20,462,132	5,162	3,963.99	4.14	1,925.43	43.8	23.3	7sptz77m9g11h	GatewayService.exe	select * from(select mtid, mtt...
17,497,972	5,531	3,163.62	3.54	1,547.30	52.6	7.1	gxvcgmwzuw076	GatewayService.exe	select * from(select mtid, mtt...
12,831,052	7,240	1,772.24	2.59	845.93	56.6	34.5	acxbsus2u3vyp	w3wp.exe	Select * from adwap_page where...
10,514,672	52,258	201.21	2.13	1,114.93	68.4	.1	fmfsxc8bkp7jt	w3wp.exe	select QUEUEID, CELLPHONE, BUS...
7,756,092	186	41,699.42	1.57	6,860.45	7.8	85.1	6ky8sy37jxwj3	GatewayService.exe	select * from(select mtid, mtt...
7,250,944	7	1,035,849.14	1.47	4,160.35	11.2	59.3	g8u5mwrmgduz6	w3wp.exe	insert into Ka_PhonelistData (...
6,314,312	304	20,770.76	1.28	617.72	44.2	47.2	gdpbn3z7r88jr	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
6,300,433	304	20,725.11	1.27	494.83	54	35.9	8jpppj79wmxyn	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
6,300,301	304	20,724.67	1.27	563.66	45.7	36.2	2kvfbnkhck0n9	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
6,299,788	304	20,722.99	1.27	494.94	51.8	37.1	15grg1furvscg	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
6,299,717	304	20,722.75	1.27	515.62	48.9	37.5	9n8fbbaddhxk5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
6,299,705	304	20,722.71	1.27	549.47	46	36.4	9acck5jxvqtwp	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
6,299,681	304	20,722.63	1.27	562.52	44.1	37	5z5q40njkk2bv	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
6,279,887	303	20,725.70	1.27	564.22	44.5	36.9	ccuxk4ndnnwty	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
6,279,314	303	20,723.81	1.27	557.06	45.1	35.7	g8cnhk1k96nn8	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
6,278,851	303	20,722.28	1.27	570.37	43.9	37.1	98dmu012znzf5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
5,999,118	438	13,696.62	1.21	6,606.89	6.1	86.9	8mq0fd0973kga	GatewayService.exe	select * from(select mtid, mtt...
5,923,605	471	12,576.66	1.20	6,423.09	4.7	89	3nhnpk09bqjvb	GatewayService.exe	select * from(select mtid, mtt...
5,804,979	6,638	874.51	1.17	449.23	53.9	9.1	dcgmphux367vq	GatewayService.exe	select * from(select mtid, mtt...
5,456,774	399	13,676.13	1.10	376.55	80.8	29.7	3vafxbbtnsmr4	GatewayService.exe	SELECT * FROM MOSMSPOOL WHERE ...
5,027,133	2	2,513,566.50	1.02	17,401.70	1.3	26.9	7cwax5ja3px2f	w3wp.exe	Begin KA_PERLIST_PRO(:v0); End...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 254,183,590
Captured SQL account for 71.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
59,862,360	304	196,915.66	23.55	5,514.58	46.48	37.88	1muhv8tf83ubf	w3wp.exe	begin m_momutual_pro; end;
37,663,361	2,722	13,836.65	14.82	3,275.93	55.88	33.38	g94998wamfgyy	GatewayService.exe	UPDATE MOSMSPOOL SET MOSTATUS=...
37,650,255	2,721	13,836.92	14.81	3,306.56	55.58	33.49	8ztar1sumtc48	GatewayService.exe	begin GetSmsMo(MO_CS=>:MO_CS, ...
37,049,179	3,464	10,695.49	14.58	3,614.84	57.10	30.58	1219g9d5xkj5k	GatewayService.exe	select * from (select mtid , m...
10,855,258	7,240	1,499.35	4.27	845.93	56.63	34.55	acxbsus2u3vyp	w3wp.exe	Select * from adwap_page where...
8,955,491	3,536	2,532.66	3.52	3,560.56	46.43	27.17	15v8nnr6xdwzt	GatewayService.exe	select * from(select mtid, mtt...
7,601,789	186	40,869.83	2.99	6,860.45	7.78	85.10	6ky8sy37jxwj3	GatewayService.exe	select * from(select mtid, mtt...
6,169,964	304	20,295.93	2.43	617.72	44.15	47.24	gdpbn3z7r88jr	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
6,014,175	304	19,783.47	2.37	494.83	53.97	35.87	8jpppj79wmxyn	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
5,996,255	304	19,724.52	2.36	494.94	51.84	37.07	15grg1furvscg	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
5,985,871	304	19,690.37	2.35	515.62	48.87	37.53	9n8fbbaddhxk5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
5,975,109	304	19,654.96	2.35	549.47	46.03	36.36	9acck5jxvqtwp	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
5,968,804	304	19,634.22	2.35	562.52	44.12	36.98	5z5q40njkk2bv	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
5,962,489	304	19,613.45	2.35	563.66	45.66	36.24	2kvfbnkhck0n9	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
5,959,122	303	19,667.07	2.34	570.37	43.90	37.12	98dmu012znzf5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
5,941,170	303	19,607.82	2.34	564.22	44.51	36.87	ccuxk4ndnnwty	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
5,914,766	303	19,520.68	2.33	557.06	45.05	35.67	g8cnhk1k96nn8	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
5,218,948	399	13,080.07	2.05	376.55	80.76	29.71	3vafxbbtnsmr4	GatewayService.exe	SELECT * FROM MOSMSPOOL WHERE ...
4,459,500	438	10,181.51	1.75	6,606.89	6.05	86.91	8mq0fd0973kga	GatewayService.exe	select * from(select mtid, mtt...
3,189,681	471	6,772.15	1.25	6,423.09	4.75	89.03	3nhnpk09bqjvb	GatewayService.exe	select * from(select mtid, mtt...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 49,039,613
Captured SQL account for % of Total
Total UnOptimized Read Requests: 1
Captured SQL account for % of Total
Total Optimized Read Requests: 1
Captured SQL account for % of Total

Executions	SQL Id	SQL Module	SQL Text
36	039q4phv4kn06	w3wp.exe	begin KA_movetopool_pro; end;
5,163	04xtrk7uyhknh		select obj#, type#, ctime, mti...
893	0fr8zhn4ymu3v		select intcol#, type, flags, l...
33,633	0h6b2sajwb74n		select privilege#, level from ...
11,189	0k8522rmdzg4k		select privilege# from sysauth...
12,063	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
3,464	1219g9d5xkj5k	GatewayService.exe	select * from (select mtid , m...
17	130dvvr5s8bgn		select obj#, dataobj#, part#, ...
0	14rxuqktwyz1z	exp@minfo79 (TNS V1-V3)	SELECT OBJID, NAME, OWNER, OWN...
304	15grg1furvscg	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 1,982,324
Captured SQL account for 46.8% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
339,910	339,910	1.00	534.69	28.9	2.4	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
54,083	58,336	1.08	92.00	10.8	60.2	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
52,258	0	0.00	1,114.93	68.4	.1	fmfsxc8bkp7jt	w3wp.exe	select QUEUEID, CELLPHONE, BUS...
33,633	288,286	8.57	283.71	43.1	.8	0h6b2sajwb74n		select privilege#, level from ...
28,338	0	0.00	29.86	22.3	0	a3pdtfwpb4tyv	GatewayService.exe	select * from(select mtid, mtt...
21,498	34,711	1.61	38.62	14.6	40.2	6769wyy3yf66f		select pos#, intcol#, col#, sp...
21,285	17,198	0.81	409.56	1.6	95.5	96g93hntrzjtr		select /+ rule / bucket_cnt,...
16,944	282,252	16.66	548.40	1.8	96.5	db78fxqxwxt7r		select /+ rule / bucket, end...
16,059	177,064	11.03	78.61	12.8	68.4	83taa7kaw59c1		select name, intcol#, segcol#,...
14,210	0	0.00	20.60	16.7	0	6q7mub24skb40	GatewayService.exe	select * from(select mtid, cel...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,256,949
Captured SQL account for 62.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
339,911	339,910	27.04	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
52,258	52,258	4.16	fmfsxc8bkp7jt	w3wp.exe	select QUEUEID, CELLPHONE, BUS...
33,539	33,633	2.67	0h6b2sajwb74n		select privilege#, level from ...
28,338	28,338	2.25	a3pdtfwpb4tyv	GatewayService.exe	select * from(select mtid, mtt...
14,210	14,210	1.13	6q7mub24skb40	GatewayService.exe	select * from(select mtid, cel...
14,163	14,163	1.13	9jks316cgtwa2	GatewayService.exe	select * from (select mtid , c...
14,123	14,123	1.12	9t96w63r4kjkg	GatewayService.exe	select * from (select mtid , m...
12,063	12,063	0.96	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
12,019	12,019	0.96	459f3z9u4fb3u		select value$ from props$ wher...
11,088	11,189	0.88	0k8522rmdzg4k		select privilege# from sysauth...

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
4,299,178	14,197	3.31	7ng34ruy5awxq	select i.obj#, i.ts#, i.file#,...
2,895,396	33,633	2.23	0h6b2sajwb74n	select privilege#, level from ...
1,986,606	238	1.53	aykvshm7zsabd	select size_for_estimate, size...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
113	114	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

039q4phv4kn06 begin KA_movetopool_pro; end;

04xtrk7uyhknh select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

0fr8zhn4ymu3v select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc

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

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

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')

1219g9d5xkj5k select * from (select mtid , mttag, cellphone , message, pushmethod, pushlink from mtsmsgroup where mtstatus ='0' and projectid in( '610000') order by mtid)where rownum<50

130dvvr5s8bgn select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#

14rxuqktwyz1z SELECT OBJID, NAME, OWNER, OWNERID, TABLESPACE, TSNO, FILENO, BLOCKNO, AUDIT$, COMMENT$, CLUSTERFLAG, PCTFREE$, PCTUSED$, INITRANS, MAXTRANS, DEGREE, INSTANCES, CACHE, PROPERTY, DEFLOG, TSDEFLOG, ROID, ROWCNT, BLKCNT, AVGRLEN, TFLAGS, TRIGFLAG, OBJSTATUS, XDBOOL FROM SYS.EXU10TAB T$ WHERE OWNERID = :1 AND NOT EXISTS ( SELECT NAME FROM SYS.EXU8NXP N$ WHERE N$.OWNERID = T$.OWNERID AND N$.NAME = T$.NAME AND N$.TYPE = 2) ORDER BY T$.XDBOOL DESC, T$.NAME

15grg1furvscg INSERT INTO KEYACCOUNT.MTSMSPOOL(CELLPHONE, MESSAGE, MTTIME, PUSHMETHOD, PROJECTID, MTTAG) SELECT MOBILE, CONTENT, SYSDATE, 'SMS', CHANNEL, LPAD(LPAD(QUEUEID, 8, '0'), 10, 'MV')||LPAD(LPAD(TEMPLATEID, 5, '0'), 6, 'E') FROM M_MTQUEUE WHERE STATUS=0 AND CATEGORY='????'

15v8nnr6xdwzt select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '300000') order by isfirst desc nulls last, mtid asc) where rownum<100

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

1muhv8tf83ubf begin m_momutual_pro; end;

2kvfbnkhck0n9 INSERT INTO KEYACCOUNT.MTSMSPOOL(CELLPHONE, MESSAGE, MTTIME, PUSHMETHOD, PROJECTID, MTTAG) SELECT MOBILE, CONTENT, SYSDATE, 'SMS', CHANNEL, LPAD(LPAD(QUEUEID, 8, '0'), 10, 'ML')||LPAD(LPAD(TEMPLATEID, 5, '0'), 6, 'E') FROM M_MTQUEUE WHERE STATUS=0 AND CATEGORY='????'

3nhnpk09bqjvb select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '111111', '202101', '202102') order by isfirst desc nulls last, mtid asc) where rownum<100

3vafxbbtnsmr4 SELECT * FROM MOSMSPOOL WHERE MOSTATUS=:B1

437tknshytsgw SELECT /*+NESTED_TABLE_GET_REFS+*/ "MINFODB"."USERS".* FROM "MINFODB"."USERS"

459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'

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

53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1

5475bk0vk65g1 SELECT ID, TELNUM, MSGCONTENT, PRIORRANK, PROJECTID, MSGCOUNT FROM KA_MTSMSLIST WHERE SENTSTATE=0 AND AUDITSTATE=0 AND SENTTIME<SYSDATE

5z5q40njkk2bv UPDATE M_MTQUEUE SET STATUS=1 WHERE STATUS=0 AND CATEGORY='????'

6769wyy3yf66f select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1

6ky8sy37jxwj3 select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '205101') order by isfirst desc nulls last, mtid asc) where rownum<100

6q7mub24skb40 select * from(select mtid, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ('') order by isfirst desc nulls last, mtid asc) where rownum<100

7cwax5ja3px2f Begin KA_PERLIST_PRO(:v0); End;

7m5pa24sqkymg SELECT distinct cellphonenumber FROM users where ((homeaddresscity=' ') or (HomeAddressState=' ')) and (length(CellPhoneNumber)=11) and ((CellPhoneNumber like '13%') or (CellPhoneNumber like '15%'))

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#

7sptz77m9g11h select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '500002') order by isfirst desc nulls last, mtid asc) where rownum<100

83taa7kaw59c1 select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#

8jpppj79wmxyn UPDATE M_MTQUEUE SET STATUS=1 WHERE STATUS=0 AND CATEGORY='????'

8mq0fd0973kga select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '500001') order by isfirst desc nulls last, mtid asc) where rownum<100

8ztar1sumtc48 begin GetSmsMo(MO_CS=>:MO_CS, ServerID=>:ServerID); end;

96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

98dmu012znzf5 UPDATE M_MTQUEUE SET STATUS=1 WHERE STATUS=0 AND CATEGORY='????'

9acck5jxvqtwp UPDATE M_MTQUEUE SET STATUS=1 WHERE STATUS=0 AND CATEGORY='????'

9jks316cgtwa2 select * from (select mtid , cellphone , message, pushmethod, pushlink from mtsmsgroup where mtstatus ='0' and projectid in('') order by mtid)where rownum<100

9n8fbbaddhxk5 UPDATE M_MTQUEUE SET STATUS=1 WHERE STATUS=0 AND CATEGORY='????'

9t96w63r4kjkg select * from (select mtid , mttag, cellphone , message, pushmethod, pushlink from mtsmsgroup where mtstatus ='0' and projectid in('') order by mtid)where rownum<50

a3pdtfwpb4tyv select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ('') order by isfirst desc nulls last, mtid asc) where rownum<100

a9tw7k3t4w1tf DELETE FROM KA_PHONELISTDATA A WHERE A.ID!=(SELECT MIN(ID) FROM KA_PHONELISTDATA B WHERE A.TELNUM=B.TELNUM AND A.GROUPID=B.GROUPID)

acmbnggz3s3sq select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '610000') order by isfirst desc nulls last, mtid asc) where rownum<100

acxbsus2u3vyp Select * from adwap_page where targetid=118 and layout='M' order by sequence asc

aykvshm7zsabd select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'

bj0ps0v1d8rz0 select * from(select * from mtmmspool where mtstatus='0' and projectid in ( '200491', '200492', '200401', '200450', '200455', '200460', '200451', '200454', '200461', '200420', '200488', '200489', '200490', '200470', '200421', '200422', '200423', '200430', '200424', '200425', '200494', '200402', '200403', '200404', '200405', '202401', '111113', '202901', '200495', '200410', '203010', '203801', '200496', '200497', '205103') order by mtid) where rownum<100

ccuxk4ndnnwty INSERT INTO KEYACCOUNT.MTSMSPOOL(CELLPHONE, MESSAGE, MTTIME, PUSHMETHOD, PROJECTID, MTTAG) SELECT MOBILE, CONTENT, SYSDATE, 'SMS', CHANNEL, LPAD(LPAD(QUEUEID, 8, '0'), 10, 'MF') ||LPAD(LPAD(TEMPLATEID, 5, '0'), 6, 'E') FROM M_MTQUEUE WHERE STATUS=0 AND CATEGORY='????'

cv6dvb45t88ds select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '500000') order by isfirst desc nulls last, mtid asc) where rownum<100

db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

dcgmphux367vq select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '201401', '110011', '111188') order by isfirst desc nulls last, mtid asc) where rownum<100

dmapqnhh3y0rr select * from(select * from mtmmspool where mtstatus='0' and projectid in ( '111111', '201401', '111188') order by mtid) where rownum<100

fmfsxc8bkp7jt select QUEUEID, CELLPHONE, BUSINESSCODE, LINKID, SERVICENUMBER, MESSAGE, PUSHMETHOD, PUSHLINK from CHSENDSMSQUEUE where MtStatus<>'deliver' and ClientApp = 'SmartClub' order by QUEUEID Asc

g8cnhk1k96nn8 INSERT INTO KEYACCOUNT.MTSMSPOOL(CELLPHONE, MESSAGE, MTTIME, PUSHMETHOD, PROJECTID, MTTAG) SELECT MOBILE, CONTENT, SYSDATE, 'SMS', CHANNEL, LPAD(LPAD(QUEUEID, 8, '0'), 10, 'ME') ||LPAD(LPAD(TEMPLATEID, 5, '0'), 6, 'E') FROM M_MTQUEUE WHERE STATUS=0 AND CATEGORY='????'

g8u5mwrmgduz6 insert into Ka_PhonelistData (groupId, telnum, telname, auditstate, addtime) values(:groupId1, :tlenum1, :telname1, :auditstate1, :addtime1)

g94998wamfgyy UPDATE MOSMSPOOL SET MOSTATUS=:B1 WHERE MOID IN(SELECT MOID FROM (SELECT MOID FROM MOSMSPOOL WHERE MOSTATUS='0' ORDER BY MOID) WHERE ROWNUM <100)

gdpbn3z7r88jr INSERT INTO KEYACCOUNT.MTSMSPOOL(CELLPHONE, MESSAGE, MTTIME, PUSHMETHOD, PROJECTID, MTTAG) SELECT MOBILE, CONTENT, SYSDATE, 'SMS', CHANNEL, LPAD(LPAD(QUEUEID, 8, '0'), 10, 'MM')||LPAD(LPAD(TEMPLATEID, 5, '0'), 6, 'E') FROM M_MTQUEUE WHERE STATUS=0 AND CATEGORY='????'

gxvcgmwzuw076 select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '500003') order by isfirst desc nulls last, mtid asc) where rownum<100

SQL Id	SQL Text
039q4phv4kn06	begin KA_movetopool_pro; end;
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0fr8zhn4ymu3v	select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
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')
1219g9d5xkj5k	select * from (select mtid , mttag, cellphone , message, pushmethod, pushlink from mtsmsgroup where mtstatus ='0' and projectid in( '610000') order by mtid)where rownum<50
130dvvr5s8bgn	select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#
14rxuqktwyz1z	SELECT OBJID, NAME, OWNER, OWNERID, TABLESPACE, TSNO, FILENO, BLOCKNO, AUDIT$, COMMENT$, CLUSTERFLAG, PCTFREE$, PCTUSED$, INITRANS, MAXTRANS, DEGREE, INSTANCES, CACHE, PROPERTY, DEFLOG, TSDEFLOG, ROID, ROWCNT, BLKCNT, AVGRLEN, TFLAGS, TRIGFLAG, OBJSTATUS, XDBOOL FROM SYS.EXU10TAB T$ WHERE OWNERID = :1 AND NOT EXISTS ( SELECT NAME FROM SYS.EXU8NXP N$ WHERE N$.OWNERID = T$.OWNERID AND N$.NAME = T$.NAME AND N$.TYPE = 2) ORDER BY T$.XDBOOL DESC, T$.NAME
15grg1furvscg	INSERT INTO KEYACCOUNT.MTSMSPOOL(CELLPHONE, MESSAGE, MTTIME, PUSHMETHOD, PROJECTID, MTTAG) SELECT MOBILE, CONTENT, SYSDATE, 'SMS', CHANNEL, LPAD(LPAD(QUEUEID, 8, '0'), 10, 'MV')\|\|LPAD(LPAD(TEMPLATEID, 5, '0'), 6, 'E') FROM M_MTQUEUE WHERE STATUS=0 AND CATEGORY='????'
15v8nnr6xdwzt	select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '300000') order by isfirst desc nulls last, mtid asc) where rownum<100
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))
1muhv8tf83ubf	begin m_momutual_pro; end;
2kvfbnkhck0n9	INSERT INTO KEYACCOUNT.MTSMSPOOL(CELLPHONE, MESSAGE, MTTIME, PUSHMETHOD, PROJECTID, MTTAG) SELECT MOBILE, CONTENT, SYSDATE, 'SMS', CHANNEL, LPAD(LPAD(QUEUEID, 8, '0'), 10, 'ML')\|\|LPAD(LPAD(TEMPLATEID, 5, '0'), 6, 'E') FROM M_MTQUEUE WHERE STATUS=0 AND CATEGORY='????'
3nhnpk09bqjvb	select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '111111', '202101', '202102') order by isfirst desc nulls last, mtid asc) where rownum<100
3vafxbbtnsmr4	SELECT * FROM MOSMSPOOL WHERE MOSTATUS=:B1
437tknshytsgw	SELECT /+NESTED_TABLE_GET_REFS+/ "MINFODB"."USERS".* FROM "MINFODB"."USERS"
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
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
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5475bk0vk65g1	SELECT ID, TELNUM, MSGCONTENT, PRIORRANK, PROJECTID, MSGCOUNT FROM KA_MTSMSLIST WHERE SENTSTATE=0 AND AUDITSTATE=0 AND SENTTIME<SYSDATE
5z5q40njkk2bv	UPDATE M_MTQUEUE SET STATUS=1 WHERE STATUS=0 AND CATEGORY='????'
6769wyy3yf66f	select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6ky8sy37jxwj3	select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '205101') order by isfirst desc nulls last, mtid asc) where rownum<100
6q7mub24skb40	select * from(select mtid, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ('') order by isfirst desc nulls last, mtid asc) where rownum<100
7cwax5ja3px2f	Begin KA_PERLIST_PRO(:v0); End;
7m5pa24sqkymg	SELECT distinct cellphonenumber FROM users where ((homeaddresscity=' ') or (HomeAddressState=' ')) and (length(CellPhoneNumber)=11) and ((CellPhoneNumber like '13%') or (CellPhoneNumber like '15%'))
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#
7sptz77m9g11h	select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '500002') order by isfirst desc nulls last, mtid asc) where rownum<100
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8jpppj79wmxyn	UPDATE M_MTQUEUE SET STATUS=1 WHERE STATUS=0 AND CATEGORY='????'
8mq0fd0973kga	select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '500001') order by isfirst desc nulls last, mtid asc) where rownum<100
8ztar1sumtc48	begin GetSmsMo(MO_CS=>:MO_CS, ServerID=>:ServerID); end;
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
98dmu012znzf5	UPDATE M_MTQUEUE SET STATUS=1 WHERE STATUS=0 AND CATEGORY='????'
9acck5jxvqtwp	UPDATE M_MTQUEUE SET STATUS=1 WHERE STATUS=0 AND CATEGORY='????'
9jks316cgtwa2	select * from (select mtid , cellphone , message, pushmethod, pushlink from mtsmsgroup where mtstatus ='0' and projectid in('') order by mtid)where rownum<100
9n8fbbaddhxk5	UPDATE M_MTQUEUE SET STATUS=1 WHERE STATUS=0 AND CATEGORY='????'
9t96w63r4kjkg	select * from (select mtid , mttag, cellphone , message, pushmethod, pushlink from mtsmsgroup where mtstatus ='0' and projectid in('') order by mtid)where rownum<50
a3pdtfwpb4tyv	select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ('') order by isfirst desc nulls last, mtid asc) where rownum<100
a9tw7k3t4w1tf	DELETE FROM KA_PHONELISTDATA A WHERE A.ID!=(SELECT MIN(ID) FROM KA_PHONELISTDATA B WHERE A.TELNUM=B.TELNUM AND A.GROUPID=B.GROUPID)
acmbnggz3s3sq	select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '610000') order by isfirst desc nulls last, mtid asc) where rownum<100
acxbsus2u3vyp	Select * from adwap_page where targetid=118 and layout='M' order by sequence asc
aykvshm7zsabd	select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
bj0ps0v1d8rz0	select * from(select * from mtmmspool where mtstatus='0' and projectid in ( '200491', '200492', '200401', '200450', '200455', '200460', '200451', '200454', '200461', '200420', '200488', '200489', '200490', '200470', '200421', '200422', '200423', '200430', '200424', '200425', '200494', '200402', '200403', '200404', '200405', '202401', '111113', '202901', '200495', '200410', '203010', '203801', '200496', '200497', '205103') order by mtid) where rownum<100
ccuxk4ndnnwty	INSERT INTO KEYACCOUNT.MTSMSPOOL(CELLPHONE, MESSAGE, MTTIME, PUSHMETHOD, PROJECTID, MTTAG) SELECT MOBILE, CONTENT, SYSDATE, 'SMS', CHANNEL, LPAD(LPAD(QUEUEID, 8, '0'), 10, 'MF') \|\|LPAD(LPAD(TEMPLATEID, 5, '0'), 6, 'E') FROM M_MTQUEUE WHERE STATUS=0 AND CATEGORY='????'
cv6dvb45t88ds	select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '500000') order by isfirst desc nulls last, mtid asc) where rownum<100
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dcgmphux367vq	select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '201401', '110011', '111188') order by isfirst desc nulls last, mtid asc) where rownum<100
dmapqnhh3y0rr	select * from(select * from mtmmspool where mtstatus='0' and projectid in ( '111111', '201401', '111188') order by mtid) where rownum<100
fmfsxc8bkp7jt	select QUEUEID, CELLPHONE, BUSINESSCODE, LINKID, SERVICENUMBER, MESSAGE, PUSHMETHOD, PUSHLINK from CHSENDSMSQUEUE where MtStatus<>'deliver' and ClientApp = 'SmartClub' order by QUEUEID Asc
g8cnhk1k96nn8	INSERT INTO KEYACCOUNT.MTSMSPOOL(CELLPHONE, MESSAGE, MTTIME, PUSHMETHOD, PROJECTID, MTTAG) SELECT MOBILE, CONTENT, SYSDATE, 'SMS', CHANNEL, LPAD(LPAD(QUEUEID, 8, '0'), 10, 'ME') \|\|LPAD(LPAD(TEMPLATEID, 5, '0'), 6, 'E') FROM M_MTQUEUE WHERE STATUS=0 AND CATEGORY='????'
g8u5mwrmgduz6	insert into Ka_PhonelistData (groupId, telnum, telname, auditstate, addtime) values(:groupId1, :tlenum1, :telname1, :auditstate1, :addtime1)
g94998wamfgyy	UPDATE MOSMSPOOL SET MOSTATUS=:B1 WHERE MOID IN(SELECT MOID FROM (SELECT MOID FROM MOSMSPOOL WHERE MOSTATUS='0' ORDER BY MOID) WHERE ROWNUM <100)
gdpbn3z7r88jr	INSERT INTO KEYACCOUNT.MTSMSPOOL(CELLPHONE, MESSAGE, MTTIME, PUSHMETHOD, PROJECTID, MTTAG) SELECT MOBILE, CONTENT, SYSDATE, 'SMS', CHANNEL, LPAD(LPAD(QUEUEID, 8, '0'), 10, 'MM')\|\|LPAD(LPAD(TEMPLATEID, 5, '0'), 6, 'E') FROM M_MTQUEUE WHERE STATUS=0 AND CATEGORY='????'
gxvcgmwzuw076	select * from(select mtid, mttag, cellphone, message, pushmethod, pushlink from mtsmspool where mtstatus='0' and projectid in ( '500003') order by isfirst desc nulls last, mtid asc) where rownum<100

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

Ordered by statistic name

Statistic	Total	per Second	per Trans
CPU used by this session	2,350,951	326.58	98.63
CPU used when call started	2,333,168	324.11	97.88
CR blocks created	33,964	4.72	1.42
Cached Commit SCN referenced	35,256	4.90	1.48
Commit SCN cached	4	0.00	0.00
DB time	17,971,610	2,496.50	753.94
DBWR checkpoint buffers written	466	0.06	0.02
DBWR checkpoints	22	0.00	0.00
DBWR revisited being-written buffer	196	0.03	0.01
DBWR thread checkpoint buffers written	199	0.03	0.01
DBWR transaction table writes	942	0.13	0.04
DBWR undo block writes	56,226	7.81	2.36
IMU CR rollbacks	28,107	3.90	1.18
IMU Flushes	3,834	0.53	0.16
IMU Redo allocation size	5,552,864	771.37	232.95
IMU commits	22,368	3.11	0.94
IMU contention	387	0.05	0.02
IMU ktichg flush	6	0.00	0.00
IMU pool not allocated	1,399	0.19	0.06
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	32,827,944	4,560.24	1,377.18
IMU- failed to get a private strand	1,399	0.19	0.06
Misses for writing mapping	2	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	16,008,960	2,223.86	671.60
active txn count during cleanout	71,936	9.99	3.02
application wait time	769,294	106.87	32.27
background checkpoints completed	23	0.00	0.00
background checkpoints started	22	0.00	0.00
background timeouts	21,660	3.01	0.91
branch node splits	14	0.00	0.00
buffer is not pinned count	198,468,677	27,569.93	8,326.08
buffer is pinned count	7,384,622,251	1,025,822.07	309,796.63
bytes received via SQL*Net from client	5,148,537,609	715,200.23	215,989.33
bytes sent via SQL*Net to client	12,481,111,983	1,733,792.15	523,602.47
calls to get snapshot scn: kcmgss	26,382,070	3,664.82	1,106.77
calls to kcmgas	652,649	90.66	27.38
calls to kcmgcs	13,738	1.91	0.58
change write time	16,994	2.36	0.71
cleanout - number of ktugct calls	95,734	13.30	4.02
cleanouts and rollbacks - consistent read gets	26,868	3.73	1.13
cleanouts only - consistent read gets	4,663	0.65	0.20
cluster key scan block gets	133,826	18.59	5.61
cluster key scans	81,020	11.25	3.40
commit batch performed	7	0.00	0.00
commit batch requested	7	0.00	0.00
commit batch/immediate performed	281	0.04	0.01
commit batch/immediate requested	281	0.04	0.01
commit cleanout failures: block lost	7,960	1.11	0.33
commit cleanout failures: buffer being written	1,661	0.23	0.07
commit cleanout failures: callback failure	16	0.00	0.00
commit cleanout failures: cannot pin	68	0.01	0.00
commit cleanouts	430,913	59.86	18.08
commit cleanouts successfully completed	421,208	58.51	17.67
commit immediate performed	274	0.04	0.01
commit immediate requested	274	0.04	0.01
commit txn count during cleanout	77,689	10.79	3.26
concurrency wait time	897,208	124.63	37.64
consistent changes	3,861,915	536.47	162.01
consistent gets	485,476,680	67,439.16	20,366.52
consistent gets - examination	8,058,947	1,119.49	338.09
consistent gets direct	407,229	56.57	17.08
consistent gets from cache	485,069,449	67,382.59	20,349.43
current blocks converted for CR	7,683	1.07	0.32
cursor authentications	66,381	9.22	2.78
data blocks consistent reads - undo records applied	3,767,014	523.29	158.03
db block changes	7,989,552	1,109.85	335.17
db block gets	9,304,289	1,292.49	390.33
db block gets direct	569	0.08	0.02
db block gets from cache	9,303,720	1,292.41	390.31
deferred (CURRENT) block cleanout applications	419,442	58.27	17.60
dirty buffers inspected	383,571	53.28	16.09
enqueue conversions	1,481	0.21	0.06
enqueue releases	1,062,703	147.62	44.58
enqueue requests	1,062,714	147.63	44.58
enqueue timeouts	7	0.00	0.00
enqueue waits	1,233	0.17	0.05
exchange deadlocks	38	0.01	0.00
execute count	1,982,324	275.37	83.16
frame signature mismatch	0	0.00	0.00
free buffer inspected	293,816,134	40,814.96	12,326.05
free buffer requested	253,755,738	35,250.04	10,645.46
heap block compress	7,988	1.11	0.34
hot buffers moved to head of LRU	8,522,091	1,183.83	357.52
immediate (CR) block cleanout applications	31,535	4.38	1.32
immediate (CURRENT) block cleanout applications	43,239	6.01	1.81
index fast full scans (full)	182	0.03	0.01
index fetch by key	690,613	95.94	28.97
index scans kdiixs1	2,532,734	351.83	106.25
leaf node 90-10 splits	787	0.11	0.03
leaf node splits	3,531	0.49	0.15
lob reads	396,999	55.15	16.65
lob writes	300	0.04	0.01
lob writes unaligned	256	0.04	0.01
logons cumulative	12,194	1.69	0.51
messages received	33,872	4.71	1.42
messages sent	33,873	4.71	1.42
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	473,677,629	65,800.11	19,871.53
opened cursors cumulative	1,353,165	187.97	56.77
parse count (failures)	458	0.06	0.02
parse count (hard)	213,947	29.72	8.98
parse count (total)	1,256,949	174.61	52.73
parse time cpu	171,521	23.83	7.20
parse time elapsed	641,319	89.09	26.90
physical read IO requests	49,039,613	6,812.25	2,057.29
physical read bytes	2,082,271,969,280	289,255,220.54	87,354,615.48
physical read total IO requests	49,046,538	6,813.22	2,057.58
physical read total bytes	2,082,382,292,992	289,270,545.97	87,359,243.74
physical read total multi block requests	16,558,461	2,300.19	694.65
physical reads	254,183,590	35,309.48	10,663.41
physical reads cache	253,589,543	35,226.95	10,638.48
physical reads cache prefetch	205,071,210	28,487.11	8,603.06
physical reads direct	594,047	82.52	24.92
physical reads direct (lob)	407,191	56.56	17.08
physical reads direct temporary tablespace	186,621	25.92	7.83
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	368,149	51.14	15.44
physical write bytes	5,812,699,136	807,461.08	243,851.96
physical write total IO requests	334,896	46.52	14.05
physical write total bytes	7,068,963,840	981,972.92	296,554.26
physical write total multi block requests	107,906	14.99	4.53
physical writes	709,558	98.57	29.77
physical writes direct	270,227	37.54	11.34
physical writes direct (lob)	103	0.01	0.00
physical writes direct temporary tablespace	269,451	37.43	11.30
physical writes from cache	439,331	61.03	18.43
physical writes non checkpoint	609,408	84.65	25.57
pinned buffers inspected	68,670	9.54	2.88
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	37,730	5.24	1.58
process last non-idle time	7,222	1.00	0.30
recursive calls	11,477,867	1,594.43	481.51
recursive cpu usage	691,580	96.07	29.01
redo blocks written	2,149,425	298.58	90.17
redo buffer allocation retries	2,166	0.30	0.09
redo entries	3,951,758	548.95	165.78
redo log space requests	3,187	0.44	0.13
redo log space wait time	85,066	11.82	3.57
redo ordering marks	49,177	6.83	2.06
redo size	1,056,463,032	146,756.74	44,320.30
redo synch time	371,811	51.65	15.60
redo synch writes	31,609	4.39	1.33
redo wastage	8,038,040	1,116.59	337.21
redo write time	288,899	40.13	12.12
redo writer latching time	1,086	0.15	0.05
redo writes	26,906	3.74	1.13
rollback changes - undo records applied	13,109	1.82	0.55
rollbacks only - consistent read gets	14,351	1.99	0.60
rows fetched via callback	175,589	24.39	7.37
session connect time	0	0.00	0.00
session cursor cache hits	904,614	125.66	37.95
session logical reads	494,780,946	68,731.64	20,756.85
shared hash latch upgrades - no wait	2,730,858	379.35	114.56
shared hash latch upgrades - wait	1,046	0.15	0.04
sorts (disk)	14	0.00	0.00
sorts (memory)	588,957	81.81	24.71
sorts (rows)	18,568,026	2,579.35	778.96
sql area purged	0	0.00	0.00
summed dirty queue length	740,506	102.87	31.07
switch current to new buffer	4,322	0.60	0.18
table fetch by rowid	3,784,905,978	525,773.69	158,782.82
table fetch continued row	6,029,786	837.62	252.96
table scan blocks gotten	254,823,503	35,398.37	10,690.25
table scan rows gotten	14,142,337,403	1,964,558.42	593,293.51
table scans (cache partitions)	100	0.01	0.00
table scans (long tables)	25,615	3.56	1.07
table scans (short tables)	239,154	33.22	10.03
total number of times SMON posted	16	0.00	0.00
transaction rollbacks	281	0.04	0.01
transaction tables consistent read rollbacks	142	0.02	0.01
transaction tables consistent reads - undo records applied	88,821	12.34	3.73
undo change vector size	384,200,076	53,370.49	16,117.80
user I/O wait time	12,255,574	1,702.46	514.14
user calls	16,654,605	2,313.55	698.69
user commits	23,738	3.30	1.00
user rollbacks	99	0.01	0.00
workarea executions - multipass	2	0.00	0.00
workarea executions - onepass	18	0.00	0.00
workarea executions - optimal	187,480	26.04	7.87
write clones created in background	20	0.00	0.00
write clones created in foreground	74,595	10.36	3.13

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
workarea memory allocated	1,628	16,478
session pga memory	16,813,621,680	17,021,027,480
session uga memory max	138,218,942,616	141,646,245,556
opened cursors current	735	729
session pga memory max	27,193,640,632	27,561,561,124
session uga memory	41,695,508,575,516	42,189,747,396,392
session cursor cache count	2,679,171	2,754,745
logons current	167	145

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)	22	11.00

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

No data exists for this section of the report.

Back to IO Stats
Back to Top

IOStat by Filetype summary

No data exists for this section of the report.

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

No data exists for this section of the report.

Back to IO Stats
Back to Top

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)
MINFO1108	48,554,164	6,745	1.90	5.22	307,680	43	446,993	54.99
USERS	327,566	46	2.68	1.18	23	0	59	76.27
SYSTEM	179,389	25	30.01	1.09	1,401	0	332	440.06
TEMP	126,541	18	20.37	1.48	19,838	3	0	0.00
UNDOTBS1	110,998	15	17.90	1.00	32,728	5	11,878	83.61
SYSAUX	24,207	3	32.83	1.13	5,585	1	0	0.00
EXAMPLE	26	0	68.46	1.00	23	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
EXAMPLE	/newdisk/u01/app/oracle/oradata/minfo/example01.dbf	26	0	68.46	1.00	23	0	0	0.00
MINFO1108	/newdisk/u01/app/oracle/oradata/minfo/minfo1108.dbf	11,723,973	1,629	1.90	4.34	1,629	0	162,192	57.69
MINFO1108	/newdisk/u01/app/oracle/oradata/minfo/minfo110802.dbf	11,712,128	1,627	1.99	4.26	2,030	0	178,689	58.07
MINFO1108	/newdisk/u01/app/oracle/oradata/minfo/minfo110803.dbf	12,996,721	1,805	2.17	6.48	148,527	21	60,224	49.59
MINFO1108	/newdisk/u01/app/oracle/oradata/minfo/minfo110804.dbf	12,121,342	1,684	1.54	5.64	155,494	22	45,888	40.57
SYSAUX	/newdisk/u01/app/oracle/oradata/minfo/sysaux01.dbf	24,207	3	32.83	1.13	5,585	1	0	0.00
SYSTEM	/newdisk/u01/app/oracle/oradata/minfo/system01.dbf	179,389	25	30.01	1.09	1,401	0	332	440.06
TEMP	/newdisk/u01/app/oracle/oradata/minfo/temp01.dbf	126,541	18	20.37	1.48	19,838	3	0
UNDOTBS1	/newdisk/u01/app/oracle/oradata/minfo/undotbs01.dbf	110,998	15	17.90	1.00	32,728	5	11,878	83.61
USERS	/newdisk/u01/app/oracle/oradata/minfo/users01.dbf	327,566	46	2.68	1.18	23	0	59	76.27

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

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	49,016	49	493,906,864	253,516,688	438,431	181	11	459,773

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 709,558

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	185	0	0	267	14

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
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 RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	24	80	16394	86089	184320	86089
E	0	25	857	52764	184320	184320	348110

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

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 (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time
D	40	0.10	5	1.37	32,446,717	1
D	80	0.20	10	1.33	31,543,507	1
D	120	0.30	15	1.29	30,640,633	1
D	160	0.40	20	1.25	29,729,478	1
D	200	0.50	25	1.22	28,799,823	1
D	240	0.59	30	1.17	27,831,144	1
D	280	0.69	35	1.13	26,879,274	1
D	320	0.79	40	1.09	25,911,453	1
D	360	0.89	45	1.05	24,925,962	1
D	400	0.99	50	1.00	23,808,999	1
D	404	1.00	50	1.00	23,700,949	1
D	440	1.09	55	0.96	22,728,508	1
D	480	1.19	60	0.91	21,683,112	1
D	520	1.29	65	0.87	20,668,528	1
D	560	1.39	70	0.83	19,680,537	1
D	600	1.49	75	0.79	18,716,498	1
D	640	1.58	80	0.75	17,775,165	1
D	680	1.68	85	0.71	16,855,861	1
D	720	1.78	90	0.67	15,958,003	1
D	760	1.88	95	0.64	15,062,083	1
D	800	1.98	100	0.60	14,165,832	1

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
76.55	3,845	1,178

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	179	35	267.07	1.59	0.60	100.00	0.00	36,659
E	179	35	293.37	16.09	5.49	100.00	0.00	1,912

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs	M-Pass Execs
2K	4K	184,127	184,127	0	0
64K	128K	331	331	0	0
128K	256K	126	126	0	0
256K	512K	16	16	0	0
512K	1024K	2,408	2,408	0	0
1M	2M	483	483	0	0
2M	4M	8	8	0	0
16M	32M	2	0	1	1
32M	64M	16	0	15	1
64M	128M	2	0	2	0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
22	0.13	252,264.05	20,410.42	93.00	4,068
45	0.25	252,264.05	20,410.42	93.00	4,067
90	0.50	252,264.05	17,383.37	94.00	3,398
134	0.75	252,264.05	1,005.90	100.00	19
179	1.00	252,264.05	548.83	100.00	0
215	1.20	252,264.05	388.38	100.00	0
251	1.40	252,264.05	388.38	100.00	0
286	1.60	252,264.05	71.09	100.00	0
322	1.80	252,264.05	71.09	100.00	0
358	2.00	252,264.05	0.00	100.00	0
537	3.00	252,264.05	0.00	100.00	0
716	4.00	252,264.05	0.00	100.00	0
1,074	6.00	252,264.05	0.00	100.00	0
1,432	8.00	252,264.05	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 (K)
124	1.00	18	2,882	1,706,836	1.00	562,972	1.00	65,903
140	1.13	33	4,951	1,719,687	1.01	550,121	0.98	66,820
156	1.26	48	6,919	1,732,205	1.01	537,603	0.95	67,713
172	1.39	63	8,900	1,744,432	1.02	525,376	0.93	68,581
188	1.52	78	10,847	1,756,297	1.03	513,511	0.91	69,425
204	1.65	93	12,924	1,767,771	1.04	502,037	0.89	70,244
220	1.77	108	15,003	1,778,988	1.04	490,820	0.87	71,040
236	1.90	123	16,696	1,789,881	1.05	479,927	0.85	71,814
252	2.03	138	18,763	1,800,466	1.05	469,342	0.83	72,568

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
270	0.50	11,226,382	30,640,950,414
405	0.75	10,336,342	26,879,565,180
540	1.00	9,560,062	23,701,230,209
675	1.25	8,607,883	19,681,501,566
810	1.50	7,916,701	16,856,314,925
945	1.75	7,258,012	14,166,225,296
1,080	2.00	7,190,147	14,166,225,296

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	447,301	24,708	55
undo block	11,903	998	84
segment header	253	36	144
undo header	92	3	33

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	9	5	0	5	2,939	587,814.00
TX-Transaction (index contention)	1,209	1,209	0	1,200	114	94.72
SQ-Sequence Cache	1,035	1,035	0	11	44	4,001.82
CF-Controlfile Transaction	3,600	3,599	1	10	24	2,434.00
US-Undo Segment	1,014	1,014	0	3	1	370.00
JS-Job Scheduler (queue lock)	25,872	25,872	0	1	0	320.00
HW-Segment High Water Mark	656	656	0	3	0	86.67

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	49.74	375,820	139,948	12	2271.2/2346.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
19-Jul 17:57	3,122	2,693	138,441	8	2,321	0/0	0/0/0/0/0/0
19-Jul 17:47	3,692	2,828	137,841	8	2,311	0/0	0/0/0/0/0/0
19-Jul 17:37	728	5,848	137,238	7	2,301	0/0	0/0/0/0/0/0
19-Jul 17:27	5,553	53,716	136,635	9	2,291	0/0	0/0/0/0/0/0
19-Jul 17:17	13,495	121,481	136,034	12	2,281	0/0	0/0/0/0/0/0
19-Jul 17:07	9,745	59,484	135,432	11	2,271	0/0	0/0/0/0/0/0
19-Jul 16:57	11,136	105,612	139,948	11	2,346	0/0	0/0/0/0/0/0
19-Jul 16:47	1,007	10,001	139,345	8	2,336	0/0	0/0/0/0/0/0
19-Jul 16:37	236	2,829	138,741	7	2,326	0/0	0/0/0/0/0/0
19-Jul 16:27	136	2,354	138,136	6	2,316	0/0	0/0/0/0/0/0
19-Jul 16:17	208	3,989	137,532	8	2,306	0/0	0/0/0/0/0/0
19-Jul 16:07	684	4,985	136,925	8	2,296	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
Mutex Sleep Summary
Parent Latch Statistics
Child Latch Statistics

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AWR Alerted Metric Element list	20,938	0.00		0	0
Consistent RBA	26,981	0.00	0.00	0	0
FIB s.o chain latch	84	0.00		0	0
FOB s.o list latch	7,459	0.00		0	0
In memory undo latch	3,674,429	0.09	0.00	1	35,206	0.00
JS mem alloc latch	14	0.00		0	0
JS queue access latch	14	0.00		0	0
JS queue state obj latch	51,708	0.00		0	0
JS slv state obj latch	133	0.00		0	0
KMG MMAN ready and startup request latch	3,145	0.00		0	0
KMG resize request state object freelist	40	0.00		0	0
KTF sga latch	22	0.00		0	2,256	0.09
KWQMN job cache list latch	74	0.00		0	0
MQL Tracking Latch	0			0	144	0.00
Memory Management Latch	1,139	0.00		0	3,144	0.00
OS process	36,375	0.00		0	0
OS process allocation	26,648	0.03	1.00	1	0
OS process: request allocation	24,077	0.02	0.75	0	0
PL/SQL warning settings	19,926	0.00		0	0
SGA IO buffer pool latch	21,158	0.01	1.00	0	31,787	0.17
SQL memory manager latch	202	0.99	0.00	0	2,206	0.00
SQL memory manager workarea list latch	201,428	0.00	0.00	0	0
Shared B-Tree	269	0.00		0	0
active checkpoint queue latch	7,358	0.00		0	0
active service list	87,030	0.02	0.53	2	4,548	0.02
archive control	68	0.00		0	0
begin backup scn array	98	0.00		0	0
buffer pool	106	0.00		0	0
cache buffer handles	10,817	0.00		0	0
cache buffers chains	1,261,595,865	0.07	0.15	6794	516,661,567	6.44
cache buffers lru chain	2,903,407	45.24	0.04	1100	536,846,503	7.58
cache table scan latch	0			0	15,752,368	4.93
channel handle pool latch	24,087	0.00		0	0
channel operations parent latch	76,579	0.01	0.83	1	0
checkpoint queue latch	574,948	0.00	0.07	0	438,627	0.01
client/application info	63,359	0.00		0	0
commit callback allocation	8	0.00		0	0
compile environment latch	102,210	0.00	0.00	0	0
dml lock allocation	775,389	0.01	0.13	1	0
dummy allocation	24,310	0.00		0	0
enqueue hash chains	2,138,203	0.02	0.13	3	11,928	0.05
enqueues	698,628	0.05	0.09	4	0
event group latch	12,036	0.00		0	0
file cache latch	372	0.00		0	0
global KZLD latch for mem in SGA	11,995	0.00		0	0
hash table column usage latch	3,002	0.00		0	2,177,923	0.01
hash table modification latch	184	0.00		0	0
job workq parent latch	0			0	230	0.00
job_queue_processes parameter latch	234	0.00		0	0
kks stats	640,772	0.07	0.41	5	0
kmcptab latch	1	0.00		0	0
kmcpvec latch	0			0	1	0.00
ksuosstats global area	484	0.00		0	0
ktm global data	34	0.00		0	0
kwqbsn:qsga	269	0.00		0	0
lgwr LWN SCN	26,990	0.00	0.00	0	0
library cache	13,025,159	0.47	0.33	1107	650,377	1.14
library cache load lock	135,004	0.01	0.13	0	2,714	0.00
library cache lock	3,266,132	0.03	0.19	35	0
library cache lock allocation	22,672	0.00		0	0
library cache pin	7,621,321	0.03	0.05	7	3,040	0.00
library cache pin allocation	16,926	0.00		0	0
list of block allocation	7,257	0.00		0	0
loader state object freelist	747,668	0.02	0.04	0	0
longop free list parent	10,743	0.00		0	341	0.00
message pool operations parent latch	42	0.00		0	0
messages	153,226	0.01	0.14	0	0
mostly latch-free SCN	27,069	0.16	0.23	0	0
multiblock read objects	35,882,893	0.29	0.02	98	0
ncodef allocation latch	258	0.00		0	0
object queue header heap	105,449	0.00	1.00	0	105,367	0.00
object queue header operation	508,899,188	0.00	0.03	7	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	912	0.00		0	0
parameter list	109,770	0.00	0.00	0	0
parameter table allocation management	12,202	0.01	0.00	0	0
post/wait queue	50,646	0.01	0.00	0	26,324	0.00
process allocation	24,077	0.06	8.13	3	12,035	0.01
process group creation	24,077	0.00		0	0
qmn task queue latch	1,028	0.10	0.00	0	0
redo allocation	158,605	0.05	0.27	1	3,946,680	0.04
redo copy	0			0	3,947,084	0.03
redo writing	98,710	0.01	0.00	0	0
resmgr group change latch	12,659	0.00		0	0
resmgr:actses active list	24,299	0.00		0	0
resmgr:actses change group	12,110	0.00		0	0
resmgr:free threads list	24,298	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	18,985,514	0.10	0.02	18	28,673	0.11
rules engine aggregate statistics	2	0.00		0	0
rules engine rule set statistics	4	0.00		0	0
sequence cache	726,513	0.03	0.04	1	0
session allocation	3,565,691	0.06	0.03	9	0
session idle bit	33,424,883	0.01	0.06	8	0
session state list latch	462	0.00		0	0
session switching	258	0.00		0	0
session timer	4,549	0.00		0	0
shared pool	7,434,959	0.59	0.25	212	0
simulator hash latch	94,747,456	0.01	0.04	3	0
simulator lru latch	46,540,295	1.65	0.04	1495	16,141,655	0.42
slave class	6	0.00		0	0
slave class create	24	4.17	1.00	1	0
sort extent pool	2,103	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	140	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	529	0.00		0	0
transaction allocation	2,572	0.00		0	0
transaction branch allocation	258	0.00		0	0
undo global data	5,223,424	0.10	0.00	1	1	0.00
user lock	48,603	0.01	0.40	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers lru chain	2,903,407	1,313,437	55,433	1,259,772
cache buffers chains	1,261,595,865	875,222	130,672	748,371
simulator lru latch	46,540,295	767,018	30,834	737,182
multiblock read objects	35,882,893	104,695	2,554	102,192
library cache	13,025,159	61,747	20,595	42,246
shared pool	7,434,959	43,728	10,925	33,261
row cache objects	18,985,514	18,411	339	18,075
object queue header operation	508,899,188	15,991	514	15,484
simulator hash latch	94,747,456	13,737	618	13,138
undo global data	5,223,424	5,403	19	5,384
session idle bit	33,424,883	4,940	304	4,640
In memory undo latch	3,674,429	3,375	8	3,367
library cache pin	7,621,321	2,437	132	2,306
session allocation	3,565,691	2,296	79	2,218
library cache lock	3,266,132	941	178	764
kks stats	640,772	441	183	265
enqueue hash chains	2,138,203	380	49	331
enqueues	698,628	364	34	330
sequence cache	726,513	225	9	216
loader state object freelist	747,668	139	5	134
dml lock allocation	775,389	79	10	69
redo allocation	158,605	78	21	57
mostly latch-free SCN	27,069	43	10	33
checkpoint queue latch	574,948	27	2	25
active service list	87,030	15	8	7
library cache load lock	135,004	15	2	13
process allocation	24,077	15	122	3
messages	153,226	14	2	12
OS process allocation	26,648	7	7	0
channel operations parent latch	76,579	6	5	1
user lock	48,603	5	2	3
OS process: request allocation	24,077	4	3	1
SGA IO buffer pool latch	21,158	3	3	0
object queue header heap	105,449	2	2	0
slave class create	24	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	kturbk	4	8
In memory undo latch	ktichg: child	2	0
In memory undo latch	ktiTxnPoolFree	1	0
In memory undo latch	kticmt: child	1	0
OS process allocation	kso_delete_process:1	4	5
OS process allocation	kso_new_process:2	3	0
OS process: request allocation	kso_new_process	2	2
OS process: request allocation	ksoreqholder_delete	1	1
SGA IO buffer pool latch	ksfd_free_sgabuffer	2	7
SGA IO buffer pool latch	ksfd_alloc_sgabuffer	1	0
active service list	ksws_event: ksws event	7	2
active service list	kswsgetso: get service object	1	1
active service list	kswssyis: find service entry 1	1	0
cache buffers chains	kcbgtcr: kslbegin excl	57,640	122,519
cache buffers chains	kcbzib: multi-block read: nowait	53,408	0
cache buffers chains	kcbrls: kslbegin	9,484	1,950
cache buffers chains	kcbzgb: scan from tail. nowait	6,801	0
cache buffers chains	kcbzib: finish free bufs	2,772	6,648
cache buffers chains	kcbget: pin buffer	1,424	700
cache buffers chains	kcbgtcr: fast path	1,273	2,855
cache buffers chains	kcbgtcr: kslbegin shared	1,069	429
cache buffers chains	kcbzwb	742	67
cache buffers chains	kcbgcur: kslbegin	608	441
cache buffers chains	kcbchg: kslbegin: bufs not pinned	276	196
cache buffers chains	kcbbic1	201	140
cache buffers chains	kcbchg: kslbegin: call CR func	97	40
cache buffers chains	kcbgtcr	79	0
cache buffers chains	kcbbxsv	70	122
cache buffers chains	kcbnew: new latch again	67	19
cache buffers chains	kcbnlc	63	5
cache buffers chains	kcbget: exchange rls	58	5
cache buffers chains	kcbget: exchange	39	8
cache buffers chains	kcbbic2	19	17
cache buffers chains	kcb_post_apply: kcbhq62	2	1
cache buffers chains	kcbcge	2	0
cache buffers chains	kcbnew_1	2	0
cache buffers chains	kcbzib: exchange rls	2	5
cache buffers lru chain	kcbzgws	41,392	53,673
cache buffers lru chain	kcbzar: KSLNBEGIN	12,603	0
cache buffers lru chain	kcbzgm	858	0
cache buffers lru chain	kcbo_link_q	259	22
cache buffers lru chain	kcbzgb: posted for free bufs	166	1,155
cache buffers lru chain	kcbkubc	55	345
cache buffers lru chain	kcbbxsv: move to being written	34	73
cache buffers lru chain	kcbbic2	23	10
cache buffers lru chain	kcbbwlru	6	122
cache buffers lru chain	kcbzswcu	5	0
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	2	0
channel operations parent latch	ksrchdelete()	6	6
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	2	0
cost function	kzulgt: find user res	2	2
dml lock allocation	ktaiam	5	8
dml lock allocation	ktaidm	5	2
enqueue hash chains	ksqgtl3	21	35
enqueue hash chains	ksqrcl	17	14
enqueue hash chains	ksqcmi: get hash chain latch after wait	7	2
enqueue hash chains	ksqcmi: if deadlock detected	3	0
enqueue hash chains	ksucallcbksafely: ksqhngcbk1	1	0
enqueues	ksqgel: create enqueue	15	24
enqueues	ksqdel	14	3
enqueues	ksqies	5	7
kks stats	kks stats alloc/free	181	181
library cache	kglpin: child: heap processing	4,797	5,759
library cache	kglhdgc: child:	4,044	190
library cache	kglpndl: child: before processing	3,982	5,616
library cache	kglpnc: child	745	851
library cache	kglobpn: child:	670	693
library cache	kglpndl: child: after processing	598	45
library cache	kgldte: child 0	587	400
library cache	kglukp: child	581	659
library cache	kglhdgn: child:	469	2,920
library cache	kglobld	443	404
library cache	kglpin	263	193
library cache	kglrtl	211	73
library cache	kgldti: 2child	164	139
library cache	kglati	76	0
library cache	kgldtld: 2child	46	83
library cache	kglpnp: child	29	66
library cache	kglini: child	24	20
library cache	kglic	2	4
library cache	kglpur: child	2	3
library cache load lock	kglllal: llatch	2	1
library cache lock	kgllkdl: child: no lock handle	638	1,019
library cache lock	kgllkdl: child: cleanup	96	70
library cache lock	kgllkal: child: multiinstance	82	108
library cache pin	kglpndl	72	51
library cache pin	kglpnal: child: alloc space	39	72
library cache pin	kglpnc: child	17	7
library cache pin	kgldnp: child	4	2
loader state object freelist	kcblfs	4	0
loader state object freelist	kcblgs	1	5
messages	ksarcv	1	0
messages	ksarcv: after wait	1	0
mostly latch-free SCN	kcs04	8	9
mostly latch-free SCN	kcs05	2	1
multiblock read objects	kcbzib: mbr get	1,376	987
multiblock read objects	kcbzib: normal mbr free	1,178	1,567
object queue header heap	kcbw_link_q:alloc	2	2
object queue header operation	kcbw_link_q	376	0
object queue header operation	kcbw_unlink_q	88	89
object queue header operation	kcbo_switch_cq	43	390
object queue header operation	kcbo_switch_q_bg	2	1
object queue header operation	kcbo_htab_size_ck	1	32
object queue header operation	kcbo_link_q:reget	1	0
object queue header operation	kcbo_swap_buf	1	0
object queue header operation	kcbo_switch_mq_bg	1	1
object queue header operation	kcbw_unlink_q_bg	1	0
process allocation	ksuapc	111	50
process allocation	ksucrp	10	0
process allocation	ksudlp	1	72
redo allocation	kcrfw_redo_gen: redo allocation 1	21	0
row cache objects	kqreqd: reget	137	2
row cache objects	kqrpre: find obj	121	312
row cache objects	kqrso	44	1
row cache objects	kqreqd	30	2
row cache objects	kqrcmt: while loop	2	0
row cache objects	kqrcmt: clear flag	1	5
sequence cache	kdnssd	4	3
sequence cache	kdnss	3	6
sequence cache	kdnnxt: cached seq	2	0
session allocation	ksudlc	15	14
session allocation	ksuprc	15	9
session allocation	ksucri	12	27
session allocation	ksuxds: KSUSFCLC not set	12	3
session allocation	ksuxds: not user session	11	21
session allocation	ksucrp	9	0
session allocation	ksudlp	5	5
session idle bit	ksupuc: set busy	236	149
session idle bit	ksupuc: clear busy	70	165
session idle bit	ksuxds	20	12
shared pool	kghalo	5,681	3,436
shared pool	kghfrunp: alloc: cursor dur	2,151	36
shared pool	kghupr1	1,799	5,644
shared pool	kghfrunp: clatch: nowait	1,613	0
shared pool	kghfrunp: clatch: wait	616	1,466
shared pool	kghfre	517	1,123
shared pool	kghfrunp: alloc: session dur	392	4
shared pool	kghalp	278	536
shared pool	kghasp	81	119
shared pool	kghfrunp: alloc: wait	11	6
shared pool	kghfen: not perm alloc class	7	11
shared pool	kgh: sim resz update	2	0
shared pool	kgh: quiesce extents	1	0
shared pool	kghfree_extents: scan	1	4
simulator hash latch	kcbs_lookup_setid: lookup dba	322	257
simulator hash latch	kcbsacc: lookup dba	145	303
simulator hash latch	kcbsacc: remove dba	106	58
simulator hash latch	kcbsacc: insert dba	45	0
simulator lru latch	kcbs_simulate: simulate set	28,850	30,762
simulator lru latch	kcbs_lookup_setid	1,937	0
simulator lru latch	kcbs_simbufseq	46	73
simulator lru latch	kcbs_shrink_pool	4	0
slave class create	ksvcreate	1	0
undo global data	kturimugur: child	10	5
undo global data	ktudnx:child	4	2
undo global data	ktudba: KSLBEGIN	3	2
undo global data	ktufrbs: child	2	10

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

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 Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 494,780,946
Captured Segments account for 96.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
KEYACCOUNT	MINFO1108	MTSMSPOOL	TABLE	145,034,688	29.31
MCRM	MINFO1108	M_MTQUEUE	TABLE	67,680,496	13.68
KEYACCOUNT	MINFO1108	MTSMSGROUP	TABLE	60,157,312	12.16
KEYACCOUNT	MINFO1108	MOSMSPOOL	TABLE	50,199,120	10.15
KEYACCOUNT	MINFO1108	MTMMSPOOL	TABLE	44,179,616	8.93

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 254,183,590
Captured Segments account for 98.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
MCRM	MINFO1108	M_MTQUEUE	TABLE	63,189,118	24.86
KEYACCOUNT	MINFO1108	MOSMSPOOL	TABLE	48,398,791	19.04
KEYACCOUNT	MINFO1108	MTSMSGROUP	TABLE	47,979,952	18.88
MINFODB	MINFO1108	STOCKDATA_HISTORY	TABLE	35,112,512	13.81
KEYACCOUNT	MINFO1108	MTSMSPOOL	TABLE	24,381,344	9.59

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 709,558
Captured Segments account for 51.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
HSBC	MINFO1108	KA_PHONELISTDATA_TELNUM	INDEX	221,309	31.19
HSBC	MINFO1108	KA_PHONELISTDATA	TABLE	39,208	5.53
HSBC	MINFO1108	KA_PHONELISTDATA_ADDTIME	INDEX	23,296	3.28
HSBC	MINFO1108	KA_PHONELISTDATA_GROUPID	INDEX	23,226	3.27
HSBC	MINFO1108	IDPRIMARY	INDEX	22,472	3.17

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 270,227
Captured Segments account for 0.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_4214485585_17412	TABLE PARTITION	466	0.17

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 25,797
Captured Segments account for 96.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
MINFODB	MINFO1108	ADWAP_PAGE	TABLE	8,580	33.26
KEYACCOUNT	MINFO1108	MTSMSGROUP	TABLE	5,140	19.92
KEYACCOUNT	MINFO1108	MOSMSPOOL	TABLE	3,505	13.59
MCRM	MINFO1108	M_MTQUEUE	TABLE	3,268	12.67
MINFODB	MINFO1108	STOCKDATADAILY	TABLE	1,461	5.66

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
HSBC	MINFO1108	KA_PHONELISTDATA	TABLE	4,011,808	55.36
HSBC	MINFO1108	IDPRIMARY	INDEX	773,792	10.68
HSBC	MINFO1108	KA_PHONELISTDATA_GROUPID	INDEX	581,456	8.02
HSBC	MINFO1108	KA_PHONELISTDATA_ADDTIME	INDEX	492,960	6.80
HSBC	MINFO1108	KA_PHONELISTDATA_TELNUM	INDEX	477,776	6.59

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
HSBC	MINFO1108	KA_PHONELISTDATA_GROUPID	INDEX	666	52.40
HSBC	MINFO1108	IDPRIMARY	INDEX	515	40.52
HSBC	MINFO1108	KA_PHONELISTDATA_AUDITSTATE	INDEX	56	4.41
HSBC	MINFO1108	KA_PHONELISTDATA	TABLE	14	1.10
HSBC	MINFO1108	KA_PHONELISTDATA_ADDTIME	INDEX	6	0.47

Back to Segment Statistics
Back to Top

Segments by ITL Waits

% of Capture shows % of ITL waits for each top segment compared
with total ITL waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
MINFODB	MINFO1108	ERRORLOG_TIMEINDEX		INDEX	1	100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
HSBC	MINFO1108	IDPRIMARY	INDEX	732	32.66
HSBC	MINFO1108	KA_PHONELISTDATA_GROUPID	INDEX	715	31.91
HSBC	MINFO1108	KA_PHONELISTDATA	TABLE	383	17.09
HSBC	MINFO1108	KA_PHONELISTDATA_AUDITSTATE	INDEX	208	9.28
SYS	SYSTEM	SEQ$	TABLE	131	5.85

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	137	0.73	2	1
dc_files	9	100.00	0	0
dc_global_oids	11,744	1.23	0	9
dc_histogram_data	816,689	2.06	0	1,818
dc_histogram_defs	2,542,240	0.84	0	2,247
dc_object_grants	22,359	3.66	0	66
dc_object_ids	908,143	0.49	0	619
dc_objects	332,153	1.83	11	607
dc_profiles	12,200	0.07	0	2
dc_rollback_segments	3,071	0.00	6	44
dc_segments	377,743	1.44	7	585
dc_sequences	340,950	0.06	340,950	15
dc_tablespaces	236,242	0.02	0	5
dc_usernames	77,313	0.06	0	12
dc_users	933,109	0.01	0	52
outstanding_alerts	195	86.15	2	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	1,619	4.39	15,057	14.94	2,174	0
CLUSTER	771	0.52	10,459	1.49	152	0
INDEX	44	77.27	148	24.32	2	0
SQL AREA	217,967	40.91	2,849,848	12.06	139,330	1,504
TABLE/PROCEDURE	70,693	9.61	1,191,797	5.36	30,545	0
TRIGGER	214	21.03	8,244	9.55	726	0

Memory Statistics

Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Memory Dynamic Components

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

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	221.98		1.31	5.09	62	65	170	170
B	Freeable	34.06	0.00	0.40	0.27	1		85	85
B	SQL	9.72	4.94	0.06	0.09	1	6	161	147
B	PL/SQL	2.09	1.22	0.01	0.02	0	0	167	167
E	Other	230.75		1.58	5.54	62	65	146	146
E	Freeable	35.38	0.00	0.45	0.31	1		78	78
E	SQL	22.60	18.39	0.16	0.50	4	25	138	132
E	PL/SQL	1.93	1.15	0.01	0.02	0	0	144	144

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	419,430,400
Fixed Size	1,220,580
Redo Buffers	7,168,000
Variable Size	138,412,060

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	4.00	4.00	0.00
large	PX msg pool	1.02	1.02	0.00
large	free memory	2.98	2.98	0.00
shared	ASH buffers	8.00	8.00	0.00
shared	CCursor	14.21	14.17	-0.30
shared	FileOpenBlock	2.59	2.59	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGH: NO ACCESS	25.33	33.09	30.66
shared	KQR M PO	1.69	1.75	3.88
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KTI-UNDO	3.99	3.99	0.00
shared	PCursor	3.02	2.83	-6.34
shared	XDB Schema Cac	5.25	5.25	0.00
shared	event statistics per sess	4.24	4.24	0.00
shared	free memory	1.59	5.51	245.52
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kglsim heap	1.96	1.96	0.00
shared	kglsim object batch	3.75	3.75	0.00
shared	library cache	7.09	7.16	0.88
shared	private strands	3.87	3.87	0.00
shared	row cache	3.57	3.57	0.00
shared	sessions	2.54	2.54	0.00
shared	sql area	6.21	3.21	-48.38
shared	trace buffer	3.47	3.47	0.00
	buffer_cache	400.00	400.00	0.00
	fixed_sga	1.16	1.16	0.00
	log_buffer	6.84	6.84	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

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 Capture Rate

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

Streams Apply Rate

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 Queue 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

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

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.

Shared Server Statistics

Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers

Shared Servers Activity

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/newdisk/u01/app/oracle/admin/minfo/adump
background_dump_dest	/newdisk/u01/app/oracle/admin/minfo/bdump
compatible	10.2.0.1.0
control_files	/newdisk/u01/app/oracle/oradata/minfo/control01.ctl, /newdisk/u01/app/oracle/oradata/minfo/control02.ctl, /newdisk/u01/app/oracle/oradata/minfo/control03.ctl
core_dump_dest	/newdisk/u01/app/oracle/admin/minfo/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	minfo
db_recovery_file_dest	/newdisk/u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=minfoXDB)
job_queue_processes	10
open_cursors	300
pga_aggregate_target	187695104
processes	500
remote_login_passwordfile	EXCLUSIVE
sga_target	566231040
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/newdisk/u01/app/oracle/admin/minfo/udump

Buffer Nowait %:	99.91	Redo NoWait %:	99.92
Buffer Hit %:	48.70	In-memory Sort %:	100.00
Library Hit %:	89.92	Soft Parse %:	82.98
Execute to Parse %:	36.59	Latch Hit %:	99.84
Parse CPU to Parse Elapsd %:	26.75	% Non-Parse CPU:	92.65