WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release Cluster Host

ORCL 1342668293 orcl 1 10.1.0.2.0 NO HHXA-TEST-008

DB Name	DB Id	Instance	Inst num	Release	Cluster	Host
ORCL	1342668293	orcl	1	10.1.0.2.0	NO	HHXA-TEST-008

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 742 14-8月 -13 12:00:16 13 4.6

End Snap: 747 14-8月 -13 15:00:30 18 6.6

Elapsed: 180.23 (mins)

DB Time: 108.08 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	742	14-8月 -13 12:00:16	13	4.6
End Snap:	747	14-8月 -13 15:00:30	18	6.6
Elapsed:		180.23 (mins)
DB Time:		108.08 (mins)

Report Summary

Cache Sizes (end)

Buffer Cache: 24M Std Block Size: 8K

Shared Pool Size: 80M Log Buffer: 512K

Load Profile

Per Second Per Transaction

Redo size: 819.28 67,117.55

Logical reads: 384.74 31,518.89

Block changes: 8.39 687.32

Physical reads: 190.82 15,632.26

Physical writes: 4.98 407.69

User calls: 5.29 433.43

Parses: 0.82 67.15

Hard parses: 0.11 9.11

Sorts: 0.57 47.06

Logons: 0.00 0.17

Executes: 1.90 156.01

Transactions: 0.01

	Per Second	Per Transaction
Redo size:	819.28	67,117.55
Logical reads:	384.74	31,518.89
Block changes:	8.39	687.32
Physical reads:	190.82	15,632.26
Physical writes:	4.98	407.69
User calls:	5.29	433.43
Parses:	0.82	67.15
Hard parses:	0.11	9.11
Sorts:	0.57	47.06
Logons:	0.00	0.17
Executes:	1.90	156.01
Transactions:	0.01

% Blocks changed per Read: 2.18 Recursive Call %: 79.81

Rollback per transaction %: 2.27 Rows per Sort: 550.56

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 95.32 Redo NoWait %: 99.99

Buffer Hit %: 51.64 In-memory Sort %: 99.90

Library Hit %: 91.94 Soft Parse %: 86.44

Execute to Parse %: 56.96 Latch Hit %: 99.53

Parse CPU to Parse Elapsd %: 3.54 % Non-Parse CPU: 96.41

Shared Pool Statistics

Begin End

Memory Usage %: 91.78 93.88

% SQL with executions>1: 82.11 69.49

% Memory for SQL w/exec>1: 74.06 63.07

	Begin	End
Memory Usage %:	91.78	93.88
% SQL with executions>1:	82.11	69.49
% Memory for SQL w/exec>1:	74.06	63.07

Top 5 Timed Events

Event Waits Time(s) Percent Total DB Time Wait Class

db file parallel read 20,888 3,479 53.65 User I/O

db file sequential read 25,222 2,230 34.39 User I/O

db file scattered read 104,512 517 7.97 User I/O

read by other session 194,685 273 4.21 User I/O

direct path read temp 12,443 159 2.45 User I/O

Event	Waits	Time(s)	Percent Total DB Time	Wait Class
db file parallel read	20,888	3,479	53.65	User I/O
db file sequential read	25,222	2,230	34.39	User I/O
db file scattered read	104,512	517	7.97	User I/O
read by other session	194,685	273	4.21	User I/O
direct path read temp	12,443	159	2.45	User I/O

Main Report

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

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	Timeouts	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file parallel read	20,888	0	3,479	167	158.24
db file sequential read	25,222	0	2,230	88	191.08
db file scattered read	104,512	0	517	5	791.76
read by other session	194,685	0	273	1	1,474.89
direct path read temp	12,443	0	159	13	94.27
control file parallel write	3,687	0	97	26	27.93
control file sequential read	2,040	0	33	16	15.45
class slave wait	6	6	31	5,097	0.05
log file parallel write	1,025	0	29	28	7.77
direct path read	192	0	23	121	1.45
SQL*Net more data to client	61,369	0	19	0	464.92
db file parallel write	1,371	0	17	13	10.39
direct path write temp	9,239	0	14	2	69.99
buffer busy waits	41	0	5	124	0.31
library cache pin	28	0	2	69	0.21
latch: cache buffers chains	291	278	1	4	2.20
write complete waits	1	1	1	1,016	0.01
rdbms ipc reply	77	0	1	10	0.58
log file sync	75	0	1	7	0.57
local write wait	304	0	0	1	2.30
SQL*Net message to client	57,060	0	0	0	432.27
control file single write	80	0	0	2	0.61
library cache load lock	2	0	0	56	0.02
log file switch completion	2	0	0	43	0.02
latch free	70	12	0	1	0.53
process startup	6	0	0	12	0.05
db file single write	77	0	0	0	0.58
log file sequential read	2	0	0	4	0.02
SQL*Net break/reset to client	12	0	0	0	0.09
log buffer space	1	0	0	2	0.01
latch: cache buffers lru chain	12	0	0	0	0.09
log file single write	2	0	0	0	0.02
direct path write	40	0	0	0	0.30
LGWR wait for redo copy	6	0	0	0	0.05
ksfd: async disk IO	3	0	0	0	0.02
virtual circuit status	364	364	10,808	29,694	2.76
Queue Monitor Wait	355	355	10,803	30,431	2.69
wakeup time manager	37	2	10,343	279,545	0.28
SQL*Net message from client	57,055	0	5,723	100	432.23

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	Timeouts	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file sequential read	2,333	0	385	165	17.67
control file parallel write	3,533	0	97	27	26.77
log file parallel write	1,025	0	29	28	7.77
db file parallel write	1,371	0	17	13	10.39
control file sequential read	861	0	17	19	6.52
db file scattered read	269	0	7	26	2.04
direct path read	16	0	0	7	0.12
process startup	6	0	0	12	0.05
control file single write	3	0	0	6	0.02
log file sequential read	2	0	0	4	0.02
log file single write	2	0	0	0	0.02
direct path write	22	0	0	0	0.17
LGWR wait for redo copy	6	0	0	0	0.05
rdbms ipc message	31,660	30,426	83,629	2,641	239.85
Queue Monitor Wait	355	355	10,803	30,431	2.69
wakeup time manager	37	2	10,343	279,545	0.28
smon timer	35	35	10,256	293,026	0.27

Back to Wait Events Statistics
Back to Top

Time Model Statistics

ordered by Time (seconds) desc

