WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

PINGTAI 2817430 pingtai 1 10.2.0.4.0 NO SCK-DB1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
PINGTAI	2817430	pingtai	1	10.2.0.4.0	NO	SCK-DB1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 11421 27-Nov-11 08:00:30 159 .6

End Snap: 11433 27-Nov-11 20:00:51 160 .6

Elapsed: 720.35 (mins)

DB Time: 816.90 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	11421	27-Nov-11 08:00:30	159	.6
End Snap:	11433	27-Nov-11 20:00:51	160	.6
Elapsed:		720.35 (mins)
DB Time:		816.90 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 15,920M 15,920M Std Block Size: 8K

Shared Pool Size: 4,496M 4,496M Log Buffer: 14,308K

	Begin	End
Buffer Cache:	15,920M	15,920M	Std Block Size:	8K
Shared Pool Size:	4,496M	4,496M	Log Buffer:	14,308K

Load Profile

Per Second Per Transaction

Redo size: 3,404.33 3.56

Logical reads: 198,260.20 207.61

Block changes: 21.49 0.02

Physical reads: 234.53 0.25

Physical writes: 0.81 0.00

User calls: 11,760.39 12.32

Parses: 1,387.41 1.45

Hard parses: 0.24 0.00

Sorts: 171.28 0.18

Logons: 0.83 0.00

Executes: 1,391.32 1.46

Transactions: 954.95

	Per Second	Per Transaction
Redo size:	3,404.33	3.56
Logical reads:	198,260.20	207.61
Block changes:	21.49	0.02
Physical reads:	234.53	0.25
Physical writes:	0.81	0.00
User calls:	11,760.39	12.32
Parses:	1,387.41	1.45
Hard parses:	0.24	0.00
Sorts:	171.28	0.18
Logons:	0.83	0.00
Executes:	1,391.32	1.46
Transactions:	954.95

% Blocks changed per Read: 0.01 Recursive Call %: 16.95

Rollback per transaction %: 99.81 Rows per Sort: 0.72

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.95 Soft Parse %: 99.98

Execute to Parse %: 0.28 Latch Hit %: 99.93

Parse CPU to Parse Elapsd %: 0.63 % Non-Parse CPU: 99.99

Shared Pool Statistics

Begin End

Memory Usage %: 69.60 68.52

% SQL with executions>1: 98.67 99.48

% Memory for SQL w/exec>1: 96.81 97.71

	Begin	End
Memory Usage %:	69.60	68.52
% SQL with executions>1:	98.67	99.48
% Memory for SQL w/exec>1:	96.81	97.71

Top 5 Timed Events

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

CPU time 46,438 94.7

db file scattered read 640,820 334 1 .7 User I/O

SQL*Net message to client 500,794,241 324 0 .7 Network

Streams AQ: qmn coordinator waiting for slave to start 18 88 4,883 .2 Other

log file sync 41,885 72 2 .1 Commit

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		46,438		94.7
db file scattered read	640,820	334	1	.7	User I/O
SQL*Net message to client	500,794,241	324	0	.7	Network
Streams AQ: qmn coordinator waiting for slave to start	18	88	4,883	.2	Other
log file sync	41,885	72	2	.1	Commit

Main Report

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

Time Model Statistics

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

Statistic Name	Time (s)	% of DB Time
DB CPU	46,437.52	94.74
sql execute elapsed time	45,450.18	92.73
parse time elapsed	1,183.68	2.41
PL/SQL execution elapsed time	19.21	0.04
hard parse elapsed time	11.87	0.02
sequence load elapsed time	4.88	0.01
hard parse (sharing criteria) elapsed time	0.96	0.00
connection management call elapsed time	0.22	0.00
PL/SQL compilation elapsed time	0.02	0.00
repeated bind elapsed time	0.01	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
failed parse elapsed time	0.00	0.00
DB time	49,013.95
background elapsed time	308.18
background cpu time	126.81

