WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

DETAIL 730809871 detail 1 10.2.0.5.0 NO n003-000-000-000.static.ge.com

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
DETAIL	730809871	detail	1	10.2.0.5.0	NO	n003-000-000-000.static.ge.com

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 21012 12-Mar-14 13:00:52 17 2.5

End Snap: 21013 12-Mar-14 14:00:55 17 2.5

Elapsed: 60.05 (mins)

DB Time: 0.21 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	21012	12-Mar-14 13:00:52	17	2.5
End Snap:	21013	12-Mar-14 14:00:55	17	2.5
Elapsed:		60.05 (mins)
DB Time:		0.21 (mins)

Report Summary

Cache Sizes

Begin End

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

Shared Pool Size: 864M 864M Log Buffer: 14,336K

	Begin	End
Buffer Cache:	80M	80M	Std Block Size:	8K
Shared Pool Size:	864M	864M	Log Buffer:	14,336K

Load Profile

Per Second Per Transaction

Redo size: 730.93 5,878.13

Logical reads: 77.10 620.03

Block changes: 3.84 30.89

Physical reads: 6.53 52.48

Physical writes: 0.38 3.02

User calls: 0.14 1.16

Parses: 6.90 55.46

Hard parses: 0.23 1.84

Sorts: 2.70 21.68

Logons: 0.04 0.30

Executes: 10.44 83.99

Transactions: 0.12

	Per Second	Per Transaction
Redo size:	730.93	5,878.13
Logical reads:	77.10	620.03
Block changes:	3.84	30.89
Physical reads:	6.53	52.48
Physical writes:	0.38	3.02
User calls:	0.14	1.16
Parses:	6.90	55.46
Hard parses:	0.23	1.84
Sorts:	2.70	21.68
Logons:	0.04	0.30
Executes:	10.44	83.99
Transactions:	0.12

% Blocks changed per Read: 4.98 Recursive Call %: 99.91

Rollback per transaction %: 0.00 Rows per Sort: 4.69

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 95.31 Soft Parse %: 96.69

Execute to Parse %: 33.97 Latch Hit %: 99.83

Parse CPU to Parse Elapsd %: 42.78 % Non-Parse CPU: 50.73

Shared Pool Statistics

Begin End

Memory Usage %: 86.09 89.96

% SQL with executions>1: 65.75 77.98

% Memory for SQL w/exec>1: 61.73 77.74

	Begin	End
Memory Usage %:	86.09	89.96
% SQL with executions>1:	65.75	77.98
% Memory for SQL w/exec>1:	61.73	77.74

Top 5 Timed Events

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

os thread startup 1,106 305 276 2,373.4 Concurrency

control file parallel write 1,197 12 10 97.2 System I/O

CPU time 5 37.4

log file parallel write 496 3 7 26.7 System I/O

log file sync 83 1 11 7.3 Commit

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
os thread startup	1,106	305	276	2,373.4	Concurrency
control file parallel write	1,197	12	10	97.2	System I/O
CPU time		5		37.4
log file parallel write	496	3	7	26.7	System I/O
log file sync	83	1	11	7.3	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): 12.9s
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	17.50	136.12
parse time elapsed	7.66	59.55
DB CPU	4.81	37.41
hard parse elapsed time	4.28	33.26
failed parse elapsed time	1.09	8.50
PL/SQL execution elapsed time	0.46	3.59
hard parse (sharing criteria) elapsed time	0.43	3.32
hard parse (bind mismatch) elapsed time	0.37	2.84
PL/SQL compilation elapsed time	0.15	1.20
connection management call elapsed time	0.02	0.19
repeated bind elapsed time	0.01	0.11
sequence load elapsed time	0.00	0.00
DB time	12.86
background elapsed time	336.27
background cpu time	6.07

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
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%Total Call Time
Concurrency	1,132	8	305	270	2374.26
System I/O	3,391		16	5	124.13
CPU time			5		37.41
Other	34	15	1	33	8.83
Commit	83		1	11	7.25
User I/O	14,514		0	0	1.91
Network	1,158		0	0	1.18
Application	1		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)
%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
os thread startup	1,106	8	305	276	2.47
control file parallel write	1,197		12	10	2.67
log file parallel write	496		3	7	1.11
log file sync	83		1	11	0.19
enq: PR - contention	5		1	157	0.01
latch free	1		0	207	0.00
db file sequential read	12,612		0	0	28.15
SQL*Net message from dblink	510		0	0	1.14
cursor: pin S wait on X	10	100	0	11	0.02
kksfbc child completion	2	100	0	50	0.00
db file scattered read	1,897		0	0	4.23
SGA: allocation forcing component growth	6	50	0	7	0.01
control file sequential read	1,698		0	0	3.79
direct path sync	1		0	17	0.00
library cache load lock	5		0	1	0.01
SQL*Net more data from dblink	12		0	0	0.03
buffer busy waits	3		0	0	0.01
SQL*Net message to dblink	504		0	0	1.13
LGWR wait for redo copy	20		0	0	0.04
latch: In memory undo latch	4		0	0	0.01
latch: cache buffers chains	4		0	0	0.01
SQL*Net message to client	126		0	0	0.28
SQL*Net more data to dblink	6		0	0	0.01
read by other session	3		0	0	0.01
enq: TX - row lock contention	1		0	0	0.00
direct path write	1		0	0	0.00
Streams AQ: qmn slave idle wait	502		6,991	13926	1.12
jobq slave wait	2,210	97	6,426	2908	4.93
Streams AQ: qmn coordinator idle wait	387	34	3,495	9032	0.86
virtual circuit status	120	100	3,492	29104	0.27
Streams AQ: waiting for time management or cleanup tasks	182	76	3,477	19102	0.41
SQL*Net message from client	132		41	312	0.29
single-task message	6		0	24	0.01
class slave wait	8		0	0	0.02

Back to Wait Events Statistics
Back to Top

Background Wait Events

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
os thread startup	1,106	8	305	276	2.47
control file parallel write	1,197		12	10	2.67
log file parallel write	496		3	7	1.11
events in waitclass Other	25		1	31	0.06
db file sequential read	1,784		0	0	3.98
db file scattered read	1,554		0	0	3.47
control file sequential read	1,564		0	0	3.49
rdbms ipc message	12,882	89	29,968	2326	28.75
Streams AQ: qmn slave idle wait	502		6,991	13926	1.12
Streams AQ: qmn coordinator idle wait	387	34	3,495	9032	0.86
Streams AQ: waiting for time management or cleanup tasks	182	76	3,477	19102	0.41
smon timer	12	100	3,345	278719	0.03
pmon timer	11,400	9	3,219	282	25.45

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	54,311
IDLE_TIME	2,827,371
IOWAIT_TIME	12,718
NICE_TIME	0
SYS_TIME	23,498
USER_TIME	30,559
LOAD	0
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	4,378,624
VM_OUT_BYTES	2,780,291,072
PHYSICAL_MEMORY_BYTES	50,635,173,888
NUM_CPUS	8
NUM_CPU_SOCKETS	2

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	9.90	4.60	10,552	206,220
detail	2.90	0.20	10	1,002
SYS$BACKGROUND	0.00	0.00	12,960	71,468
detailXDB	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 seconds