Statistic Name	Time (seconds)	% Total DB Time
DB time	6,484.58	100.00
sql execute elapsed time	6,468.85	99.76
background elapsed time	654.46	10.09
parse time elapsed	180.24	2.78
hard parse elapsed time	178.20	2.75
DB CPU	109.21	1.68
PL/SQL execution elapsed time	29.23	0.45
PL/SQL compilation elapsed time	25.11	0.39
connection management call elapsed time	21.22	0.33
background cpu time	13.29	0.21
failed parse elapsed time	1.30	0.02
hard parse (sharing criteria) elapsed time	1.13	0.02
sequence load elapsed time	0.72	0.01
hard parse (bind mismatch) elapsed time	0.59	0.01
inbound PL/SQL rpc elapsed time	0.00	0.00
Java execution elapsed time	0.00	0.00
failed parse (out of shared memory) elapsed t	0.00	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Name	Value
AVG_BUSY_TICKS	###############
AVG_IDLE_TICKS	939,279
AVG_IN_BYTES	615,718,912
AVG_OUT_BYTES	1,063,421,952
AVG_SYS_TICKS	###############
AVG_USER_TICKS	114,204
BUSY_TICKS	310,285
IDLE_TICKS	1,878,930
IN_BYTES	1,231,437,824
OUT_BYTES	2,126,843,904
RSRC_MGR_CPU_WAIT_TIME	0
SYS_TICKS	81,529
USER_TICKS	228,756

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time
us - microsecond - 1000000th of a second

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
ORCL	5,984.30	104.80	2,050,677	3,965,883
SYS$USERS	455.60	4.20	2,665	102,115
ORCLXDB	0.00	0.00	0	0
SYS$BACKGROUND	0.00	0.00	7,270	89,497

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
ORCL	360,406	584,956	362	822	118,118	1,977
SYS$USERS	2,537	43,802	0	0	267	0
SYS$BACKGROUND	4,672	39,977	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
549	35	2	274.44	8.46	56wtxtwtvx4ks	w3wp.exe	select substr(id, 2, 2) prov...
289	1	2	144.40	4.45	f16rcwh0pg3am	w3wp.exe	select count(*) ct, server, ...
218	33	2	109.05	3.36	fm5np7mv4ws56	w3wp.exe	select rtrim(id) as id, natio...
107	2	1	107.20	1.65	95rbybk0fzdgd	TOAD 9.7.2.5	Select * from table(dbms_workl...
53	0	28	1.89	0.82	7ajk19xfu1g0r		select smontabv.cnt, smontabv...
48	2	2	23.79	0.73	fp7br2hwxcxfb	w3wp.exe	select rtrim(id) as id from st...
47	0	3	15.69	0.73	7ptuqb2nxxzrv	TOAD后台查询会话	select object_name nam, Decod...
33	0	3,383	0.01	0.50	96g93hntrzjtr		select /+ rule / bucket_cnt,...
32	2	2	16.07	0.50	5nccq9vqfg5cw	w3wp.exe	select count(*) as ct, dbType...
28	0	214	0.13	0.42	cqgv56fmuj63x		select owner#, name, namespace...

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
35	549	2	17.41	8.46	56wtxtwtvx4ks	w3wp.exe	select substr(id, 2, 2) prov...
33	218	2	16.62	3.36	fm5np7mv4ws56	w3wp.exe	select rtrim(id) as id, natio...
2	32	2	1.17	0.50	5nccq9vqfg5cw	w3wp.exe	select count(*) as ct, dbType...
2	107	1	2.16	1.65	95rbybk0fzdgd	TOAD 9.7.2.5	Select * from table(dbms_workl...
2	48	2	1.01	0.73	fp7br2hwxcxfb	w3wp.exe	select rtrim(id) as id from st...
2	3	5	0.33	0.05	584ypkst2k8p7		insert into wrh$_bg_event_summ...
1	289	2	0.59	4.45	f16rcwh0pg3am	w3wp.exe	select count(*) ct, server, ...
1	10	2	0.58	0.16	821a53m61hj2u	w3wp.exe	select rtrim(id1) as id1, rel...
1	4	3	0.34	0.06	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
1	8	1	0.94	0.12	1uk5m5qbzj1vt	sqlplus.exe	BEGIN dbms_workload_repository...

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: 4,160,494
Captured SQL accounts for 85.8% of Total Buffer Gets

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
3,149,872	2	1,574,936.00	75.71	34.83	548.87	56wtxtwtvx4ks	w3wp.exe	select substr(id, 2, 2) prov...
95,585	1	95,585.00	2.30	2.16	107.20	95rbybk0fzdgd	TOAD 9.7.2.5	Select * from table(dbms_workl...
83,993	1	83,993.00	2.02	0.72	9.49	c8khjbn635s3c	plsqldev.exe	select s.synonym_name object_n...
34,513	2	17,256.50	0.83	1.18	288.80	f16rcwh0pg3am	w3wp.exe	select count(*) ct, server, ...
31,488	2	15,744.00	0.76	33.25	218.09	fm5np7mv4ws56	w3wp.exe	select rtrim(id) as id, natio...
30,916	2	15,458.00	0.74	2.35	32.15	5nccq9vqfg5cw	w3wp.exe	select count(*) as ct, dbType...
22,284	2	11,142.00	0.54	2.02	47.59	fp7br2hwxcxfb	w3wp.exe	select rtrim(id) as id from st...
13,626	3	4,542.00	0.33	1.02	3.99	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
12,950	1	12,950.00	0.31	0.94	7.84	1uk5m5qbzj1vt	sqlplus.exe	BEGIN dbms_workload_repository...
9,023	3,383	2.67	0.22	0.28	32.66	96g93hntrzjtr		select /+ rule / bucket_cnt,...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 2,063,458
Captured SQL accounts for 83.3% of Total Disk Reads

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,574,871	2	787,435.50	76.32	34.83	548.87	56wtxtwtvx4ks	w3wp.exe	select substr(id, 2, 2) prov...
58,139	2	29,069.50	2.82	33.25	218.09	fm5np7mv4ws56	w3wp.exe	select rtrim(id) as id, natio...
25,376	2	12,688.00	1.23	1.18	288.80	f16rcwh0pg3am	w3wp.exe	select count(*) ct, server, ...
22,323	2	11,161.50	1.08	2.35	32.15	5nccq9vqfg5cw	w3wp.exe	select count(*) as ct, dbType...
22,180	2	11,090.00	1.07	2.02	47.59	fp7br2hwxcxfb	w3wp.exe	select rtrim(id) as id from st...
2,502	3	834.00	0.12	0.08	1.81	cfz686a6qp0kg		select o.obj#, u.name, o.nam...
2,418	2	1,209.00	0.12	0.32	7.28	8hxupdnt3pj2m	w3wp.exe	select count(*) from str where...
2,091	3	697.00	0.10	0.17	47.07	7ptuqb2nxxzrv	TOAD后台查询会话	select object_name nam, Decod...
1,694	1	1,694.00	0.08	0.72	9.49	c8khjbn635s3c	plsqldev.exe	select s.synonym_name object_n...
1,096	1	1,096.00	0.05	2.16	107.20	95rbybk0fzdgd	TOAD 9.7.2.5	Select * from table(dbms_workl...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 20,593
Captured SQL accounts for 78.0% of Total Executions

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Text
3,383	2,193	0.65	0.01	96g93hntrzjtr	select /+ rule / bucket_cnt,...
2,047	0	0.00	0.00	803b7z0t84sq7	select job, nvl2(last_date, ...
1,658	1,658	1.00	0.00	g2wr3u7s1gtf3	select count(*) from sys.job$ ...
928	1,234	1.33	0.00	53saa2zkr6wc3	select intcol#, nvl(pos#, 0), ...
843	13,234	15.70	0.03	db78fxqxwxt7r	select /+ rule / bucket, en...
826	826	1.00	0.00	3c1kubcdjnppq	update sys.col_usage$ set eq...
453	5,528	12.20	0.02	83taa7kaw59c1	select name, intcol#, segcol#,...
450	1,103	2.45	0.01	6769wyy3yf66f	select pos#, intcol#, col#, sp...
366	366	1.00	0.04	2ym6hhaq30r73	select type#, blocks, extents,...
362	0	0.00	0.00	afx304d90ps3z	select rowcnt, blkcnt, empcn...
351	450	1.28	0.06	1tjnwqfpzxnng	select i.obj#, i.ts#, i.file#,...
345	0	0.00	0.00	b2gnxm5z6r51n	lock table sys.col_usage$ in e...
341	323	0.95	0.07	04xtrk7uyhknh	select obj#, type#, ctime, mti...
243	243	1.00	0.02	5ngzsfstg8tmy	select o.owner#, o.name, o.nam...
214	423	1.98	0.06	8swypbbr0m372	select order#, columns, types ...
214	460	2.15	0.13	cqgv56fmuj63x	select owner#, name, namespace...
206	206	1.00	0.05	1gu8t96d0bdmu	select t.ts#, t.file#, t.block...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 8,864
Captured SQL accounts for 57.0% of Total Parse Calls

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
366	366	4.13	2ym6hhaq30r73	select type#, blocks, extents,...
362	362	4.08	afx304d90ps3z	select rowcnt, blkcnt, empcn...
345	826	3.89	3c1kubcdjnppq	update sys.col_usage$ set eq...
345	345	3.89	b2gnxm5z6r51n	lock table sys.col_usage$ in e...
214	214	2.41	8swypbbr0m372	select order#, columns, types ...
214	214	2.41	cqgv56fmuj63x	select owner#, name, namespace...
194	194	2.19	350f5yrnnmshs	lock table sys.mon_mods$ in ex...
194	194	2.19	g00cj285jmgsw	update sys.mon_mods$ set inser...
149	453	1.68	83taa7kaw59c1	select name, intcol#, segcol#,...
133	351	1.50	1tjnwqfpzxnng	select i.obj#, i.ts#, i.file#,...
124	450	1.40	6769wyy3yf66f	select pos#, intcol#, col#, sp...
124	124	1.40	8hd36umbhpgsz	select parttype, partcnt, pa...
116	190	1.31	2q93zsrvbdw48	select grantee#, privilege#, n...
116	190	1.31	6aq34nj2zb2n7	select col#, grantee#, privi...
113	3,383	1.27	96g93hntrzjtr	select /+ rule / bucket_cnt,...
110	206	1.24	1gu8t96d0bdmu	select t.ts#, t.file#, t.block...
100	100	1.13	41ytarfvyaxm8	declare vsn va...
95	95	1.07	3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_messa...
94	341	1.06	04xtrk7uyhknh	select obj#, type#, ctime, mti...
91	179	1.03	f8pavn1bvsj7t	select con#, obj#, rcon#, enab...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts wher e t.obj#= :1 and t.obj# = ts.obj# (+)

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

1uk5m5qbzj1vt BEGIN dbms_workload_repository.create_snapshot; END;
2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

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

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), tim estamp = :time where obj# = :objn and intcol# = :coln

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)

41ytarfvyaxm8 declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2)); end if; end;

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

56wtxtwtvx4ks select substr(id, 2, 2) province, max(substr(id, 14, 10)) maxnum from org where length(trim(id))=24 and (timecreated>to_date('2009-05-01', 'yyyy-mm-dd') or timecreated is null) group by substr(id, 2, 2)

584ypkst2k8p7 insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session_event e where e.sid in (select s.sid from v$session s where s.type = 'BACKGROUND') group by e.event_id

5nccq9vqfg5cw select count(*) as ct, dbType from STR where dbType!=8 and id not in (select id from org where resv1 is not null and VRIFY_OLD_CIRCS in('dna2.0', 'dna3.5')) group by dbType order by dbType

5ngzsfstg8tmy select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1

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

6aq34nj2zb2n7 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

7ajk19xfu1g0r select smontabv.cnt, smontabv.mpmax, smontab.scn, smontab.num_mappings, smontab.tim_scn_map from smon_scn_time smontab, (select max(time_mp) mpmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time where thread=0) smontabv where smontab.time_mp = smontabv.mpmax and thread=0

7ptuqb2nxxzrv select object_name nam, Decode(object_type, 'TABLE', 1, 'VIEW', 2, 3) typ from user_objects where object_type in ('TABLE', 'PROCEDURE', 'PACKAGE', 'FUNCTION')

803b7z0t84sq7 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) order by next_date, job
821a53m61hj2u select rtrim(id1) as id1, relation, rtrim(id2) as id2 from relatives order by id1

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

