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: 17474 24-Jul-13 16:00:43 111 3.7

End Snap: 17475 24-Jul-13 18:00:54 120 3.3

Elapsed: 120.18 (mins)

DB Time: 379.49 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	17474	24-Jul-13 16:00:43	111	3.7
End Snap:	17475	24-Jul-13 18:00:54	120	3.3
Elapsed:		120.18 (mins)
DB Time:		379.49 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 3.2 2.8 0.02 0.01

DB CPU(s): 2.5 2.2 0.02 0.01

Redo size: 2,991.3 2,633.4

Logical reads: 84,120.6 74,056.6

Block changes: 17.5 15.4

Physical reads: 36,724.8 32,331.2

Physical writes: 3.9 3.4

User calls: 465.8 410.1

Parses: 144.0 126.8

Hard parses: 34.8 30.6

W/A MB processed: 0.7 0.6

Logons: 3.1 2.7

Executes: 165.5 145.7

Rollbacks: 0.0 0.0

Transactions: 1.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	3.2	2.8	0.02	0.01
DB CPU(s):	2.5	2.2	0.02	0.01
Redo size:	2,991.3	2,633.4
Logical reads:	84,120.6	74,056.6
Block changes:	17.5	15.4
Physical reads:	36,724.8	32,331.2
Physical writes:	3.9	3.4
User calls:	465.8	410.1
Parses:	144.0	126.8
Hard parses:	34.8	30.6
W/A MB processed:	0.7	0.6
Logons:	3.1	2.7
Executes:	165.5	145.7
Rollbacks:	0.0	0.0
Transactions:	1.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96 Redo NoWait %: 99.99

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

Library Hit %: 81.25 Soft Parse %: 75.86

Execute to Parse %: 12.98 Latch Hit %: 99.85

Parse CPU to Parse Elapsd %: 83.13 % Non-Parse CPU: 89.47

Shared Pool Statistics

Begin End

Memory Usage %: 93.33 93.01

% SQL with executions>1: 63.27 61.98

% Memory for SQL w/exec>1: 90.65 89.94

	Begin	End
Memory Usage %:	93.33	93.01
% SQL with executions>1:	63.27	61.98
% Memory for SQL w/exec>1:	90.65	89.94

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		17,911		78.66
db file scattered read	21,266,485	5,141	0	22.58	User I/O
db file sequential read	8,111,966	1,154	0	5.07	User I/O
read by other session	228,114	779	3	3.42	User I/O
latch: cache buffers chains	21,296	251	12	1.10	Concurrency

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

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

4.65 2.93 49.3 20.4 30.3

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
4.65	2.93	49.3	20.4		30.3

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

63.9 91.7 0.0

Memory Statistics

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

Begin End

Host Mem (MB): .1 .1

SGA use (MB): 540.0 540.0

PGA use (MB): 215.3 224.3

% Host Mem used for SGA+PGA: 5.1E+05 5.4E+05

	Begin	End