Back to Wait Events Statistics
Back to Top

Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
User I/O	667,383	0.00	373	1	0.02
Network	500,794,929	0.00	325	0	12.13
Other	4,546	0.86	89	20	0.00
Commit	41,885	0.00	72	2	0.00
Concurrency	48,990	0.05	63	1	0.00
System I/O	106,041	0.00	62	1	0.00
Configuration	2	0.00	0	0	0.00
Application	2	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file scattered read	640,820	0.00	334	1	0.02
SQL*Net message to client	500,794,241	0.00	324	0	12.13
Streams AQ: qmn coordinator waiting for slave to start	18	100.00	88	4883	0.00
log file sync	41,885	0.00	72	2	0.00
os thread startup	1,561	0.00	47	30	0.00
log file parallel write	46,800	0.00	45	1	0.00
db file sequential read	26,538	0.00	40	1	0.00
buffer busy waits	26,020	0.00	11	0	0.00
control file parallel write	14,448	0.00	10	1	0.00
db file parallel write	4,636	0.00	7	1	0.00
latch: In memory undo latch	12,386	0.00	3	0	0.00
latch: shared pool	399	0.00	1	2	0.00
row cache lock	1,702	0.00	1	0	0.00
control file sequential read	40,157	0.00	1	0	0.00
SQL*Net more data from client	269	0.00	1	3	0.00
latch free	3,053	0.00	1	0	0.00
latch: cache buffers chains	6,558	0.00	0	0	0.00
cursor: pin S wait on X	25	100.00	0	10	0.00
jobq slave TJ process wait	19	100.00	0	11	0.00
latch: library cache	283	0.00	0	1	0.00
LGWR wait for redo copy	890	0.00	0	0	0.00
latch: session allocation	355	0.00	0	0	0.00
latch: library cache lock	24	0.00	0	1	0.00
latch: redo allocation	4	0.00	0	4	0.00
latch: enqueue hash chains	13	0.00	0	1	0.00
SQL*Net more data to client	419	0.00	0	0	0.00
latch: row cache objects	25	0.00	0	0	0.00
enq: TX - index contention	4	0.00	0	3	0.00
read by other session	2	0.00	0	5	0.00
cursor: pin S	174	0.00	0	0	0.00
latch: library cache pin	3	0.00	0	1	0.00
direct path write	23	0.00	0	0	0.00
rdbms ipc reply	14	0.00	0	0	0.00
enq: SQ - contention	2	0.00	0	0	0.00
latch: messages	1	0.00	0	0	0.00
SQL*Net break/reset to client	2	0.00	0	0	0.00
enq: JS - queue lock	1	0.00	0	0	0.00
latch: object queue header operation	1	0.00	0	0	0.00
buffer deadlock	2	100.00	0	0	0.00
latch: cache buffers lru chain	1	0.00	0	0	0.00
SQL*Net message from client	500,794,243	0.00	3,344,017	7	12.13
jobq slave wait	132,279	68.01	340,517	2574	0.00
Streams AQ: qmn slave idle wait	21,310	0.07	98,870	4640	0.00
Streams AQ: qmn coordinator idle wait	15,884	47.92	42,091	2650	0.00
virtual circuit status	1,441	100.00	42,069	29194	0.00
Streams AQ: waiting for time management or cleanup tasks	33	100.00	36,615	1109555	0.00
class slave wait	43	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)
events in waitclass Other	927	1.94	88	95
os thread startup	1,561	0.00	47	30
log file parallel write	46,800	0.00	45	1
control file parallel write	14,448	0.00	10	1
db file parallel write	4,636	0.00	7	1
control file sequential read	31,102	0.00	1	0
direct path write	2	0.00	0	0
latch: cache buffers chains	1	0.00	0	0
rdbms ipc message	181,870	76.49	453,515	2494
pmon timer	15,979	100.00	42,185	2640
Streams AQ: qmn coordinator idle wait	15,884	47.92	42,091	2650
smon timer	144	100.00	40,688	282556
Streams AQ: waiting for time management or cleanup tasks	33	100.00	36,615	1109555
Streams AQ: qmn slave idle wait	6,902	0.00	29,588	4287
class slave wait	2	0.00	-0	-0

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	1,955,357
AVG_IDLE_TIME	2,364,221
AVG_IOWAIT_TIME	5,390
AVG_SYS_TIME	618,272
AVG_USER_TIME	1,336,050
BUSY_TIME	7,825,791
IDLE_TIME	9,461,313
IOWAIT_TIME	25,492
SYS_TIME	2,477,352
USER_TIME	5,348,439
LOAD	0
OS_CPU_WAIT_TIME	7,986,300
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,151,778,816
NUM_CPUS	4
NUM_CPU_CORES	2

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	49,012.90	46,436.50	10,151,635	8,568,572,370
SYS$BACKGROUND	0.00	0.00	135	271,412
pingtai	0.00	0.00	0	0
pingtaiXDB	0.00	0.00	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	666445	37280	47423	1619	500794167	32511
SYS$BACKGROUND	950	69	1563	4671	0	0
pingtai	0	0	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
17,661	17,633	10,553,104	0.00	36.03	agj1j6fgt3fau	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
8,696	8,694	15,263,872	0.00	17.74	499qvnk58tnma	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
8,595	8,592	15,380,311	0.00	17.54	bubvndbsu5g22	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
1,912	1,311	72	26.55	3.90	8837q9srgwr21		DECLARE job BINARY_INTEGER := ...
1,900	1,299	24,912	0.08	3.88	4rs0pqpy6umy2		SELECT COUNT(0) FROM ( SELECT ...
807	437	1	806.64	1.65	82np786bz6xx9		DECLARE job BINARY_INTEGER := ...
779	779	7,195,902	0.00	1.59	9ywv5gv72bkn6		SELECT smq.id, smq.src_id, ...
757	530	720	1.05	1.55	369vgg6vtck7a		DECLARE job BINARY_INTEGER := ...
515	515	5,523,049	0.00	1.05	1djxjq6p71c6d	JDBC Thin Client	select * from mmsc_mt_queue wh...
474	324	720	0.66	0.97	3y7r75zr0w2n6		DECLARE job BINARY_INTEGER := ...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
17,633	17,661	10,553,104	0.00	36.03	agj1j6fgt3fau	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
8,694	8,696	15,263,872	0.00	17.74	499qvnk58tnma	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
8,592	8,595	15,380,311	0.00	17.54	bubvndbsu5g22	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
1,311	1,912	72	18.21	3.90	8837q9srgwr21		DECLARE job BINARY_INTEGER := ...
1,299	1,900	24,912	0.05	3.88	4rs0pqpy6umy2		SELECT COUNT(0) FROM ( SELECT ...
779	779	7,195,902	0.00	1.59	9ywv5gv72bkn6		SELECT smq.id, smq.src_id, ...
530	757	720	0.74	1.55	369vgg6vtck7a		DECLARE job BINARY_INTEGER := ...
515	515	5,523,049	0.00	1.05	1djxjq6p71c6d	JDBC Thin Client	select * from mmsc_mt_queue wh...
437	807	1	436.52	1.65	82np786bz6xx9		DECLARE job BINARY_INTEGER := ...
372	372	5,523,042	0.00	0.76	awu6kx11pdhmg	JDBC Thin Client	select count(*) from mmsc_mt_q...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
Total Buffer Gets: 8,569,025,287
Captured SQL account for 100.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
3,830,792,548	10,553,104	363.00	44.71	17633.32	17660.67	agj1j6fgt3fau	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
2,076,344,182	15,380,311	135.00	24.23	8592.20	8594.80	bubvndbsu5g22	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
2,045,359,047	15,263,872	134.00	23.87	8693.83	8696.28	499qvnk58tnma	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
309,139,786	72	4,293,608.14	3.61	1311.03	1911.62	8837q9srgwr21		DECLARE job BINARY_INTEGER := ...
308,983,536	24,912	12,403.00	3.61	1299.48	1899.80	4rs0pqpy6umy2		SELECT COUNT(0) FROM ( SELECT ...
61,992,834	720	86,101.16	0.72	529.55	757.49	369vgg6vtck7a		DECLARE job BINARY_INTEGER := ...
54,421,225	720	75,585.03	0.64	324.02	473.73	3y7r75zr0w2n6		DECLARE job BINARY_INTEGER := ...
54,357,145	57,600	943.70	0.63	317.36	468.65	86qwp69f7mzfz		SELECT MOBILES, CONTENT FROM S...
50,827,092	8,633	5,887.54	0.59	164.89	295.42	gd8f0tnhg47h3		DECLARE job BINARY_INTEGER := ...
50,371,314	7,195,902	7.00	0.59	779.26	779.31	9ywv5gv72bkn6		SELECT smq.id, smq.src_id, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 10,136,748
Captured SQL account for 85.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
10,125,781	1	10,125,781.00	99.89	436.52	806.64	82np786bz6xx9	DECLARE job BINARY_INTEGER := ...
1,684,540	1	1,684,540.00	16.62	69.98	133.31	6xm86md1dz097	SELECT COUNT(*) FROM SMS_MT_HI...
1,684,539	1	1,684,539.00	16.62	69.98	133.43	9d3kamqbvsdxw	SELECT COUNT(*) FROM SMS_MT_HI...
1,684,539	1	1,684,539.00	16.62	62.50	128.27	dks2upbvu3hjh	SELECT COUNT(*) FROM SMS_MT_HI...
1,684,536	1	1,684,536.00	16.62	63.50	126.94	3p4jjqmx746g0	SELECT COUNT(*) FROM SMS_MT_HI...
1,684,500	1	1,684,500.00	16.62	80.55	150.89	dharnsv5z4n3g	SELECT COUNT(*) FROM SMS_MT_HI...
1,459,320	0		14.40	79.90	112.82	6tt7bn8sktdny	SELECT COUNT(*) FROM SMS_MT_HI...
243,807	1	243,807.00	2.41	5.34	14.04	5qmkgqr8pztfh	SELECT COUNT(*) FROM SMS_WAIT_...
139	539	0.26	0.00	3.87	6.77	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
135	2	67.50	0.00	0.28	0.68	89qyn4bbt03jq	SELECT /+ USE_HASH(f a) / SU...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 60,134,552
Captured SQL account for 99.8% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
15,380,311	953	0.00	0.00	0.00	bubvndbsu5g22	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
15,263,872	961	0.00	0.00	0.00	499qvnk58tnma	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
10,553,104	1,941	0.00	0.00	0.00	agj1j6fgt3fau	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
7,195,902	0	0.00	0.00	0.00	9ywv5gv72bkn6		SELECT smq.id, smq.src_id, ...
5,523,049	0	0.00	0.00	0.00	1djxjq6p71c6d	JDBC Thin Client	select * from mmsc_mt_queue wh...
5,523,042	5,523,043	1.00	0.00	0.00	awu6kx11pdhmg	JDBC Thin Client	select count(*) from mmsc_mt_q...
171,330	0	0.00	0.00	0.00	7gukhdbzh1rqv		SELECT id, mobile, mt_id, r...
57,600	0	0.00	0.01	0.01	86qwp69f7mzfz		SELECT MOBILES, CONTENT FROM S...
33,981	33,981	1.00	0.00	0.00	47a50dvdgnxc2		update sys.job$ set failures=0...
33,835	32,999	0.98	0.00	0.00	aq8yqxyyb40nn		update sys.job$ set this_date=...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 59,965,184
Captured SQL account for 99.8% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
15,380,311	15,380,311	25.65	bubvndbsu5g22	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
15,263,872	15,263,872	25.45	499qvnk58tnma	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
10,553,104	10,553,104	17.60	agj1j6fgt3fau	JDBC Thin Client	select t.id, t.sms_id, t.src_i...
7,195,902	7,195,902	12.00	9ywv5gv72bkn6		SELECT smq.id, smq.src_id, ...
5,523,048	5,523,049	9.21	1djxjq6p71c6d	JDBC Thin Client	select * from mmsc_mt_queue wh...
5,523,042	5,523,042	9.21	awu6kx11pdhmg	JDBC Thin Client	select count(*) from mmsc_mt_q...
171,330	171,330	0.29	7gukhdbzh1rqv		SELECT id, mobile, mt_id, r...
30,497	30,854	0.05	a1mbfp580hw3k		select u1.user#, u2.user#, u...
29,411	33,981	0.05	47a50dvdgnxc2		update sys.job$ set failures=0...
24,901	33,835	0.04	aq8yqxyyb40nn		update sys.job$ set this_date=...

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
2,938,369	12	0.06	31a13pnjps7j3		SELECT source, (case w...
1,615,022	32	0.03	8vkjh60z1g287		select OBJOID, CLSOID, RUNT...
1,123,420	12	0.02	akh9zqqkx3wj7		select 1, max(id) from sys.wr...
1,123,419	1,187	0.02	az33m61ym46y4	JDBC Thin Client	SELECT NULL AS table_cat, ...
1,089,856	24	0.02	10xj8nynmpqtq		SELECT dbin.db_name, dbin.ins...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Text
31	12	298ppdduqr7wm	SELECT status FROM sys.wri$_ad...
30	12	akh9zqqkx3wj7	select 1, max(id) from sys.wr...
29	770	6d64jpfzqc9rv	INSERT INTO MGMT_METRICS_RAW (...
26	12	14566d856s6hs	SELECT owner# FROM sys.wri$_ad...
25	12	0cn2wm9d7zq8d	SELECT decode(value, 'FATAL', ...
25	12	0vwa9n600yvgm	SELECT sum(delta_cpu_time) as ...
25	12	31a13pnjps7j3	SELECT source, (case w...
25	12	bhvyz9bgyrhb2	SELECT name, datatype, value, ...
24	24	10xj8nynmpqtq	SELECT dbin.db_name, dbin.ins...
24	1,592	18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFOR...
23	12	b5yyh2vc9g8tm	SELECT sx.id, sum(decode(e.sn...
22	12	gdn3ysuyssf82	SELECT advisor_id FROM sys.wri...
21	742	3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_messa...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

0vwa9n600yvgm SELECT sum(delta_cpu_time) as total_cpu, sum(case when session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' ) then delta_cpu_time else 0 end) as logmr_cpu, sum(case when session_type in ( 'STREAMS Capture' ) then delta_cpu_time else 0 end) as captr_cpu, sum(case when session_type in ( 'Propagation Sender' , 'Propagation Receiver' ) then delta_cpu_time else 0 end) as prpgt_cpu, sum(case when session_type in ( 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' ) then delta_cpu_time else 0 end) as apply_cpu, sum(case when session_type in ( 'QMON Slaves' , 'QMON Coordinator' ) then delta_cpu_time else 0 end) as qmon_cpu FROM ( SELECT b.session_type, (case when b.min_logon_time = e.min_logon_time then e.sum_cpu_time - b.sum_cpu_time else e.sum_cpu_time end) as delta_cpu_time FROM wrh$_sess_time_stats b, wrh$_sess_time_stats e WHERE b.dbid = :dbid AND b.instance_number = :instance_number AND b.snap_id = :startsn AND e.dbid = :dbid AND e.instance_number = :instance_number AND e.snap_id = :endsn AND e.se ssion_type = b.session_type AND e.session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' , 'STREAMS Capture' , 'Propagation Sender' , 'Propagation Receiver' , 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' , 'QMON Slaves' , 'QMON Coordinator' ) ) all_types

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

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

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

1djxjq6p71c6d select * from mmsc_mt_queue where rownum<100

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

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

369vgg6vtck7a DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PRO_SMS_HELP_TASK; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

3m8smr0v7v1m6 INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)

3p4jjqmx746g0 SELECT COUNT(*) FROM SMS_MT_HISTORY A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND RPTCODE='DELIVRD' AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515275' AND A.MOBILE = B.MOBILETEL)

3y7r75zr0w2n6 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN pro_mo_kf_answer; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

47a50dvdgnxc2 update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4

499qvnk58tnma select t.id, t.sms_id, t.src_id, t.mobiles, t.content, t.priority, t.sms_origin, t.serviceid, t.feetype, t.feecode, t.city, to_char(t.send_time, 'yyyy-MM-dd hh24:mm:ss') as sendtime from sms_mt_queue t where rownum<1001 and ssnumid in (3)

4rs0pqpy6umy2 SELECT COUNT(0) FROM ( SELECT DISTINCT A.ID FROM BS_CONTENTS A WHERE A.SH_STATUS='SHZT005' AND A.COLUMNS IS NOT NULL AND SEND_TYPE = 'BSFSZT001' AND A.ORG_ID = :B1 AND A.INFOR_TYPE = 'BSLX005')

5qmkgqr8pztfh SELECT COUNT(*) FROM SMS_WAIT_STATE A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515268' AND A.MOBILETEL = B.MOBILETEL)

6d64jpfzqc9rv INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KEY_VALUE, VALUE, STRING_VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , NULL, :B1 )

6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

6tt7bn8sktdny SELECT COUNT(*) FROM SMS_MT_HISTORY A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515275' AND A.MOBILE = B.MOBILETEL)

6xm86md1dz097 SELECT COUNT(*) FROM SMS_MT_HISTORY A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND RPTCODE IS NOT NULL AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515275' AND A.MOBILE = B.MOBILETEL)

7gukhdbzh1rqv SELECT id, mobile, mt_id, rpt_code , sms_origin FROM jxsms_rpt_queue WHERE rownum<201 AND sms_origin = :1 ORDER BY receive_time ASC

82np786bz6xx9 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN lm.lm2(to_char(sysdate-1, 'yyyymmdd')); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

86qwp69f7mzfz SELECT MOBILES, CONTENT FROM SMS_MO_QUEUE WHERE SRC_ID=:B1

8837q9srgwr21 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PRO_SIQUN_NEEDSEND_NUM; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

89qyn4bbt03jq SELECT /*+ USE_HASH(f a) */ SUM(NVL(F.BYTES - NVL(A.BYTES, 0), 0)/1024/1024), SUM(NVL(F.BYTES, 0)/1024/1024) FROM (SELECT DISTINCT TABLESPACE_NAME FROM USER_TABLES) U, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) F, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) A WHERE A.TABLESPACE_NAME = U.TABLESPACE_NAME AND F.TABLESPACE_NAME = U.TABLESPACE_NAME

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

9d3kamqbvsdxw SELECT COUNT(*) FROM SMS_MT_HISTORY A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND RPTCODE IS NOT NULL AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515268' AND A.MOBILE = B.MOBILETEL)

9ywv5gv72bkn6 SELECT smq.id, smq.src_id, smq.mobile, smq.content, smq.msg_id, smq.service_id, '1' entity_type FROM jxsms_mo_queue smq WHERE rownum<501 ORDER BY receive_time ASC

a1mbfp580hw3k select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1 from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name

agj1j6fgt3fau select t.id, t.sms_id, t.src_id, t.mobiles, t.content, t.priority, t.sms_origin, t.serviceid, t.feetype, t.feecode, t.city, to_char(t.send_time, 'yyyy-MM-dd hh24:mm:ss') as sendtime from sms_mt_queue t where rownum<1001 and ssnumid in (1, 2)

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

aq8yqxyyb40nn update sys.job$ set this_date=:1 where job=:2

awu6kx11pdhmg select count(*) from mmsc_mt_queue

az33m61ym46y4 SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name

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

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

bubvndbsu5g22 select t.id, t.sms_id, t.src_id, t.mobiles, t.content, t.priority, t.sms_origin, t.serviceid, t.feetype, t.feecode, t.city, to_char(t.send_time, 'yyyy-MM-dd hh24:mm:ss') as sendtime from sms_mt_queue t where rownum<1001 and ssnumid in (4)

dharnsv5z4n3g SELECT COUNT(*) FROM SMS_MT_HISTORY A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515268' AND A.MOBILE = B.MOBILETEL)

dks2upbvu3hjh SELECT COUNT(*) FROM SMS_MT_HISTORY A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND RPTCODE='DELIVRD' AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515268' AND A.MOBILE = B.MOBILETEL)

gd8f0tnhg47h3 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN pro_dxhz; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

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

SQL Id	SQL Text
0cn2wm9d7zq8d	SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0vwa9n600yvgm	SELECT sum(delta_cpu_time) as total_cpu, sum(case when session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' ) then delta_cpu_time else 0 end) as logmr_cpu, sum(case when session_type in ( 'STREAMS Capture' ) then delta_cpu_time else 0 end) as captr_cpu, sum(case when session_type in ( 'Propagation Sender' , 'Propagation Receiver' ) then delta_cpu_time else 0 end) as prpgt_cpu, sum(case when session_type in ( 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' ) then delta_cpu_time else 0 end) as apply_cpu, sum(case when session_type in ( 'QMON Slaves' , 'QMON Coordinator' ) then delta_cpu_time else 0 end) as qmon_cpu FROM ( SELECT b.session_type, (case when b.min_logon_time = e.min_logon_time then e.sum_cpu_time - b.sum_cpu_time else e.sum_cpu_time end) as delta_cpu_time FROM wrh$_sess_time_stats b, wrh$_sess_time_stats e WHERE b.dbid = :dbid AND b.instance_number = :instance_number AND b.snap_id = :startsn AND e.dbid = :dbid AND e.instance_number = :instance_number AND e.snap_id = :endsn AND e.se ssion_type = b.session_type AND e.session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' , 'STREAMS Capture' , 'Propagation Sender' , 'Propagation Receiver' , 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' , 'QMON Slaves' , 'QMON Coordinator' ) ) all_types
10xj8nynmpqtq	SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
14566d856s6hs	SELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1djxjq6p71c6d	select * from mmsc_mt_queue where rownum<100
298ppdduqr7wm	SELECT status FROM sys.wri$_adv_tasks WHERE id = :1
31a13pnjps7j3	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
369vgg6vtck7a	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PRO_SMS_HELP_TASK; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3p4jjqmx746g0	SELECT COUNT(*) FROM SMS_MT_HISTORY A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND RPTCODE='DELIVRD' AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515275' AND A.MOBILE = B.MOBILETEL)
3y7r75zr0w2n6	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN pro_mo_kf_answer; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
47a50dvdgnxc2	update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
499qvnk58tnma	select t.id, t.sms_id, t.src_id, t.mobiles, t.content, t.priority, t.sms_origin, t.serviceid, t.feetype, t.feecode, t.city, to_char(t.send_time, 'yyyy-MM-dd hh24:mm:ss') as sendtime from sms_mt_queue t where rownum<1001 and ssnumid in (3)
4rs0pqpy6umy2	SELECT COUNT(0) FROM ( SELECT DISTINCT A.ID FROM BS_CONTENTS A WHERE A.SH_STATUS='SHZT005' AND A.COLUMNS IS NOT NULL AND SEND_TYPE = 'BSFSZT001' AND A.ORG_ID = :B1 AND A.INFOR_TYPE = 'BSLX005')
5qmkgqr8pztfh	SELECT COUNT(*) FROM SMS_WAIT_STATE A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515268' AND A.MOBILETEL = B.MOBILETEL)
6d64jpfzqc9rv	INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KEY_VALUE, VALUE, STRING_VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , NULL, :B1 )
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6tt7bn8sktdny	SELECT COUNT(*) FROM SMS_MT_HISTORY A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515275' AND A.MOBILE = B.MOBILETEL)
6xm86md1dz097	SELECT COUNT(*) FROM SMS_MT_HISTORY A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND RPTCODE IS NOT NULL AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515275' AND A.MOBILE = B.MOBILETEL)
7gukhdbzh1rqv	SELECT id, mobile, mt_id, rpt_code , sms_origin FROM jxsms_rpt_queue WHERE rownum<201 AND sms_origin = :1 ORDER BY receive_time ASC
82np786bz6xx9	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN lm.lm2(to_char(sysdate-1, 'yyyymmdd')); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
86qwp69f7mzfz	SELECT MOBILES, CONTENT FROM SMS_MO_QUEUE WHERE SRC_ID=:B1
8837q9srgwr21	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PRO_SIQUN_NEEDSEND_NUM; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
89qyn4bbt03jq	SELECT /+ USE_HASH(f a) / SUM(NVL(F.BYTES - NVL(A.BYTES, 0), 0)/1024/1024), SUM(NVL(F.BYTES, 0)/1024/1024) FROM (SELECT DISTINCT TABLESPACE_NAME FROM USER_TABLES) U, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) F, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) A WHERE A.TABLESPACE_NAME = U.TABLESPACE_NAME AND F.TABLESPACE_NAME = U.TABLESPACE_NAME
8vkjh60z1g287	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
9d3kamqbvsdxw	SELECT COUNT(*) FROM SMS_MT_HISTORY A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND RPTCODE IS NOT NULL AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515268' AND A.MOBILE = B.MOBILETEL)
9ywv5gv72bkn6	SELECT smq.id, smq.src_id, smq.mobile, smq.content, smq.msg_id, smq.service_id, '1' entity_type FROM jxsms_mo_queue smq WHERE rownum<501 ORDER BY receive_time ASC
a1mbfp580hw3k	select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1 from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
agj1j6fgt3fau	select t.id, t.sms_id, t.src_id, t.mobiles, t.content, t.priority, t.sms_origin, t.serviceid, t.feetype, t.feecode, t.city, to_char(t.send_time, 'yyyy-MM-dd hh24:mm:ss') as sendtime from sms_mt_queue t where rownum<1001 and ssnumid in (1, 2)
akh9zqqkx3wj7	select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
awu6kx11pdhmg	select count(*) from mmsc_mt_queue
az33m61ym46y4	SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name
b5yyh2vc9g8tm	SELECT sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id between :bid and :eid AND s.status = 0 AND x.ver_type = :exists_type ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = :inst_num AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.id
bhvyz9bgyrhb2	SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1
bubvndbsu5g22	select t.id, t.sms_id, t.src_id, t.mobiles, t.content, t.priority, t.sms_origin, t.serviceid, t.feetype, t.feecode, t.city, to_char(t.send_time, 'yyyy-MM-dd hh24:mm:ss') as sendtime from sms_mt_queue t where rownum<1001 and ssnumid in (4)
dharnsv5z4n3g	SELECT COUNT(*) FROM SMS_MT_HISTORY A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515268' AND A.MOBILE = B.MOBILETEL)
dks2upbvu3hjh	SELECT COUNT(*) FROM SMS_MT_HISTORY A WHERE TO_CHAR(SENDTIME, 'yyyymmdd') = :B1 AND SERVICECODE <> 'HELP' AND RPTCODE='DELIVRD' AND EXISTS (SELECT 1 FROM SI_SUB_CUSTOMERS B WHERE ORG_ID = '20100625000000515268' AND A.MOBILE = B.MOBILETEL)
gd8f0tnhg47h3	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN pro_dxhz; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
gdn3ysuyssf82	SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	639,307	14.79	0.02
CPU used when call started	346,895	8.03	0.01
CR blocks created	5,772	0.13	0.00
Cached Commit SCN referenced	2,839	0.07	0.00
Commit SCN cached	11	0.00	0.00
DB time	39,920,917	923.64	0.97
DBWR checkpoint buffers written	34,959	0.81	0.00
DBWR checkpoints	0	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	2,376	0.05	0.00
DBWR undo block writes	9,262	0.21	0.00
IMU CR rollbacks	2,668	0.06	0.00
IMU Flushes	16,327	0.38	0.00
IMU Redo allocation size	49,558,052	1,146.62	1.20
IMU commits	61,876	1.43	0.00
IMU contention	13,045	0.30	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	2	0.00	0.00
IMU undo allocation size	256,593,544	5,936.76	6.22
IMU- failed to get a private strand	0	0.00	0.00
Misses for writing mapping	2	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SMON posted for undo segment shrink	1	0.00	0.00
SQL*Net roundtrips to/from client	500,803,819	11,587.02	12.13
active txn count during cleanout	9,252	0.21	0.00
application wait time	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	139,176	3.22	0.00
branch node splits	5	0.00	0.00
buffer is not pinned count	11,512,675	266.37	0.28
buffer is pinned count	12,873,195	297.85	0.31
bytes received via SQL*Net from client	25,038,123,039	579,303.15	606.63
bytes sent via SQL*Net to client	26,277,008,054	607,967.04	636.65
calls to get snapshot scn: kcmgss	86,857,042	2,009.60	2.10
calls to kcmgas	108,537	2.51	0.00
calls to kcmgcs	2,794	0.06	0.00
change write time	677	0.02	0.00
cleanout - number of ktugct calls	19,407	0.45	0.00
cleanouts and rollbacks - consistent read gets	3,823	0.09	0.00
cleanouts only - consistent read gets	1,670	0.04	0.00
cluster key scan block gets	46,360	1.07	0.00
cluster key scans	4,425	0.10	0.00
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	6	0.00	0.00
commit batch/immediate requested	6	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	188	0.00	0.00
commit cleanout failures: cannot pin	12,355	0.29	0.00
commit cleanouts	188,063	4.35	0.00
commit cleanouts successfully completed	175,520	4.06	0.00
commit immediate performed	6	0.00	0.00
commit immediate requested	6	0.00	0.00
commit txn count during cleanout	17,443	0.40	0.00
concurrency wait time	6,290	0.15	0.00
consistent changes	29,369	0.68	0.00
consistent gets	8,568,103,507	198,238.88	207.59
consistent gets - examination	99,263,824	2,296.65	2.40
consistent gets direct	0	0.00	0.00
consistent gets from cache	8,568,103,506	198,238.88	207.59
current blocks converted for CR	0	0.00	0.00
cursor authentications	355	0.01	0.00
data blocks consistent reads - undo records applied	26,688	0.62	0.00
db block changes	928,915	21.49	0.02
db block gets	921,770	21.33	0.02
db block gets direct	126	0.00	0.00
db block gets from cache	921,644	21.32	0.02
deferred (CURRENT) block cleanout applications	74,891	1.73	0.00
dirty buffers inspected	0	0.00	0.00
doubling up with imu segment	0	0.00	0.00
enqueue conversions	8,702	0.20	0.00
enqueue deadlocks	0	0.00	0.00
enqueue releases	758,903	17.56	0.02
enqueue requests	758,916	17.56	0.02
enqueue timeouts	14	0.00	0.00
enqueue waits	7	0.00	0.00
exchange deadlocks	2	0.00	0.00
execute count	60,134,552	1,391.32	1.46
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	10,144,613	234.71	0.25
free buffer requested	10,152,721	234.90	0.25
heap block compress	20,052	0.46	0.00
hot buffers moved to head of LRU	5,730	0.13	0.00
immediate (CR) block cleanout applications	5,493	0.13	0.00
immediate (CURRENT) block cleanout applications	16,526	0.38	0.00
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	5,539,301	128.16	0.13
index fast full scans (full)	120	0.00	0.00
index fetch by key	2,261,916	52.33	0.05
index scans kdiixs1	57,400,238	1,328.06	1.39
leaf node 90-10 splits	252	0.01	0.00
leaf node splits	573	0.01	0.00
lob reads	112	0.00	0.00
lob writes	764	0.02	0.00
lob writes unaligned	764	0.02	0.00
logons cumulative	35,771	0.83	0.00
messages received	51,021	1.18	0.00
messages sent	51,021	1.18	0.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	8,436,569,255	195,195.59	204.40
opened cursors cumulative	60,135,681	1,391.35	1.46
parse count (failures)	1	0.00	0.00
parse count (hard)	10,250	0.24	0.00
parse count (total)	59,965,184	1,387.41	1.45
parse time cpu	662	0.02	0.00
parse time elapsed	105,587	2.44	0.00
physical read IO requests	665,641	15.40	0.02
physical read bytes	83,040,239,616	1,921,289.09	2,011.92
physical read total IO requests	706,591	16.35	0.02
physical read total bytes	83,704,676,352	1,936,662.06	2,028.02
physical read total multi block requests	639,895	14.81	0.02
physical reads	10,136,748	234.53	0.25
physical reads cache	10,136,748	234.53	0.25
physical reads cache prefetch	9,471,092	219.13	0.23
physical reads direct	0	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	23,354	0.54	0.00
physical write bytes	287,416,320	6,649.91	6.96
physical write total IO requests	124,677	2.88	0.00
physical write total bytes	1,170,744,832	27,087.34	28.37
physical write total multi block requests	58,695	1.36	0.00
physical writes	35,085	0.81	0.00
physical writes direct	126	0.00	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	34,959	0.81	0.00
physical writes non checkpoint	6,107	0.14	0.00
pinned buffers inspected	2	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	42,988	0.99	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	103,711,707	2,399.56	2.51
recursive cpu usage	293,519	6.79	0.01
redo blocks written	338,147	7.82	0.01
redo buffer allocation retries	0	0.00	0.00
redo entries	314,147	7.27	0.01
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	4,293	0.10	0.00
redo size	147,138,728	3,404.33	3.56
redo subscn max counts	10,132	0.23	0.00
redo synch time	6,772	0.16	0.00
redo synch writes	38,159	0.88	0.00
redo wastage	20,188,268	467.09	0.49
redo write time	5,391	0.12	0.00
redo writer latching time	28	0.00	0.00
redo writes	46,802	1.08	0.00
rollback changes - undo records applied	12	0.00	0.00
rollbacks only - consistent read gets	1,752	0.04	0.00
rows fetched via callback	142,979	3.31	0.00
serializable aborts	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	59,658,559	1,380.31	1.45
session logical reads	8,569,025,287	198,260.20	207.61
session pga memory	38,395,939,520	888,360.87	930.27
session pga memory max	###############	219,566,671.12	229,923.89
session uga memory	###############	3,379,366,404.28	3,538,775.05
session uga memory max	9,939,479,464	229,968.19	240.82
shared hash latch upgrades - no wait	5,548,090	128.37	0.13
shared hash latch upgrades - wait	1	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	7,403,080	171.28	0.18
sorts (rows)	5,331,880	123.36	0.13
sql area evicted	11,479	0.27	0.00
sql area purged	1	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	4,966	0.11	0.00
table fetch by rowid	4,511,640	104.39	0.11
table fetch continued row	138,171	3.20	0.00
table scan blocks gotten	555,625,947	12,855.43	13.46
table scan rows gotten	15,996,382,572	370,105.81	387.56
table scans (long tables)	37	0.00	0.00
table scans (short tables)	13,095,378	302.99	0.32
total number of times SMON posted	1	0.00	0.00
transaction rollbacks	6	0.00	0.00
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	51,531,444	1,192.27	1.25
user I/O wait time	37,314	0.86	0.00
user calls	508,297,117	11,760.39	12.32
user commits	78,203	1.81	0.00
user rollbacks	41,195,953	953.14	1.00
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	20,344	0.47	0.00
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	16,478,841	16,732,930
opened cursors current	91	91
logons current	159	160

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
HNNX	666,430	15	0.56	15.23	12,121	90	0.22
UNDOTBS1	0	0	0.00	0.00	5,463	97	0.21
SYSAUX	118	0	0.08	1.00	4,345	0	0.00
SYSTEM	25	0	2.40	1.00	1,078	25,827	0.29
TBS_SI_QUARTER4	2	0	0.00	1.00	345	0	0.00
TBS_SI_SUB0730	2	0	5.00	1.00	0	0	0.00
TBS_SI_SUB0731	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0732	2	0	5.00	1.00	0	0	0.00
TBS_SI_SUB0733	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0734	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0735	2	0	5.00	1.00	0	0	0.00
TBS_SI_SUB0736	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0737	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0738	2	0	5.00	1.00	0	0	0.00
TBS_SI_SUB0739	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0743	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0744	2	0	5.00	1.00	0	0	0.00
TBS_SI_SUB0745	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0746	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUBOTHER	2	0	5.00	1.00	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)
HNNX	/oradata/pingtai/hnnx01.dbf	61,230	1	0.82	15.71	1,977	9	0.00
HNNX	/oradata/pingtai/hnnx02.dbf	91,326	2	0.79	15.91	1,299	32	0.00
HNNX	/oradata/pingtai/hnnx03.dbf	167,490	4	0.55	14.80	3,282	40	0.25
HNNX	/oradata/pingtai/hnnx04.dbf	157,420	4	0.46	15.46	3,294	2	0.00
HNNX	/oradata/pingtai/hnnx05.dbf	188,964	4	0.45	14.95	2,269	7	1.43
SYSAUX	/oradata/pingtai/sysaux01.dbf	118	0	0.08	1.00	4,345	0	0.00
SYSTEM	/oradata/pingtai/system01.dbf	25	0	2.40	1.00	1,078	25,827	0.29
TBS_SI_QUARTER4	/oradata/pingtai/si_send_sms/si_down_quarter4.dbf	2	0	0.00	1.00	345	0	0.00
TBS_SI_SUB0730	/oradata/pingtai/si_sub_customer/si_sub_0730.dbf	2	0	5.00	1.00	0	0	0.00
TBS_SI_SUB0731	/oradata/pingtai/si_sub_customer/si_sub_0731.dbf	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0732	/oradata/pingtai/si_sub_customer/si_sub_0732.dbf	2	0	5.00	1.00	0	0	0.00
TBS_SI_SUB0733	/oradata/pingtai/si_sub_customer/si_sub_0733.dbf	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0734	/oradata/pingtai/si_sub_customer/si_sub_0734.dbf	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0735	/oradata/pingtai/si_sub_customer/si_sub_0735.dbf	2	0	5.00	1.00	0	0	0.00
TBS_SI_SUB0736	/oradata/pingtai/si_sub_customer/si_sub_0736.dbf	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0737	/oradata/pingtai/si_sub_customer/si_sub_0737.dbf	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0738	/oradata/pingtai/si_sub_customer/si_sub_0738.dbf	2	0	5.00	1.00	0	0	0.00
TBS_SI_SUB0739	/oradata/pingtai/si_sub_customer/si_sub_0739.dbf	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0743	/oradata/pingtai/si_sub_customer/si_sub_0743.dbf	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0744	/oradata/pingtai/si_sub_customer/si_sub_0744.dbf	2	0	5.00	1.00	0	0	0.00
TBS_SI_SUB0745	/oradata/pingtai/si_sub_customer/si_sub_0745.dbf	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUB0746	/oradata/pingtai/si_sub_customer/si_sub_0746.dbf	2	0	0.00	1.00	0	0	0.00
TBS_SI_SUBOTHER	/oradata/pingtai/si_sub_customer/si_sub_other.dbf.db	2	0	5.00	1.00	0	0	0.00
UNDOTBS1	/oradata/pingtai/undotbs01.dbf	0	0			5,463	97	0.21

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	1,969,097	139	-25,682,297	10,136,860	34,959	0	0	26,020