8hd36umbhpgsz select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags from partobj$ where obj# = :1

8hxupdnt3pj2m select count(*) from str where timecreated>to_date('2009-05-01', 'yyyy-mm-dd') and timecreated

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

95rbybk0fzdgd Select * from table(dbms_workload_repository.awr_report_html( 1342668293, 1, 732, 736, 0))

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

afx304d90ps3z select rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, analyzetime, samplesize, avgspc_flb, flbcnt, flags from tab_stats$ where obj#=:1

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

c8khjbn635s3c select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

cfz686a6qp0kg select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#

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

d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;

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

f16rcwh0pg3am select count(*) ct, server, to_char(timecreated, 'yyyymm') || decode(to_char(timecreated, 'dd'), '01', '1', '02', '1', '03', '1', '04', '1', '05', '1', '06', '1', '07', '1', '08', '1', '09', '1', '10', '1', '11', '1', '12', '1', '13', '1', '14', '1', '15', '1', '16', '2', '17', '2', '18', '2', '19', '2', '20', '2', '21', '2', '22', '2', '23', '2', '24', '2', '25', '2', '26', '2', '27', '2', '28', '2', '29', '2', '30', '2', '31', ' 2') months, flag1 from org where serial_type=7 and resv2 is null and timecreated>to_date('2009-05-01', 'yyyy-mm-dd') and timecreated