Service Name	User I/O Total Wts	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts
SYS$USERS	9710	26	0	0
detail	10	0	0	1140
SYS$BACKGROUND	4817	1106	305	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
Total DB Time (s): 13
Captured SQL account for 161.8% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
6	1	60	0.10	44.70	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
5	0	60	0.09	40.40	08vznc16ycuag	EM_PING	SELECT SYS_GUID() FROM SYS.DUA...
3	0	6	0.46	21.48	ampwwknpczbmz	php@localhost.localdomain (TNS V1-V3)	SELECT iid, SUM(show) click, S...
1	1	6	0.23	10.76	amjcj0k84rwd4		DECLARE job BINARY_INTEGER := ...
1	1	6	0.17	8.08	9jcc36mx2396g		INSERT /*+ BYPASS_RECURSIVE_CH...
1	1	975	0.00	5.75	an4593dzvqr4v		select obj#, dataobj#, subpart...
1	1	6	0.12	5.62	380fqq36rnguf		DECLARE job BINARY_INTEGER := ...
1	1	6	0.10	4.58	ddbjpy3dp3yv1		DECLARE job BINARY_INTEGER := ...
0	0	14,388	0.00	3.13	2ym6hhaq30r73		select type#, blocks, extents,...
0	0	376	0.00	1.94	9b4m3fr3vf9kn		select obj#, dataobj#, subpart...
0	0	2	0.07	1.15	8mrg623amm8rx		select OBJOID, CLSOID, RUNTIME...

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 is the CPU Time divided into the Total CPU Time times 100
Total CPU Time (s): 5
Captured SQL account for 154.5% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Text
1	1	6	0.23	28.33	10.76	amjcj0k84rwd4	DECLARE job BINARY_INTEGER := ...
1	1	6	0.18	22.14	8.08	9jcc36mx2396g	INSERT /*+ BYPASS_RECURSIVE_CH...
1	1	975	0.00	15.71	5.75	an4593dzvqr4v	select obj#, dataobj#, subpart...
1	1	6	0.12	14.67	5.62	380fqq36rnguf	DECLARE job BINARY_INTEGER := ...
1	6	60	0.01	11.83	44.70	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
1	1	6	0.09	10.83	4.58	ddbjpy3dp3yv1	DECLARE job BINARY_INTEGER := ...
0	0	14,388	0.00	8.90	3.13	2ym6hhaq30r73	select type#, blocks, extents,...
0	0	376	0.00	5.34	1.94	9b4m3fr3vf9kn	select obj#, dataobj#, subpart...
0	0	2	0.08	3.16	1.15	8mrg623amm8rx	select OBJOID, CLSOID, RUNTIME...
0	0	21	0.00	2.08	0.76	abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_...
0	0	6	0.02	1.93	0.70	94dwfuzns8gsk	/* MV_REFRESH (INS) */INSERT /...
0	0	2,162	0.00	1.81	0.65	0h6b2sajwb74n	select privilege#, level from ...
0	0	15	0.01	1.60	0.56	9pudktzqq9ywb	select a.obj# OBJOID, a.class_...
0	0	1,259	0.00	1.58	0.57	db78fxqxwxt7r	select /+ rule / bucket, end...
0	0	1	0.08	1.58	0.62	bunssq950snhf	insert into wrh$_sga_target_ad...
0	0	1	0.07	1.37	0.50	g1xrqw56260aj	DECLARE job BINARY_INTEGER := ...
0	0	1	0.06	1.27	0.47	4p0unv4varfz8	INSERT INTO STATIC_DATA_CHECK ...
0	0	864	0.00	1.25	0.46	3c1kubcdjnppq	update sys.col_usage$ set equa...
0	0	3,132	0.00	1.10	0.46	96g93hntrzjtr	select /+ rule / bucket_cnt,...
0	0	3	0.02	1.10	0.41	9ph46ktgmyr4k	select nvl(max(t2.spare1), 0) ...

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: 277,775
Captured SQL account for 111.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
104,102	6	17,350.33	37.48	1.36	1.38	amjcj0k84rwd4	DECLARE job BINARY_INTEGER := ...
94,570	6	15,761.67	34.05	1.06	1.04	9jcc36mx2396g	INSERT /*+ BYPASS_RECURSIVE_CH...
57,484	14,388	4.00	20.69	0.43	0.40	2ym6hhaq30r73	select type#, blocks, extents,...
43,121	975	44.23	15.52	0.76	0.74	an4593dzvqr4v	select obj#, dataobj#, subpart...
33,940	6	5,656.67	12.22	0.71	0.72	380fqq36rnguf	DECLARE job BINARY_INTEGER := ...
28,113	6	4,685.50	10.12	0.52	0.59	ddbjpy3dp3yv1	DECLARE job BINARY_INTEGER := ...
19,067	60	317.78	6.86	0.57	5.75	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
13,772	376	36.63	4.96	0.26	0.25	9b4m3fr3vf9kn	select obj#, dataobj#, subpart...
12,510	6	2,085.00	4.50	0.09	0.09	94dwfuzns8gsk	/* MV_REFRESH (INS) */INSERT /...
12,058	2	6,029.00	4.34	0.15	0.15	8mrg623amm8rx	select OBJOID, CLSOID, RUNTIME...
11,877	3,132	3.79	4.28	0.05	0.06	96g93hntrzjtr	select /+ rule / bucket_cnt,...
9,376	2,162	4.34	3.38	0.09	0.08	0h6b2sajwb74n	select privilege#, level from ...
5,835	7	833.57	2.10	0.04	0.04	bfkzhbhp4u6k5	select obj#, part#, hiboundlen...
5,432	3	1,810.67	1.96	0.05	0.05	9ph46ktgmyr4k	select nvl(max(t2.spare1), 0) ...
3,884	1,259	3.08	1.40	0.08	0.07	db78fxqxwxt7r	select /+ rule / bucket, end...
3,683	1	3,683.00	1.33	0.07	0.06	g1xrqw56260aj	DECLARE job BINARY_INTEGER := ...
3,608	1	3,608.00	1.30	0.06	0.06	4p0unv4varfz8	INSERT INTO STATIC_DATA_CHECK ...
3,261	110	29.65	1.17	0.01	0.01	451q2032pshqm	select owner#, name, namespace...
2,994	21	142.57	1.08	0.10	0.10	abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_...
2,896	864	3.35	1.04	0.06	0.06	3c1kubcdjnppq	update sys.col_usage$ set equa...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 23,509
Captured SQL account for 72.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
5,577	6	929.50	23.72	1.36	1.38	amjcj0k84rwd4	DECLARE job BINARY_INTEGER := ...
4,901	6	816.83	20.85	1.06	1.04	9jcc36mx2396g	INSERT /*+ BYPASS_RECURSIVE_CH...
4,817	2	2,408.50	20.49	0.15	0.15	8mrg623amm8rx	select OBJOID, CLSOID, RUNTIME...
2,201	6	366.83	9.36	0.71	0.72	380fqq36rnguf	DECLARE job BINARY_INTEGER := ...
1,890	14,388	0.13	8.04	0.43	0.40	2ym6hhaq30r73	select type#, blocks, extents,...
1,660	975	1.70	7.06	0.76	0.74	an4593dzvqr4v	select obj#, dataobj#, subpart...
1,458	6	243.00	6.20	0.52	0.59	ddbjpy3dp3yv1	DECLARE job BINARY_INTEGER := ...
977	60	16.28	4.16	0.57	5.75	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
930	6	155.00	3.96	0.09	0.09	94dwfuzns8gsk	/* MV_REFRESH (INS) */INSERT /...
481	376	1.28	2.05	0.26	0.25	9b4m3fr3vf9kn	select obj#, dataobj#, subpart...
434	1,259	0.34	1.85	0.08	0.07	db78fxqxwxt7r	select /+ rule / bucket, end...
295	94	3.14	1.25	0.01	0.01	cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_id...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 37,626
Captured SQL account for 73.6% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Text
14,388	14,367	1.00	2ym6hhaq30r73	select type#, blocks, extents,...
3,132	2,331	0.74	96g93hntrzjtr	select /+ rule / bucket_cnt,...
2,162	3,502	1.62	0h6b2sajwb74n	select privilege#, level from ...
1,259	18,367	14.59	db78fxqxwxt7r	select /+ rule / bucket, end...
975	7,800	8.00	an4593dzvqr4v	select obj#, dataobj#, subpart...
864	846	0.98	3c1kubcdjnppq	update sys.col_usage$ set equa...
718	79	0.11	8cuu0uynbrhbn	select job, nvl2(last_date, 1,...
492	487	0.99	04xtrk7uyhknh	select obj#, type#, ctime, mti...
376	3,008	8.00	9b4m3fr3vf9kn	select obj#, dataobj#, subpart...
314	0	0.00	b2gnxm5z6r51n	lock table sys.col_usage$ in e...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 24,844
Captured SQL account for 81.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
14,388	14,388	57.91	2ym6hhaq30r73	select type#, blocks, extents,...
2,162	2,162	8.70	0h6b2sajwb74n	select privilege#, level from ...
314	864	1.26	3c1kubcdjnppq	update sys.col_usage$ set equa...
314	314	1.26	b2gnxm5z6r51n	lock table sys.col_usage$ in e...
299	18	1.20	0v3dvmc22qnam	insert into sys.col_usage$ (ob...
153	153	0.62	350f5yrnnmshs	lock table sys.mon_mods$ in ex...
153	153	0.62	g00cj285jmgsw	update sys.mon_mods$ set inser...
110	110	0.44	451q2032pshqm	select owner#, name, namespace...
110	110	0.44	8swypbbr0m372	select order#, columns, types ...
94	94	0.38	39m4sx9k63ba2	select /*+ index(idl_ub2$ i_id...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Text
1,026	17	4w93fuv5khc59	select name, online$, contents...
936	14,388	2ym6hhaq30r73	select type#, blocks, extents,...
98	110	451q2032pshqm	select owner#, name, namespace...
62	94	ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_id...
61	94	c6awqs517jpj0	select /*+ index(idl_char$ i_i...
59	110	8swypbbr0m372	select order#, columns, types ...
51	94	39m4sx9k63ba2	select /*+ index(idl_ub2$ i_id...
48	94	cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_id...
22	492	04xtrk7uyhknh	select obj#, type#, ctime, mti...

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

08vznc16ycuag SELECT SYS_GUID() FROM SYS.DUAL

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

0v3dvmc22qnam insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)

2ym6hhaq30r73 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait

380fqq36rnguf DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"SITESTAT4MUZHIWAN"."MV_STATIC_COMMON_CLICK"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#

3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln

451q2032pshqm select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

4p0unv4varfz8 INSERT INTO STATIC_DATA_CHECK SELECT TO_CHAR(SYSDATE-5/24, 'yyyy-mm-dd hh24')||'��, ��PV��(detail):', COUNT(*), '��IP��(detail):', COUNT(DISTINCT IP) FROM STATIC_COMMON_DETAILS WHERE NCELL = 0 AND ACCESSTIME >= TO_DATE(TO_CHAR(SYSDATE-5/24, 'yyyy-mm-dd HH24')||':00:00', 'yyyy-mm-dd HH24:mi:ss') AND ACCESSTIME < TO_DATE(TO_CHAR(SYSDATE-1/6, 'yyyy-mm-dd HH24')||':00:00', 'yyyy-mm-dd HH24:mi:ss')

4w93fuv5khc59 select name, online$, contents$, undofile#, undoblock#, blocksize, dflmaxext, dflinit, dflincr, dflextpct, dflminext, dflminlen, owner#, scnwrp, scnbas, NVL(pitrscnwrp, 0), NVL(pitrscnbas, 0), dflogging, bitmapped, inc#, flags, plugged, NVL(spare1, 0), NVL(spare2, 0) from ts$ where ts#=:1

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;

8cuu0uynbrhbn select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job

8mrg623amm8rx 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 f.type# = 69 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 i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

94dwfuzns8gsk /* MV_REFRESH (INS) */INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "SITESTAT4MUZHIWAN"."MV_STATIC_AGG_10MIN"("AGGTIME", "SITEID", "ALLSHOW", "ALLIP", "ALLUSER") SELECT TRUNC("STATIC_AGG_10MIN"."AGGTIME"), "STATIC_AGG_10MIN"."SITEID", SUM("STATIC_AGG_10MIN"."ALLSHOW"), SUM("STATIC_AGG_10MIN"."ALLIP"), SUM("STATIC_AGG_10MIN"."ALLUSER") FROM "STATIC_AGG_10MIN" "STATIC_AGG_10MIN" GROUP BY TRUNC("STATIC_AGG_10MIN"."AGGTIME"), "STATIC_AGG_10MIN"."SITEID"

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

9b4m3fr3vf9kn select obj#, dataobj#, subpart#, hiboundlen, hiboundval, flags, ts#, file#, block#, pctfree$, initrans, maxtrans, analyzetime, samplesize, rowcnt, blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, spare2, length(bhiboundval), bhiboundval from indsubpart$ where pobj# = :1 order by subpart#

9jcc36mx2396g INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "SITESTAT4MUZHIWAN"."MV_STATIC_COMMON_REFFER" select trunc(aggtime) as aggtime, siteid, avg(staytime) as staytime from static_common_reffer group by trunc(aggtime), siteid

9ph46ktgmyr4k select nvl(max(t2.spare1), 0) from tabcompart$ t1, tabsubpart$ t2 where t1.bo#= :1 and t1.obj#= t2.pobj# and t2.spare1 <= :2

9pudktzqq9ywb 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 not null and a.class_oid in (select b.obj# from scheduler$_class b where bitand(b.flags, :4) <> 0 and lower(b.affinity) = lower(:5)) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID

abtp0uqvdb1d3 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)

amjcj0k84rwd4 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"SITESTAT4MUZHIWAN"."MV_STATIC_COMMON_REFFER"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

ampwwknpczbmz SELECT iid, SUM(show) click, SUM(iiduser) clickuser FROM v_static_agg_hour WHERE aggtime >=to_date('2014-03-12', 'yyyy-mm-dd') and aggtime<to_date('2014-03-12', 'yyyy-mm-dd')+1 AND iid = 148171 AND ncell = 0 GROUP BY iid

an4593dzvqr4v select obj#, dataobj#, subpart#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabsubpart$ where pobj# = :1 order by subpart#

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

bfkzhbhp4u6k5 select obj#, part#, hiboundlen, hiboundval, subpartcnt, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, definiexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, defbufpool, deflogging, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, mod(spare2, 256) defhscflags, length(bhiboundval), bhiboundval from tabcompart$ where bo# = :1 order by part#

bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice

c6awqs517jpj0 select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#

cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#

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

ddbjpy3dp3yv1 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"SITESTAT4MUZHIWAN"."MV_STATIC_AGG_10MIN"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

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

ga9j9xk5cy9s0 select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#

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
08vznc16ycuag	SELECT SYS_GUID() FROM SYS.DUAL
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
380fqq36rnguf	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"SITESTAT4MUZHIWAN"."MV_STATIC_COMMON_CLICK"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
451q2032pshqm	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
4p0unv4varfz8	INSERT INTO STATIC_DATA_CHECK SELECT TO_CHAR(SYSDATE-5/24, 'yyyy-mm-dd hh24')\|\|'��, ��PV��(detail):', COUNT(*), '��IP��(detail):', COUNT(DISTINCT IP) FROM STATIC_COMMON_DETAILS WHERE NCELL = 0 AND ACCESSTIME >= TO_DATE(TO_CHAR(SYSDATE-5/24, 'yyyy-mm-dd HH24')\|\|':00:00', 'yyyy-mm-dd HH24:mi:ss') AND ACCESSTIME < TO_DATE(TO_CHAR(SYSDATE-1/6, 'yyyy-mm-dd HH24')\|\|':00:00', 'yyyy-mm-dd HH24:mi:ss')
4w93fuv5khc59	select name, online$, contents$, undofile#, undoblock#, blocksize, dflmaxext, dflinit, dflincr, dflextpct, dflminext, dflminlen, owner#, scnwrp, scnbas, NVL(pitrscnwrp, 0), NVL(pitrscnbas, 0), dflogging, bitmapped, inc#, flags, plugged, NVL(spare1, 0), NVL(spare2, 0) from ts$ where ts#=:1
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;
8cuu0uynbrhbn	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
8mrg623amm8rx	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 f.type# = 69 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 i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
94dwfuzns8gsk	/* MV_REFRESH (INS) /INSERT /+ BYPASS_RECURSIVE_CHECK */ INTO "SITESTAT4MUZHIWAN"."MV_STATIC_AGG_10MIN"("AGGTIME", "SITEID", "ALLSHOW", "ALLIP", "ALLUSER") SELECT TRUNC("STATIC_AGG_10MIN"."AGGTIME"), "STATIC_AGG_10MIN"."SITEID", SUM("STATIC_AGG_10MIN"."ALLSHOW"), SUM("STATIC_AGG_10MIN"."ALLIP"), SUM("STATIC_AGG_10MIN"."ALLUSER") FROM "STATIC_AGG_10MIN" "STATIC_AGG_10MIN" GROUP BY TRUNC("STATIC_AGG_10MIN"."AGGTIME"), "STATIC_AGG_10MIN"."SITEID"
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9b4m3fr3vf9kn	select obj#, dataobj#, subpart#, hiboundlen, hiboundval, flags, ts#, file#, block#, pctfree$, initrans, maxtrans, analyzetime, samplesize, rowcnt, blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, spare2, length(bhiboundval), bhiboundval from indsubpart$ where pobj# = :1 order by subpart#
9jcc36mx2396g	INSERT /+ BYPASS_RECURSIVE_CHECK / INTO "SITESTAT4MUZHIWAN"."MV_STATIC_COMMON_REFFER" select trunc(aggtime) as aggtime, siteid, avg(staytime) as staytime from static_common_reffer group by trunc(aggtime), siteid
9ph46ktgmyr4k	select nvl(max(t2.spare1), 0) from tabcompart$ t1, tabsubpart$ t2 where t1.bo#= :1 and t1.obj#= t2.pobj# and t2.spare1 <= :2
9pudktzqq9ywb	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 not null and a.class_oid in (select b.obj# from scheduler$_class b where bitand(b.flags, :4) <> 0 and lower(b.affinity) = lower(:5)) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
amjcj0k84rwd4	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"SITESTAT4MUZHIWAN"."MV_STATIC_COMMON_REFFER"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
ampwwknpczbmz	SELECT iid, SUM(show) click, SUM(iiduser) clickuser FROM v_static_agg_hour WHERE aggtime >=to_date('2014-03-12', 'yyyy-mm-dd') and aggtime<to_date('2014-03-12', 'yyyy-mm-dd')+1 AND iid = 148171 AND ncell = 0 GROUP BY iid
an4593dzvqr4v	select obj#, dataobj#, subpart#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabsubpart$ where pobj# = :1 order by subpart#
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
bfkzhbhp4u6k5	select obj#, part#, hiboundlen, hiboundval, subpartcnt, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, definiexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, defbufpool, deflogging, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, mod(spare2, 256) defhscflags, length(bhiboundval), bhiboundval from tabcompart$ where bo# = :1 order by part#
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c6awqs517jpj0	select /+ index(idl_char$ i_idl_char1) +/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
ddbjpy3dp3yv1	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"SITESTAT4MUZHIWAN"."MV_STATIC_AGG_10MIN"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g1xrqw56260aj	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN proc_data_check; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
ga9j9xk5cy9s0	select /+ index(idl_sb4$ i_idl_sb41) +/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#

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	596	0.17	1.33
CPU used when call started	169	0.05	0.38
CR blocks created	133	0.04	0.30
Cached Commit SCN referenced	180	0.05	0.40
Commit SCN cached	1	0.00	0.00
DB time	660,184	183.24	1,473.63
DBWR checkpoint buffers written	804	0.22	1.79
DBWR checkpoints	0	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR transaction table writes	98	0.03	0.22
DBWR undo block writes	297	0.08	0.66
IMU CR rollbacks	44	0.01	0.10
IMU Flushes	66	0.02	0.15
IMU Redo allocation size	461,416	128.07	1,029.95
IMU commits	426	0.12	0.95
IMU contention	8	0.00	0.02
IMU ktichg flush	0	0.00	0.00
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	2,195,992	609.52	4,901.77
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
RowCR - row contention	0	0.00	0.00
RowCR attempts	150	0.04	0.33
RowCR hits	150	0.04	0.33
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	108	0.03	0.24
SQL*Net roundtrips to/from dblink	504	0.14	1.13
active txn count during cleanout	80	0.02	0.18
application wait time	0	0.00	0.00
background timeouts	11,519	3.20	25.71
branch node splits	0	0.00	0.00
buffer is not pinned count	99,881	27.72	222.95
buffer is pinned count	89,624	24.88	200.05
bytes received via SQL*Net from client	45,426	12.61	101.40
bytes received via SQL*Net from dblink	227,104	63.03	506.93
bytes sent via SQL*Net to client	53,159	14.75	118.66
bytes sent via SQL*Net to dblink	115,119	31.95	256.96
calls to get snapshot scn: kcmgss	108,412	30.09	241.99
calls to kcmgas	1,705	0.47	3.81
calls to kcmgcs	91	0.03	0.20
change write time	9	0.00	0.02
cleanout - number of ktugct calls	79	0.02	0.18
cleanouts and rollbacks - consistent read gets	28	0.01	0.06
cleanouts only - consistent read gets	7	0.00	0.02
cluster key scan block gets	22,142	6.15	49.42
cluster key scans	17,179	4.77	38.35
commit batch performed	96	0.03	0.21
commit batch requested	96	0.03	0.21
commit batch/immediate performed	96	0.03	0.21
commit batch/immediate requested	96	0.03	0.21
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	5	0.00	0.01
commit cleanout failures: cannot pin	4	0.00	0.01
commit cleanouts	2,613	0.73	5.83
commit cleanouts successfully completed	2,604	0.72	5.81
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	37	0.01	0.08
concurrency wait time	30,531	8.47	68.15
consistent changes	200	0.06	0.45
consistent gets	265,104	73.58	591.75
consistent gets - examination	91,199	25.31	203.57
consistent gets direct	1	0.00	0.00
consistent gets from cache	265,103	73.58	591.75
cursor authentications	411	0.11	0.92
data blocks consistent reads - undo records applied	185	0.05	0.41
db block changes	13,839	3.84	30.89
db block gets	12,671	3.52	28.28
db block gets direct	1	0.00	0.00
db block gets from cache	12,670	3.52	28.28
deferred (CURRENT) block cleanout applications	1,516	0.42	3.38
dirty buffers inspected	422	0.12	0.94
enqueue conversions	1,820	0.51	4.06
enqueue releases	37,278	10.35	83.21
enqueue requests	37,285	10.35	83.23
enqueue timeouts	7	0.00	0.02
enqueue waits	6	0.00	0.01
execute count	37,626	10.44	83.99
free buffer inspected	23,742	6.59	53.00
free buffer requested	24,019	6.67	53.61
heap block compress	69	0.02	0.15
hot buffers moved to head of LRU	9,009	2.50	20.11
immediate (CR) block cleanout applications	35	0.01	0.08
immediate (CURRENT) block cleanout applications	377	0.10	0.84
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	2,307	0.64	5.15
index fast full scans (full)	2	0.00	0.00
index fetch by key	25,763	7.15	57.51
index scans kdiixs1	16,570	4.60	36.99
leaf node 90-10 splits	8	0.00	0.02
leaf node splits	14	0.00	0.03
lob reads	1,251	0.35	2.79
lob writes	99	0.03	0.22
lob writes unaligned	99	0.03	0.22
logons cumulative	135	0.04	0.30
messages received	3,070	0.85	6.85
messages sent	3,067	0.85	6.85
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	112,441	31.21	250.98
opened cursors cumulative	31,678	8.79	70.71
parse count (failures)	12	0.00	0.03
parse count (hard)	823	0.23	1.84
parse count (total)	24,844	6.90	55.46
parse time cpu	237	0.07	0.53
parse time elapsed	554	0.15	1.24
physical read IO requests	14,319	3.97	31.96
physical read bytes	192,585,728	53,454.10	429,878.86
physical read total IO requests	16,250	4.51	36.27
physical read total bytes	222,062,592	61,635.70	495,675.43
physical read total multi block requests	1,921	0.53	4.29
physical reads	23,509	6.53	52.48
physical reads cache	23,508	6.52	52.47
physical reads cache prefetch	9,190	2.55	20.51
physical reads direct	1	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	941	0.26	2.10
physical write bytes	11,100,160	3,080.96	24,777.14
physical write total IO requests	5,096	1.41	11.38
physical write total bytes	72,919,040	20,239.41	162,765.71
physical write total multi block requests	626	0.17	1.40
physical writes	1,355	0.38	3.02
physical writes direct	1	0.00	0.00
physical writes direct (lob)	1	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	1,354	0.38	3.02
physical writes non checkpoint	758	0.21	1.69
pinned buffers inspected	0	0.00	0.00
pinned cursors current	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	553,754	153.70	1,236.06
recursive cpu usage	487	0.14	1.09
redo blocks read for recovery	0	0.00	0.00
redo blocks written	5,660	1.57	12.63
redo entries	5,928	1.65	13.23
redo ordering marks	159	0.04	0.35
redo size	2,633,400	730.93	5,878.13
redo subscn max counts	436	0.12	0.97
redo synch time	95	0.03	0.21
redo synch writes	83	0.02	0.19
redo wastage	139,328	38.67	311.00
redo write time	343	0.10	0.77
redo writer latching time	0	0.00	0.00
redo writes	496	0.14	1.11
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	97	0.03	0.22
rows fetched via callback	15,369	4.27	34.31
session cursor cache hits	26,599	7.38	59.37
session logical reads	277,775	77.10	620.03
shared hash latch upgrades - no wait	3,729	1.04	8.32
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	9,714	2.70	21.68
sorts (rows)	45,538	12.64	101.65
sql area evicted	411	0.11	0.92
sql area purged	12	0.00	0.03
summed dirty queue length	571	0.16	1.27
switch current to new buffer	120	0.03	0.27
table fetch by rowid	74,757	20.75	166.87
table fetch continued row	343	0.10	0.77
table scan blocks gotten	43,330	12.03	96.72
table scan rows gotten	2,683,602	744.86	5,990.18
table scans (long tables)	8	0.00	0.02
table scans (short tables)	19,968	5.54	44.57
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	96	0.03	0.21
undo change vector size	885,192	245.69	1,975.88
user I/O wait time	25	0.01	0.06
user calls	519	0.14	1.16
user commits	448	0.12	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	4,245	1.18	9.48
write clones created in foreground	2	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 pga memory max	3,667,813,544	3,864,751,744
session cursor cache count	49,596	52,100
session uga memory	6.9E+12	7.3E+12
opened cursors current	42	42
logons current	17	17
session uga memory max	2,576,652,880	2,706,541,576
session pga memory	2,480,808,456	2,604,215,264

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
SYSTEM	8,827	2	0.01	2.01	156	6
TS_STATDATA	4,379	1	0.01	1.03	27	0
SYSAUX	1,009	0	0.11	1.15	540	0
UNDOTBS1	104	0	0.00	1.00	218	0
TEMPINDEX	2	0	0.00	1.00	0	0
TEMP	1	0	0.00	1.00	0	0

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)
SYSAUX	/Data/apps/oracle/product/10.2.0/oradata/detail/sysaux01.dbf	1,009	0	0.11	1.15	540	0	0.00
SYSTEM	/Data/apps/oracle/product/10.2.0/oradata/detail/system01.dbf	8,827	2	0.01	2.01	156	6	0.00
TEMP	/Data/apps/oracle/product/10.2.0/oradata/detail/temp01.dbf	1	0	0.00	1.00	0	0
TEMPINDEX	/home/oracle/tempindex.dbf	2	0	0.00	1.00	0	0
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0001.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0005.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0007.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0009.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0011.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0029.dbf	1,000	0	0.01	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0031.dbf	626	0	0.02	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0033.dbf	408	0	0.05	1.02	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0035.dbf	337	0	0.00	1.02	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0037.dbf	136	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0039.dbf	199	0	0.00	1.02	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0041.dbf	374	0	0.00	1.02	10	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0043.dbf	137	0	0.00	1.19	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0045.dbf	88	0	0.11	1.41	4	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0047.dbf	59	0	0.00	1.46	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0049.dbf	9	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0051.dbf	8	0	0.00	1.00	5	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0053.dbf	7	0	0.00	1.57	2	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0055.dbf	16	0	0.00	1.31	3	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0057.dbf	8	0	0.00	1.25	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0061.dbf	19	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0063.dbf	14	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0065.dbf	6	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0067.dbf	81	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0069.dbf	100	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0071.dbf	27	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0073.dbf	5	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0075.dbf	4	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0077.dbf	5	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0079.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0081.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0083.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0085.dbf	33	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0087.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0089.dbf	9	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0091.dbf	13	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0093.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0095.dbf	4	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0097.dbf	11	0	0.00	1.55	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0099.dbf	3	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0101.dbf	4	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0111.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0113.dbf	1	0	0.00	1.00	1	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0119.dbf	8	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0121.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0141.dbf	9	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0143.dbf	13	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0145.dbf	9	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0147.dbf	5	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0149.dbf	4	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0151.dbf	5	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0157.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0159.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data1/oradata/ts_statdata0173.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0004.dbf	9	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0008.dbf	12	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0012.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0014.dbf	12	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0026.dbf	17	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0032.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0038.dbf	4	0	0.00	2.50	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0040.dbf	15	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0042.dbf	8	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0044.dbf	19	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0046.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0048.dbf	5	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0050.dbf	8	0	0.00	1.00	2	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0052.dbf	3	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0054.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0058.dbf	11	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0062.dbf	4	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0064.dbf	14	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0066.dbf	49	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0068.dbf	97	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0070.dbf	79	0	0.00	1.03	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0074.dbf	14	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0076.dbf	7	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0078.dbf	15	0	0.00	1.53	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0080.dbf	4	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0082.dbf	4	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0084.dbf	7	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0086.dbf	7	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0088.dbf	13	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0090.dbf	10	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0092.dbf	7	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0094.dbf	3	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0096.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0098.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0100.dbf	7	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0102.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0110.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0112.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0114.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0116.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0120.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0124.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0126.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0128.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0130.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0132.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0136.dbf	3	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0138.dbf	4	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0142.dbf	3	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0144.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0146.dbf	1	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0148.dbf	3	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0150.dbf	3	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0152.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0154.dbf	3	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0158.dbf	4	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0160.dbf	4	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0162.dbf	5	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0170.dbf	3	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0174.dbf	4	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0176.dbf	2	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0178.dbf	16	0	0.00	1.00	0	0	0.00
TS_STATDATA	/oracledata/data2/oradata/ts_statdata0180.dbf	2	0	0.00	1.00	0	0	0.00
UNDOTBS1	/Data/apps/oracle/product/10.2.0/oradata/detail/undotbs01.dbf	104	0	0.00	1.00	218	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	9,810	92	278,000	23,503	1,354	0	0	6

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	13	274	1097	1605	3317760	1605
E	0	13	283	906	1714	3317760	1714

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	16	0.17	1,979	4.40	3,208
D	32	0.33	3,958	4.40	3,208
D	48	0.50	5,937	4.40	3,208
D	64	0.67	7,916	2.33	1,701
D	80	0.83	9,895	1.87	1,361
D	96	1.00	11,874	1.00	729
D	112	1.17	13,853	0.87	632
D	128	1.33	15,832	0.87	632
D	144	1.50	17,811	0.87	632
D	160	1.67	19,790	0.87	632
D	176	1.83	21,769	0.87	632
D	192	2.00	23,748	0.87	632

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	54	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	383	328	33.15	0.00	0.00	0.00	0.00	78,438
E	383	328	33.52	0.00	0.00	0.00	0.00	78,438

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	4,184	4,184
64K	128K	15	15
128K	256K	4	4
512K	1024K	37	37
1M	2M	12	12

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %
48	0.13	1,926.24	41.68	98.00
96	0.25	1,926.24	41.68	98.00
192	0.50	1,926.24	41.68	98.00
287	0.75	1,926.24	0.00	100.00
383	1.00	1,926.24	0.00	100.00
460	1.20	1,926.24	0.00	100.00
536	1.40	1,926.24	0.00	100.00
613	1.60	1,926.24	0.00	100.00
689	1.80	1,926.24	0.00	100.00
766	2.00	1,926.24	0.00	100.00
1,149	3.00	1,926.24	0.00	100.00
1,532	4.00	1,926.24	0.00	100.00
2,298	6.00	1,926.24	0.00	100.00
3,064	8.00	1,926.24	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 (K)
768	0.89	97	5,562	169,030	1.00	3,683	1.07	1,770
864	1.00	194	10,587	169,285	1.00	3,428	1.00	1,771
960	1.11	260	14,034	169,430	1.00	3,283	0.96	1,772
1,056	1.22	260	14,034	169,477	1.00	3,236	0.94	1,772
1,152	1.33	260	14,034	169,486	1.00	3,227	0.94	1,772
1,248	1.44	260	14,034	169,487	1.00	3,226	0.94	1,773
1,344	1.56	260	14,034	169,487	1.00	3,226	0.94	1,773
1,440	1.67	260	14,034	169,487	1.00	3,226	0.94	1,773
1,536	1.78	260	14,034	169,487	1.00	3,226	0.94	1,773
1,632	1.89	260	14,034	169,487	1.00	3,226	0.94	1,773
1,728	2.00	260	14,034	169,487	1.00	3,226	0.94	1,773

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
864	0.75	9,168	7,203
1,152	1.00	8,683	335
1,440	1.25	8,625	335
1,728	1.50	8,625	335
2,016	1.75	8,625	335
2,304	2.00	8,625	335

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)	Avg Time (ms)
data block	6	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	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
PR-Process Startup	1,021	1,021	0	5	1	160.00
TX-Transaction (row lock contention)	1	1	0	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	0.21	1,234	0	3	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 Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
12-Mar 14:00	33	179	3	15	0/0	0/0/0/0/0/0
12-Mar 13:50	20	114	2	15	0/0	0/0/0/0/0/0
12-Mar 13:40	24	212	3	15	0/0	0/0/0/0/0/0
12-Mar 13:30	25	114	3	15	0/0	0/0/0/0/0/0
12-Mar 13:20	33	433	2	15	0/0	0/0/0/0/0/0
12-Mar 13:10	74	182	3	15	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,394	0.00		0
AWR Alerted Metric Element list	19,631	0.00		0
Consistent RBA	496	0.00		0
FIB s.o chain latch	24	0.00		0
FOB s.o list latch	3,621	0.00		0
In memory undo latch	5,463	0.07	1.00	1,404	0.00
JS mem alloc latch	8	0.00		0
JS queue access latch	8	0.00		0
JS queue state obj latch	25,954	0.00		0
JS slv state obj latch	160	0.00		0
KMG MMAN ready and startup request latch	2,276	0.00		0
KMG resize request state object freelist	12	0.00		0
KTF sga latch	55	0.00		1,105	0.00
KWQMN job cache list latch	298	0.00		0
KWQP Prop Status	2	0.00		0
MQL Tracking Latch	0			72	0.00
Memory Management Latch	1,195	0.00		2,273	0.00
OS process	9,207	0.00		0
OS process allocation	7,338	0.00		0
OS process: request allocation	2,054	0.00		0
PL/SQL warning settings	309	0.00		0
SGA IO buffer pool latch	4	0.00		4	0.00
SQL memory manager latch	1	0.00		1,197	0.00
SQL memory manager workarea list latch	81,998	0.00		0
Shared B-Tree	131	0.00		0
active checkpoint queue latch	1,791	0.00		0
active service list	7,826	0.00		13,446	0.00
archive control	8	0.00		0
begin backup scn array	1	0.00		0
buffer pool	80	0.00		0
cache buffer handles	30	0.00		0
cache buffers chains	526,877	0.01	0.09	108,515	0.01
cache buffers lru chain	15,951	0.13	0.00	91,846	0.23
cache table scan latch	0			1,896	0.05
channel handle pool latch	2,054	0.00		0
channel operations parent latch	21,938	0.00		0
checkpoint queue latch	104,248	0.00	0.00	7,210	0.01
client/application info	1,648	0.00		0
commit callback allocation	182	0.00		0
compile environment latch	135	0.00		0
constraint object allocation	36	0.00		0
dml lock allocation	14,585	0.01	0.00	0
dummy allocation	270	0.00		0
enqueue hash chains	76,373	0.01	0.00	0
enqueues	68,132	0.01	0.00	0
event group latch	1,027	0.00		0
file cache latch	350	0.00		0
global KZLD latch for mem in SGA	6	0.00		0
global tx hash mapping	396	0.00		0
hash table column usage latch	603	0.00		18,464	0.00
hash table modification latch	73	0.00		0
job workq parent latch	0			162	0.62
job_queue_processes parameter latch	129	0.00		0
kks stats	2,311	0.13	0.00	0
kmcptab latch	1	0.00		0
kmcpvec latch	0			1	0.00
kokc descriptor allocation latch	126	0.00		0
ksuosstats global area	243	0.00		0
ktm global data	12	0.00		0
kwqbsn:qsga	130	0.00		0
lgwr LWN SCN	1,459	0.00		0
library cache	79,841	0.11	0.00	1,095	0.00
library cache load lock	2,364	0.00		0
library cache lock	165,033	0.08	0.00	0
library cache lock allocation	2,218	0.00		0
library cache pin	20,953	0.01	0.00	0
library cache pin allocation	600	0.00		0
list of block allocation	231	0.00		0
loader state object freelist	6	0.00		0
logminer context allocation	1	0.00		0
messages	31,668	0.00		0
mostly latch-free SCN	1,460	0.00		0
multiblock read objects	7,372	0.00		0
ncodef allocation latch	10,349	0.00		0
object queue header heap	12,166	0.00		5,071	0.02
object queue header operation	59,058	0.01	0.00	5,895	0.02
object stats modification	2	0.00		0
parallel query alloc buffer	480	0.00		0
parameter list	310	0.00		0
parameter table management	320	0.00		0
post/wait queue	250	0.00		83	0.00
process allocation	2,054	0.00		1,027	0.00
process group creation	2,054	0.00		0
qmn task queue latch	1,142	0.79	0.00	0
redo allocation	6,196	0.02	0.00	5,904	0.00
redo copy	0			5,904	0.39
redo writing	5,794	0.00		0
resmgr group change latch	403	0.00		0
resmgr:active threads	255	0.00		0
resmgr:actses change group	87	0.00		0
resmgr:free threads list	254	0.00		0
resmgr:resource group CPU method	87	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	180,130	0.81	0.00	3,517	0.00
rules engine aggregate statistics	30	0.00		0
rules engine rule set statistics	160	0.00		0
sequence cache	545	0.00		0
session allocation	4,997	0.04	0.00	0
session idle bit	1,490	0.00		0
session state list latch	342	0.00		0
session switching	15,484	0.00		0
session timer	10,427	0.00		0
shared pool	117,676	1.12	0.00	0
shared pool sim alloc	11	0.00		0
shared pool simulator	5,681	0.00		0
simulator hash latch	22,464	0.00		0
simulator lru latch	1,655	0.00		17,397	0.07
slave class	8	0.00		0
slave class create	32	3.13	1.00	0
sort extent pool	10,397	0.00		0
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
temp lob duration state obj allocation	2	0.00		0
threshold alerts latch	262	0.00		0
transaction allocation	443	0.00		0
transaction branch allocation	10,619	0.00		0
undo global data	7,577	0.00		0
user lock	186	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	526,877	47	4	43
In memory undo latch	5,463	4	4	1
slave class create	32	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	ktiFlush: child	3	2
In memory undo latch	kticmt: child	2	3
cache buffers chains	kcbgtcr: kslbegin excl	4	2
cache buffers chains	kcbchg: kslbegin: bufs not pinned	2	1
object queue header operation	kcbo_switch_cq	1	1
slave class create	ksvcreate	1	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: 277,775
Captured Segments account for 65.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	I_FILE#_BLOCK#	INDEX	42,608	15.34
SYS	SYSTEM	OBJ$	TABLE	25,312	9.11
SYS	SYSTEM	SEG$	TABLE	18,816	6.77
SYS	SYSTEM	TABSUBPART$	TABLE	17,680	6.36
SYS	SYSTEM	I_SYSAUTH1	INDEX	11,616	4.18

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 23,509
Captured Segments account for 70.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	OBJ$	TABLE	8,526	36.27
SYS	SYSTEM	SEG$	TABLE	3,480	14.80
SYS	SYSTEM	TABSUBPART$	TABLE	1,012	4.30
SYS	SYSTEM	TAB$	TABLE	918	3.90
SYS	SYSTEM	I_FILE#_BLOCK#	INDEX	482	2.05

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
SYS	SYSTEM	DBMS_LOCK_ALLOCATED		TABLE	2	100.00

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
SYS	SYSTEM	DBMS_LOCK_ALLOCATED	TABLE	1	33.33
SYS	SYSTEM	JOB$	TABLE	1	33.33
SYS	SYSTEM	SNAP$	TABLE	1	33.33

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	65	3.08	2	1
dc_database_links	578	1.04	0	3
dc_global_oids	220	16.82	0	0
dc_histogram_data	5,611	22.67	0	291
dc_histogram_defs	7,590	42.03	0	797
dc_object_grants	20	35.00	0	0
dc_object_ids	6,491	9.64	0	216
dc_objects	2,820	18.48	5	178
dc_profiles	89	2.25	0	1
dc_rollback_segments	1,390	0.00	0	59
dc_segments	15,910	90.84	6	202
dc_sequences	10	40.00	10	0
dc_table_scns	45	13.33	0	0
dc_tablespaces	4,743	0.36	0	3
dc_usernames	2,679	2.91	0	37
dc_users	8,984	1.16	0	49
global database name	36	5.56	0	0
kqlsubheap_object	4	100.00	0	0
outstanding_alerts	106	40.57	30	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	955	3.25	1,312	2.67	4	0
CLUSTER	35	5.71	99	3.03	1	0
INDEX	44	40.91	93	21.51	2	0
SQL AREA	5,874	18.56	60,232	3.58	273	141
TABLE/PROCEDURE	1,791	21.55	8,284	13.00	276	0
TRIGGER	12	8.33	194	2.06	3	0

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	24.65		1.30	2.42	11	11	19	19
	Freeable	7.75	0.00	1.29	0.65	2		6	6
	SQL	0.61	0.57	0.06	0.05	0	2	11	8
	PL/SQL	0.15	0.08	0.01	0.02	0	0	17	17
E	Other	23.47		1.24	2.42	11	11	19	19
	Freeable	9.31	0.00	1.33	0.49	2		7	7
	SQL	0.60	0.55	0.05	0.05	0	2	11	8
	PL/SQL	0.15	0.08	0.01	0.02	0	0	17	17

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	83,886,080
Fixed Size	2,095,864
Redo Buffers	14,680,064
Variable Size	1,107,297,544

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	160.00	160.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	ASH buffers	15.50	15.50	0.00
shared	KGH: NO ACCESS	15.70	31.39	99.90
shared	KSN WaitID	10.00	10.49	4.82
shared	NETWORK BUFFER	631.08	661.53	4.82
shared	free memory	120.14	86.71	-27.82
streams	KGH: NO ACCESS	15.97	15.97	0.00
streams	free memory	16.01	16.01	0.00
	buffer_cache	80.00	80.00	0.00
	fixed_sga	2.00	2.00	0.00
	log_buffer	14.00	14.00	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

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

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Slaves	45,992	13,994	0
QMON Coordinator	0	0	0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/Data/apps/oracle/admin/detail/adump
background_dump_dest	/Data/apps/oracle/admin/detail/bdump
compatible	10.2.0.1.0
control_files	/Data/apps/oracle/product/10.2.0/oradata/detail/control01.ctl, /Data/apps/oracle/product/10.2.0/oradata/detail/control02.ctl, /Data/apps/oracle/product/10.2.0/oradata/detail/control03.ctl
core_dump_dest	/Data/apps/oracle/admin/detail/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	detail
db_recovery_file_dest	/Data/apps/oracle/flash_recovery_area
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=detailXDB)
java_pool_size	167772160
job_queue_processes	50
open_cursors	300
pga_aggregate_target	401604608
processes	150
remote_login_passwordfile	EXCLUSIVE
sga_target	1207959552
shared_pool_size	167772160
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/Data/apps/oracle/admin/detail/udump

End of Report

% Blocks changed per Read:	4.98	Recursive Call %:	99.91
Rollback per transaction %:	0.00	Rows per Sort:	4.69

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	91.54	In-memory Sort %:	100.00
Library Hit %:	95.31	Soft Parse %:	96.69
Execute to Parse %:	33.97	Latch Hit %:	99.83
Parse CPU to Parse Elapsd %:	42.78	% Non-Parse CPU:	50.73