Advisory Statistics

Instance Recovery Stats
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	11	349	1968	10063	2764800	10063
E	0	11	330	2497	9450	2764800	9450

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	1,584	0.10	195,921	1.08	728,184,562
D	3,168	0.20	391,842	1.01	680,768,834
D	4,752	0.30	587,763	1.01	677,036,062
D	6,336	0.40	783,684	1.00	675,987,428
D	7,920	0.50	979,605	1.00	674,865,831
D	9,504	0.60	1,175,526	1.00	673,854,855
D	11,088	0.70	1,371,447	1.00	673,524,355
D	12,672	0.80	1,567,368	1.00	673,161,549
D	14,256	0.89	1,763,289	1.00	673,048,621
D	15,840	0.99	1,959,210	1.00	672,959,608
D	15,936	1.00	1,971,084	1.00	672,956,688
D	17,424	1.09	2,155,131	1.00	672,891,709
D	19,008	1.19	2,351,052	1.00	672,808,062
D	20,592	1.29	2,546,973	1.00	672,721,274
D	22,176	1.39	2,742,894	1.00	672,665,614
D	23,760	1.49	2,938,815	1.00	672,624,434
D	25,344	1.59	3,134,736	1.00	672,577,599
D	26,928	1.69	3,330,657	1.00	672,512,201
D	28,512	1.79	3,526,578	1.00	672,366,789
D	30,096	1.89	3,722,499	1.00	671,605,060
D	31,680	1.99	3,918,420	0.99	663,951,974

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	1,755	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	7,103	6,307	291.18	0.50	0.17	100.00	0.00	727,340
E	7,103	6,305	244.44	0.00	0.00	0.00	0.00	727,340

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	19,102	19,102
64K	128K	74	74
128K	256K	18	18
256K	512K	6	6
512K	1024K	739	739
1M	2M	246	246
2M	4M	155	155
32M	64M	1	1
64M	128M	3	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 %
888	0.13	1,595,742.05	628,113.15	72.00
1,776	0.25	1,595,742.05	5,676.71	100.00
3,552	0.50	1,595,742.05	3,938.78	100.00
5,327	0.75	1,595,742.05	3,938.78	100.00
7,103	1.00	1,595,742.05	3,938.78	100.00
8,524	1.20	1,595,742.05	0.00	100.00
9,944	1.40	1,595,742.05	0.00	100.00
11,365	1.60	1,595,742.05	0.00	100.00
12,785	1.80	1,595,742.05	0.00	100.00
14,206	2.00	1,595,742.05	0.00	100.00
21,309	3.00	1,595,742.05	0.00	100.00
28,412	4.00	1,595,742.05	0.00	100.00
42,618	6.00	1,595,742.05	0.00	100.00
56,824	8.00	1,595,742.05	0.00	100.00

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
784	0.17	501	84,757	35,634,606	0.99	403,537	2.02	1,359,288,288
1,248	0.28	963	120,022	35,730,822	1.00	307,321	1.54	1,359,363,412
1,712	0.38	1,426	159,113	35,763,832	1.00	274,311	1.37	1,359,391,153
2,176	0.48	1,889	201,324	35,779,858	1.00	258,285	1.29	1,359,402,519
2,640	0.59	2,352	248,629	35,789,505	1.00	248,638	1.24	1,359,409,843
3,104	0.69	2,815	291,032	35,802,639	1.00	235,504	1.18	1,359,416,167
3,568	0.79	3,278	331,493	35,817,316	1.00	220,827	1.10	1,359,421,845
4,032	0.90	3,741	365,357	35,831,666	1.00	206,477	1.03	1,359,427,039
4,496	1.00	4,204	408,077	35,838,286	1.00	199,857	1.00	1,359,430,178
4,960	1.10	4,667	454,171	35,845,197	1.00	192,946	0.97	1,359,433,365
5,424	1.21	5,130	500,393	35,850,316	1.00	187,827	0.94	1,359,437,183
5,888	1.31	5,593	544,473	35,854,599	1.00	183,544	0.92	1,359,439,758
6,352	1.41	6,056	580,641	35,856,712	1.00	181,431	0.91	1,359,441,094
6,816	1.52	6,519	616,156	35,857,935	1.00	180,208	0.90	1,359,442,070
7,280	1.62	6,982	654,079	35,859,556	1.00	178,587	0.89	1,359,442,929
7,744	1.72	7,445	694,456	35,860,115	1.00	178,028	0.89	1,359,443,371
8,208	1.83	7,908	745,107	35,860,163	1.00	177,980	0.89	1,359,443,737
8,672	1.93	8,371	790,239	35,860,723	1.00	177,420	0.89	1,359,444,718
9,136	2.03	9,136	961,276	35,863,145	1.00	174,998	0.88	1,359,449,313

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
5,120	0.25	4,237,288	680,224,620
10,240	0.50	4,142,722	680,224,620
15,360	0.75	4,132,399	675,446,628
20,480	1.00	4,129,507	672,956,688
25,600	1.25	4,128,682	672,418,323
30,720	1.50	4,128,682	672,081,844
35,840	1.75	4,128,269	671,947,253
40,960	2.00	4,119,184	663,400,703

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

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)
data block	25,917	7
undo header	51	0
undo block	46	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	Av Wt Time(ms)
TX-Transaction (index contention)	100	100	4	3.00
SQ-Sequence Cache	75	75	2	0.00
JS-Job Scheduler (queue lock)	156,045	156,045	1	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	7.07	94,505	204	8	15/15.4	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
27-Nov 20:07	112	1,179	0	4	15	0/0	0/0/0/0/0/0
27-Nov 19:57	52	1,027	105	3	15	0/0	0/0/0/0/0/0
27-Nov 19:47	51	1,024	0	4	15	0/0	0/0/0/0/0/0
27-Nov 19:37	47	1,048	64	3	15	0/0	0/0/0/0/0/0
27-Nov 19:27	53	1,001	64	3	15	0/0	0/0/0/0/0/0
27-Nov 19:17	49	1,143	0	3	15	0/0	0/0/0/0/0/0
27-Nov 19:07	123	1,104	64	3	15	0/0	0/0/0/0/0/0
27-Nov 18:57	50	1,031	0	3	15	0/0	0/0/0/0/0/0
27-Nov 18:47	50	1,003	0	3	15	0/0	0/0/0/0/0/0
27-Nov 18:37	49	1,021	0	4	15	0/0	0/0/0/0/0/0
27-Nov 18:27	59	998	76	3	15	0/0	0/0/0/0/0/0
27-Nov 18:17	153	1,119	76	3	15	0/0	0/0/0/0/0/0
27-Nov 18:07	110	1,102	77	3	15	0/0	0/0/0/0/0/0
27-Nov 17:57	51	1,028	77	2	15	0/0	0/0/0/0/0/0
27-Nov 17:47	50	1,022	0	3	15	0/0	0/0/0/0/0/0
27-Nov 17:37	50	1,056	77	3	15	0/0	0/0/0/0/0/0
27-Nov 17:27	52	1,023	0	4	15	0/0	0/0/0/0/0/0
27-Nov 17:17	120	1,348	103	3	15	0/0	0/0/0/0/0/0
27-Nov 17:07	110	1,089	78	3	15	0/0	0/0/0/0/0/0
27-Nov 16:57	49	1,026	0	3	15	0/0	0/0/0/0/0/0
27-Nov 16:47	46	1,011	78	3	15	0/0	0/0/0/0/0/0
27-Nov 16:37	51	1,023	0	3	15	0/0	0/0/0/0/0/0
27-Nov 16:27	53	1,034	0	3	15	0/0	0/0/0/0/0/0
27-Nov 16:17	55	1,124	76	3	15	0/0	0/0/0/0/0/0
27-Nov 16:07	121	1,118	0	3	15	0/0	0/0/0/0/0/0
27-Nov 15:57	47	1,021	66	4	15	0/0	0/0/0/0/0/0
27-Nov 15:47	50	1,015	0	4	15	0/0	0/0/0/0/0/0
27-Nov 15:37	48	1,051	78	3	15	0/0	0/0/0/0/0/0
27-Nov 15:27	51	1,023	0	4	15	0/0	0/0/0/0/0/0
27-Nov 15:17	161	1,981	76	5	15	0/0	0/0/0/0/0/0
27-Nov 15:07	2,349	15,994	0	8	15	0/0	0/0/0/0/0/0
27-Nov 14:57	51	1,084	123	2	15	0/0	0/0/0/0/0/0
27-Nov 14:47	49	1,029	0	2	15	0/0	0/0/0/0/0/0
27-Nov 14:37	51	1,052	96	4	15	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	28,818	0.00		0	0
AWR Alerted Metric Element list	280,794	0.00		0	0
Consistent RBA	46,805	0.01	0.00	0	0
FAL request queue	864	0.00		0	0
FAL subheap alocation	864	0.00		0	0
FOB s.o list latch	2,009	0.00		0	0
In memory undo latch	488,762	3.40	0.75	3	99,037	26.72
JS mem alloc latch	202	0.00		0	0
JS queue access latch	202	0.00		0	0
JS queue state obj latch	312,090	0.00		0	0
JS slv state obj latch	4,686	0.09	0.00	0	0
KMG MMAN ready and startup request latch	14,406	0.00		0	0
KTF sga latch	80	1.25	0.00	0	9,125	0.02
KWQMN job cache list latch	33	0.00		0	0
KWQP Prop Status	5,128	0.00		0	0
MQL Tracking Latch	0			0	864	0.00
Memory Management Latch	0			0	14,406	0.00
Memory Queue	10,208	0.00		0	0
OS process	14,655	0.00		0	0
OS process allocation	24,178	0.03	0.00	0	0
OS process: request allocation	3,527	0.23	0.00	0	0
PL/SQL warning settings	69,798	0.00		0	0
SGA IO buffer pool latch	632,187	0.00		0	632,187	0.00
SQL memory manager latch	12	0.00		0	14,401	0.00
SQL memory manager workarea list latch	976,730	0.00		0	0
Shared B-Tree	51,833	0.00		0	0
active checkpoint queue latch	19,040	0.00		0	0
active service list	195,188	5.47	0.03	0	15,979	0.00
archive control	816	0.00		0	0
archive process latch	16,129	0.01	0.00	0	0
begin backup scn array	27	0.00		0	0
bq:time manger info latch	3,038	0.00		0	0
bufq statistics	10,268	0.00		0	0
cache buffer handles	3,150	0.00		0	0
cache buffers chains	17,051,500,841	0.03	0.00	0	20,104,200	0.00
cache buffers lru chain	79,834	0.04	0.03	0	21,049,437	0.00
cache table scan latch	0			0	639,912	0.00
channel handle pool latch	3,527	0.17	0.00	0	0
channel operations parent latch	210,572	0.00	0.00	0	0
checkpoint queue latch	653,089	0.00		0	32,452	0.08
client/application info	185,927	0.00	0.00	0	0
compile environment latch	35,366	0.02	0.00	0	0
dml lock allocation	277,385	8.04	0.00	0	0
dummy allocation	71,541	6.99	0.00	0	0
enqueue hash chains	1,526,527	2.34	0.00	0	1,473	0.00
enqueue sob latch	18	0.00		0	0
enqueues	101,874,950	0.44	0.00	0	0
event group latch	1,764	0.00		0	0
file cache latch	5,811	0.00		0	0
global KZLD latch for mem in SGA	203	0.00		0	0
hash table column usage latch	656	0.00		0	74,887	0.00
hash table modification latch	943	0.00		0	0
job workq parent latch	74	89.19	0.08	0	55,226	5.98
job_queue_processes parameter latch	9,377	0.00		0	0
kks stats	44,920	0.21	0.05	0	0
kmcptab latch	3	0.00		0	0
kmcpvec latch	0			0	3	0.00
kokc descriptor allocation latch	432	0.00		0	0
ksuosstats global area	2,905	0.00		0	0
ktm global data	144	0.00		0	0
kwqbsn:qsga	38,383	0.00		0	0
lgwr LWN SCN	49,594	0.02	0.09	0	0
library cache	103,124,252	0.76	0.00	0	52,895	0.12
library cache load lock	526	0.00		0	4	0.00
library cache lock	1,733,298	4.54	0.00	0	0
library cache lock allocation	112,264	0.82	0.01	0	0
library cache pin	608,266	5.07	0.00	0	0
library cache pin allocation	3,805	0.00		0	0
list of block allocation	69,686	11.86	0.00	0	0
loader state object freelist	24	0.00		0	0
logminer context allocation	12	0.00		0	0
longop free list parent	37	0.00		0	36	0.00
messages	437,346	0.85	0.00	0	0
mostly latch-free SCN	49,832	0.31	0.00	0	0
multiblock read objects	1,329,446	0.00		0	0
ncodef allocation latch	761	0.00		0	0
object queue header heap	38,108	0.00		0	0
object queue header operation	20,443,191	0.00	0.01	0	0
object stats modification	12	0.00		0	0
parallel query alloc buffer	5,392	0.00		0	0
parameter list	3,150	0.00		0	0
parameter table allocation management	35,796	15.54	0.00	0	0
post/wait queue	58,464	0.00	0.00	0	41,859	0.06
process allocation	3,527	0.00		0	1,764	0.00
process group creation	3,527	0.11	0.00	0	0
qmn state object latch	34	0.00		0	0
qmn task queue latch	54,274	4.69	0.01	0	0
redo allocation	359,123	0.04	0.03	0	310,683	2.76
redo copy	0			0	314,162	0.29
redo writing	201,399	0.00		0	0
resmgr group change latch	36,377	0.00		0	0
resmgr:active threads	71,469	0.00		0	0
resmgr:actses change group	34,209	0.00		0	0
resmgr:free threads list	71,457	15.68	0.00	0	0
resmgr:schema config	12	0.00		0	0
row cache objects	1,858,456	9.29	0.00	0	18	0.00
rules engine rule set statistics	1,200	0.00		0	0
sequence cache	128,188	22.49	0.00	0	0
session allocation	202,188,566	1.17	0.00	0	0
session idle bit	1,117,337,051	0.35	0.00	0	0
session state list latch	71,694	15.97	0.00	0	0
session switching	761	0.00		0	0
session timer	15,979	0.00		0	0
shared pool	3,004,102	4.09	0.00	1	0
shared pool simulator	39,734,637	0.02	0.00	0	0
simulator hash latch	514,379,469	0.00	0.00	0	0
slave class	41	0.00		0	0
slave class create	166	7.23	1.00	0	0
sort extent pool	1,121	0.00		0	0
state object free list	24	0.00		0	0
statistics aggregation	6,720	0.00		0	0
threshold alerts latch	19,338	0.00		0	0
transaction allocation	68,888	4.14	0.00	0	0
transaction branch allocation	15,979	0.00		0	0
undo global data	493,348	1.03	0.00	0	0
user lock	68,825	14.27	0.00	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	17,051,500,841	5,683,846	6,558	5,680,795
session idle bit	1,117,337,051	3,863,359	2,506	3,861,106
session allocation	202,188,566	2,375,248	355	2,374,911
library cache	103,124,252	787,311	283	787,062
enqueues	101,874,950	443,283	22	443,262
row cache objects	1,858,456	172,733	25	172,708
shared pool	3,004,102	122,801	399	122,483
library cache lock	1,733,298	78,625	24	78,601
enqueue hash chains	1,526,527	35,664	13	35,651
library cache pin	608,266	30,838	3	30,835
sequence cache	128,188	28,834	14	28,820
simulator hash latch	514,379,469	24,978	101	24,884
dml lock allocation	277,385	22,289	1	22,288
In memory undo latch	488,762	16,612	12,386	4,448
resmgr:free threads list	71,457	11,205	2	11,203
active service list	195,188	10,672	333	10,339
user lock	68,825	9,823	16	9,807
shared pool simulator	39,734,637	6,782	14	6,770
dummy allocation	71,541	4,999	2	4,997
messages	437,346	3,729	1	3,728
qmn task queue latch	54,274	2,543	13	2,530
library cache lock allocation	112,264	922	6	916
redo allocation	359,123	128	4	124
kks stats	44,920	96	5	91
object queue header operation	20,443,191	79	1	78
job workq parent latch	74	66	5	61
cache buffers lru chain	79,834	30	1	29
slave class create	166	12	12	0
lgwr LWN SCN	49,594	11	1	10

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	10,816	4,515
In memory undo latch	kticmt: child	3,941	8,584
In memory undo latch	ktichg: child	467	1,981
In memory undo latch	ktiTxnPoolFree	1	1
active service list	ksws_event: ksws event	4,737	4,736
active service list	kswssyis: find service entry 1	1	0
cache buffers chains	kcbgtcr: kslbegin excl	15,167	12,334
cache buffers chains	kcbgcur: kslbegin	3,297	3,265
cache buffers chains	kcbrls: kslbegin	1,393	4,363
cache buffers chains	kcbgtcr: fast path	451	131
cache buffers chains	kcbzwb	47	23
cache buffers chains	kcbzgb: scan from tail. nowait	33	0
cache buffers chains	kcbchg: kslbegin: bufs not pinned	30	133
cache buffers chains	kcbnlc	15	28
cache buffers chains	kcbzib: multi-block read: nowait	15	0
cache buffers chains	kcbchg: kslbegin: call CR func	6	48
cache buffers chains	kcbget: pin buffer	6	0
cache buffers chains	kcb_pre_apply: kcbhq61	4	128
cache buffers chains	kcb_post_apply: kcbhq62	3	8
cache buffers chains	kcbbic1	1	0
cache buffers chains	kcbget: exchange	1	1
cache buffers lru chain	kcbzgws	1	0
cost function	kzulgt: find user res	16	16
dml lock allocation	ktaidm	1	1
dummy allocation	ktcdod	1	2
dummy allocation	ktcscnfy	1	0
enqueue hash chains	ksqgtl3	8	10
enqueue hash chains	ksqrcl	5	3
enqueues	ksqies	20	19
enqueues	ksqgel: create enqueue	2	3
event range base latch	No latch	13	13
job workq parent latch	kkjgnwqi	5	5
kks stats	kks stats alloc/free	5	5
library cache	kgldte: child 0	98	196
library cache	kglScanDependency	50	0
library cache	kglic	33	0
library cache	kglpndl: child: after processing	31	8
library cache	kglLockCursor	19	13
library cache	kglpin	10	2
library cache	kglobpn: child:	5	23
library cache	kglhdgn: child:	4	13
library cache	kglpndl: child: before processing	3	17
library cache	kgldti: 2child	1	0
library cache lock	kgllkal: child: multiinstance	19	16
library cache lock	kgllkdl: child: no lock handle	11	8
library cache lock	kgllkdl: child: cleanup	5	8
library cache lock allocation	kgllkget	6	6
library cache pin	kglpndl	3	0
messages	ksarcv	1	0
mostly latch-free SCN	kcs024	1	0
object queue header operation	kcbo_switch_cq	26	27
object queue header operation	kcbw_unlink_q	2	0
redo allocation	kcrfw_redo_gen: redo allocation 1	4	0
resmgr:free threads list	kgskthrcreate	2	1
row cache objects	kqreqd: reget	20	2
row cache objects	kqrpre: find obj	4	16
row cache objects	kqreqd	1	7
sequence cache	kdnssd	14	2
session allocation	ksucri	175	222
session allocation	ksuxds: not user session	144	86
session allocation	ksuxds: KSUSFCLC not set	12	37
session allocation	ksufap: active sessions	10	0
session allocation	ksusroll	8	6
session allocation	ksuprc	3	4
session allocation	ksudlc	2	0
session allocation	ksuxds: KSUSFCLC set	1	0
session idle bit	ksupuc: set busy	1,947	1,382
session idle bit	ksupuc: clear busy	1,591	1,910
session idle bit	ksuxds	320	569
shared pool	kghalo	329	175
shared pool	kghupr1	38	146
shared pool	kghfrunp: alloc: session dur	27	0
shared pool	kghfrunp: clatch: nowait	16	0
shared pool	kghfre	5	59
shared pool	kghfrunp: clatch: wait	2	1
shared pool simulator	kglsim_unpin_simhp: fast path	12	14
shared pool simulator	kglsim_unpin_simhp	2	0
simulator hash latch	kcbsacc: lookup dba	89	98
simulator hash latch	kcbs_lookup_setid: lookup dba	11	2
simulator hash latch	kcbsacc: remove dba	1	1
slave class create	ksvcreate	12	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 8,569,025,287
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
HNNX	HNNX	SMS_MT_QUEUE_SSNUMID	INDEX	7,950,313,072	92.78
HNNX	HNNX	BS_CONTENTS	TABLE	310,740,096	3.63
HNNX	HNNX	SMS_MO_QUEUE	TABLE	56,732,240	0.66
HNNX	HNNX	JXSMS_MO_QUEUE	TABLE	50,379,344	0.59
HNNX	HNNX	SMS_RPT_QUEUE	TABLE	48,326,144	0.56

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 10,136,748
Captured Segments account for 100.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
HNNX	HNNX	SMS_MT_HISTORY	MONTH08	TABLE PARTITION	2,443,886	24.11
HNNX	HNNX	SMS_MT_HISTORY	MONTH09	TABLE PARTITION	1,867,038	18.42
HNNX	HNNX	SMS_MT_HISTORY	MONTH10	TABLE PARTITION	1,838,767	18.14
HNNX	HNNX	SMS_MT_HISTORY	MONTH06	TABLE PARTITION	1,825,530	18.01
HNNX	HNNX	SMS_MT_HISTORY	MONTH07	TABLE PARTITION	1,822,246	17.98

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
HNNX	HNNX	INDEX_SI_SEND_SMS_TASKID	INDEX	32	32.00
HNNX	HNNX	SYS_C006055	INDEX	22	22.00
HNNX	HNNX	INDEX_SI_SEND_SMS_ORG_ID	INDEX	12	12.00
HNNX	HNNX	INDEX_SI_SEND_SMS_OPERATORID	INDEX	10	10.00
HNNX	HNNX	INDEX_SI_SEND_SMS_RPT_STATE	INDEX	7	7.00

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
HNNX	HNNX	INDEX_SI_SEND_SMS_TASKID		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
SYS	SYSTEM	JOB$	TABLE	16,696	64.85
SYS	SYSTEM	I_JOB_NEXT	INDEX	8,961	34.81
HNNX	HNNX	IDX_CREATETIME_SMS_WAIT_STATE	INDEX	66	0.26
HNNX	HNNX	SYS_C006054	INDEX	7	0.03
HNNX	HNNX	SYS_C005615	INDEX	5	0.02

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	771	0.00	24	1
dc_database_links	430	0.00	0	1
dc_files	198	0.00	0	66
dc_global_oids	2,828	0.21	0	134
dc_histogram_data	67,636	0.49	0	8,626
dc_histogram_defs	31,503	2.14	0	4,255
dc_object_grants	6	0.00	0	36
dc_object_ids	131,378	0.01	0	1,823
dc_objects	66,841	0.01	65	1,680
dc_profiles	34,235	0.00	0	1
dc_rollback_segments	36,605	0.00	0	127
dc_segments	48,385	0.01	60	2,026
dc_sequences	11,698	0.00	11,698	9
dc_table_scns	2,729	0.00	0	21
dc_tablespace_quotas	1	0.00	0	2
dc_tablespaces	20,494	0.00	0	64
dc_usernames	5,733	0.00	0	52
dc_users	205,726	0.00	0	68
outstanding_alerts	9,240	0.00	0	126

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	10,767	0.00	13,492	0.01	0
CLUSTER	15	0.00	17	0.00	0
INDEX	15	0.00	135	0.00	0
SQL AREA	233,286	8.61	60,399,612	0.05	83
TABLE/PROCEDURE	11,030	0.00	195,732	0.14	147
TRIGGER	388	0.00	2,325	0.04	1

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