f8pavn1bvsj7t select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1

fm5np7mv4ws56 select rtrim(id) as id, nation_code, serial_address, server, dbType, rtrim(allele) as allele from STR where dbType!=8 and id not in (select id from org where resv1 is not null and VRIFY_OLD_CIRCS in('dna2.0', 'dna3.5')) order by dbType, id

fp7br2hwxcxfb select rtrim(id) as id from str where (dbType='5' or dbType='7' or dbType='13' or dbType='17' or dbType='27' or dbType='29' )

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

g2wr3u7s1gtf3 select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))

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
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts wher e t.obj#= :1 and t.obj# = ts.obj# (+)
1tjnwqfpzxnng	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256) ), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
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
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), tim estamp = :time where obj# = :objn and intcol# = :coln
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)
41ytarfvyaxm8	declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) \|\| substr(vsn, 4, 2) \|\| substr(vsn, 7, 2)); end if; end;
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
56wtxtwtvx4ks	select substr(id, 2, 2) province, max(substr(id, 14, 10)) maxnum from org where length(trim(id))=24 and (timecreated>to_date('2009-05-01', 'yyyy-mm-dd') or timecreated is null) group by substr(id, 2, 2)
584ypkst2k8p7	insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session_event e where e.sid in (select s.sid from v$session s where s.type = 'BACKGROUND') group by e.event_id
5nccq9vqfg5cw	select count(*) as ct, dbType from STR where dbType!=8 and id not in (select id from org where resv1 is not null and VRIFY_OLD_CIRCS in('dna2.0', 'dna3.5')) group by dbType order by dbType
5ngzsfstg8tmy	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
6769wyy3yf66f	select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
7ajk19xfu1g0r	select smontabv.cnt, smontabv.mpmax, smontab.scn, smontab.num_mappings, smontab.tim_scn_map from smon_scn_time smontab, (select max(time_mp) mpmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time where thread=0) smontabv where smontab.time_mp = smontabv.mpmax and thread=0
7ptuqb2nxxzrv	select object_name nam, Decode(object_type, 'TABLE', 1, 'VIEW', 2, 3) typ from user_objects where object_type in ('TABLE', 'PROCEDURE', 'PACKAGE', 'FUNCTION')
803b7z0t84sq7	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) order by next_date, job
821a53m61hj2u	select rtrim(id1) as id1, relation, rtrim(id2) as id2 from relatives order by id1
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8hd36umbhpgsz	select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags from partobj$ where obj# = :1
8hxupdnt3pj2m	select count(*) from str where timecreated>to_date('2009-05-01', 'yyyy-mm-dd') and timecreated
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
95rbybk0fzdgd	Select * from table(dbms_workload_repository.awr_report_html( 1342668293, 1, 732, 736, 0))
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
afx304d90ps3z	select rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, analyzetime, samplesize, avgspc_flb, flbcnt, flags from tab_stats$ where obj#=:1
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
c8khjbn635s3c	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
cfz686a6qp0kg	select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#
cqgv56fmuj63x	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
f16rcwh0pg3am	select count(*) ct, server, to_char(timecreated, 'yyyymm') \|\| decode(to_char(timecreated, 'dd'), '01', '1', '02', '1', '03', '1', '04', '1', '05', '1', '06', '1', '07', '1', '08', '1', '09', '1', '10', '1', '11', '1', '12', '1', '13', '1', '14', '1', '15', '1', '16', '2', '17', '2', '18', '2', '19', '2', '20', '2', '21', '2', '22', '2', '23', '2', '24', '2', '25', '2', '26', '2', '27', '2', '28', '2', '29', '2', '30', '2', '31', ' 2') months, flag1 from org where serial_type=7 and resv2 is null and timecreated>to_date('2009-05-01', 'yyyy-mm-dd') and timecreated
f8pavn1bvsj7t	select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1
fm5np7mv4ws56	select rtrim(id) as id, nation_code, serial_address, server, dbType, rtrim(allele) as allele from STR where dbType!=8 and id not in (select id from org where resv1 is not null and VRIFY_OLD_CIRCS in('dna2.0', 'dna3.5')) order by dbType, id
fp7br2hwxcxfb	select rtrim(id) as id from str where (dbType='5' or dbType='7' or dbType='13' or dbType='17' or dbType='27' or dbType='29' )
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
g2wr3u7s1gtf3	select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))

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	9,858	0.91	74.68
CPU used when call started	9,856	0.91	74.67
CR blocks created	43	0.00	0.33
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	639,602	59.15	4,845.47
DBWR checkpoint buffers written	655	0.06	4.96
DBWR checkpoints	1	0.00	0.01
DBWR transaction table writes	51	0.00	0.39
DBWR undo block writes	487	0.05	3.69
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	18	0.00	0.14
IMU Redo allocation size	210,768	19.49	1,596.73
IMU commits	111	0.01	0.84
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	532,992	49.29	4,037.82
IMU- failed to get a private strand	0	0.00	0.00
SQL*Net roundtrips to/from client	57,021	5.27	431.98
active txn count during cleanout	155	0.01	1.17
application wait time	1	0.00	0.01
background checkpoints completed	1	0.00	0.01
background checkpoints started	1	0.00	0.01
background timeouts	30,464	2.82	230.79
buffer is not pinned count	708,045	65.48	5,363.98
buffer is pinned count	1,549,899	143.33	11,741.66
bytes received via SQL*Net from client	773,971	71.57	5,863.42
bytes sent via SQL*Net to client	164,449,170	15,207.39	1,245,827.05
calls to get snapshot scn: kcmgss	75,667	7.00	573.23
calls to kcmgas	1,793	0.17	13.58
calls to kcmgcs	242	0.02	1.83
change write time	18	0.00	0.14
cleanout - number of ktugct calls	239	0.02	1.81
cleanouts and rollbacks - consistent read gets	8	0.00	0.06
cleanouts only - consistent read gets	60	0.01	0.45
cluster key scan block gets	53,762	4.97	407.29
cluster key scans	22,979	2.12	174.08
commit cleanout failures: block lost	21	0.00	0.16
commit cleanout failures: callback failure	0	0.00	0.00
commit cleanouts	2,070	0.19	15.68
commit cleanouts successfully completed	2,049	0.19	15.52
commit txn count during cleanout	147	0.01	1.11
concurrency wait time	816	0.08	6.18
consistent changes	37,168	3.44	281.58
consistent gets	4,008,073	370.65	30,364.19
consistent gets - examination	100,324	9.28	760.03
consistent gets direct	182	0.02	1.38
consistent gets from cache	4,007,891	370.63	30,362.81
cursor authentications	457	0.04	3.46
data blocks consistent reads - undo records applied	43	0.00	0.33
db block changes	90,726	8.39	687.32
db block gets	152,421	14.10	1,154.70
db block gets direct	16	0.00	0.12
db block gets from cache	152,405	14.09	1,154.58
deferred (CURRENT) block cleanout applications	1,241	0.11	9.40
dirty buffers inspected	1,851	0.17	14.02
enqueue conversions	2,153	0.20	16.31
enqueue releases	90,524	8.37	685.79
enqueue requests	90,525	8.37	685.80
execute count	20,593	1.90	156.01
free buffer inspected	2,052,990	189.85	15,552.95
free buffer requested	2,022,108	186.99	15,319.00
heap block compress	51	0.00	0.39
hot buffers moved to head of LRU	73,582	6.80	557.44
immediate (CR) block cleanout applications	68	0.01	0.52
immediate (CURRENT) block cleanout applications	180	0.02	1.36
index fast full scans (full)	43	0.00	0.33
index fetch by key	70,809	6.55	536.43
index scans kdiixs1	19,685	1.82	149.13
leaf node 90-10 splits	33	0.00	0.25
leaf node splits	55	0.01	0.42
logons cumulative	23	0.00	0.17
messages received	2,568	0.24	19.45
messages sent	2,568	0.24	19.45
no buffer to keep pinned count	6,277	0.58	47.55
no work - consistent read gets	3,879,673	358.77	29,391.46
number of auto extends on undo tablespace	0	0.00	0.00
opened cursors cumulative	8,350	0.77	63.26
parse count (failures)	11	0.00	0.08
parse count (hard)	1,202	0.11	9.11
parse count (total)	8,864	0.82	67.15
parse time cpu	354	0.03	2.68
parse time elapsed	9,993	0.92	75.70
physical read IO requests	481,128	44.49	3,644.91
physical reads	2,063,458	190.82	15,632.26
physical reads cache	2,012,349	186.09	15,245.07
physical reads cache prefetch	1,861,725	172.16	14,103.98
physical reads direct	51,109	4.73	387.19
physical reads direct (lob)	176	0.02	1.33
physical reads direct temporary tablespace	50,917	4.71	385.73
physical write IO requests	9,795	0.91	74.20
physical writes	53,815	4.98	407.69
physical writes direct	50,949	4.71	385.98
physical writes direct (lob)	6	0.00	0.05
physical writes direct temporary tablespace	50,917	4.71	385.73
physical writes from cache	2,866	0.27	21.71
physical writes non checkpoint	53,117	4.91	402.40
pinned buffers inspected	7,537	0.70	57.10
prefetch clients - default	1	0.00	0.01
prefetched blocks aged out before use	87	0.01	0.66
process last non-idle time	8,258,769,308	763,727.39	62,566,434.15
recursive calls	226,155	20.91	1,713.30
recursive cpu usage	1,000	0.09	7.58
redo blocks written	18,677	1.73	141.49
redo buffer allocation retries	3	0.00	0.02
redo entries	27,582	2.55	208.95
redo log space requests	2	0.00	0.02
redo log space wait time	10	0.00	0.08
redo ordering marks	371	0.03	2.81
redo size	8,859,516	819.28	67,117.55
redo synch time	56	0.01	0.42
redo synch writes	75	0.01	0.57
redo wastage	313,092	28.95	2,371.91
redo write time	2,940	0.27	22.27
redo writer latching time	0	0.00	0.00
redo writes	1,026	0.09	7.77
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	35	0.00	0.27
rows fetched via callback	36,139	3.34	273.78
session connect time	8,258,769,308	763,727.39	62,566,434.15
session logical reads	4,160,494	384.74	31,518.89
session pga memory	983,932	90.99	7,454.03
session pga memory max	3,670,908	339.47	27,809.91
session uga memory	3,500,520	323.71	26,519.09
session uga memory max	21,241,332	1,964.29	160,919.18
shared hash latch upgrades - no wait	16,897	1.56	128.01
sorts (disk)	6	0.00	0.05
sorts (memory)	6,206	0.57	47.02
sorts (rows)	3,420,054	316.27	25,909.50
summed dirty queue length	11,343	1.05	85.93
switch current to new buffer	31	0.00	0.23
table fetch by rowid	1,014,365	93.80	7,684.58
table fetch continued row	218	0.02	1.65
table scan blocks gotten	3,228,370	298.54	24,457.35
table scan rows gotten	7,459,823	689.85	56,513.81
table scans (long tables)	23	0.00	0.17
table scans (short tables)	2,595	0.24	19.66
transaction rollbacks	0	0.00	0.00
undo change vector size	2,571,892	237.83	19,484.03
user I/O wait time	673,586	62.29	5,102.92
user calls	57,213	5.29	433.43
user commits	129	0.01	0.98
user rollbacks	3	0.00	0.02
workarea executions - multipass	4	0.00	0.03
workarea executions - onepass	17	0.00	0.13
workarea executions - optimal	2,771	0.26	20.99
write clones created in background	304	0.03	2.30
write clones created in foreground	6	0.00	0.05

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)
Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Begin Value	End Value
logons current	13	18
open threads (derived)	1	1
opened cursors current	60	118
workarea memory allocated	0	72

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic	Total	per Hour
log switches (derived)	1	0.33

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
CBIDB	455,890	42	107.33	4.37	3	0	194,620	1.41
TEMP	11,122	1	21.48	4.60	8,379	1	41	124.39
SYSTEM	6,330	1	103.94	1.78	85	0	65	4.62
SYSAUX	3,604	0	95.93	1.10	1,030	0	0	0.00
UNDOTBS1	191	0	150.94	1.00	237	0	0	0.00
BACKGROUND_INFO	1	0	90.00	1.00	1	0	0	0.00
CBIDBTMP	1	0	280.00	1.00	1	0	0	0.00
EXAMNATION_INFO	1	0	110.00	1.00	1	0	0	0.00
SYSTEM_INFO	1	0	90.00	1.00	1	0	0	0.00
USERS	1	0	50.00	1.00	1	0	0	0.00
TRANSFER_INFO	1	0	90.00	1.00	1	0	0	0.00
TJALIMS	1	0	140.00	1.00	1	0	0	0.00
FJFID	1	0	110.00	1.00	1	0	0	0.00
GENE_INFO	1	0	90.00	1.00	1	0	0	0.00
LAB_INFO	1	0	50.00	1.00	1	0	0	0.00
LOG_INFO	1	0	50.00	1.00	1	0	0	0.00
PHOTO_INFO	1	0	50.00	1.00	1	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
BACKGROUND_INFO	D:\ORADATA\ORCL\DNA\BACKGROUND_INFO.DBF	1	0	90.00	1.00	1	0	0	0.00
CBIDB	C:\WINDOWS\SYSTEM32\CBI_DATA.ORA	455,890	42	107.33	4.37	3	0	194,620	1.41
CBIDBTMP	C:\WINDOWS\SYSTEM32\CBI_TMP.ORA	1	0	280.00	1.00	1	0	0	0.00
EXAMNATION_INFO	D:\ORADATA\ORCL\DNA\EXAMNATION_INFO.DBF	1	0	110.00	1.00	1	0	0	0.00
FJFID	D:\ORADATA\ORCL\FJFID.DBF	1	0	110.00	1.00	1	0	0	0.00
GENE_INFO	D:\ORADATA\ORCL\DNA\GENE_INFO.DBF	1	0	90.00	1.00	1	0	0	0.00
LAB_INFO	D:\ORADATA\ORCL\DNA\LAB_INFO.DBF	1	0	50.00	1.00	1	0	0	0.00
LOG_INFO	D:\ORADATA\ORCL\DNA\LOG_INFO.DBF	1	0	50.00	1.00	1	0	0	0.00
PHOTO_INFO	D:\ORADATA\ORCL\DNA\PHOTO_INFO.DBF	1	0	50.00	1.00	1	0	0	0.00
SYSAUX	D:\ORADATA\ORCL\SYSAUX01.DBF	3,604	0	95.93	1.10	1,030	0	0	0.00
SYSTEM	D:\ORADATA\ORCL\SYSTEM01.DBF	6,330	1	103.94	1.78	85	0	65	4.62
SYSTEM_INFO	D:\ORADATA\ORCL\DNA\SYSTEM_INFO.DBF	1	0	90.00	1.00	1	0	0	0.00
TEMP	D:\ORADATA\ORCL\TEMP01.DBF	11,122	1	21.48	4.60	8,379	1	41	124.39
TJALIMS	C:\WINDOWS\SYSTEM32\TJALIMS.DBF	1	0	140.00	1.00	1	0	0	0.00
TRANSFER_INFO	D:\ORADATA\ORCL\DNA\TRANSFER_INFO.DBF	1	0	90.00	1.00	1	0	0	0.00
UNDOTBS1	D:\ORADATA\ORCL\UNDOTBS01.DBF	191	0	150.94	1.00	237	0	0	0.00
USERS	D:\ORADATA\ORCL\USERS01.DBF	1	0	50.00	1.00	1	0	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	3,006	52	4,152,939	2,011,197	2,845	0	0	194,726

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
Java Pool Advisory

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	23	164	1,577	676	18,432	676
E	0	24	42	1,439	2,287	18,432	2,287

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 Estimate (M)	Size Factr	Buffers for Estimate	Est Physical Read Factor	Estimated Physical Reads
D	4	0.17	501	1.05	11,736,180
D	8	0.33	1,002	1.03	11,557,130
D	12	0.50	1,503	1.02	11,425,323
D	16	0.67	2,004	1.01	11,330,614
D	20	0.83	2,505	1.01	11,257,331
D	24	1.00	3,006	1.00	11,195,329
D	28	1.17	3,507	0.99	11,137,814
D	32	1.33	4,008	0.99	11,082,896
D	36	1.50	4,509	0.99	11,030,526
D	40	1.67	5,010	0.98	10,992,914
D	44	1.83	5,511	0.98	10,956,569
D	48	2.00	6,012	0.98	10,926,939

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
28.53	549	1,375

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	24	10	30.71	0.00	0.00	0.00	0.00	1,228
E	24	10	29.35	0.06	0.21	100.00	0.00	1,228

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs	M-Pass Execs
2K	4K	2,640	2,640	0	0
64K	128K	8	4	4	0
128K	256K	10	10	0	0
512K	1024K	127	127	0	0
1M	2M	4	0	4	0
2M	4M	5	0	5	0
16M	32M	4	0	4	0
64M	128M	4	0	0	4

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
12	0.50	1,825.66	4,185.79	30.00	93
18	0.75	1,825.66	3,998.92	31.00	4
24	1.00	1,825.66	2,643.01	41.00	1
29	1.20	1,825.66	2,642.31	41.00	1
34	1.40	1,825.66	2,630.67	41.00	0
38	1.60	1,825.66	2,618.62	41.00	0
43	1.80	1,825.66	2,618.62	41.00	0
48	2.00	1,825.66	2,618.62	41.00	0
72	3.00	1,825.66	947.25	66.00	0
96	4.00	1,825.66	947.25	66.00	0
144	6.00	1,825.66	947.25	66.00	0
192	8.00	1,825.66	947.25	66.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
64	0.80	6	1,025	335	0.88	248	1.23	22,780
72	0.90	13	2,349	377	0.99	206	1.02	24,235
80	1.00	20	3,672	382	1.00	201	1.00	24,656
88	1.10	27	4,798	382	1.00	201	1.00	24,671
96	1.20	27	5,007	382	1.00	201	1.00	24,671
104	1.30	27	5,007	382	1.00	201	1.00	24,671
112	1.40	27	5,007	382	1.00	201	1.00	24,671
120	1.50	27	5,007	382	1.00	201	1.00	24,671
128	1.60	27	5,007	382	1.00	201	1.00	24,671
136	1.70	27	5,007	382	1.00	201	1.00	24,671
144	1.80	27	5,007	382	1.00	201	1.00	24,671
152	1.90	27	5,007	382	1.00	201	1.00	24,671
160	2.00	27	5,007	382	1.00	201	1.00	24,671

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	194,677	274	1
file header block	41	5	124
segment header	8	0	18

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Undo Blocks	Num Trans	Max Qry Len (s)	Max Tx Concurcy	Snap TooOld	OutOf Space	uS/uR/uU/ eS/eR/eU
1	372	1,054	1,691	3	0	0	0/0/0/1/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