Host Mem (MB):	.1	.1
SGA use (MB):	540.0	540.0
PGA use (MB):	215.3	224.3
% Host Mem used for SGA+PGA:	5.1E+05	5.4E+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): 22769.7s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	20,369.28	89.46
DB CPU	17,911.36	78.66
parse time elapsed	2,313.61	10.16
hard parse elapsed time	771.68	3.39
connection management call elapsed time	552.17	2.43
failed parse elapsed time	60.32	0.26
PL/SQL execution elapsed time	22.39	0.10
PL/SQL compilation elapsed time	18.76	0.08
hard parse (sharing criteria) elapsed time	17.83	0.08
sequence load elapsed time	8.85	0.04
hard parse (bind mismatch) elapsed time	0.81	0.00
repeated bind elapsed time	0.80	0.00
DB time	22,769.67
background elapsed time	177.93
background cpu time	38.75

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	1,957,107
IDLE_TIME	850,365
NICE_TIME	161
SYS_TIME	572,537
USER_TIME	1,384,409
LOAD	5	3
PHYSICAL_MEMORY_BYTES	153,888	148,336
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
24-Jul 16:00:43	4.65
24-Jul 18:00:54	2.93	69.71	49.31	20.39	30.29	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 114.2% of Total DB time 22,769.67 (s)
Total FG Wait Time: 8,097.68 (s) DB CPU time: 17,911.36 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			17,911		78.66
User I/O	30,651,051	0	7,252	0	31.85
Concurrency	59,983	0	481	8	2.11
Other	19,370	1	147	8	0.64
Application	110,587	0	108	1	0.47
Commit	7,605	0	56	7	0.24
Network	3,322,301	0	55	0	0.24
System I/O	1,993	0	0	0	0.00
Configuration	5	0	0	64	0.00

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 scattered read	21,266,485	0	5,141	0	2,596.32	22.58
db file sequential read	8,111,966	0	1,154	0	990.35	5.07
read by other session	228,114	0	779	3	27.85	3.42
latch: cache buffers chains	21,296	0	251	12	2.60	1.10
db file parallel read	410,658	0	174	0	50.14	0.77
latch: library cache	21,875	0	171	8	2.67	0.75
SQL*Net break/reset to client	110,586	0	108	1	13.50	0.47
latch free	10,039	0	87	9	1.23	0.38
log file sync	7,605	0	56	7	0.93	0.24
latch: cache buffers lru chain	8,981	0	50	6	1.10	0.22
latch: shared pool	13,566	0	38	3	1.66	0.17
SQL*Net more data from client	267,608	0	35	0	32.67	0.15
library cache pin	1,703	0	13	8	0.21	0.06
SQL*Net more data to client	395,540	0	11	0	48.29	0.05
kksfbc child completion	232	82	10	42	0.03	0.04
SQL*Net message to client	2,659,153	0	8	0	324.64	0.04
library cache load lock	25	0	3	137	0.00	0.02
direct path read	625,232	0	3	0	76.33	0.01
row cache lock	333	0	1	3	0.04	0.00
latch: row cache objects	66	0	1	10	0.01	0.00
enq: TX - index contention	12	0	1	49	0.00	0.00
cursor: mutex X	536	0	1	1	0.07	0.00
latch: library cache lock	52	0	0	7	0.01	0.00
control file sequential read	1,992	0	0	0	0.24	0.00
latch: library cache pin	50	0	0	6	0.01	0.00
log file switch completion	3	0	0	105	0.00	0.00
latch: object queue header operation	22	0	0	8	0.00	0.00
cursor: mutex S	435	0	0	0	0.05	0.00
latch: enqueue hash chains	18	0	0	8	0.00	0.00
buffer busy waits	31	0	0	3	0.00	0.00
latch: session allocation	12	0	0	4	0.00	0.00
wait list latch free	3	0	0	10	0.00	0.00
direct path read temp	7,832	0	0	0	0.96	0.00
enq: TX - row lock contention	1	0	0	14	0.00	0.00
latch: In memory undo latch	3	0	0	2	0.00	0.00
LGWR wait for redo copy	61	0	0	0	0.01	0.00
direct path write temp	616	0	0	0	0.08	0.00
enq: SQ - contention	2	0	0	2	0.00	0.00
buffer deadlock	1	100	0	3	0.00	0.00
SQL*Net message from client	2,659,148	0	559,922	211	324.64
Streams AQ: waiting for messages in the queue	1,442	100	7,036	4879	0.18
wait for unread message on broadcast channel	7,191	100	7,035	978	0.88
virtual circuit status	241	100	7,023	29143	0.03
dispatcher timer	120	100	6,995	58294	0.01
jobq slave wait	2,242	99	6,569	2930	0.27
pipe get	10	100	20	1954	0.00
class slave wait	1	100	5	4883	0.00
rdbms ipc message	1	100	3	2931	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	12,909	0	49	4	1.58	27.70
control file parallel write	2,398	0	37	15	0.29	20.57
db file sequential read	7,235	0	9	1	0.88	5.01
os thread startup	96	0	7	74	0.01	3.99
db file scattered read	249	0	1	6	0.03	0.77
events in waitclass Other	177	0	1	4	0.02	0.42
latch: library cache	117	0	1	6	0.01	0.37
control file sequential read	327	0	0	0	0.04	0.07
latch: shared pool	45	0	0	3	0.01	0.07
latch: cache buffers chains	5	0	0	16	0.00	0.04
log file sequential read	2	0	0	16	0.00	0.02
log file single write	2	0	0	4	0.00	0.00
rdbms ipc message	35,587	65	60,743	1707	4.34
pmon timer	4,168	100	7,034	1688	0.51
Streams AQ: qmn coordinator idle wait	529	52	7,015	13261	0.06
Streams AQ: qmn slave idle wait	256	0	7,015	27402	0.03
smon timer	26	85	6,405	246363	0.00
Streams AQ: waiting for time management or cleanup tasks	8	100	3,881	485069	0.00
SGA: MMAN sleep for component shrink	22	68	0	8	0.00

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	22,604	17,815	264,797	606,161
SYS$USERS	169	99	21	433
SYS$BACKGROUND	0	0	11	77
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	30634904	7208	58866	474	3209507	42
SYS$USERS	18239	37	749	5	2561	0
SYS$BACKGROUND	9154	18	294	8	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 64.9% of Total DB Time (s): 22,770
Captured PL/SQL account for 30.8% of Total DB Time (s): 22,770

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
4,210.68	508	8.29	18.49	84.68	44.83	1muhv8tf83ubf	w3wp.exe	begin m_momutual_pro; end;
2,798.04	4,320	0.65	12.29	90.21	40.50	8ztar1sumtc48	GatewayService.exe	begin GetSmsMo(MO_CS=>:MO_CS, ...
2,792.29	4,320	0.65	12.26	90.22	40.58	g94998wamfgyy	GatewayService.exe	UPDATE MOSMSPOOL SET MOSTATUS=...
2,678.44	4,449	0.60	11.76	89.86	35.89	1219g9d5xkj5k	GatewayService.exe	select * from (select mtid , m...
1,354.55	5,792	0.23	5.95	87.95	0.00	dmapqnhh3y0rr	GatewayService.exe	select * from(select * from mt...
1,349.73	5,798	0.23	5.93	88.33	0.00	bj0ps0v1d8rz0	GatewayService.exe	select * from(select * from mt...
839.37	58,891	0.01	3.69	95.07	0.00	fmfsxc8bkp7jt	w3wp.exe	select QUEUEID, CELLPHONE, BUS...
616.85	6,544	0.09	2.71	93.24	0.00	f7m8b72gatgfs	GatewayService.exe	select * from (select mtid , m...
436.87	507	0.86	1.92	84.97	43.72	8jpppj79wmxyn	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
430.46	507	0.85	1.89	83.41	44.83	15grg1furvscg	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
430.16	507	0.85	1.89	86.04	45.42	gdpbn3z7r88jr	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
421.63	506	0.83	1.85	83.84	44.29	2kvfbnkhck0n9	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
421.53	507	0.83	1.85	83.06	45.00	ccuxk4ndnnwty	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
419.13	507	0.83	1.84	83.62	45.02	5z5q40njkk2bv	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
416.97	507	0.82	1.83	83.61	45.48	9n8fbbaddhxk5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
414.78	507	0.82	1.82	84.93	44.60	9acck5jxvqtwp	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
412.60	507	0.81	1.81	84.47	44.70	g8cnhk1k96nn8	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
399.33	507	0.79	1.75	85.94	45.53	98dmu012znzf5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
316.71	66,760	0.00	1.39	80.98	0.00	0h6b2sajwb74n		select privilege#, level from ...

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 71.6% of Total CPU Time (s): 17,911
Captured PL/SQL account for 34.0% of Total CPU Time (s): 17,911

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
3,565.49	508	7.02	19.91	4,210.68	84.68	44.83	1muhv8tf83ubf	w3wp.exe	begin m_momutual_pro; end;
2,524.24	4,320	0.58	14.09	2,798.04	90.21	40.50	8ztar1sumtc48	GatewayService.exe	begin GetSmsMo(MO_CS=>:MO_CS, ...
2,519.29	4,320	0.58	14.07	2,792.29	90.22	40.58	g94998wamfgyy	GatewayService.exe	UPDATE MOSMSPOOL SET MOSTATUS=...
2,406.79	4,449	0.54	13.44	2,678.44	89.86	35.89	1219g9d5xkj5k	GatewayService.exe	select * from (select mtid , m...
1,192.21	5,798	0.21	6.66	1,349.73	88.33	0.00	bj0ps0v1d8rz0	GatewayService.exe	select * from(select * from mt...
1,191.37	5,792	0.21	6.65	1,354.55	87.95	0.00	dmapqnhh3y0rr	GatewayService.exe	select * from(select * from mt...
798.01	58,891	0.01	4.46	839.37	95.07	0.00	fmfsxc8bkp7jt	w3wp.exe	select QUEUEID, CELLPHONE, BUS...
575.18	6,544	0.09	3.21	616.85	93.24	0.00	f7m8b72gatgfs	GatewayService.exe	select * from (select mtid , m...
371.19	507	0.73	2.07	436.87	84.97	43.72	8jpppj79wmxyn	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
370.10	507	0.73	2.07	430.16	86.04	45.42	gdpbn3z7r88jr	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
359.04	507	0.71	2.00	430.46	83.41	44.83	15grg1furvscg	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
353.47	506	0.70	1.97	421.63	83.84	44.29	2kvfbnkhck0n9	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
352.29	507	0.69	1.97	414.78	84.93	44.60	9acck5jxvqtwp	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
350.49	507	0.69	1.96	419.13	83.62	45.02	5z5q40njkk2bv	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
350.12	507	0.69	1.95	421.53	83.06	45.00	ccuxk4ndnnwty	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
348.64	507	0.69	1.95	416.97	83.61	45.48	9n8fbbaddhxk5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
348.53	507	0.69	1.95	412.60	84.47	44.70	g8cnhk1k96nn8	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
343.19	507	0.68	1.92	399.33	85.94	45.53	98dmu012znzf5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
256.47	66,760	0.00	1.43	316.71	80.98	0.00	0h6b2sajwb74n		select privilege#, level from ...

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 58.3% of Total User I/O Wait Time (s): 7,262
Captured PL/SQL account for 41.6% of Total User I/O Wait Time (s): 7,262

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,887.69	508	3.72	25.99	4,210.68	84.68	44.83	1muhv8tf83ubf	w3wp.exe	begin m_momutual_pro; end;
1,133.19	4,320	0.26	15.60	2,798.04	90.21	40.50	8ztar1sumtc48	GatewayService.exe	begin GetSmsMo(MO_CS=>:MO_CS, ...
1,133.19	4,320	0.26	15.60	2,792.29	90.22	40.58	g94998wamfgyy	GatewayService.exe	UPDATE MOSMSPOOL SET MOSTATUS=...
961.39	4,449	0.22	13.24	2,678.44	89.86	35.89	1219g9d5xkj5k	GatewayService.exe	select * from (select mtid , m...
195.37	507	0.39	2.69	430.16	86.04	45.42	gdpbn3z7r88jr	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
192.98	507	0.38	2.66	430.46	83.41	44.83	15grg1furvscg	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
191.01	507	0.38	2.63	436.87	84.97	43.72	8jpppj79wmxyn	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
189.70	507	0.37	2.61	421.53	83.06	45.00	ccuxk4ndnnwty	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
189.63	507	0.37	2.61	416.97	83.61	45.48	9n8fbbaddhxk5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
188.68	507	0.37	2.60	419.13	83.62	45.02	5z5q40njkk2bv	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
186.74	506	0.37	2.57	421.63	83.84	44.29	2kvfbnkhck0n9	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
184.97	507	0.36	2.55	414.78	84.93	44.60	9acck5jxvqtwp	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
184.43	507	0.36	2.54	412.60	84.47	44.70	g8cnhk1k96nn8	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
181.81	507	0.36	2.50	399.33	85.94	45.53	98dmu012znzf5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
85.23	17,331	0.00	1.17	90.14	30.25	94.55	152u8usqnbysz	w3wp.exe	SELECT COUNT(0) FROM (SELECT M...

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: 606,597,973
Captured SQL account for 85.4% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
146,176,828	6,544	22,337.53	24.10	616.85	93.2	0	f7m8b72gatgfs	GatewayService.exe	select * from (select mtid , m...
105,180,808	508	207,048.83	17.34	4,210.68	84.7	44.8	1muhv8tf83ubf	w3wp.exe	begin m_momutual_pro; end;
62,162,326	5,798	10,721.34	10.25	1,349.73	88.3	0	bj0ps0v1d8rz0	GatewayService.exe	select * from(select * from mt...
62,093,004	5,792	10,720.48	10.24	1,354.55	88	0	dmapqnhh3y0rr	GatewayService.exe	select * from(select * from mt...
61,910,288	4,320	14,331.09	10.21	2,798.04	90.2	40.5	8ztar1sumtc48	GatewayService.exe	begin GetSmsMo(MO_CS=>:MO_CS, ...
61,892,875	4,320	14,327.05	10.20	2,792.29	90.2	40.6	g94998wamfgyy	GatewayService.exe	UPDATE MOSMSPOOL SET MOSTATUS=...
53,571,712	4,449	12,041.29	8.83	2,678.44	89.9	35.9	1219g9d5xkj5k	GatewayService.exe	select * from (select mtid , m...
11,837,820	58,891	201.01	1.95	839.37	95.1	0	fmfsxc8bkp7jt	w3wp.exe	select QUEUEID, CELLPHONE, BUS...
10,511,451	507	20,732.64	1.73	430.16	86	45.4	gdpbn3z7r88jr	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
10,510,818	507	20,731.40	1.73	430.46	83.4	44.8	15grg1furvscg	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
10,510,800	507	20,731.36	1.73	412.60	84.5	44.7	g8cnhk1k96nn8	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
10,510,656	507	20,731.08	1.73	436.87	85	43.7	8jpppj79wmxyn	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
10,510,628	507	20,731.02	1.73	419.13	83.6	45	5z5q40njkk2bv	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
10,510,618	507	20,731.00	1.73	421.53	83.1	45	ccuxk4ndnnwty	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
10,510,617	507	20,731.00	1.73	399.33	85.9	45.5	98dmu012znzf5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
10,510,617	507	20,731.00	1.73	414.78	84.9	44.6	9acck5jxvqtwp	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
10,497,352	507	20,704.84	1.73	416.97	83.6	45.5	9n8fbbaddhxk5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
10,489,888	506	20,731.00	1.73	421.63	83.8	44.3	2kvfbnkhck0n9	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...

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: 264,824,536
Captured SQL account for 78.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
100,303,100	508	197,447.05	37.88	4,210.68	84.68	44.83	1muhv8tf83ubf	w3wp.exe	begin m_momutual_pro; end;
58,986,469	4,320	13,654.28	22.27	2,798.04	90.21	40.50	8ztar1sumtc48	GatewayService.exe	begin GetSmsMo(MO_CS=>:MO_CS, ...
58,986,469	4,320	13,654.28	22.27	2,792.29	90.22	40.58	g94998wamfgyy	GatewayService.exe	UPDATE MOSMSPOOL SET MOSTATUS=...
49,282,242	4,449	11,077.15	18.61	2,678.44	89.86	35.89	1219g9d5xkj5k	GatewayService.exe	select * from (select mtid , m...
10,374,624	507	20,462.77	3.92	430.16	86.04	45.42	gdpbn3z7r88jr	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
10,119,412	507	19,959.39	3.82	436.87	84.97	43.72	8jpppj79wmxyn	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
10,034,776	507	19,792.46	3.79	430.46	83.41	44.83	15grg1furvscg	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
9,962,704	507	19,650.30	3.76	416.97	83.61	45.48	9n8fbbaddhxk5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
9,961,203	506	19,686.17	3.76	421.63	83.84	44.29	2kvfbnkhck0n9	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
9,961,087	507	19,647.11	3.76	421.53	83.06	45.00	ccuxk4ndnnwty	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...
9,960,393	507	19,645.75	3.76	414.78	84.93	44.60	9acck5jxvqtwp	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
9,952,432	507	19,630.04	3.76	419.13	83.62	45.02	5z5q40njkk2bv	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
9,943,387	507	19,612.20	3.75	399.33	85.94	45.53	98dmu012znzf5	w3wp.exe	UPDATE M_MTQUEUE SET STATUS=1 ...
9,932,025	507	19,589.79	3.75	412.60	84.47	44.70	g8cnhk1k96nn8	w3wp.exe	INSERT INTO KEYACCOUNT.MTSMSPO...

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: 36,936,688
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
2,008	04xtrk7uyhknh		select obj#, type#, ctime, mti...
35	05sghzkq6r6yv		select ts#, file#, block#, col...
1	08bqjmf8490s2	OMS	SELECT PARAMETER_VALUE FROM MG...
12	0a8cwnjydmfxf	mInfoService3.exe	select * from (select title, s...
66,760	0h6b2sajwb74n		select privilege#, level from ...
22,173	0k8522rmdzg4k		select privilege# from sysauth...
65	0m78skf1mudnb		select audit$, properties from...
22,052	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
5	0xwby571mq3n2		select name, password, datats#...
4,449	1219g9d5xkj5k	GatewayService.exe	select * from (select mtid , m...

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,193,170
Captured SQL account for 53.0% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
66,760	576,606	8.64	316.71	81	0	0h6b2sajwb74n		select privilege#, level from ...
58,891	0	0.00	839.37	95.1	0	fmfsxc8bkp7jt	w3wp.exe	select QUEUEID, CELLPHONE, BUS...
28,690	0	0.00	7.81	82	0	a3pdtfwpb4tyv	GatewayService.exe	select * from(select mtid, mtt...
26,495	29,452	1.11	5.72	73.2	10.4	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
22,173	66,760	3.01	31.37	81.7	0	0k8522rmdzg4k		select privilege# from sysauth...
22,159	0	0.00	6.06	89	0	f4nkbzq57mqpq	w3wp.exe	select id, message, cellphone,...
22,052	22,052	1.00	19.25	83.2	0	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
22,052	22,052	1.00	13.36	85.5	0	459f3z9u4fb3u		select value$ from props$ wher...
22,052	22,052	1.00	10.08	86.2	0	5ur69atw3vfhj		select decode(failover_method,...
22,008	0	0.00	22.54	87.1	0	5gmcvq0z306vy	w3wp.exe	ALTER SESSION SET NLS_LANGUAGE...
17,331	17,331	1.00	90.14	30.2	94.6	152u8usqnbysz	w3wp.exe	SELECT COUNT(0) FROM (SELECT M...
14,349	0	0.00	4.05	75.3	0	6q7mub24skb40	GatewayService.exe	select * from(select mtid, cel...
14,349	0	0.00	4.13	75.6	0	9jks316cgtwa2	GatewayService.exe	select * from (select mtid , c...
14,335	0	0.00	9.90	51	0	9t96w63r4kjkg	GatewayService.exe	select * from (select mtid , m...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,038,313
Captured SQL account for 53.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
66,760	66,760	6.43	0h6b2sajwb74n		select privilege#, level from ...
58,891	58,891	5.67	fmfsxc8bkp7jt	w3wp.exe	select QUEUEID, CELLPHONE, BUS...
28,684	28,690	2.76	a3pdtfwpb4tyv	GatewayService.exe	select * from(select mtid, mtt...
22,173	22,173	2.14	0k8522rmdzg4k		select privilege# from sysauth...
22,159	22,159	2.13	f4nkbzq57mqpq	w3wp.exe	select id, message, cellphone,...
22,052	22,052	2.12	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
22,052	22,052	2.12	459f3z9u4fb3u		select value$ from props$ wher...
22,052	22,052	2.12	5ur69atw3vfhj		select decode(failover_method,...
22,008	22,008	2.12	5gmcvq0z306vy	w3wp.exe	ALTER SESSION SET NLS_LANGUAGE...
14,349	14,349	1.38	9jks316cgtwa2	GatewayService.exe	select * from (select mtid , c...
14,348	14,349	1.38	6q7mub24skb40	GatewayService.exe	select * from(select mtid, cel...
14,334	14,335	1.38	9t96w63r4kjkg	GatewayService.exe	select * from (select mtid , m...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
6,067,326	6,463	3.91	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
3,663,092	66,760	2.36	0h6b2sajwb74n		select privilege#, level from ...
2,783,574	239	1.79	aykvshm7zsabd		select size_for_estimate, size...
1,300,520	217	0.84	fy7x1t70t5m0h	mInfoAdService.exe	Select admsensegroup.groupid, ...
1,103,982	9	0.71	bkdusjx00dsmc		select i.obj#, i.ts#, i.file#,...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
188	116	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

05sghzkq6r6yv select ts#, file#, block#, cols, nvl(size$, -1), pctfree$, pctused$, initrans, maxtrans, hashkeys, func, extind, avgchn, nvl(degree, 1), nvl(instances, 1), nvl(flags, 0), nvl(spare1, 0)from clu$ where obj#=:1

08bqjmf8490s2 SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

0a8cwnjydmfxf select * from (select title, source, type, time , url from newwapnews where type='??' and source = '??' order by time DESC) where rownum <= 100

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

0m78skf1mudnb select audit$, properties from type_misc$ where obj#=:1

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

0xwby571mq3n2 select name, password, datats#, tempts#, type#, defrole, resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass, NULL, 'DEFAULT_CONSUMER_GROUP', defschclass), spare1 from user$ where user#=:1

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

152u8usqnbysz SELECT COUNT(0) FROM (SELECT MTSTATUS FROM KEYACCOUNT.MTSMSPOOL M WHERE M.CELLPHONE=:B5 AND M.PROJECTID=:B4 AND M.PUSHMETHOD='SMS'AND M.MESSAGE=:B3 AND M.MTTAG=LPAD(LPAD(:B2 , 8, '0'), 10, 'MM')||LPAD(LPAD(:B1 , 5, '0'), 6, 'E'))

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='????'

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='????'

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

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

5gmcvq0z306vy ALTER SESSION SET NLS_LANGUAGE= 'SIMPLIFIED CHINESE' NLS_TERRITORY= 'CHINA' NLS_CURRENCY= '?' NLS_ISO_CURRENCY= 'CHINA' NLS_NUMERIC_CHARACTERS= '., ' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'SIMPLIFIED CHINESE' NLS_SORT= 'BINARY' TIME_ZONE= '+08:00' NLS_COMP= 'BINARY' NLS_DUAL_CURRENCY= '?' NLS_TIME_FORMAT= 'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT= 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM TZR'

5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1

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

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

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#

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

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

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

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

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

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='????'

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

f4nkbzq57mqpq select id, message, cellphone, servicecode, linkid, carrier, serviceid from messagequeue where method='SMS' and delivertime<CURRENT_TIMESTAMP and status=' ' and queuename='ZhangShangTong'

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

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

fy7x1t70t5m0h Select admsensegroup.groupid, admsensegroup.merchantid, admsensegroup.content, admsensegroup.city, admsensegroup.ispush, admsensegroup.internalurl, admsensekeyword.sid, admsensekeyword.keyword from admsensegroup, admsensekeyword, admerchants where admerchants.merchantid=admsensegroup.merchantid and admerchants.status=1 and admsensekeyword.status=1 and admsensegroup.status=1 and admsensekeyword.groupid=admsensegroup.groupid order by length(admsensekeyword.keyword) desc

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='????'

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='????'

SQL Id	SQL Text
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
05sghzkq6r6yv	select ts#, file#, block#, cols, nvl(size$, -1), pctfree$, pctused$, initrans, maxtrans, hashkeys, func, extind, avgchn, nvl(degree, 1), nvl(instances, 1), nvl(flags, 0), nvl(spare1, 0)from clu$ where obj#=:1
08bqjmf8490s2	SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
0a8cwnjydmfxf	select * from (select title, source, type, time , url from newwapnews where type='??' and source = '??' order by time DESC) where rownum <= 100
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
0m78skf1mudnb	select audit$, properties from type_misc$ where obj#=:1
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')
0xwby571mq3n2	select name, password, datats#, tempts#, type#, defrole, resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass, NULL, 'DEFAULT_CONSUMER_GROUP', defschclass), spare1 from user$ where user#=:1
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
152u8usqnbysz	SELECT COUNT(0) FROM (SELECT MTSTATUS FROM KEYACCOUNT.MTSMSPOOL M WHERE M.CELLPHONE=:B5 AND M.PROJECTID=:B4 AND M.PUSHMETHOD='SMS'AND M.MESSAGE=:B3 AND M.MTTAG=LPAD(LPAD(:B2 , 8, '0'), 10, 'MM')\|\|LPAD(LPAD(:B1 , 5, '0'), 6, 'E'))
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='????'
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='????'
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5gmcvq0z306vy	ALTER SESSION SET NLS_LANGUAGE= 'SIMPLIFIED CHINESE' NLS_TERRITORY= 'CHINA' NLS_CURRENCY= '?' NLS_ISO_CURRENCY= 'CHINA' NLS_NUMERIC_CHARACTERS= '., ' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'SIMPLIFIED CHINESE' NLS_SORT= 'BINARY' TIME_ZONE= '+08:00' NLS_COMP= 'BINARY' NLS_DUAL_CURRENCY= '?' NLS_TIME_FORMAT= 'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT= 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM TZR'
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5z5q40njkk2bv	UPDATE M_MTQUEUE SET STATUS=1 WHERE STATUS=0 AND CATEGORY='????'
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
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#
8jpppj79wmxyn	UPDATE M_MTQUEUE SET STATUS=1 WHERE STATUS=0 AND CATEGORY='????'
8ztar1sumtc48	begin GetSmsMo(MO_CS=>:MO_CS, ServerID=>:ServerID); end;
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
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
bkdusjx00dsmc	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, spare2, spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)) from ind$ i, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.bo#=:1 order by i.obj#
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='????'
dmapqnhh3y0rr	select * from(select * from mtmmspool where mtstatus='0' and projectid in ( '111111', '201401', '111188') order by mtid) where rownum<100
f4nkbzq57mqpq	select id, message, cellphone, servicecode, linkid, carrier, serviceid from messagequeue where method='SMS' and delivertime<CURRENT_TIMESTAMP and status=' ' and queuename='ZhangShangTong'
f7m8b72gatgfs	select * from (select mtid , mttag, cellphone , message, pushmethod, pushlink from mtsmsgroup where mtstatus ='0' and projectid in( '500000') order by mtid)where rownum<50
fmfsxc8bkp7jt	select QUEUEID, CELLPHONE, BUSINESSCODE, LINKID, SERVICENUMBER, MESSAGE, PUSHMETHOD, PUSHLINK from CHSENDSMSQUEUE where MtStatus<>'deliver' and ClientApp = 'SmartClub' order by QUEUEID Asc
fy7x1t70t5m0h	Select admsensegroup.groupid, admsensegroup.merchantid, admsensegroup.content, admsensegroup.city, admsensegroup.ispush, admsensegroup.internalurl, admsensekeyword.sid, admsensekeyword.keyword from admsensegroup, admsensekeyword, admerchants where admerchants.merchantid=admsensegroup.merchantid and admerchants.status=1 and admsensekeyword.status=1 and admsensegroup.status=1 and admsensekeyword.groupid=admsensegroup.groupid order by length(admsensekeyword.keyword) desc
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='????'
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='????'

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	1,818,307	252.16	221.99
CPU used when call started	1,811,280	251.18	221.13
CR blocks created	2,143	0.30	0.26
Cached Commit SCN referenced	4,147	0.58	0.51
Commit SCN cached	1	0.00	0.00
DB time	4,454,600	617.75	543.84
DBWR checkpoint buffers written	1,209	0.17	0.15
DBWR checkpoints	1	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	230	0.03	0.03
DBWR undo block writes	2,827	0.39	0.35
IMU CR rollbacks	2,096	0.29	0.26
IMU Flushes	2,924	0.41	0.36
IMU Redo allocation size	1,794,568	248.86	219.09
IMU commits	6,485	0.90	0.79
IMU contention	28	0.00	0.00
IMU ktichg flush	1	0.00	0.00
IMU pool not allocated	3,207	0.44	0.39
IMU recursive-transaction flush	3	0.00	0.00
IMU undo allocation size	11,632,928	1,613.21	1,420.21
IMU- failed to get a private strand	3,207	0.44	0.39
Misses for writing mapping	0	0.00	0.00
SMON posted for undo segment shrink	1	0.00	0.00
SQL*Net roundtrips to/from client	2,592,101	359.46	316.46
active txn count during cleanout	1,914	0.27	0.23
application wait time	10,802	1.50	1.32
background checkpoints completed	0	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	23,024	3.19	2.81
branch node splits	1	0.00	0.00
buffer is not pinned count	293,682,507	40,726.73	35,854.29
buffer is pinned count	3,349,545,058	464,501.65	408,929.93
bytes received via SQL*Net from client	1,256,298,362	174,218.48	153,375.46
bytes sent via SQL*Net to client	2,333,174,284	323,555.37	284,846.09
calls to get snapshot scn: kcmgss	4,789,296	664.16	584.70
calls to kcmgas	17,943	2.49	2.19
calls to kcmgcs	142	0.02	0.02
change write time	475	0.07	0.06
cleanout - number of ktugct calls	2,024	0.28	0.25
cleanouts and rollbacks - consistent read gets	1,794	0.25	0.22
cleanouts only - consistent read gets	13	0.00	0.00
cluster key scan block gets	401,476	55.68	49.01
cluster key scans	250,416	34.73	30.57
commit batch performed	8	0.00	0.00
commit batch requested	8	0.00	0.00
commit batch/immediate performed	155	0.02	0.02
commit batch/immediate requested	155	0.02	0.02
commit cleanout failures: block lost	11	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	8	0.00	0.00
commit cleanout failures: cannot pin	24	0.00	0.00
commit cleanouts	29,249	4.06	3.57
commit cleanouts successfully completed	29,206	4.05	3.57
commit immediate performed	147	0.02	0.02
commit immediate requested	147	0.02	0.02
commit txn count during cleanout	294	0.04	0.04
concurrency wait time	48,668	6.75	5.94
consistent changes	4,669	0.65	0.57
consistent gets	606,477,439	84,103.89	74,041.93
consistent gets - examination	3,472,560	481.56	423.95
consistent gets direct	626,345	86.86	76.47
consistent gets from cache	605,851,095	84,017.03	73,965.46
current blocks converted for CR	5	0.00	0.00
cursor authentications	5,185	0.72	0.63
data blocks consistent reads - undo records applied	3,190	0.44	0.39
db block changes	126,347	17.52	15.43
db block gets	120,565	16.72	14.72
db block gets direct	178	0.02	0.02
db block gets from cache	120,387	16.69	14.70
deferred (CURRENT) block cleanout applications	14,438	2.00	1.76
dirty buffers inspected	10,557	1.46	1.29
enqueue conversions	1,450	0.20	0.18
enqueue deadlocks	0	0.00	0.00
enqueue releases	387,504	53.74	47.31
enqueue requests	387,504	53.74	47.31
enqueue timeouts	0	0.00	0.00
enqueue waits	14	0.00	0.00
exchange deadlocks	1	0.00	0.00
execute count	1,193,170	165.46	145.67
frame signature mismatch	0	0.00	0.00
free buffer inspected	266,621,988	36,974.08	32,550.60
free buffer requested	264,186,889	36,636.39	32,253.31
heap block compress	728	0.10	0.09
hot buffers moved to head of LRU	216,503	30.02	26.43
immediate (CR) block cleanout applications	1,807	0.25	0.22
immediate (CURRENT) block cleanout applications	2,196	0.30	0.27
index fast full scans (full)	84	0.01	0.01
index fetch by key	692,043	95.97	84.49
index scans kdiixs1	3,039,865	421.56	371.12
leaf node 90-10 splits	34	0.00	0.00
leaf node splits	63	0.01	0.01
lob reads	647,555	89.80	79.06
lob writes	225	0.03	0.03
lob writes unaligned	195	0.03	0.02
logons cumulative	22,264	3.09	2.72
messages received	14,476	2.01	1.77
messages sent	14,476	2.01	1.77
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	598,330,465	82,974.10	73,047.30
opened cursors cumulative	1,036,123	143.69	126.50
parse count (failures)	54,824	7.60	6.69
parse count (hard)	250,640	34.76	30.60
parse count (total)	1,038,313	143.99	126.76
parse time cpu	188,557	26.15	23.02
parse time elapsed	226,812	31.45	27.69
physical read IO requests	36,936,688	5,122.23	4,509.42
physical read bytes	2,169,442,598,912	300,849,709.55	264,856,867.16
physical read total IO requests	36,939,438	5,122.61	4,509.76
physical read total bytes	2,169,481,673,728	300,855,128.29	264,861,637.62
physical read total multi block requests	21,270,153	2,949.66	2,596.77
physical reads	264,824,536	36,724.82	32,331.16
physical reads cache	264,182,913	36,635.84	32,252.83
physical reads cache prefetch	234,383,995	32,503.44	28,614.82
physical reads direct	641,623	88.98	78.33
physical reads direct (lob)	626,307	86.85	76.46
physical reads direct temporary tablespace	15,278	2.12	1.87
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	10,197	1.41	1.24
physical write bytes	230,801,408	32,006.63	28,177.44
physical write total IO requests	30,767	4.27	3.76
physical write total bytes	375,220,224	52,034.05	45,808.84
physical write total multi block requests	15,196	2.11	1.86
physical writes	28,174	3.91	3.44
physical writes direct	15,456	2.14	1.89
physical writes direct (lob)	125	0.02	0.02
physical writes direct temporary tablespace	15,278	2.12	1.87
physical writes from cache	12,718	1.76	1.55
physical writes non checkpoint	26,816	3.72	3.27
pinned buffers inspected	24,463	3.39	2.99
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	560	0.08	0.07
process last non-idle time	7,205	1.00	0.88
recursive calls	4,345,482	602.61	530.52
recursive cpu usage	987,150	136.89	120.52
redo blocks written	50,138	6.95	6.12
redo buffer allocation retries	3	0.00	0.00
redo entries	45,040	6.25	5.50
redo log space requests	3	0.00	0.00
redo log space wait time	32	0.00	0.00
redo ordering marks	699	0.10	0.09
redo size	21,570,056	2,991.25	2,633.38
redo synch time	5,690	0.79	0.69
redo synch writes	15,635	2.17	1.91
redo wastage	3,459,060	479.69	422.30
redo write time	5,039	0.70	0.62
redo writer latching time	0	0.00	0.00
redo writes	12,908	1.79	1.58
rollback changes - undo records applied	370	0.05	0.05
rollbacks only - consistent read gets	348	0.05	0.04
rows fetched via callback	196,189	27.21	23.95
session connect time	0	0.00	0.00
session cursor cache hits	471,751	65.42	57.59
session logical reads	606,597,973	84,120.61	74,056.64
shared hash latch upgrades - no wait	3,053,382	423.43	372.77
shared hash latch upgrades - wait	5,731	0.79	0.70
sorts (disk)	1	0.00	0.00
sorts (memory)	839,773	116.46	102.52
sorts (rows)	28,429,835	3,942.54	3,470.86
sql area purged	0	0.00	0.00
summed dirty queue length	10,982	1.52	1.34
switch current to new buffer	555	0.08	0.07
table fetch by rowid	1,778,206,873	246,594.69	217,092.77
table fetch continued row	83,462,755	11,574.28	10,189.57
table scan blocks gotten	269,496,333	37,372.68	32,901.52
table scan rows gotten	14,310,823,897	1,984,568.39	1,747,140.02
table scans (cache partitions)	116	0.02	0.01
table scans (long tables)	24,549	3.40	3.00
table scans (short tables)	261,997	36.33	31.99
total number of times SMON posted	4	0.00	0.00
transaction rollbacks	155	0.02	0.02
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	7,415,852	1,028.40	905.37
user I/O wait time	726,221	100.71	88.66
user calls	3,358,785	465.78	410.06
user commits	8,124	1.13	0.99
user rollbacks	67	0.01	0.01
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	3	0.00	0.00
workarea executions - optimal	194,782	27.01	23.78
write clones created in background	0	0.00	0.00
write clones created in foreground	18	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
workarea memory allocated	648	80
session pga memory	27,785,964,424	27,988,953,740
session uga memory max	280,446,437,216	285,962,132,284
opened cursors current	406	397
session pga memory max	44,617,837,448	44,891,081,356
session uga memory	70,016,045,804,532	70,514,826,924,084
session cursor cache count	5,853,277	5,977,181
logons current	111	120

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

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	36,261,548	5,029	0.18	7.28	4,320	1	227,976	3.52
USERS	623,875	87	0.02	1.00	33	0	0	0.00
SYSTEM	43,516	6	2.10	2.23	357	0	10	9.00
SYSAUX	8,580	1	2.21	1.19	2,668	0	0	0.00
TEMP	7,844	1	0.02	1.95	617	0	0	0.00
UNDOTBS1	1,984	0	0.37	1.00	2,256	0	3	0.00
EXAMPLE	2	0	0.00	1.00	0	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
EXAMPLE	/newdisk/u01/app/oracle/oradata/minfo/example01.dbf	2	0	0.00	1.00	0	0	0.00
MINFO1108	/newdisk/u01/app/oracle/oradata/minfo/minfo1108.dbf	3,384,327	469	0.30	10.87	209	101,245	3.28
MINFO1108	/newdisk/u01/app/oracle/oradata/minfo/minfo110802.dbf	3,401,687	472	0.29	10.90	429	105,293	3.31
MINFO1108	/newdisk/u01/app/oracle/oradata/minfo/minfo110803.dbf	15,188,451	2,106	0.15	6.31	1,687	14,862	5.67
MINFO1108	/newdisk/u01/app/oracle/oradata/minfo/minfo110804.dbf	14,287,083	1,981	0.15	6.60	1,995	6,576	5.82
SYSAUX	/newdisk/u01/app/oracle/oradata/minfo/sysaux01.dbf	8,580	1	2.21	1.19	2,668	0	0.00
SYSTEM	/newdisk/u01/app/oracle/oradata/minfo/system01.dbf	43,516	6	2.10	2.23	357	10	9.00
TEMP	/newdisk/u01/app/oracle/oradata/minfo/temp01.dbf	7,844	1	0.02	1.95	617	0
UNDOTBS1	/newdisk/u01/app/oracle/oradata/minfo/undotbs01.dbf	1,984	0	0.37	1.00	2,256	3	0.00
USERS	/newdisk/u01/app/oracle/oradata/minfo/users01.dbf	623,875	87	0.02	1.00	33	0	0.00

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	46,068	56	605,430,776	264,137,018	12,718	0	0	228,144

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 28,174

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	1,209	0

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	118	3367	58408	184320	58408
E	0	24	1002	4620	12405	184320	12405

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	36	0.10	4	1.37	54,477,598	1
D	72	0.19	9	1.33	52,936,773	1
D	108	0.29	13	1.28	51,136,098	1
D	144	0.38	18	1.25	49,771,169	1
D	180	0.48	22	1.21	48,401,899	1
D	216	0.57	27	1.18	47,016,354	1
D	252	0.67	31	1.14	45,594,251	1
D	288	0.77	36	1.11	44,099,305	1
D	324	0.86	40	1.06	42,415,859	1
D	360	0.96	45	1.02	40,684,576	1
D	376	1.00	47	1.00	39,859,461	1
D	396	1.05	49	0.97	38,828,067	1
D	432	1.15	54	0.93	37,059,534	1
D	468	1.24	58	0.89	35,415,765	1
D	504	1.34	63	0.85	33,884,379	1
D	540	1.44	67	0.81	32,429,569	1
D	576	1.53	72	0.78	31,012,378	1
D	612	1.63	76	0.74	29,622,872	1
D	648	1.72	81	0.71	28,218,003	1
D	684	1.82	85	0.67	26,873,367	1
D	720	1.91	90	0.64	25,587,867	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
96.95	4,661	147

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	64	215.35	0.63	0.29	100.00	0.00	36,659
E	179	62	224.31	0.55	0.24	100.00	0.00	36,659

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
2K	4K	185,478	185,478	0
64K	128K	5,000	5,000	0
128K	256K	118	118	0
256K	512K	60	60	0
512K	1024K	3,518	3,518	0
1M	2M	567	567	0
2M	4M	32	32	0
4M	8M	8	8	0
32M	64M	3	0	3

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	434,456.42	28,756.41	94.00	6,484
45	0.25	434,456.42	28,756.41	94.00	6,483
90	0.50	434,456.42	25,729.36	94.00	5,814
134	0.75	434,456.42	1,647.95	100.00	118
179	1.00	434,456.42	727.24	100.00	0
215	1.20	434,456.42	532.75	100.00	0
251	1.40	434,456.42	532.75	100.00	0
286	1.60	434,456.42	159.16	100.00	0
322	1.80	434,456.42	159.16	100.00	0
358	2.00	434,456.42	88.06	100.00	0
537	3.00	434,456.42	0.00	100.00	0
716	4.00	434,456.42	0.00	100.00	0
1,074	6.00	434,456.42	0.00	100.00	0
1,432	8.00	434,456.42	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)
132	0.89	17	2,713	3,412,655	1.00	938,000	1.02	111,447
148	1.00	32	5,106	3,429,632	1.00	921,023	1.00	112,635
164	1.11	47	7,546	3,446,585	1.00	904,070	0.98	113,821
180	1.22	62	10,026	3,463,486	1.01	887,169	0.96	115,003
196	1.32	77	12,518	3,480,312	1.01	870,343	0.95	116,178
212	1.43	92	14,961	3,497,041	1.02	853,614	0.93	117,344
228	1.54	107	17,425	3,513,658	1.02	836,997	0.91	118,500
244	1.65	122	18,807	3,530,150	1.03	820,505	0.89	119,646
260	1.76	137	20,632	3,546,510	1.03	804,145	0.87	120,781
276	1.86	152	22,651	3,562,733	1.04	787,922	0.86	121,904
292	1.97	167	24,998	3,578,824	1.04	771,831	0.84	123,017
308	2.08	182	27,509	3,594,791	1.05	755,864	0.82	124,119

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	19,604,707	52,493,908,208
405	0.75	18,135,785	46,806,071,685
540	1.00	16,357,702	39,858,700,234
675	1.25	14,661,409	33,289,986,435
810	1.50	13,187,580	27,586,206,432
945	1.75	12,744,287	26,266,883,454
1,080	2.00	12,660,863	26,266,883,454

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	228,064	803	4
segment header	45	1	16
undo header	3	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (index contention)	12	12	12	1	49.17
TX-Transaction (row lock contention)	1	1	1	0	40.00
SQ-Sequence Cache	1,217	1,217	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	1.04	14,410	143	7	15/15	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
24-Jul 17:57	58	1,202	0	5	15	0/0	0/0/0/0/0/0
24-Jul 17:47	87	1,244	107	6	15	0/0	0/0/0/0/0/0
24-Jul 17:37	53	769	141	4	15	0/0	0/0/0/0/0/0
24-Jul 17:27	97	1,685	16	6	15	0/0	0/0/0/0/0/0
24-Jul 17:17	78	1,229	143	5	15	0/0	0/0/0/0/0/0
24-Jul 17:07	172	1,488	63	5	15	0/0	0/0/0/0/0/0
24-Jul 16:57	67	1,232	97	7	15	0/0	0/0/0/0/0/0
24-Jul 16:47	75	1,010	53	5	15	0/0	0/0/0/0/0/0
24-Jul 16:37	68	1,123	81	4	15	0/0	0/0/0/0/0/0
24-Jul 16:27	65	1,007	93	6	15	0/0	0/0/0/0/0/0
24-Jul 16:17	71	1,166	90	5	15	0/0	0/0/0/0/0/0
24-Jul 16:07	152	1,255	64	5	15	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
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	18,901	0.00		0	0
Consistent RBA	12,913	0.01	0.00	0	0
FIB s.o chain latch	232	0.00		0	0
FOB s.o list latch	4,752	0.00		0	0
In memory undo latch	66,421	0.09	0.05	0	19,189	0.01
JS mem alloc latch	12	0.00		0	0
JS queue access latch	12	0.00		0	0
JS queue state obj latch	52,068	0.00		0	0
JS slv state obj latch	307	0.00		0	0
KMG MMAN ready and startup request latch	2,424	0.00		0	0
KMG resize request state object freelist	116	0.00		0	0
KTF sga latch	15	0.00		0	1,811	0.00
KWQMN job cache list latch	13	0.00		0	0
MQL Tracking Latch	0			0	144	0.00
Memory Management Latch	1,182	0.00		0	2,424	0.00
OS process	67,053	0.00		0	0
OS process allocation	47,103	0.00	1.00	0	0
OS process: request allocation	44,317	0.00		0	0
PL/SQL warning settings	32,221	0.00		0	0
SGA IO buffer pool latch	2,023	0.00		0	2,023	0.00
SQL memory manager latch	4	0.00		0	2,388	0.00
SQL memory manager workarea list latch	193,076	0.00		0	0
Shared B-Tree	268	0.00		0	0
active checkpoint queue latch	4,195	0.00		0	0
active service list	147,721	0.00	0.67	0	4,167	0.02
archive control	68	0.00		0	0
begin backup scn array	76	0.00		0	0
buffer pool	193	0.00		0	0
cache buffer handles	1,650	0.00		0	0
cache buffers chains	1,473,386,121	0.10	0.01	252	596,095,968	0.32
cache table scan latch	0			0	20,545,341	3.51
channel handle pool latch	44,321	0.00	0.00	0	0
channel operations parent latch	108,882	0.00	0.00	0	0
checkpoint queue latch	121,575	0.00	0.00	0	26,604	0.00
client/application info	113,440	0.00		0	0
compile environment latch	59,484	0.00		0	0
dml lock allocation	68,651	0.06	0.07	0	0
dummy allocation	44,549	0.00		0	0
enqueue hash chains	776,481	0.06	0.04	0	51	0.00
enqueues	734,543	0.23	0.01	0	0
event group latch	22,158	0.00		0	0
file cache latch	303	0.00		0	0
global KZLD latch for mem in SGA	22,062	0.00	0.00	0	0
hash table column usage latch	2,003	0.00		0	2,390,097	0.08
hash table modification latch	144	0.00		0	0
job workq parent latch	0			0	232	0.00
job_queue_processes parameter latch	235	0.00		0	0
kks stats	769,630	0.31	0.04	2	0
kmcptab latch	1	0.00		0	0
kmcpvec latch	0			0	1	0.00
ksuosstats global area	483	0.00		0	0
ktm global data	28	0.00		0	0
kwqbsn:qsga	268	0.00		0	0
lgwr LWN SCN	13,129	0.01	0.00	0	0
library cache	9,302,789	0.85	0.28	172	729,507	6.07
library cache load lock	57,756	0.00	0.00	0	167	0.00
library cache lock	3,105,034	0.07	0.02	0	0
library cache lock allocation	16,956	0.00		0	0
library cache pin	4,474,615	0.06	0.02	0	302	0.00
library cache pin allocation	10,441	0.00		0	0
list of block allocation	3,211	0.00		0	0
loader state object freelist	1,205,300	0.06	0.00	0	0
longop free list parent	46	0.00		0	44	4.55
message pool operations parent latch	6	0.00		0	0
messages	110,561	0.01	0.00	0	0
mostly latch-free SCN	13,152	0.06	0.00	0	0
multiblock read objects	51,038,658	0.32	0.01	10	0
ncodef allocation latch	199	0.00		0	0
object queue header heap	16,812	0.00		0	16,531	0.00
object queue header operation	528,416,689	0.00	0.03	0	0
object stats modification	6	0.00		0	0
parallel query alloc buffer	956	0.00		0	0
parameter list	200,164	0.00	0.00	0	0
parameter table allocation management	22,396	0.00		0	0
post/wait queue	13,061	0.01	0.00	0	7,676	0.04
process allocation	44,317	0.03	0.50	0	22,155	0.01
process group creation	44,317	0.00		0	0
qmn task queue latch	1,024	0.00		0	0
redo allocation	74,496	0.03	0.00	0	44,940	0.04
redo copy	0			0	44,949	0.15
redo writing	47,980	0.00		0	0
resmgr group change latch	22,694	0.00	0.00	0	0
resmgr:actses active list	44,546	0.00		0	0
resmgr:actses change group	22,178	0.00		0	0
resmgr:free threads list	44,545	0.00	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	16,045,437	1.12	0.00	1	7,661	0.00
sequence cache	77,776	0.04	0.00	0	0
session allocation	1,606,448	0.01	0.06	0	0
session idle bit	6,756,404	0.09	0.00	0	0
session state list latch	557	0.00		0	0
session switching	199	0.00		0	0
session timer	4,168	0.00		0	0
shared pool	6,357,844	1.16	0.18	38	0
simulator hash latch	101,742,874	0.01	0.02	0	0
simulator lru latch	53,453,539	1.22	0.01	75	16,550,585	0.11
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	374	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	526	0.00		0	0
transaction allocation	3,182	0.00		0	0
transaction branch allocation	199	0.00		0	0
undo global data	66,581	0.11	0.01	0	0
user lock	88,502	0.01	0.20	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	1,473,386,121	1,482,416	21,302	1,461,734
cache buffers lru chain	961,921	784,546	8,981	775,793
simulator lru latch	53,453,539	650,382	8,533	642,052
row cache objects	16,045,437	179,669	66	179,603
multiblock read objects	51,038,658	163,147	1,148	162,007
library cache	9,302,789	79,327	21,983	59,079
shared pool	6,357,844	73,619	13,609	61,109
simulator hash latch	101,742,874	11,269	215	11,060
session idle bit	6,756,404	5,832	10	5,822
library cache pin	4,474,615	2,632	50	2,583
kks stats	769,630	2,381	97	2,287
library cache lock	3,105,034	2,142	52	2,091
enqueues	734,543	1,679	21	1,658
object queue header operation	528,416,689	839	22	817
enqueue hash chains	776,481	487	18	469
session allocation	1,606,448	197	12	185
undo global data	66,581	70	1	69
In memory undo latch	66,421	63	3	60
dml lock allocation	68,651	41	3	38
process allocation	44,317	12	6	7
active service list	147,721	6	4	2
user lock	88,502	5	1	4
OS process allocation	47,103	1	1	0
slave class create	8	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	ktiTxnPoolFree	2	0
In memory undo latch	ktiFlush: child	1	2
OS process allocation	kso_delete_process:1	1	1
active service list	ksws_event: ksws event	4	0
active service list	kswssyis: find service entry 1	1	0
cache buffers chains	kcbzib: multi-block read: nowait	10,550	0
cache buffers chains	kcbgtcr: kslbegin excl	6,517	20,083
cache buffers chains	kcbrls: kslbegin	2,619	457
cache buffers chains	kcbzgb: scan from tail. nowait	2,163	0
cache buffers chains	kcbzib: finish free bufs	640	1,682
cache buffers chains	kcbgtcr: fast path	288	549
cache buffers chains	kcbgtcr: kslbegin shared	43	21
cache buffers chains	kcbzwb	18	50
cache buffers chains	kcbchg: kslbegin: bufs not pinned	11	9
cache buffers chains	kcbgcur: kslbegin	10	7
cache buffers chains	kcbgtcr	5	0
cache buffers chains	kcb_post_apply: kcbhq62	3	0
cache buffers chains	kcbget: pin buffer	2	3
cache buffers chains	kcbnlc	2	0
cache buffers chains	kcbbic1	1	0
cache buffers lru chain	kcbzgws	7,123	8,893
cache buffers lru chain	kcbzar: KSLNBEGIN	1,643	0
cache buffers lru chain	kcbzgm	193	0
cache buffers lru chain	kcbo_link_q	12	0
cache buffers lru chain	kcbbic2	4	1
cache buffers lru chain	kcbbxsv: move to being written	3	12
cache buffers lru chain	kcbkubc	2	40
cache buffers lru chain	kcbbwlru	1	26
cost function	kzulgt: find user res	1	1
dml lock allocation	ktaidm	2	2
dml lock allocation	ktaiam	1	1
enqueue hash chains	ksqgtl3	14	18
enqueue hash chains	ksqrcl	4	0
enqueues	ksqgel: create enqueue	14	17
enqueues	ksqdel	7	1
kks stats	kks stats alloc/free	97	97
library cache	kglhdgc: child:	7,278	294
library cache	kglpin: child: heap processing	5,864	5,110
library cache	kglpndl: child: before processing	1,769	6,286
library cache	kglobpn: child:	938	924
library cache	kglpnc: child	526	408
library cache	kglukp: child	443	915
library cache	kglhdgn: child:	435	3,628
library cache	kglobld	348	591
library cache	kgldte: child 0	299	276
library cache	kglrtl	294	55
library cache	kglpndl: child: after processing	245	55
library cache	kglpin	129	515
library cache	kgldti: 2child	126	302
library cache	kglpnp: child	16	72
library cache	kglati	9	1
library cache	kgldtld: 2child	9	21
library cache	kglini: child	5	2
library cache	kglget: unpin heap 0	1	0
library cache	kglic	1	0
library cache	kglpur: child	1	29
library cache lock	kgllkdl: child: no lock handle	706	1,355
library cache lock	kgllkal: child: multiinstance	33	34
library cache lock	kgllkdl: child: cleanup	19	18
library cache pin	kglpndl	26	18
library cache pin	kglpnal: child: alloc space	20	31
library cache pin	kglpnc: child	3	0
library cache pin	kgldnp: child	1	1
multiblock read objects	kcbzib: mbr get	619	464
multiblock read objects	kcbzib: normal mbr free	529	684
object queue header operation	kcbw_link_q	16	0
object queue header operation	kcbw_unlink_q	5	3
object queue header operation	kcbo_switch_cq	1	2
process allocation	ksucrp	4	0
process allocation	ksuapc	1	5
process allocation	ksudlp	1	1
row cache objects	kqreqd: reget	40	0
row cache objects	kqrpre: find obj	20	65
row cache objects	kqreqd	3	0
row cache objects	kqrso	3	1
session allocation	ksucri	3	2
session allocation	ksudlc	2	1
session allocation	ksudlp	2	2
session allocation	ksuprc	2	0
session allocation	ksuxds: not user session	2	4
session allocation	ksuxds: KSUSFCLC not set	1	3
session idle bit	ksupuc: set busy	7	4
session idle bit	ksupuc: clear busy	2	6
session idle bit	ksuxds	1	0
shared pool	kghalo	7,246	6,206
shared pool	kghfrunp: alloc: cursor dur	4,370	37
shared pool	kghfrunp: clatch: nowait	1,562	0
shared pool	kghfrunp: clatch: wait	972	1,137
shared pool	kghupr1	887	5,718
shared pool	kghfre	640	1,367
shared pool	kghalp	249	239
shared pool	kghfrunp: alloc: session dur	198	8
shared pool	kgh: sim resz update	6	0
shared pool	kghasp	4	20
shared pool	kghfrunp: alloc: wait	4	2
shared pool	kgh: quiesce extents	2	0
shared pool	kgh_next_free	1	0
shared pool	kghfen: not perm alloc class	1	5
simulator hash latch	kcbs_lookup_setid: lookup dba	141	74
simulator hash latch	kcbsacc: lookup dba	38	121
simulator hash latch	kcbsacc: insert dba	21	0
simulator hash latch	kcbsacc: remove dba	15	20
simulator lru latch	kcbs_simulate: simulate set	8,372	8,522
simulator lru latch	kcbs_lookup_setid	159	0
simulator lru latch	kcbs_simbufseq	2	11
slave class create	ksvcreate	1	0
undo global data	ktudnx:child	1	0

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: 606,597,973
Captured Segments account for 99.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
KEYACCOUNT	MINFO1108	MTSMSGROUP	TABLE	200,141,328	32.99
KEYACCOUNT	MINFO1108	MTMMSPOOL	TABLE	121,480,608	20.03
MCRM	MINFO1108	M_MTQUEUE	TABLE	105,254,368	17.35
KEYACCOUNT	MINFO1108	MOSMSPOOL	TABLE	62,061,744	10.23
HSBC	MINFO1108	KA_MTSMSLIST	TABLE	22,799,264	3.76

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 264,824,536
Captured Segments account for 99.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
MCRM	MINFO1108	M_MTQUEUE	TABLE	100,412,071	37.92
KEYACCOUNT	MINFO1108	MOSMSPOOL	TABLE	59,113,852	22.32
KEYACCOUNT	MINFO1108	MTSMSGROUP	TABLE	49,729,576	18.78
HSBC	MINFO1108	KA_MTSMSLIST	TABLE	22,681,726	8.56
HSBCCUPON	MINFO1108	KA_MTSMSLIST	TABLE	13,485,260	5.09

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

Total Direct Physical Reads: 641,623
Captured Segments account for 96.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
MINFOWEB	USERS	SYS_LOB0000128452C00004$$		LOB	618,935	96.46

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 28,174
Captured Segments account for 22.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK	INDEX	2,315	8.22
KEYACCOUNT	MINFO1108	MTSMSPOOL	TABLE	879	3.12
MINFODB	MINFO1108	ERRORID_INDEX	INDEX	691	2.45
KEYACCOUNT	MINFO1108	MTSMSPOOL_REPORTFORMT	INDEX	610	2.17
SYSMAN	SYSAUX	MGMT_SYSTEM_PERFORMANCE_LOG	TABLE	173	0.61

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: 15,456
Captured Segments account for 0.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_4214485585_17468	TABLE PARTITION	53	0.34
MINFOWEB	USERS	SYS_LOB0000128452C00004$$		LOB	12	0.08

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 24,633
Captured Segments account for 98.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
MINFODB	MINFO1108	ADWAP_PAGE	TABLE	8,009	32.51
MCRM	MINFO1108	M_MTQUEUE	TABLE	5,082	20.63
KEYACCOUNT	MINFO1108	MTSMSGROUP	TABLE	4,494	18.24
KEYACCOUNT	MINFO1108	MOSMSPOOL	TABLE	4,333	17.59
HSBCCUPON	MINFO1108	KA_MTSMSLIST	TABLE	1,109	4.50

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
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK	INDEX	6,736	30.91
KEYACCOUNT	MINFO1108	IDX$$_94A30001	INDEX	4,768	21.88
SYS	SYSTEM	SEQ$	TABLE	4,240	19.46
KEYACCOUNT	MINFO1108	MTSMSPOOL_REPORTFORMT	INDEX	672	3.08
KEYACCOUNT	MINFO1108	MTSMSPOOL	TABLE	640	2.94

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
MINFODB	MINFO1108	ADSESSIONLOG_PK		INDEX	12	85.71
MINFODB	MINFO1108	SESSIONOBJECTS		TABLE	2	14.29

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
MINFODB	MINFO1108	ADSESSIONLOG_PK	INDEX	15	53.57
MINFODB	MINFO1108	ADSESSIONLOG	TABLE	6	21.43
KEYACCOUNT	MINFO1108	IDX$$_94A30001	INDEX	5	17.86
SYS	SYSTEM	SEQ$	TABLE	1	3.57
MINFODB	MINFO1108	UPDATELOG	TABLE	1	3.57

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	127	0.00	2	1
dc_files	9	100.00	0	0
dc_global_oids	11,392	0.23	0	24
dc_histogram_data	2,659,169	0.21	0	2,346
dc_histogram_defs	1,343,518	0.50	0	2,447
dc_object_grants	2,355	3.86	0	117
dc_object_ids	809,092	0.10	0	779
dc_objects	260,219	0.78	11	793
dc_profiles	22,247	0.00	0	2
dc_rollback_segments	2,933	0.00	0	44
dc_segments	457,266	0.31	4	725
dc_sequences	3,867	1.47	3,867	17
dc_tablespaces	332,930	0.00	0	7
dc_usernames	58,809	0.01	0	14
dc_users	1,525,227	0.00	0	61
outstanding_alerts	192	76.04	0	2

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	1,516	1.78	13,039	5.76	724	0
CLUSTER	448	0.45	1,935	2.38	44	0
INDEX	39	48.72	101	25.74	7	0
PIPE	4	50.00	4	50.00	0	0
SQL AREA	212,652	89.02	1,725,172	25.55	66,330	5
TABLE/PROCEDURE	39,377	10.66	759,156	3.61	14,567	0
TRIGGER	138	18.84	3,870	5.71	195	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	181.69		1.61	6.49	65	65	113	113
B	Freeable	26.56	0.00	0.47	0.31	1		57	57
B	SQL	5.80	2.64	0.06	0.07	1	9	105	101
B	PL/SQL	1.36	0.73	0.01	0.02	0	0	111	111
E	Other	186.17		1.53	6.25	65	65	122	122
E	Freeable	31.75	0.00	0.50	0.29	1		63	63
E	SQL	5.20	2.09	0.05	0.03	0	5	114	110
E	PL/SQL	1.27	0.66	0.01	0.02	0	0	120	120

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	394,264,576
Fixed Size	1,220,580
Redo Buffers	7,168,000
Variable Size	163,577,884

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	18.60	18.18	-2.25
shared	FileOpenBlock	2.59	2.59	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGH: NO ACCESS	21.44	17.45	-18.59
shared	KQR M PO	2.25	2.02	-10.31
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KTI-UNDO	3.99	3.99	0.00
shared	PCursor	2.85	2.91	2.06
shared	PL/SQL MPCODE	1.62		-100.00
shared	XDB Schema Cac	4.48	4.48	0.00
shared	event statistics per sess	4.24	4.24	0.00
shared	free memory	9.87	10.34	4.73
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kglsim heap	2.43	2.43	0.00
shared	kglsim object batch	4.86	5.14	5.56
shared	library cache	10.22	10.56	3.40
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	7.78	8.75	12.44
shared	trace buffer	3.47	3.47	0.00
	buffer_cache	376.00	376.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.96	Redo NoWait %:	99.99
Buffer Hit %:	56.40	In-memory Sort %:	100.00
Library Hit %:	81.25	Soft Parse %:	75.86
Execute to Parse %:	12.98	Latch Hit %:	99.85
Parse CPU to Parse Elapsd %:	83.13	% Non-Parse CPU:	89.47