B: Begin snap E: End snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	188.80		1.17	2.97	22	29	162	162
	Freeable	100.06	0.00	2.63	7.88	48		38	38
	SQL	1.48	1.01	0.01	0.05	1	269	152	36
	PL/SQL	0.85	0.43	0.01	0.01	0	0	160	160
E	Other	190.05		1.17	2.96	22	29	163	163
	Freeable	52.69	0.00	1.39	2.19	11		38	38
	SQL	0.94	0.48	0.01	0.02	0	269	152	37
	PL/SQL	0.77	0.39	0.00	0.01	0	0	161	161

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	16,693,329,920
Fixed Size	2,122,472
Redo Buffers	14,651,392
Variable Size	4,764,732,696

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	CCursor	339.83	342.23	0.71
shared	Cursor Stats	84.26	84.26	0.00
shared	PCursor	612.73	571.20	-6.78
shared	db_block_hash_buckets	90.00	90.00	0.00
shared	free memory	1,366.70	1,415.35	3.56
shared	kglsim heap	94.75	94.75	0.00
shared	kglsim object batch	130.52	130.52	0.00
shared	library cache	307.98	294.58	-4.35
shared	sql area	1,349.70	1,351.43	0.13
streams	KGH: NO ACCESS	15.98	15.98	0.00
streams	free memory	15.99	15.99	0.00
	buffer_cache	15,920.00	15,920.00	0.00
	fixed_sga	2.02	2.02	0.00
	log_buffer	13.97	13.97	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