ordered by Time desc

End Time	Undo Blocks	Num Trans	Max Qry Len (s)	Max Tx Concy	uS/uR/uU/ eS/eR/eU
14-8月 14:52	5	108	1,691	1	0/0/0/0/0/0
14-8月 14:42	0	0	1,088	0	0/0/0/0/0/0
14-8月 14:32	72	119	479	2	0/0/0/0/0/0
14-8月 14:22	1	136	477	1	0/0/0/0/0/0
14-8月 14:12	67	106	163	3	0/0/0/0/0/0
14-8月 14:02	72	46	0	3	0/0/0/0/0/0
14-8月 13:52	0	5	0	0	0/0/0/0/0/0
14-8月 13:42	0	0	0	0	0/0/0/0/0/0
14-8月 13:32	1	3	0	1	0/0/0/0/0/0
14-8月 13:22	0	0	0	0	0/0/0/0/0/0
14-8月 13:12	3	158	0	1	0/0/0/0/0/0
14-8月 13:02	67	39	0	3	0/0/0/0/0/0
14-8月 12:52	0	0	0	0	0/0/0/0/0/0
14-8月 12:42	0	8	0	0	0/0/0/0/0/0
14-8月 12:32	1	5	0	1	0/0/0/0/0/0
14-8月 12:22	0	0	0	0	0/0/0/0/0/0
14-8月 12:12	6	224	0	1	0/0/0/0/0/0
14-8月 12:02	77	97	0	3	0/0/0/1/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 network background latch	3	0.00		0	0
Consistent RBA	1,027	0.00		0	0
FIB s.o chain latch	174	0.00		0	0
FOB s.o list latch	419	0.00		0	0
In memory undo latch	1,804	0.00		0	453	0.00
JS queue state obj latch	76,644	0.00		0	0
KTF sga enqueue	0			0	3,521	0.00
KWQMN job cache list latch	47	0.00		0	0
MQL Tracking Latch	0			0	215	0.00
Memory Management Latch	53,025	0.00		0	3,550	0.00
PL/SQL warning settings	60	0.00		0	0
SQL memory manager latch	5	0.00		0	3,522	0.00
SQL memory manager workarea list latch	236,806	0.00		0	0
SWRF Alerted Metric Element list	36,367	0.00		0	0
active checkpoint queue latch	5,174	0.00		0	0
active service list	17,834	0.00		0	0
archive control	29	0.00		0	0
begin backup scn array	8	0.00		0	0
cache buffer handles	58	0.00		0	0
cache buffers chains	10,612,442	0.13	0.02	1	4,052,134	0.00
cache buffers lru chain	2,037,938	3.85	0.00	0	2,891,350	16.81
channel handle pool latch	40	0.00		0	0
channel operations parent latch	35,499	0.00		0	0
checkpoint queue latch	77,062	0.00		0	1,515	0.00
child cursor hash table	13,517	0.00		0	0
client/application info	14	0.00		0	0
commit callback allocation	20	0.00		0	0
compile environment latch	454	0.00		0	0
cursor bind value capture	577	0.00		0	325	0.00
dml lock allocation	2,910	0.00		0	0
dummy allocation	40	0.00		0	0
enqueue hash chains	183,410	0.00	0.00	0	0
enqueues	176,716	0.00	0.00	0	0
event group latch	23	0.00		0	0
file cache latch	510	0.00		0	0
global KZLD latch for mem in SGA	7	0.00		0	0
hash table column usage latch	838	0.00		0	49,055	0.00
hash table modification latch	181	0.00		0	0
job_queue_processes parameter latch	177	0.00		0	0
kmcptab latch	1	0.00		0	0
kmcpvec latch	0			0	1	0.00
ksuosstats global area	738	0.00		0	0
ktm global data	35	0.00		0	0
lgwr LWN SCN	4,330	0.00		0	0
library cache	183,857	0.01	0.00	0	4,476	0.00
library cache load lock	4,104	0.00		0	0
library cache lock	55,116	0.00		0	0
library cache lock allocation	935	0.00		0	0
library cache pin	99,712	0.00	0.00	0	0
library cache pin allocation	1,224	0.00		0	0
list of block allocation	65	0.00		0	0
loader state object freelist	414	0.00		0	0
longop free list parent	154	0.00		0	17	0.00
messages	67,665	0.01	0.00	0	0
mostly latch-free SCN	4,334	0.09	0.00	0	0
multiblock read objects	251,654	0.00		0	0
ncodef allocation latch	176	0.00		0	0
object queue header heap	2,795	0.00		0	0
object queue header operation	4,104,605	0.00	0.00	0	0
object stats modification	304	0.00		0	0
parallel query alloc buffer	1,408	0.00		0	0
parameter list	48	0.00		0	0
parameter table allocation management	40	0.00		0	0
post/wait queue	162	0.00		0	78	0.00
process allocation	23	0.00		0	23	0.00
process group creation	40	0.00		0	0
redo allocation	10,774	0.02	0.00	0	27,586	0.01
redo copy	0			0	27,594	0.02
redo writing	15,659	0.00		0	0
row cache objects	252,526	0.00		0	2,057	0.00
sequence cache	587	0.00		0	0
session allocation	344,689	0.00		0	0
session idle bit	114,845	0.01	1.33	0	0
session switching	176	0.00		0	0
session timer	3,685	0.00		0	0
shared pool	224,870	0.01	0.00	0	0
simulator hash latch	612,589	0.28	0.01	0	0
simulator lru latch	127,234	0.00		0	1,640	4.57
slave class	6	0.00		0	0
slave class create	24	12.50	16.33	0	0
sort extent pool	968	0.00		0	0
state object free list	10	0.00		0	0
statistics aggregation	700	0.00		0	0
temp lob duration state obj allocation	5	0.00		0	0
threshold alerts latch	835	0.00		0	0
transaction allocation	51	0.00		0	0
transaction branch allocation	176	0.00		0	0
undo global data	5,514	0.00		0	0
user lock	24	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	Sleep1	Sleep2	Sleep3
cache buffers lru chain	2,037,938	78,481	13	78,473	6	0	2
cache buffers chains	10,612,442	13,891	291	13,705	81	105	0
simulator hash latch	612,589	1,702	9	1,700	0	0	2
session idle bit	114,845	9	12	3	0	6	0
slave class create	24	3	49	0	0	0	3

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
cache buffers chains	kcbgtcr: kslbegin excl	147	264
cache buffers chains	kcbrls: kslbegin	122	12
cache buffers chains	kcbzib: finish free bufs	19	16
cache buffers chains	kcbzwb	2	14
cache buffers chains	kcbgtcr: fast path	1	1
cache buffers lru chain	kcbzgws_1	6	13
cache buffers lru chain	kcbzar: KSLNBEGIN	5	0
cache buffers lru chain	kcbzgm	2	0
session idle bit	ksupuc: set busy	10	4
session idle bit	ksupuc: clear busy	2	8
simulator hash latch	kcbsacc: lookup dba	5	0
simulator hash latch	kcbsacc: insert dba	4	0
slave class create	ksvcreate	49	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 Buffer Busy Waits
Segments by Row Lock Waits
Segments by ITL Waits

Segments by Logical Reads

% Total shows % of logical reads for each top segment compared with total logical reads for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
CBI	CBIDB	ORG	TABLE	3,666,192	91.12
CBI	CBIDB	STR	TABLE	66,832	1.66
SYS	SYSTEM	USER$	TABLE	35,472	0.88
SYS	SYSTEM	I_OBJ1	INDEX	32,512	0.81
SYS	SYSTEM	OBJ$	TABLE	15,328	0.38

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
CBI	CBIDB	ORG	TABLE	1,930,723	96.24
CBI	CBIDB	STR	TABLE	44,370	2.21
CBI	CBIDB	ORG_OTHER	INDEX	6,923	0.35
CBI	CBIDB	PK_ORG	INDEX	5,212	0.26
SYS	SYSTEM	OBJ$	TABLE	2,963	0.15

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

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

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	202	0.00	10	1
dc_global_oids	6,865	0.32	0	17
dc_histogram_data	8,617	9.28	0	560
dc_histogram_defs	14,914	22.66	0	1,351
dc_object_ids	20,126	1.11	0	359
dc_objects	5,962	5.89	0	361
dc_profiles	6	0.00	0	1
dc_rollback_segments	1,194	0.00	0	22
dc_segments	5,670	6.67	12	227
dc_sequences	16	12.50	16	1
dc_tablespaces	10,543	0.00	0	17
dc_usernames	496	0.60	0	2
dc_users	13,199	0.01	0	32
outstanding_alerts	339	2.36	10	17

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	66	16.67	440	3.86	4
CLUSTER	62	4.84	119	3.36	1
INDEX	127	45.67	306	18.95	0
SQL AREA	9,127	6.34	38,159	5.38	531
TABLE/PROCEDURE	2,021	15.64	11,699	16.74	799