Streams processes ordered by CPU usage
CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Coordinator	1,136,818	0	0
QMON Slaves	583,003	0	0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

The Spill Rate should be very close to zero
The Diff in Percentage Spilled should be very close to zero or negative

Queue Schema and Name	Incoming per second	Outgoing per second	Spilled per second	Diff Pct Spilled
SYS.KUPC$C_1_20110714120950	0	0	0	0
SYS.KUPC$S_1_20110714120950	0	0	0	0

Back to Streams Statistics
Back to Top

Buffered Subscribers

All Subscribers should have a zero spill rate

Subscriber Name	Incoming per second	Outgoing per second	Spilled per second
MCP	0	0	0

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
_complex_view_merging	FALSE
_optimizer_filter_pred_pullup	FALSE
audit_file_dest	/opt/oracle/admin/pingtai/adump
background_dump_dest	/opt/oracle/admin/pingtai/bdump
compatible	10.2.0.3.0
control_files	/oradata/pingtai/control01.ctl, /oradata/pingtai/control02.ctl, /oradata/pingtai/control03.ctl
core_dump_dest	/opt/oracle/admin/pingtai/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	pingtai
db_recovery_file_dest	/oradata/flash_recovery_area
db_recovery_file_dest_size	64424509440
dispatchers	(PROTOCOL=TCP) (SERVICE=pingtaiXDB)
global_names	TRUE
job_queue_processes	10
open_cursors	300
pga_aggregate_target	7448035328
processes	300
remote_login_passwordfile	EXCLUSIVE
sga_max_size	21474836480
sga_target	21474836480
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/opt/oracle/admin/pingtai/udump

End of Report

% Blocks changed per Read:	0.01	Recursive Call %:	16.95
Rollback per transaction %:	99.81	Rows per Sort:	0.72

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.88	In-memory Sort %:	100.00
Library Hit %:	99.95	Soft Parse %:	99.98
Execute to Parse %:	0.28	Latch Hit %:	99.93
Parse CPU to Parse Elapsd %:	0.63	% Non-Parse CPU:	99.99