SGA Statistics

SGA Memory Summary
SGA breakdown difference

SGA Memory Summary

SGA regions	Size in Bytes
Database Buffers	25,165,824
Fixed Size	787,988
Redo Buffers	524,288
Variable Size	145,488,364

Back to SGA Statistics
Back to Top

SGA breakdown difference

Pool	Name	Begin value	End value	% Diff
java	free memory	50,331,648	50,331,648	0.00
large	free memory	8,388,608	8,388,608	0.00
shared	ASH buffers	4,194,304	4,194,304	0.00
shared	FileOpenBlock	2,848,180	2,848,180	0.00
shared	KGLS heap	1,141,248	1,192,892	4.53
shared	KQR L SO	452,612	305,152	-32.58
shared	KQR M PO	1,201,784	1,168,800	-2.74
shared	KQR M SO	327,280	333,424	1.88
shared	KQR S PO	87,892	86,612	-1.46
shared	KQR S SO	3,844	3,844	0.00
shared	KSXR pending messages que	841,036	841,036	0.00
shared	KSXR receive buffers	1,033,000	1,033,000	0.00
shared	PL/SQL DIANA	1,046,664	545,256	-47.91
shared	PL/SQL MPCODE	775,764	1,292,032	66.55
shared	PLS non-lib hp	30,248	30,248	0.00
shared	VIRTUAL CIRCUITS	1,086,680	1,086,680	0.00
shared	alert threshol	728	728	0.00
shared	event statistics per sess	17,151,680	17,151,680	0.00
shared	fixed allocation callback	308	308	0.00
shared	free memory	6,893,900	5,133,172	-25.54
shared	joxs heap	4,220	4,220	0.00
shared	kmgsb circular statistics	823,296	823,296	0.00
shared	library cache	5,058,312	4,895,436	-3.22
shared	miscellaneous	26,741,788	26,876,204	0.50
shared	parameters	5,724	5,092	-11.04
shared	partitioning d	64,760	85,024	31.29
shared	pl/sql source	104	92	-11.54
shared	repository	41,416	49,708	20.02
shared	row cache	3,707,272	3,707,272	0.00
shared	sessions	3,056,344	3,056,344	0.00
shared	sql area	4,149,208	6,189,196	49.17
shared	table definiti	280	352	25.71
shared	transaction	929,984	929,984	0.00
shared	trigger inform	1,892	1,860	-1.69
shared	type object de	184,328	14,652	-92.05
	buffer_cache	25,165,824	25,165,824	0.00
	fixed_sga	787,988	787,988	0.00
	log_buffer	524,288	524,288	0.00

Back to SGA 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)
background_dump_dest	D:\ADMIN\ORCL\BDUMP
compatible	10.1.0.2.0
control_files	D:\ORADATA\ORCL\CONTROL01.CTL, D:
core_dump_dest	D:\ADMIN\ORCL\CDUMP
db_block_size	8192
db_cache_size	25165824
db_domain
db_file_multiblock_read_count	16
db_name	ORCL
db_recovery_file_dest	D:\flash_recovery_area
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=ORCLXDB)
java_pool_size	50331648
job_queue_processes	10
large_pool_size	8388608
open_cursors	300
pga_aggregate_target	25165824
processes	600
remote_login_passwordfile	EXCLUSIVE
shared_pool_size	83886080
sort_area_size	65536
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	D:\ADMIN\ORCL\UDUMP

End of Report

Buffer Cache:	24M	Std Block Size:	8K
Shared Pool Size:	80M	Log Buffer:	512K

% Blocks changed per Read:	2.18	Recursive Call %:	79.81
Rollback per transaction %:	2.27	Rows per Sort:	550.56

Buffer Nowait %:	95.32	Redo NoWait %:	99.99
Buffer Hit %:	51.64	In-memory Sort %:	99.90
Library Hit %:	91.94	Soft Parse %:	86.44
Execute to Parse %:	56.96	Latch Hit %:	99.53
Parse CPU to Parse Elapsd %:	3.54	% Non-Parse CPU:	96.41