fj-zyite-db01$ cat awrrpt_1_42807_42808.html AWR Report

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

DBNMS 623989050 dbnms 1 10.2.0.1.0 NO fj-zyite-db01

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
DBNMS	623989050	dbnms	1	10.2.0.1.0	NO	fj-zyite-db01

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 42807 19-4月 -12 08:00:13 468 1.6

End Snap: 42808 19-4月 -12 09:00:30 427 1.7

Elapsed: 60.28 (mins)

DB Time: 19,391.05 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	42807	19-4月 -12 08:00:13	468	1.6
End Snap:	42808	19-4月 -12 09:00:30	427	1.7
Elapsed:		60.28 (mins)
DB Time:		19,391.05 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 2,048M 2,048M Std Block Size: 8K

Shared Pool Size: 2,048M 2,048M Log Buffer: 4,224K

	Begin	End
Buffer Cache:	2,048M	2,048M	Std Block Size:	8K
Shared Pool Size:	2,048M	2,048M	Log Buffer:	4,224K

Load Profile

Per Second Per Transaction

Redo size: 527,935.49 12,142.70

Logical reads: 1,409,326.02 32,414.98

Block changes: 3,458.25 79.54

Physical reads: 3,063.13 70.45

Physical writes: 335.00 7.71

User calls: 1,789.84 41.17

Parses: 482.24 11.09

Hard parses: 53.50 1.23

Sorts: 1,219.55 28.05

Logons: 1.33 0.03

Executes: 1,000.52 23.01

Transactions: 43.48

	Per Second	Per Transaction
Redo size:	527,935.49	12,142.70
Logical reads:	1,409,326.02	32,414.98
Block changes:	3,458.25	79.54
Physical reads:	3,063.13	70.45
Physical writes:	335.00	7.71
User calls:	1,789.84	41.17
Parses:	482.24	11.09
Hard parses:	53.50	1.23
Sorts:	1,219.55	28.05
Logons:	1.33	0.03
Executes:	1,000.52	23.01
Transactions:	43.48

% Blocks changed per Read: 0.25 Recursive Call %: 28.69

Rollback per transaction %: 1.47 Rows per Sort: 4.14

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.87 Redo NoWait %: 100.00

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

Library Hit %: 95.20 Soft Parse %: 88.91

Execute to Parse %: 51.80 Latch Hit %: 95.69

Parse CPU to Parse Elapsd %: 10.11 % Non-Parse CPU: 95.16

Shared Pool Statistics

Begin End

Memory Usage %: 90.92 89.97

% SQL with executions>1: 60.70 61.59

% Memory for SQL w/exec>1: 65.96 65.60

	Begin	End
Memory Usage %:	90.92	89.97
% SQL with executions>1:	60.70	61.59
% Memory for SQL w/exec>1:	65.96	65.60

Top 5 Timed Events

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

buffer busy waits 6,793,343 607,524 89 52.2 Concurrency

latch: undo global data 4,104,131 253,198 62 21.8 Other

latch: cache buffers chains 1,334,748 89,938 67 7.7 Concurrency

CPU time 49,567 4.3

latch free 480,262 26,992 56 2.3 Other

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
buffer busy waits	6,793,343	607,524	89	52.2	Concurrency
latch: undo global data	4,104,131	253,198	62	21.8	Other
latch: cache buffers chains	1,334,748	89,938	67	7.7	Concurrency
CPU time		49,567		4.3
latch free	480,262	26,992	56	2.3	Other

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): 1163463.1s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	1,134,968.38	97.55
DB CPU	49,567.29	4.26
parse time elapsed	23,351.38	2.01
hard parse elapsed time	10,749.39	0.92
PL/SQL execution elapsed time	2,837.25	0.24
connection management call elapsed time	611.22	0.05
hard parse (sharing criteria) elapsed time	59.32	0.01
hard parse (bind mismatch) elapsed time	52.45	0.00
sequence load elapsed time	46.87	0.00
PL/SQL compilation elapsed time	18.42	0.00
repeated bind elapsed time	11.32	0.00
failed parse elapsed time	1.75	0.00
DB time	1,163,463.08
background elapsed time	3,065.42
background cpu time	457.02

Back to Wait Events Statistics
Back to Top

Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
Concurrency	8,894,033	0.26	721,183	81	56.56
Other	4,596,416	0.00	280,386	61	29.23
User I/O	3,018,498	0.00	19,814	7	19.19
Application	55,422	4.15	9,260	167	0.35
Configuration	1,389	86.61	3,540	2548	0.01
System I/O	495,278	0.00	2,557	5	3.15
Commit	162,250	0.05	1,318	8	1.03
Network	7,248,621	0.00	461	0	46.09

Back to Wait Events Statistics
Back to Top

Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
buffer busy waits	6,793,343	0.34	607,524	89	43.20
latch: undo global data	4,104,131	0.00	253,198	62	26.10
latch: cache buffers chains	1,334,748	0.00	89,938	67	8.49
latch free	480,262	0.00	26,992	56	3.05
latch: library cache	500,969	0.00	20,243	40	3.19
db file sequential read	1,746,158	0.00	11,971	7	11.10
enq: TX - row lock contention	11,555	19.84	8,750	757	0.07
db file scattered read	726,026	0.00	4,671	6	4.62
enq: TX - allocate ITL entry	1,203	99.83	3,532	2936	0.01
latch: shared pool	149,468	0.00	3,183	21	0.95
db file parallel write	317,514	0.00	2,147	7	2.02
read by other session	86,428	0.01	1,639	19	0.55
direct path read	458,906	0.00	1,507	3	2.92
log file sync	162,250	0.05	1,318	8	1.03
enq: UL - contention	1,147	0.61	434	378	0.01
log file parallel write	162,492	0.00	401	2	1.03
SQL*Net more data to client	2,116,883	0.00	390	0	13.46
wait list latch free	9,417	0.00	191	20	0.06
library cache pin	6,956	0.01	173	25	0.04
SQL*Net break/reset to client	42,679	0.00	65	2	0.27
SQL*Net more data from client	123,260	0.00	59	0	0.78
library cache lock	31	38.71	43	1399	0.00
latch: row cache objects	686	0.00	26	38	0.00
os thread startup	89	7.87	23	253	0.00
local write wait	142	12.68	21	146	0.00
latch: library cache pin	591	0.00	13	22	0.00
SQL*Net message to client	5,008,478	0.00	12	0	31.85
enq: RO - fast object reuse	37	5.41	11	284	0.00
latch: library cache lock	229	0.00	9	40	0.00
control file parallel write	3,703	0.00	6	2	0.02
log file switch completion	80	0.00	5	60	0.00
cursor: mutex S	30,063	0.00	3	0	0.19
library cache load lock	10	0.00	3	315	0.00
enq: SQ - contention	89	0.00	2	28	0.00
direct path write	624	0.00	2	4	0.00
db file parallel read	214	0.00	2	9	0.00
latch: enqueue hash chains	37	0.00	2	50	0.00
latch: In memory undo latch	30	0.00	2	54	0.00
control file sequential read	11,557	0.00	1	0	0.07
enq: JS - queue lock	1	0.00	1	1052	0.00
rdbms ipc reply	539	0.00	1	2	0.00
kksfbc child completion	9	100.00	0	53	0.00
cursor: mutex X	76,816	0.00	0	0	0.49
latch: session allocation	50	0.00	0	7	0.00
enq: HW - contention	6	0.00	0	35	0.00
LGWR wait for redo copy	1,811	0.11	0	0	0.01
latch: messages	17	0.00	0	9	0.00
log buffer space	6	0.00	0	23	0.00
enq: KO - fast object checkpoint	4	0.00	0	29	0.00
reliable message	41	0.00	0	2	0.00
log file sequential read	6	0.00	0	9	0.00
latch: cache buffers lru chain	71	0.00	0	1	0.00
latch: redo allocation	16	0.00	0	2	0.00
log file single write	6	0.00	0	4	0.00
latch: object queue header operation	10	0.00	0	1	0.00
latch: cache buffer handles	1	0.00	0	3	0.00
latch: redo writing	3	0.00	0	0	0.00
enq: FB - contention	1	0.00	0	1	0.00
row cache lock	4	0.00	0	0	0.00
latch: checkpoint queue latch	2	0.00	0	0	0.00
undo segment extension	2	100.00	0	0	0.00
SQL*Net message from client	5,008,474	0.00	270,372	54	31.85
pipe get	63,510	2.29	11,563	182	0.40
jobq slave wait	3,330	97.45	9,647	2897	0.02
Streams AQ: qmn coordinator idle wait	257	50.19	3,529	13730	0.00
Streams AQ: qmn slave idle wait	129	0.00	3,528	27353	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100.00	2,323	2323307	0.00
class slave wait	16	100.00	78	4887	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file parallel write	317,620	0.00	2,149	7	2.02
log file parallel write	162,604	0.00	402	2	1.03
events in waitclass Other	3,231	0.06	39	12	0.02
latch: cache buffers chains	1,096	0.00	23	21	0.01
os thread startup	89	7.87	23	253	0.00
latch: library cache	362	0.00	22	61	0.00
db file sequential read	3,767	0.00	7	2	0.02
control file parallel write	3,703	0.00	6	2	0.02
db file scattered read	220	0.00	3	14	0.00
direct path write	310	0.00	2	8	0.00
latch: shared pool	76	0.00	1	7	0.00
control file sequential read	3,944	0.00	0	0	0.03
direct path read	760	0.00	0	1	0.00
log file sequential read	6	0.00	0	9	0.00
read by other session	1	0.00	0	30	0.00
log file single write	6	0.00	0	4	0.00
buffer busy waits	8	0.00	0	1	0.00
latch: redo writing	3	0.00	0	0	0.00
latch: row cache objects	1	0.00	0	0	0.00
rdbms ipc message	185,078	11.64	60,759	328	1.18
Streams AQ: qmn coordinator idle wait	257	50.19	3,529	13730	0.00
Streams AQ: qmn slave idle wait	129	0.00	3,528	27353	0.00
pmon timer	1,980	98.94	3,484	1760	0.01
smon timer	87	0.00	3,407	39158	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100.00	2,323	2323307	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	362,262
AVG_IDLE_TIME	0
AVG_IOWAIT_TIME	0
AVG_SYS_TIME	40,083
AVG_USER_TIME	322,062
BUSY_TIME	5,798,028
IDLE_TIME	56
IOWAIT_TIME	0
SYS_TIME	643,221
USER_TIME	5,154,807
LOAD	60
OS_CPU_WAIT_TIME	17,776,700
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	9,723,904
VM_OUT_BYTES	0
PHYSICAL_MEMORY_BYTES	34,035,613,696
NUM_CPUS	16

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
dbnms	1,149,458.40	47,481.40	10,601,678	4,983,165,554
SYS$USERS	13,506.70	1,998.40	460,024	112,061,052
SYS$BACKGROUND	0.00	0.00	13,929	882,538

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
dbnms	2833095	1840824	8764155	71741770	6597233	44725
SYS$USERS	174676	134839	130250	385732	632425	639
SYS$BACKGROUND	11654	6141	2266	9253	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
650,606	25,291	40,174	16.19	55.92	6cuc59szy3tp8	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO VlanPort(DeviceID,...
412,364	13,409	34,726	11.87	35.44	bmbmrmyj9mvg6	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO Vlan(DeviceID, Vla...
6,949	1,222	32	217.16	0.60	b0jrypq3ts9cm	perl@Fj-fz-dcn-1 (TNS V1-V3)	select f.circuitid, f.inavgve...
3,539	0	0		0.30	bzzkyg10gvr3j	perl@fj-zyite-app01 (TNS V1-V3)	UPDATE FluxD SET inbusiavgvec=...
3,538	0	0		0.30	crbmyn3mfbsw9	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	UPDATE Device SET OSVersion='H...
3,052	345	629,618	0.00	0.26	6caatdwzncw9v	perl@nmscol2.qz.fjtelecom (TNS V1-V3)	INSERT INTO Flux(CIRCUITID, FL...
2,849	190	7,080	0.40	0.24	gysf9tyakgtxb	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO PPInfo(DeviceID, P...
2,446	59	0		0.21	3uubc39zu7pyk	perl@fj-zyite-app01 (TNS V1-V3)	select count(*) from (select d...
2,417	1	7,116	0.34	0.21	ch5su7mucx14t	perl@nmscol2.fz.fjtelecom (TNS V1-V3)	UPDATE RES SET IPADDRESSB = NU...
2,178	95	8,119	0.27	0.19	21dgc3grmymt8	perl@nmscol1 (TNS V1-V3)	INSERT INTO ALARMSUMMARY (SUMA...

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
25,291	650,606	40,174	0.63	55.92	6cuc59szy3tp8	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO VlanPort(DeviceID,...
13,409	412,364	34,726	0.39	35.44	bmbmrmyj9mvg6	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO Vlan(DeviceID, Vla...
1,222	6,949	32	38.19	0.60	b0jrypq3ts9cm	perl@Fj-fz-dcn-1 (TNS V1-V3)	select f.circuitid, f.inavgve...
345	3,052	629,618	0.00	0.26	6caatdwzncw9v	perl@nmscol2.qz.fjtelecom (TNS V1-V3)	INSERT INTO Flux(CIRCUITID, FL...
326	1,831	9,142	0.04	0.16	bvxzcqq23vy6u	perl@fj-zyite-app01 (TNS V1-V3)	INSERT INTO FluxD(InAvgVec, Ou...
238	1,721	1,088	0.22	0.15	dhsuv24kvusqs	perl@fj-zyite-app01 (TNS V1-V3)	SELECT sumalarmid, alarmtypeid...
221	2,101	22,372	0.01	0.18	03yjd8pbcnms0	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	update nco_status set summary=...
204	1,195	41,246	0.00	0.10	9f704q14sfukx	perl@xm-zyite-col01 (TNS V1-V3)	UPDATE ALARMSUMMARY SET LASTOC...
190	2,849	7,080	0.03	0.24	gysf9tyakgtxb	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO PPInfo(DeviceID, P...
180	1,040	9,958	0.02	0.09	3qm015bxqm8mv	perl@zwww-col01 (TNS V1-V3)	SELECT DEVICEID FROM DEVICE A,...

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: 5,097,482,882
Captured SQL account for 96.6% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
3,150,055,622	40,174	78,410.31	61.80	25290.91	650605.58	6cuc59szy3tp8	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO VlanPort(DeviceID,...
1,601,715,201	34,726	46,124.38	31.42	13408.75	412363.78	bmbmrmyj9mvg6	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO Vlan(DeviceID, Vla...
49,450,231	9,142	5,409.13	0.97	326.36	1830.57	bvxzcqq23vy6u	perl@fj-zyite-app01 (TNS V1-V3)	INSERT INTO FluxD(InAvgVec, Ou...
21,715,210	7,080	3,067.12	0.43	190.18	2849.24	gysf9tyakgtxb	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO PPInfo(DeviceID, P...
13,604,422	61	223,023.31	0.27	73.30	362.40	139m9v1hkznma	perl@fj-zyite-app01 (TNS V1-V3)	select h.sumalarmid ...
11,562,626	1,088	10,627.41	0.23	238.12	1721.47	dhsuv24kvusqs	perl@fj-zyite-app01 (TNS V1-V3)	SELECT sumalarmid, alarmtypeid...
10,964,672	9,958	1,101.09	0.22	179.87	1040.15	3qm015bxqm8mv	perl@zwww-col01 (TNS V1-V3)	SELECT DEVICEID FROM DEVICE A,...
9,725,451	7,080	1,373.65	0.19	82.96	1109.24	gzn9maxak18wz	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO PORTINFO (DEVICEID...
9,599,381	6,945	1,382.20	0.19	81.61	1339.00	0d3kn6t3s2015	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO PPExtInfo(DeviceID...
6,981,460	7,382	945.74	0.14	64.82	892.51	746gbn3kydf43	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO DevAddr(DeviceID, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 11,079,220
Captured SQL account for 53.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
3,493,336	32	109,166.75	31.53	1222.18	6949.08	b0jrypq3ts9cm	perl@Fj-fz-dcn-1 (TNS V1-V3)	select f.circuitid, f.inavgve...
1,177,505	1,088	1,082.27	10.63	238.12	1721.47	dhsuv24kvusqs	perl@fj-zyite-app01 (TNS V1-V3)	SELECT sumalarmid, alarmtypeid...
482,996	629,618	0.77	4.36	345.20	3052.28	6caatdwzncw9v	perl@nmscol2.qz.fjtelecom (TNS V1-V3)	INSERT INTO Flux(CIRCUITID, FL...
288,508	1	288,508.00	2.60	39.11	314.49	8ub359xamvghf	perl@fj-zyite-app01 (TNS V1-V3)	insert into FP_TAGFlux(TagTree...
224,378	1	224,378.00	2.03	32.71	841.24	g2nf5tdcyfsaa	perl@fj-zyite-app01 (TNS V1-V3)	DELETE FROM FluxH WHERE FluxTi...
198,809	0		1.79	59.34	2445.81	3uubc39zu7pyk	perl@fj-zyite-app01 (TNS V1-V3)	select count(*) from (select d...
56,511	472,560	0.12	0.51	130.74	490.81	23vcxnr979dch	perl@nmscol2.qz.fjtelecom (TNS V1-V3)	UPDATE ResMoniCurInfo SET Valu...
51,798	1	51,798.00	0.47	9.70	473.25	bwcz1rw3qk4fk	perl@fj-zyite-app01 (TNS V1-V3)	SELECT f.CIRCUITID, f.FLUXTIME...
25,006	337,076	0.07	0.23	77.74	318.25	77gkdbzrxptbg	perl@xm-zyite-col03.com (TNS V1-V3)	UPDATE ResMoniCurInfo SET Valu...
17,278	40,174	0.43	0.16	25290.91	650605.58	6cuc59szy3tp8	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO VlanPort(DeviceID,...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 3,618,846
Captured SQL account for 77.3% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
629,618	611,497	0.97	0.00	0.00	6caatdwzncw9v	perl@nmscol2.qz.fjtelecom (TNS V1-V3)	INSERT INTO Flux(CIRCUITID, FL...
472,560	472,557	1.00	0.00	0.00	23vcxnr979dch	perl@nmscol2.qz.fjtelecom (TNS V1-V3)	UPDATE ResMoniCurInfo SET Valu...
337,076	337,071	1.00	0.00	0.00	77gkdbzrxptbg	perl@xm-zyite-col03.com (TNS V1-V3)	UPDATE ResMoniCurInfo SET Valu...
179,266	176,360	0.98	0.00	0.00	f17gy1wrqffg1	perl@nmscol2.qz.fjtelecom (TNS V1-V3)	INSERT INTO ResMoniRawInfo(Res...
175,457	175,456	1.00	0.00	0.00	ahv7nwvbntgyd	perl@nmscol2.qz.fjtelecom (TNS V1-V3)	INSERT INTO ResMoniCurInfo(Res...
107,727	258,704	2.40	0.00	0.00	63busda1dhs8v	perl@nmscol2.qz.fjtelecom (TNS V1-V3)	DELETE FROM ResMoniCurInfo WHE...
86,713	86,713	1.00	0.00	0.00	b4j69uz7hh68h	perl@nmscol2.fz.fjtelecom (TNS V1-V3)	INSERT INTO ResMoniRawInfo(Res...
54,843	54,843	1.00	0.00	0.00	03306nz329m12		BEGIN DBMS_PIPE.UNPACK_MESSAGE...
54,843	54,843	1.00	0.00	0.01	35g3kv8rskg10		SELECT USERNAME FROM USER_USER...
54,841	54,841	1.00	0.00	0.00	7f8848vqvkf73		DECLARE status integer;BEGIN s...
54,028	54,028	1.00	0.00	0.01	dt2u89d4rasc2	perl@fj-zyite-app01 (TNS V1-V3)	BEGIN :status := DBMS_P...
44,541	44,542	1.00	0.00	0.00	70m3prfc67gxu	perl@nmscol2.np.fjtelecom (TNS V1-V3)	SELECT ALARMOCCURSEQ.NEXTVAL F...
41,246	35,531	0.86	0.00	0.03	9f704q14sfukx	perl@xm-zyite-col01 (TNS V1-V3)	UPDATE ALARMSUMMARY SET LASTOC...
40,174	40,174	1.00	0.63	16.19	6cuc59szy3tp8	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO VlanPort(DeviceID,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,744,230
Captured SQL account for 71.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
292,583	629,618	16.77	6caatdwzncw9v	perl@nmscol2.qz.fjtelecom (TNS V1-V3)	INSERT INTO Flux(CIRCUITID, FL...
236,288	472,560	13.55	23vcxnr979dch	perl@nmscol2.qz.fjtelecom (TNS V1-V3)	UPDATE ResMoniCurInfo SET Valu...
54,843	54,843	3.14	03306nz329m12		BEGIN DBMS_PIPE.UNPACK_MESSAGE...
54,841	54,841	3.14	7f8848vqvkf73		DECLARE status integer;BEGIN s...
51,010	54,843	2.92	35g3kv8rskg10		SELECT USERNAME FROM USER_USER...
44,136	44,541	2.53	70m3prfc67gxu	perl@nmscol2.np.fjtelecom (TNS V1-V3)	SELECT ALARMOCCURSEQ.NEXTVAL F...
40,313	41,246	2.31	9f704q14sfukx	perl@xm-zyite-col01 (TNS V1-V3)	UPDATE ALARMSUMMARY SET LASTOC...
40,121	40,174	2.30	6cuc59szy3tp8	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO VlanPort(DeviceID,...
34,732	34,726	1.99	bmbmrmyj9mvg6	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	INSERT INTO Vlan(DeviceID, Vla...
22,372	22,372	1.28	03yjd8pbcnms0	perl@nmscol1.fz.fjtelecom (TNS V1-V3)	update nco_status set summary=...
21,411	21,411	1.23	7gtztzv329wg0		select c.name, u.name from co...

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 Module	SQL Text
21	86,713	b4j69uz7hh68h	perl@nmscol2.fz.fjtelecom (TNS V1-V3)	INSERT INTO ResMoniRawInfo(Res...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

03306nz329m12 BEGIN DBMS_PIPE.UNPACK_MESSAGE(:msgtype); END;

03yjd8pbcnms0 update nco_status set summary=:p1, tally=tally+1, lastoccurrence=to_date(:p2, 'yyyymmddhh24miss'), AdditionalInfo=:p3 where identifier=:p4 and servername='NOD004'

0d3kn6t3s2015 INSERT INTO PPExtInfo(DeviceID, PPDescr, InfoItemCode, InfoValue, ChangeType) VALUES(:p1, :p2, :p3, :p4, :p5)

139m9v1hkznma select h.sumalarmid from alarmsummaryh h , (select sumalarmid from alarmsummary_pre_fujian pre where not exists (select sumalarmid from alarmsummary al where engiid = 0 and pre.sumalarmid = al.sumalarmid))a where h.sumalarmid=a.sumalarmid order by h.cleantime desc

21dgc3grmymt8 INSERT INTO ALARMSUMMARY (SUMALARMID, ALARMTYPEID, RESID, RESPARA, STARTTIME, LASTOCCURTIME, TIMES, GETMETHOD, ALARMLEVEL, SUMMARY, ACKSTATUS, HANDLESTATUS, KEYWORD, ADDITIONALINFO ) VALUES (ALARMSUMMARYSEQ.NEXTVAL, :B10 , :B9 , NVL (:B8 , '-1'), :B7 , :B1 , :B2 , 'Syslog', :B3 , SUBSTRB (:B4 , 0, 1024), '0', '1', :B5 , :B6 ) RETURNING SUMALARMID INTO :O0

23vcxnr979dch UPDATE ResMoniCurInfo SET Value=:p4, RecordTime=to_date(:p5, 'RRRRMMDDHH24MISS') WHERE ResID=:p1 AND ResPara=:p2 AND DataItemID=:p3

35g3kv8rskg10 SELECT USERNAME FROM USER_USERS

3qm015bxqm8mv SELECT DEVICEID FROM DEVICE A, NODE B WHERE A.LOOPADDRESS = :B2 AND A.CHANGETYPE = 0 AND A.NODECODE = B.NODECODE AND B.NODEFULLCODE LIKE '%' || :B1 || '%' AND ROWNUM = 1

3uubc39zu7pyk select count(*) from (select distinct circuitid from flux where fluxtime > to_char(sysdate-1/12, 'yyyymmddhh24mi') and circuitid like 'CIR%')

63busda1dhs8v DELETE FROM ResMoniCurInfo WHERE ResID=:p1 AND DataItemID<>'InSpeed' AND DataItemID<>'OutSpeed' and DataItemID=:p2

6caatdwzncw9v INSERT INTO Flux(CIRCUITID, FLUXTIME, INTERVAL, INAVGVEC, OUTAVGVEC) VALUES(:p1, :p2, :p3, :p4, :p5)

6cuc59szy3tp8 INSERT INTO VlanPort(DeviceID, VlanID, PortDescr, ChangeType) VALUES(:p1, :p2, :p3, :p4)

70m3prfc67gxu SELECT ALARMOCCURSEQ.NEXTVAL FROM DUAL

746gbn3kydf43 INSERT INTO DevAddr(DeviceID, IntDescr, IPAddress, NetMask, SeqNum, ChangeType, SuspStatus) VALUES(:p1, :p2, :p3, :p4, :p5, :p6, :p7)

77gkdbzrxptbg UPDATE ResMoniCurInfo SET Value=:p4, RecordTime=to_date(:p5, 'RRRRMMDDHH24MISS') WHERE ResID=:p1 AND ResPara=:p2 AND DataItemID=:p3

7f8848vqvkf73 DECLARE status integer;BEGIN status := DBMS_PIPE.RECEIVE_MESSAGE('RESALARM_fjslview'); END;

7gtztzv329wg0 select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#

8ub359xamvghf insert into FP_TAGFlux(TagTreeNodeCode, FluxTime, Interval, InAvgVec, OutAvgVec) select r.TagTreeNodeCode, f.fluxtime, avg(f.Interval), sum(case when r.operrela='A' then f.inavgvec else f.outavgvec end), sum(case when r.operrela='A' then f.outavgvec else f.inavgvec end) from TagTreeNodeCode_Res r, flux f where r.resid = f.circuitid and f.fluxtime>='201204190700' and f.fluxtime<='201204190759' group by r.TagTreeNodeCode, f.fluxtime order by r.TagTreeNodeCode, f.fluxtime

9f704q14sfukx UPDATE ALARMSUMMARY SET LASTOCCURTIME = :B6 , TIMES = TIMES + :B4 - NVL (:B5 , 0), SUMMARY = SUBSTRB ( SUBSTR (SUMMARY, 0, DECODE(INSTR (SUMMARY, '::::'), 0, 0, INSTR (SUMMARY, '::::') + 3) ) || :B3 , 0, 1024 ), KEYWORD = :B2 , STOPTIME = NULL, ADDITIONALINFO = DECODE (:B1 , NULL, ADDITIONALINFO, :B1 ) WHERE SUMALARMID = :B7

ahv7nwvbntgyd INSERT INTO ResMoniCurInfo(ResID, ResPara, DataItemID, Value, RecordTime) VALUES(:p1, :p2, :p3, :p4, to_date(:p5, 'RRRRMMDDHH24MISS'))

b0jrypq3ts9cm select f.circuitid, f.inavgvec, f.outavgvec from fluxh f where f.fluxtime = to_char(sysdate - 1 / 24, 'yyyymmddhh24')

b4j69uz7hh68h INSERT INTO ResMoniRawInfo(ResID, MoniItemCode, ItemPara, RecordTime, Value) VALUES(:p1, :p2, :p3, to_date(:p4, 'RRRRMMDDHH24MISS'), :p5)

bmbmrmyj9mvg6 INSERT INTO Vlan(DeviceID, VlanID, VlanName, VlanType, VlanStatus, ChangeType) VALUES(:p1, :p2, :p3, :p4, :p5, :p6)

bvxzcqq23vy6u INSERT INTO FluxD(InAvgVec, OutAvgVec, InMaxVec, OutMaxVec, InNonBmaxVec, OutNonBmaxVec, InMinVec, OutMinVec, InAvgRatio, OutAvgRatio, InMaxRatio, OutMaxRatio, InNonBmaxRatio, OutNonBmaxRatio, InMinRatio, OutMinRatio, inmaxtime, outmaxtime, CircuitID, FluxTime) VALUES(:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15, :p16, :p17, :p18, :p19, :p20)

bwcz1rw3qk4fk SELECT f.CIRCUITID, f.FLUXTIME, f.INAVGVEC, f.OUTAVGVEC, f.INAVGRatio, f.OUTAVGRATIO FROM Flux f WHERE f.circuitid >= 'CIR02tpz' and f.circuitid <= 'CIR02w3o' and f.FluxTime >= '20120418' AND f.FluxTime <= '20120419000000' ORDER BY f.CircuitID, f.FluxTime

bzzkyg10gvr3j UPDATE FluxD SET inbusiavgvec=:p1, outbusiavgvec=:p2, inbusiavgratio=:p3, outbusiavgratio=:p4 WHERE CircuitID=:p5 AND FluxTime='20120418'

ch5su7mucx14t UPDATE RES SET IPADDRESSB = NULL WHERE RESID IN (SELECT A.CIRCUITID RESID FROM CIRCUIT A WHERE A.CHANGETYPE = 0 AND A.BDEVICEID = :B2 AND A.BINTDESCR=:B1 )

crbmyn3mfbsw9 UPDATE Device',ET OSVersion='Huawei Versatile Routing Platform Software, Software Version 3.10, Release 0031P06 ChangeBeginTime=NULL, IsNew=0, detailmodelcode='s3552', LastCheckTime=sysdate, ConfirmTime=sysdate WHERE DeviceID='DEV00b78'

dhsuv24kvusqs SELECT sumalarmid, alarmtypeid, resid, respara, resentityclassid, getmethod, alarmlevel, to_char(starttime, 'YYYYMMDDHH24MISS'), to_char(lastoccurtime, 'YYYYMMDDHH24MISS'), times, summary, handlestatus, transfaultuserid, transfaulttime, ensummary, ackstatus, remark FROM alarmsummary ORDER BY sumalarmid

dt2u89d4rasc2 BEGIN :status := DBMS_PIPE.RECEIVE_MESSAGE('ALARM_fjslview'); IF :status = 0 THEN DBMS_PIPE.UNPACK_MESSAGE(:msgtype); DBMS_PIPE.UNPACK_MESSAGE(:serialid); DBMS_PIPE.UNPACK_MESSAGE(:alarmtype); DBMS_PIPE.UNPACK_MESSAGE(:resid); DBMS_PIPE.UNPACK_MESSAGE(:respara); DBMS_PIPE.UNPACK_MESSAGE(:starttime); DBMS_PIPE.UNPACK_MESSAGE(:lastoccurtime); DBMS_PIPE.UNPACK_MESSAGE(:times); DBMS_PIPE.UNPACK_MESSAGE(:alarmlevel); DBMS_PIPE.UNPACK_MESSAGE(:summary); DBMS_PIPE.UNPACK_MESSAGE(:ensummary); DBMS_PIPE.UNPACK_MESSAGE(:ackstatus); DBMS_PIPE.UNPACK_MESSAGE(:acktime); DBMS_PIPE.UNPACK_MESSAGE(:ackuserid); END IF; END;

f17gy1wrqffg1 INSERT INTO ResMoniRawInfo(ResID, MoniItemCode, ItemPara, RecordTime, Value) VALUES(:p1, :p2, :p3, to_date(:p4, 'RRRRMMDDHH24MISS'), :p5)

g2nf5tdcyfsaa DELETE FROM FluxH WHERE FluxTime>='2012041907' and FluxTime<='2012041908'

gysf9tyakgtxb INSERT INTO PPInfo(DeviceID, PPIndex, CardIndex, PPDescr, PPSpeed, AdminStatus, OperStatus, PPType, PortDescrDetail, PortMode, Distance, ChangeType) VALUES(:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12)

gzn9maxak18wz INSERT INTO PORTINFO (DEVICEID, PORTDESCR, PORTCLASS, PORTTYPE, PORTINDEX, PORTSPEED, VPI, VCI, DLCI, ADMINSTATUS, OPERSTATUS, PORTDESCRDETAIL, PORTMODE, DISTANCE, PPDESCR, IPADDRESS, NETMASK, FULLIPADDRESS ) VALUES (:B1 , :B2 , 'P', :B3 , :B4 , :B5 , -1, -1, -1, :B6 , :B7 , :B8 , :B9 , :B10 , :B2 , :B13 , :B12 , :B11 )

SQL Id	SQL Text
03306nz329m12	BEGIN DBMS_PIPE.UNPACK_MESSAGE(:msgtype); END;
03yjd8pbcnms0	update nco_status set summary=:p1, tally=tally+1, lastoccurrence=to_date(:p2, 'yyyymmddhh24miss'), AdditionalInfo=:p3 where identifier=:p4 and servername='NOD004'
0d3kn6t3s2015	INSERT INTO PPExtInfo(DeviceID, PPDescr, InfoItemCode, InfoValue, ChangeType) VALUES(:p1, :p2, :p3, :p4, :p5)
139m9v1hkznma	select h.sumalarmid from alarmsummaryh h , (select sumalarmid from alarmsummary_pre_fujian pre where not exists (select sumalarmid from alarmsummary al where engiid = 0 and pre.sumalarmid = al.sumalarmid))a where h.sumalarmid=a.sumalarmid order by h.cleantime desc
21dgc3grmymt8	INSERT INTO ALARMSUMMARY (SUMALARMID, ALARMTYPEID, RESID, RESPARA, STARTTIME, LASTOCCURTIME, TIMES, GETMETHOD, ALARMLEVEL, SUMMARY, ACKSTATUS, HANDLESTATUS, KEYWORD, ADDITIONALINFO ) VALUES (ALARMSUMMARYSEQ.NEXTVAL, :B10 , :B9 , NVL (:B8 , '-1'), :B7 , :B1 , :B2 , 'Syslog', :B3 , SUBSTRB (:B4 , 0, 1024), '0', '1', :B5 , :B6 ) RETURNING SUMALARMID INTO :O0
23vcxnr979dch	UPDATE ResMoniCurInfo SET Value=:p4, RecordTime=to_date(:p5, 'RRRRMMDDHH24MISS') WHERE ResID=:p1 AND ResPara=:p2 AND DataItemID=:p3
35g3kv8rskg10	SELECT USERNAME FROM USER_USERS
3qm015bxqm8mv	SELECT DEVICEID FROM DEVICE A, NODE B WHERE A.LOOPADDRESS = :B2 AND A.CHANGETYPE = 0 AND A.NODECODE = B.NODECODE AND B.NODEFULLCODE LIKE '%' \|\| :B1 \|\| '%' AND ROWNUM = 1
3uubc39zu7pyk	select count(*) from (select distinct circuitid from flux where fluxtime > to_char(sysdate-1/12, 'yyyymmddhh24mi') and circuitid like 'CIR%')
63busda1dhs8v	DELETE FROM ResMoniCurInfo WHERE ResID=:p1 AND DataItemID<>'InSpeed' AND DataItemID<>'OutSpeed' and DataItemID=:p2
6caatdwzncw9v	INSERT INTO Flux(CIRCUITID, FLUXTIME, INTERVAL, INAVGVEC, OUTAVGVEC) VALUES(:p1, :p2, :p3, :p4, :p5)
6cuc59szy3tp8	INSERT INTO VlanPort(DeviceID, VlanID, PortDescr, ChangeType) VALUES(:p1, :p2, :p3, :p4)
70m3prfc67gxu	SELECT ALARMOCCURSEQ.NEXTVAL FROM DUAL
746gbn3kydf43	INSERT INTO DevAddr(DeviceID, IntDescr, IPAddress, NetMask, SeqNum, ChangeType, SuspStatus) VALUES(:p1, :p2, :p3, :p4, :p5, :p6, :p7)
77gkdbzrxptbg	UPDATE ResMoniCurInfo SET Value=:p4, RecordTime=to_date(:p5, 'RRRRMMDDHH24MISS') WHERE ResID=:p1 AND ResPara=:p2 AND DataItemID=:p3
7f8848vqvkf73	DECLARE status integer;BEGIN status := DBMS_PIPE.RECEIVE_MESSAGE('RESALARM_fjslview'); END;
7gtztzv329wg0	select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
8ub359xamvghf	insert into FP_TAGFlux(TagTreeNodeCode, FluxTime, Interval, InAvgVec, OutAvgVec) select r.TagTreeNodeCode, f.fluxtime, avg(f.Interval), sum(case when r.operrela='A' then f.inavgvec else f.outavgvec end), sum(case when r.operrela='A' then f.outavgvec else f.inavgvec end) from TagTreeNodeCode_Res r, flux f where r.resid = f.circuitid and f.fluxtime>='201204190700' and f.fluxtime<='201204190759' group by r.TagTreeNodeCode, f.fluxtime order by r.TagTreeNodeCode, f.fluxtime
9f704q14sfukx	UPDATE ALARMSUMMARY SET LASTOCCURTIME = :B6 , TIMES = TIMES + :B4 - NVL (:B5 , 0), SUMMARY = SUBSTRB ( SUBSTR (SUMMARY, 0, DECODE(INSTR (SUMMARY, '::::'), 0, 0, INSTR (SUMMARY, '::::') + 3) ) \|\| :B3 , 0, 1024 ), KEYWORD = :B2 , STOPTIME = NULL, ADDITIONALINFO = DECODE (:B1 , NULL, ADDITIONALINFO, :B1 ) WHERE SUMALARMID = :B7
ahv7nwvbntgyd	INSERT INTO ResMoniCurInfo(ResID, ResPara, DataItemID, Value, RecordTime) VALUES(:p1, :p2, :p3, :p4, to_date(:p5, 'RRRRMMDDHH24MISS'))
b0jrypq3ts9cm	select f.circuitid, f.inavgvec, f.outavgvec from fluxh f where f.fluxtime = to_char(sysdate - 1 / 24, 'yyyymmddhh24')
b4j69uz7hh68h	INSERT INTO ResMoniRawInfo(ResID, MoniItemCode, ItemPara, RecordTime, Value) VALUES(:p1, :p2, :p3, to_date(:p4, 'RRRRMMDDHH24MISS'), :p5)
bmbmrmyj9mvg6	INSERT INTO Vlan(DeviceID, VlanID, VlanName, VlanType, VlanStatus, ChangeType) VALUES(:p1, :p2, :p3, :p4, :p5, :p6)
bvxzcqq23vy6u	INSERT INTO FluxD(InAvgVec, OutAvgVec, InMaxVec, OutMaxVec, InNonBmaxVec, OutNonBmaxVec, InMinVec, OutMinVec, InAvgRatio, OutAvgRatio, InMaxRatio, OutMaxRatio, InNonBmaxRatio, OutNonBmaxRatio, InMinRatio, OutMinRatio, inmaxtime, outmaxtime, CircuitID, FluxTime) VALUES(:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15, :p16, :p17, :p18, :p19, :p20)
bwcz1rw3qk4fk	SELECT f.CIRCUITID, f.FLUXTIME, f.INAVGVEC, f.OUTAVGVEC, f.INAVGRatio, f.OUTAVGRATIO FROM Flux f WHERE f.circuitid >= 'CIR02tpz' and f.circuitid <= 'CIR02w3o' and f.FluxTime >= '20120418' AND f.FluxTime <= '20120419000000' ORDER BY f.CircuitID, f.FluxTime
bzzkyg10gvr3j	UPDATE FluxD SET inbusiavgvec=:p1, outbusiavgvec=:p2, inbusiavgratio=:p3, outbusiavgratio=:p4 WHERE CircuitID=:p5 AND FluxTime='20120418'
ch5su7mucx14t	UPDATE RES SET IPADDRESSB = NULL WHERE RESID IN (SELECT A.CIRCUITID RESID FROM CIRCUIT A WHERE A.CHANGETYPE = 0 AND A.BDEVICEID = :B2 AND A.BINTDESCR=:B1 )
crbmyn3mfbsw9	UPDATE Device',ET OSVersion='Huawei Versatile Routing Platform Software, Software Version 3.10, Release 0031P06 ChangeBeginTime=NULL, IsNew=0, detailmodelcode='s3552', LastCheckTime=sysdate, ConfirmTime=sysdate WHERE DeviceID='DEV00b78'
dhsuv24kvusqs	SELECT sumalarmid, alarmtypeid, resid, respara, resentityclassid, getmethod, alarmlevel, to_char(starttime, 'YYYYMMDDHH24MISS'), to_char(lastoccurtime, 'YYYYMMDDHH24MISS'), times, summary, handlestatus, transfaultuserid, transfaulttime, ensummary, ackstatus, remark FROM alarmsummary ORDER BY sumalarmid
dt2u89d4rasc2	BEGIN :status := DBMS_PIPE.RECEIVE_MESSAGE('ALARM_fjslview'); IF :status = 0 THEN DBMS_PIPE.UNPACK_MESSAGE(:msgtype); DBMS_PIPE.UNPACK_MESSAGE(:serialid); DBMS_PIPE.UNPACK_MESSAGE(:alarmtype); DBMS_PIPE.UNPACK_MESSAGE(:resid); DBMS_PIPE.UNPACK_MESSAGE(:respara); DBMS_PIPE.UNPACK_MESSAGE(:starttime); DBMS_PIPE.UNPACK_MESSAGE(:lastoccurtime); DBMS_PIPE.UNPACK_MESSAGE(:times); DBMS_PIPE.UNPACK_MESSAGE(:alarmlevel); DBMS_PIPE.UNPACK_MESSAGE(:summary); DBMS_PIPE.UNPACK_MESSAGE(:ensummary); DBMS_PIPE.UNPACK_MESSAGE(:ackstatus); DBMS_PIPE.UNPACK_MESSAGE(:acktime); DBMS_PIPE.UNPACK_MESSAGE(:ackuserid); END IF; END;
f17gy1wrqffg1	INSERT INTO ResMoniRawInfo(ResID, MoniItemCode, ItemPara, RecordTime, Value) VALUES(:p1, :p2, :p3, to_date(:p4, 'RRRRMMDDHH24MISS'), :p5)
g2nf5tdcyfsaa	DELETE FROM FluxH WHERE FluxTime>='2012041907' and FluxTime<='2012041908'
gysf9tyakgtxb	INSERT INTO PPInfo(DeviceID, PPIndex, CardIndex, PPDescr, PPSpeed, AdminStatus, OperStatus, PPType, PortDescrDetail, PortMode, Distance, ChangeType) VALUES(:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12)
gzn9maxak18wz	INSERT INTO PORTINFO (DEVICEID, PORTDESCR, PORTCLASS, PORTTYPE, PORTINDEX, PORTSPEED, VPI, VCI, DLCI, ADMINSTATUS, OPERSTATUS, PORTDESCRDETAIL, PORTMODE, DISTANCE, PPDESCR, IPADDRESS, NETMASK, FULLIPADDRESS ) VALUES (:B1 , :B2 , 'P', :B3 , :B4 , :B5 , -1, -1, -1, :B6 , :B7 , :B8 , :B9 , :B10 , :B2 , :B13 , :B12 , :B11 )

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	4,872,459	1,347.11	30.98
CPU used when call started	4,871,133	1,346.75	30.98
CR blocks created	1,188,161	328.50	7.56
Cached Commit SCN referenced	88,216	24.39	0.56
Commit SCN cached	372	0.10	0.00
DB time	120,667,505	33,361.54	767.33
DBWR checkpoint buffers written	163,593	45.23	1.04
DBWR checkpoints	43	0.01	0.00
DBWR object drop buffers written	133	0.04	0.00
DBWR revisited being-written buffer	176	0.05	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	4,441	1.23	0.03
DBWR undo block writes	108,322	29.95	0.69
IMU CR rollbacks	192,151	53.12	1.22
IMU Flushes	17,162	4.74	0.11
IMU Redo allocation size	64,882,452	17,938.37	412.59
IMU commits	120,408	33.29	0.77
IMU contention	4,887	1.35	0.03
IMU ktichg flush	3	0.00	0.00
IMU pool not allocated	23,021	6.36	0.15
IMU recursive-transaction flush	56	0.02	0.00
IMU undo allocation size	442,326,296	122,292.11	2,812.76
IMU- failed to get a private strand	23,021	6.36	0.15
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	45	0.01	0.00
SQL*Net roundtrips to/from client	5,001,178	1,382.70	31.80
active txn count during cleanout	4,331,505,935	1,197,552.63	27,544.12
application wait time	922,776	255.12	5.87
background checkpoints completed	2	0.00	0.00
background checkpoints started	3	0.00	0.00
background timeouts	22,247	6.15	0.14
branch node splits	63	0.02	0.00
buffer is not pinned count	73,815,041	20,408.01	469.39
buffer is pinned count	148,110,292	40,948.78	941.84
bytes received via SQL*Net from client	1,657,622,835	458,291.09	10,540.85
bytes sent via SQL*Net to client	6,049,635,723	1,672,572.37	38,469.74
calls to get snapshot scn: kcmgss	5,108,603	1,412.40	32.49
calls to kcmgas	1,627,755	450.03	10.35
calls to kcmgcs	404,342,501	111,790.55	2,571.22
change write time	18,446	5.10	0.12
cleanout - number of ktugct calls	482,418,463	133,376.59	3,067.71
cleanouts and rollbacks - consistent read gets	1,107,131	306.09	7.04
cleanouts only - consistent read gets	20,385	5.64	0.13
cluster key scan block gets	397,210	109.82	2.53
cluster key scans	232,962	64.41	1.48
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	2,513	0.69	0.02
commit batch/immediate requested	2,513	0.69	0.02
commit cleanout failures: block lost	73,589	20.35	0.47
commit cleanout failures: buffer being written	136	0.04	0.00
commit cleanout failures: callback failure	2,427	0.67	0.02
commit cleanout failures: cannot pin	995	0.28	0.01
commit cleanouts	902,542	249.53	5.74
commit cleanouts successfully completed	825,395	228.20	5.25
commit immediate performed	2,513	0.69	0.02
commit immediate requested	2,513	0.69	0.02
commit txn count during cleanout	360,517	99.67	2.29
concurrency wait time	72,074,054	19,926.67	458.32
consistent changes	12,755,407	3,526.55	81.11
consistent gets	4,580,309,973	1,266,340.70	29,126.27
consistent gets - examination	4,465,078,186	1,234,482.00	28,393.51
consistent gets direct	460,314	127.27	2.93
consistent gets from cache	4,579,849,651	1,266,213.43	29,123.34
current blocks converted for CR	10,266	2.84	0.07
cursor authentications	16,430	4.54	0.10
data blocks consistent reads - undo records applied	12,607,178	3,485.57	80.17
db block changes	12,508,387	3,458.25	79.54
db block gets	517,172,337	142,985.16	3,288.71
db block gets direct	3,567	0.99	0.02
db block gets from cache	517,168,770	142,984.18	3,288.69
deferred (CURRENT) block cleanout applications	352,740	97.52	2.24
dirty buffers inspected	616,651	170.49	3.92
doubling up with imu segment	0	0.00	0.00
enqueue conversions	2,153	0.60	0.01
enqueue deadlocks	0	0.00	0.00
enqueue releases	849,267	234.80	5.40
enqueue requests	848,404	234.56	5.40
enqueue timeouts	0	0.00	0.00
enqueue waits	10,272	2.84	0.07
exchange deadlocks	0	0.00	0.00
execute count	3,618,846	1,000.52	23.01
free buffer inspected	11,246,716	3,109.43	71.52
free buffer requested	11,950,160	3,303.92	75.99
global undo segment hints helped	12	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	104,102	28.78	0.66
hot buffers moved to head of LRU	1,438,627	397.74	9.15
immediate (CR) block cleanout applications	1,127,726	311.79	7.17
immediate (CURRENT) block cleanout applications	127,164	35.16	0.81
index fast full scans (full)	18,713	5.17	0.12
index fetch by key	82,927,970	22,927.50	527.34
index scans kdiixs1	20,657,603	5,711.31	131.36
leaf node 90-10 splits	819	0.23	0.01
leaf node splits	12,714	3.52	0.08
lob reads	46,153	12.76	0.29
lob writes	378	0.10	0.00
lob writes unaligned	352	0.10	0.00
logons cumulative	4,806	1.33	0.03
messages received	621,560	171.85	3.95
messages sent	621,559	171.85	3.95
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	93,724,857	25,912.57	596.00
opened cursors cumulative	1,752,065	484.40	11.14
parse count (failures)	14	0.00	0.00
parse count (hard)	193,504	53.50	1.23
parse count (total)	1,744,230	482.24	11.09
parse time cpu	239,731	66.28	1.52
parse time elapsed	2,371,940	655.78	15.08
physical read IO requests	2,934,109	811.21	18.66
physical read bytes	90,760,970,240	25,093,129.25	577,150.59
physical read total IO requests	2,945,921	814.47	18.73
physical read total bytes	90,951,680,000	25,145,855.71	578,363.32
physical read total multi block requests	730,786	202.04	4.65
physical reads	11,079,220	3,063.13	70.45
physical reads cache	10,619,988	2,936.16	67.53
physical reads cache prefetch	8,140,571	2,250.66	51.77
physical reads direct	459,232	126.97	2.92
physical reads direct (lob)	458,080	126.65	2.91
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	682,909	188.81	4.34
physical write bytes	9,926,172,672	2,744,337.50	63,120.70
physical write total IO requests	899,037	248.56	5.72
physical write total bytes	12,135,027,712	3,355,030.45	77,166.85
physical write total multi block requests	396,244	109.55	2.52
physical writes	1,211,691	335.00	7.71
physical writes direct	3,877	1.07	0.02
physical writes direct (lob)	158	0.04	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	1,207,814	333.93	7.68
physical writes non checkpoint	971,669	268.64	6.18
pinned buffers inspected	5,919	1.64	0.04
prefetch clients - default	1	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	1	0.00	0.00
process last non-idle time	3,619	1.00	0.02
recovery blocks read	0	0.00	0.00
recursive calls	2,604,360	720.04	16.56
recursive cpu usage	282,348	78.06	1.80
redo blocks read for recovery	0	0.00	0.00
redo blocks written	3,958,574	1,094.45	25.17
redo buffer allocation retries	85	0.02	0.00
redo entries	6,858,122	1,896.10	43.61
redo log space requests	110	0.03	0.00
redo log space wait time	500	0.14	0.00
redo ordering marks	88,788	24.55	0.56
redo size	1,909,524,184	527,935.49	12,142.70
redo synch time	136,260	37.67	0.87
redo synch writes	227,719	62.96	1.45
redo wastage	50,653,452	14,004.41	322.11
redo write time	42,037	11.62	0.27
redo writer latching time	18	0.00	0.00
redo writes	162,528	44.93	1.03
rollback changes - undo records applied	23,479	6.49	0.15
rollbacks only - consistent read gets	91,244	25.23	0.58
rows fetched via callback	25,926,470	7,168.02	164.87
session connect time	0	0.00	0.00
session cursor cache hits	1,236,918	341.98	7.87
session logical reads	5,097,482,882	1,409,326.02	32,414.98
session pga memory	157,061,448	43,423.55	998.76
session pga memory max	216,829,448	59,947.90	1,378.82
session uga memory	###############	118,787,375.29	2,732,150.42
session uga memory max	2,551,063,920	705,305.12	16,222.26
shared hash latch upgrades - no wait	17,819,578	4,926.67	113.32
shared hash latch upgrades - wait	11,110	3.07	0.07
sorts (disk)	0	0.00	0.00
sorts (memory)	4,411,057	1,219.55	28.05
sorts (rows)	18,255,065	5,047.07	116.08
sql area purged	35	0.01	0.00
summed dirty queue length	6,597,353	1,824.00	41.95
switch current to new buffer	22,912	6.33	0.15
table fetch by rowid	40,168,050	11,105.46	255.43
table fetch continued row	1,212,860	335.33	7.71
table scan blocks gotten	39,231,117	10,846.42	249.47
table scan rows gotten	3,335,377,450	922,148.11	21,209.72
table scans (direct read)	3	0.00	0.00
table scans (long tables)	1,672	0.46	0.01
table scans (short tables)	340,094	94.03	2.16
total number of times SMON posted	87	0.02	0.00
transaction rollbacks	2,513	0.69	0.02
transaction tables consistent read rollbacks	284	0.08	0.00
transaction tables consistent reads - undo records applied	136,368	37.70	0.87
undo change vector size	698,457,800	193,106.04	4,441.51
user I/O wait time	1,992,032	550.75	12.67
user calls	6,473,777	1,789.84	41.17
user commits	154,950	42.84	0.99
user rollbacks	2,307	0.64	0.01
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	378,394	104.62	2.41
write clones created in background	325	0.09	0.00
write clones created in foreground	1,384	0.38	0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	42,573,450	42,626,940
opened cursors current	728	721
workarea memory allocated	75,562	109,588
logons current	468	427

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

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)
INDEXFLUX	912,081	252	6.89	1.00	392,099	108	11	37.27
DATALIST	1,006,351	278	6.84	3.77	123,133	34	22,129	15.35
DATAFLUX	570,472	158	6.29	8.34	7,494	2	4,141	45.81
DATACFG	200,331	55	7.57	6.69	85,445	24	6,799,789	91.65
UNDOTBS2	130,113	36	9.59	1.00	33,990	9	741	7.80
INDEXCFG	45,175	12	14.30	1.06	20,439	6	618	24.85
INDEXLIST	42,661	12	14.77	1.00	16,932	5	52,544	19.21
SYSTEM	16,389	5	5.89	2.01	416	0	1,629	53.30
SYSAUX	6,336	2	6.91	1.06	1,134	0	0	0.00
DATAEXAM	1,398	0	3.68	6.93	188	0	0	0.00
DATAPATH	604	0	13.58	2.17	24	0	0	0.00
INDEXPATH	447	0	17.45	1.00	99	0	0	0.00
INDEXEXAM	313	0	2.01	1.00	8	0	0	0.00
USERS	16	0	4.38	1.00	2	0	0	0.00
TEMP	12	0	2.50	1.00	0	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
DATACFG	/oradata1/dbnms/datacfg01.dbf	47,616	13	5.98	11.28	9,842	3	675,232	91.76
DATACFG	/oradata1/dbnms/datacfg02.dbf	40,324	11	8.19	6.26	14,889	4	840,563	91.94
DATACFG	/oradata1/dbnms/datacfg03.dbf	27,980	8	8.37	4.46	17,880	5	1,889,485	92.85
DATACFG	/oradata1/dbnms/datalist47.dbf	27,721	8	10.34	4.05	16,498	5	1,359,315	90.37
DATACFG	/oradata2/dbnms/indexflux03.dbf	56,690	16	6.73	5.52	26,336	7	2,035,194	91.23
DATAEXAM	/oradata1/dbnms/dataexam01.dbf	144	0	7.29	8.58	10	0	0	0.00
DATAEXAM	/oradata1/dbnms/dataexam02.dbf	116	0	3.45	10.46	7	0	0	0.00
DATAEXAM	/oradata1/dbnms/dataexam03.dbf	515	0	2.25	4.50	149	0	0	0.00
DATAEXAM	/oradata1/dbnms/dataexam04.dbf	291	0	2.82	4.69	6	0	0	0.00
DATAEXAM	/oradata1/dbnms/dataexam05.dbf	126	0	5.87	9.53	10	0	0	0.00
DATAEXAM	/oradata1/dbnms/dataexam06.dbf	112	0	5.00	10.58	4	0	0	0.00
DATAEXAM	/oradata1/dbnms/dataexam07.dbf	94	0	4.36	12.41	2	0	0	0.00
DATAFLUX	/oradata1/dbnms/dataflux01.dbf	10,615	3	4.64	14.20	8	0	133	50.75
DATAFLUX	/oradata1/dbnms/dataflux02.dbf	11,596	3	6.38	11.85	3	0	149	29.46
DATAFLUX	/oradata1/dbnms/dataflux03.dbf	22,153	6	7.57	7.25	1,121	0	62	110.00
DATAFLUX	/oradata1/dbnms/dataflux04.dbf	21,040	6	7.28	6.84	3,155	1	458	19.00
DATAFLUX	/oradata1/dbnms/dataflux05.dbf	14,871	4	7.35	8.92	26	0	124	32.02
DATAFLUX	/oradata1/dbnms/dataflux06.dbf	3,080	1	6.94	15.25	20	0	48	39.17
DATAFLUX	/oradata1/dbnms/dataflux07.dbf	14,857	4	6.97	8.80	3	0	116	31.29
DATAFLUX	/oradata1/dbnms/dataflux08.dbf	17,042	5	6.89	8.12	2	0	103	50.19
DATAFLUX	/oradata1/dbnms/dataflux09.dbf	6,630	2	5.94	15.47	3	0	37	78.11
DATAFLUX	/oradata1/dbnms/dataflux10.dbf	7,056	2	5.68	15.42	35	0	76	83.82
DATAFLUX	/oradata1/dbnms/dataflux11.dbf	12,315	3	7.26	9.99	2	0	106	73.11
DATAFLUX	/oradata1/dbnms/dataflux12.dbf	6,784	2	5.86	15.42	5	0	78	32.05
DATAFLUX	/oradata1/dbnms/dataflux13.dbf	23,012	6	6.33	10.28	5	0	242	54.63
DATAFLUX	/oradata1/dbnms/dataflux14.dbf	15,629	4	7.43	8.35	4	0	89	76.63
DATAFLUX	/oradata1/dbnms/dataflux15.dbf	17,868	5	7.07	8.65	8	0	124	43.15
DATAFLUX	/oradata1/dbnms/dataflux16.dbf	9,015	2	6.30	15.56	2	0	168	52.50
DATAFLUX	/oradata1/dbnms/dataflux17.dbf	18,154	5	6.91	8.69	29	0	190	51.53
DATAFLUX	/oradata1/dbnms/dataflux18.dbf	25,372	7	6.75	6.17	35	0	123	40.41
DATAFLUX	/oradata1/dbnms/dataflux19.dbf	26,257	7	7.38	5.84	3	0	149	61.68
DATAFLUX	/oradata1/dbnms/dataflux20.dbf	35,126	10	6.11	8.31	2	0	187	35.83
DATAFLUX	/oradata1/dbnms/dataflux21.dbf	38,413	11	5.67	8.49	2	0	251	61.24
DATAFLUX	/oradata1/dbnms/dataflux22.dbf	38,897	11	5.83	8.41	76	0	310	31.61
DATAFLUX	/oradata1/dbnms/dataflux23.dbf	35,215	10	5.56	7.22	40	0	167	32.16
DATAFLUX	/oradata1/dbnms/dataflux24.dbf	42,530	12	6.09	7.38	2,668	1	294	55.51
DATAFLUX	/oradata1/dbnms/dataflux25.dbf	27,669	8	6.08	5.27	184	0	81	43.95
DATAFLUX	/oradata1/dbnms/dataflux26.dbf	29,346	8	5.92	5.52	2	0	137	28.03
DATAFLUX	/oradata1/dbnms/dataflux27.dbf	26,949	7	5.74	5.44	25	0	85	73.29
DATAFLUX	/oradata3/dbnms/dataflux27.dbf	12,981	4	2.81	14.00	26	0	54	65.37
DATALIST	/oradata1/dbnms/datalist01.dbf	18,901	5	8.80	3.57	3,320	1	386	0.80
DATALIST	/oradata1/dbnms/datalist02.dbf	26,859	7	6.92	3.02	5,614	2	335	1.52
DATALIST	/oradata1/dbnms/datalist03.dbf	11,129	3	2.33	3.90	3,442	1	330	1.61
DATALIST	/oradata1/dbnms/datalist04.dbf	35,017	10	4.64	4.43	2,092	1	3,187	14.38
DATALIST	/oradata1/dbnms/datalist05.dbf	35,313	10	8.54	4.90	2,656	1	3,181	16.85
DATALIST	/oradata1/dbnms/datalist06.dbf	18,185	5	5.09	5.38	2,110	1	1,742	17.01
DATALIST	/oradata1/dbnms/datalist07.dbf	9,372	3	2.05	3.32	4,288	1	8	2.50
DATALIST	/oradata1/dbnms/datalist08.dbf	10,063	3	2.91	3.40	4,671	1	40	20.00
DATALIST	/oradata1/dbnms/datalist09.dbf	14,759	4	7.05	2.52	1,888	1	13	20.00
DATALIST	/oradata1/dbnms/datalist10.dbf	8,588	2	5.25	3.96	2,749	1	21	49.05
DATALIST	/oradata1/dbnms/datalist11.dbf	7,220	2	5.89	4.65	1,174	0	28	6.07
DATALIST	/oradata1/dbnms/datalist12.dbf	5,302	1	7.21	5.55	637	0	35	28.00
DATALIST	/oradata1/dbnms/datalist13.dbf	23,059	6	8.52	2.13	1,522	0	56	43.21
DATALIST	/oradata1/dbnms/datalist14.dbf	16,977	5	8.12	2.53	1,455	0	86	28.84
DATALIST	/oradata1/dbnms/datalist15.dbf	15,272	4	9.93	2.69	796	0	127	35.51
DATALIST	/oradata1/dbnms/datalist16.dbf	7,830	2	6.66	4.46	1,154	0	166	27.29
DATALIST	/oradata1/dbnms/datalist17.dbf	16,512	5	5.82	2.62	3,995	1	167	22.87
DATALIST	/oradata1/dbnms/datalist18.dbf	5,667	2	7.71	6.07	208	0	142	34.23
DATALIST	/oradata1/dbnms/datalist19.dbf	9,445	3	7.72	3.84	307	0	109	2.29
DATALIST	/oradata1/dbnms/datalist20.dbf	7,987	2	6.56	7.38	308	0	170	29.71
DATALIST	/oradata1/dbnms/datalist21.dbf	8,961	2	4.96	4.04	2,166	1	229	20.22
DATALIST	/oradata1/dbnms/datalist22.dbf	9,102	3	5.32	6.35	1,722	0	257	13.81
DATALIST	/oradata1/dbnms/datalist23.dbf	8,445	2	5.35	6.43	1,925	1	211	18.34
DATALIST	/oradata1/dbnms/datalist24.dbf	7,803	2	3.04	7.00	827	0	166	1.45
DATALIST	/oradata1/dbnms/datalist25.dbf	10,173	3	6.43	6.55	365	0	199	24.42
DATALIST	/oradata1/dbnms/datalist26.dbf	15,699	4	6.88	3.57	1,304	0	207	22.37
DATALIST	/oradata1/dbnms/datalist27.dbf	14,732	4	4.64	4.90	5,604	2	212	17.17
DATALIST	/oradata1/dbnms/datalist28.dbf	12,014	3	5.74	4.57	6,470	2	186	27.58
DATALIST	/oradata1/dbnms/datalist29.dbf	11,647	3	6.80	6.48	2,170	1	178	32.42
DATALIST	/oradata1/dbnms/datalist30.dbf	11,016	3	2.62	3.38	5,731	2	181	0.61
DATALIST	/oradata1/dbnms/datalist31.dbf	5,991	2	8.18	4.72	508	0	214	18.83
DATALIST	/oradata1/dbnms/datalist32.dbf	7,456	2	2.89	3.88	2,062	1	184	1.74
DATALIST	/oradata1/dbnms/datalist33.dbf	6,454	2	7.04	4.84	451	0	230	14.96
DATALIST	/oradata1/dbnms/datalist34.dbf	6,797	2	7.57	5.44	509	0	205	26.34
DATALIST	/oradata1/dbnms/datalist35.dbf	5,731	2	4.76	5.99	427	0	174	1.95
DATALIST	/oradata1/dbnms/datalist36.dbf	7,374	2	4.17	5.50	367	0	152	1.64
DATALIST	/oradata1/dbnms/datalist37.dbf	9,018	2	8.88	4.01	552	0	224	32.72
DATALIST	/oradata1/dbnms/datalist38.dbf	12,714	4	8.63	3.02	703	0	253	20.00
DATALIST	/oradata1/dbnms/datalist39.dbf	6,528	2	4.21	5.01	610	0	240	1.75
DATALIST	/oradata1/dbnms/datalist40.dbf	6,553	2	4.31	6.11	988	0	257	0.78
DATALIST	/oradata1/dbnms/datalist41.dbf	6,996	2	7.33	5.85	527	0	346	15.52
DATALIST	/oradata1/dbnms/datalist42.dbf	7,383	2	6.59	5.29	779	0	295	15.59
DATALIST	/oradata1/dbnms/datalist43.dbf	6,626	2	8.91	5.87	896	0	314	30.96
DATALIST	/oradata1/dbnms/datalist44.dbf	7,489	2	9.06	5.20	858	0	365	20.88
DATALIST	/oradata1/dbnms/datalist45.dbf	6,326	2	7.78	5.22	844	0	344	16.16
DATALIST	/oradata1/dbnms/datalist46.dbf	5,480	2	8.61	5.48	527	0	348	12.67
DATALIST	/oradata1/dbnms/datalist48.dbf	16,656	5	10.16	4.07	854	0	324	13.43
DATALIST	/oradata1/dbnms/datalist49.dbf	27,887	8	7.88	2.31	2,901	1	422	14.53
DATALIST	/oradata1/dbnms/datalist50.dbf	22,646	6	6.02	2.43	6,414	2	370	16.43
DATALIST	/oradata1/dbnms/datalist51.dbf	21,103	6	6.85	2.84	4,329	1	441	15.58
DATALIST	/oradata1/dbnms/datalist52.dbf	20,914	6	6.91	3.99	2,125	1	337	0.89
DATALIST	/oradata1/dbnms/datalist53.dbf	20,979	6	9.06	2.61	4,216	1	443	16.86
DATALIST	/oradata1/dbnms/datalist54.dbf	24,133	7	5.41	3.22	6,453	2	373	1.47
DATALIST	/oradata1/dbnms/datalist55.dbf	19,912	6	6.51	2.68	3,868	1	360	13.86
DATALIST	/oradata1/dbnms/datelist56.dbf	21,359	6	7.51	6.20	1,059	0	408	15.32
DATALIST	/oradata1/dbnms/datelist57.dbf	28,739	8	8.65	4.91	708	0	377	20.72
DATALIST	/oradata1/dbnms/datelist58.dbf	14,972	4	9.10	3.82	679	0	393	32.11
DATALIST	/oradata1/dbnms/datelist59.dbf	58,185	16	10.03	2.46	1,960	1	301	21.86
DATALIST	/oradata1/dbnms/datelist60.dbf	57,573	16	9.44	2.59	805	0	360	9.89
DATALIST	/oradata3/dbnms/datelist61.dbf	61,780	17	4.33	2.91	1,109	0	334	6.38
DATALIST	/oradata3/dbnms/datelist62.dbf	61,548	17	4.65	2.90	1,375	0	386	4.92
DATAPATH	/oradata1/dbnms/datapath01.dbf	213	0	11.27	1.66	5	0	0	0.00
DATAPATH	/oradata1/dbnms/datapath02.dbf	138	0	16.09	2.03	10	0	0	0.00
DATAPATH	/oradata1/dbnms/datapath03.dbf	195	0	12.15	2.51	2	0	0	0.00
DATAPATH	/oradata1/dbnms/datapath04.dbf	58	0	20.86	3.24	7	0	0	0.00
INDEXCFG	/oradata2/dbnms/indexcfg01.dbf	13,190	4	16.09	1.08	6,774	2	166	26.33
INDEXCFG	/oradata2/dbnms/indexcfg02.dbf	5,895	2	11.96	1.02	3,895	1	151	19.27
INDEXCFG	/oradata2/dbnms/indexcfg03.dbf	26,090	7	13.92	1.06	9,770	3	301	26.84
INDEXEXAM	/oradata2/dbnms/indexexam01.dbf	294	0	1.60	1.00	6	0	0	0.00
INDEXEXAM	/oradata2/dbnms/indexexam02.dbf	19	0	8.42	1.00	2	0	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux01.dbf	9,079	3	9.78	1.00	2,806	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux02.dbf	10,371	3	9.34	1.00	3,577	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux04.dbf	13,093	4	9.08	1.00	3,517	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux05.dbf	7,335	2	9.94	1.00	1,472	0	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux06.dbf	7,578	2	10.37	1.00	2,285	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux07.dbf	10,432	3	10.19	1.00	2,502	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux08.dbf	8,805	2	9.36	1.00	2,233	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux09.dbf	8,025	2	12.48	1.00	2,492	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux10.dbf	7,631	2	11.98	1.00	2,455	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux11.dbf	30,227	8	8.62	1.00	12,734	4	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux12.dbf	18,117	5	11.49	1.00	3,350	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux13.dbf	17,009	5	13.73	1.00	3,315	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux14.dbf	27,866	8	8.54	1.00	9,587	3	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux15.dbf	10,749	3	6.59	1.00	1,836	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux16.dbf	6,075	2	9.50	1.00	987	0	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux17.dbf	12,914	4	13.00	1.00	3,472	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux18.dbf	37,277	10	13.24	1.00	12,804	4	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux19.dbf	19,440	5	16.47	1.00	2,362	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux20.dbf	19,045	5	17.76	1.00	2,271	1	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux21.dbf	45,331	13	4.05	1.00	18,764	5	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux22.dbf	77,104	21	3.57	1.00	44,175	12	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux23.dbf	84,256	23	5.10	1.00	46,825	13	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux24.dbf	106,866	30	4.56	1.00	55,713	15	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux25.dbf	96,938	27	4.62	1.00	48,741	13	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux26.dbf	1,561	0	8.36	1.00	229	0	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux27.dbf	10,195	3	1.66	1.00	181	0	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux28.dbf	101,577	28	6.08	1.00	51,022	14	0	0.00
INDEXFLUX	/oradata2/dbnms/indexflux29.dbf	75,380	21	6.71	1.00	44,879	12	10	41.00
INDEXFLUX	/oradata3/dbnms/indexflux29.dbf	31,805	9	2.44	1.00	5,513	2	1	0.00
INDEXLIST	/oradata2/dbnms/indexlist01.dbf	11,314	3	15.66	1.00	4,967	1	14,455	18.83
INDEXLIST	/oradata2/dbnms/indexlist02.dbf	7,079	2	14.56	1.00	2,125	1	8,916	20.40
INDEXLIST	/oradata2/dbnms/indexlist03.dbf	10,347	3	11.49	1.00	5,845	2	7,704	18.85
INDEXLIST	/oradata2/dbnms/indexlist04.dbf	7,344	2	16.63	1.00	2,911	1	9,181	22.51
INDEXLIST	/oradata2/dbnms/indexlist05.dbf	5,000	1	20.09	1.00	417	0	9,336	20.22
INDEXLIST	/oradata3/dbnms/indexlist06.dbf	1,577	0	5.45	1.00	667	0	2,952	4.94
INDEXPATH	/oradata2/dbnms/indexpath01.dbf	114	0	21.23	1.00	24	0	0	0.00
INDEXPATH	/oradata2/dbnms/indexpath02.dbf	148	0	17.23	1.00	32	0	0	0.00
INDEXPATH	/oradata2/dbnms/indexpath03.dbf	185	0	15.30	1.00	43	0	0	0.00
SYSAUX	/oradata1/dbnms/sysaux01.dbf	3,961	1	8.22	1.10	985	0	0	0.00
SYSAUX	/oradata1/dbnms/sysaux02.dbf	2,375	1	4.73	1.01	149	0	0	0.00
SYSTEM	/oradata1/dbnms/system01.dbf	9,530	3	7.13	1.85	242	0	1,629	53.30
SYSTEM	/oradata1/dbnms/system02.dbf	6,859	2	4.17	2.25	174	0	0	0.00
TEMP	/oradata1/dbnms/temp01.dbf	6	0	3.33	1.00	0	0	0
TEMP	/oradata1/dbnms/temp02.dbf	6	0	1.67	1.00	0	0	0
UNDOTBS2	/oradata2/dbnms/undotbs03.dbf	116,802	32	9.87	1.00	31,225	9	680	7.85
UNDOTBS2	/oradata2/dbnms/undotbs04.dbf	13,311	4	7.15	1.00	2,765	1	61	7.21
USERS	/oradata1/dbnms/users01.dbf	16	0	4.38	1.00	2	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	253,952	100	-8,680,114,539	10,605,759	1,207,913	0	0	6,878,393

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	401	82	31471	343750	2551007	3502080	2551007
E	399	71	23052	303745	1976130	3502080	1976130

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	192	0.09	23,808	1.67	10,401,584,508
D	384	0.19	47,616	1.22	7,572,403,633
D	576	0.28	71,424	1.13	7,016,338,427
D	768	0.38	95,232	1.09	6,744,547,069
D	960	0.47	119,040	1.06	6,584,981,447
D	1,152	0.56	142,848	1.04	6,476,471,658
D	1,344	0.66	166,656	1.03	6,398,186,777
D	1,536	0.75	190,464	1.02	6,337,093,466
D	1,728	0.84	214,272	1.01	6,285,577,070
D	1,920	0.94	238,080	1.00	6,240,500,123
D	2,048	1.00	253,952	1.00	6,212,564,827
D	2,112	1.03	261,888	1.00	6,199,360,909
D	2,304	1.13	285,696	0.99	6,160,372,028
D	2,496	1.22	309,504	0.99	6,122,685,524
D	2,688	1.31	333,312	0.98	6,088,650,643
D	2,880	1.41	357,120	0.97	6,055,706,649
D	3,072	1.50	380,928	0.97	6,023,765,808
D	3,264	1.59	404,736	0.96	5,991,923,546
D	3,456	1.69	428,544	0.96	5,961,985,126
D	3,648	1.78	452,352	0.96	5,934,130,583
D	3,840	1.88	476,160	0.93	5,769,697,744

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	5,830	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	2,048	1,513	786.98	37.34	4.75	100.00	0.00	209,710
E	2,048	1,520	793.50	93.63	11.80	100.00	0.00	209,710

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	373,422	373,422
64K	128K	247	247
128K	256K	374	374
256K	512K	206	206
512K	1024K	2,374	2,374
1M	2M	1,678	1,678
2M	4M	28	28
4M	8M	11	11
8M	16M	34	34
16M	32M	17	17
32M	64M	4	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
256	0.13	6,095,799.78	352,013.32	95.00	9,848
512	0.25	6,095,799.78	116,485.96	98.00	0
1,024	0.50	6,095,799.78	112,369.53	98.00	0
1,536	0.75	6,095,799.78	112,369.53	98.00	0
2,048	1.00	6,095,799.78	96,576.12	98.00	0
2,458	1.20	6,095,799.78	96,576.12	98.00	0
2,867	1.40	6,095,799.78	96,576.12	98.00	0
3,277	1.60	6,095,799.78	96,576.12	98.00	0
3,686	1.80	6,095,799.78	96,576.12	98.00	0
4,096	2.00	6,095,799.78	96,576.12	98.00	0
6,144	3.00	6,095,799.78	96,576.12	98.00	0
8,192	4.00	6,095,799.78	96,576.12	98.00	0
12,288	6.00	6,095,799.78	96,576.12	98.00	0
16,384	8.00	6,095,799.78	96,576.12	98.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
1,008	0.49	246	28,022	41,005,052	0.99	7,552,643	1.07	3,930,875,763
1,216	0.59	452	46,787	41,220,002	0.99	7,337,693	1.04	3,941,796,095
1,424	0.70	659	63,958	41,302,490	1.00	7,255,205	1.03	3,946,211,475
1,632	0.80	866	83,306	41,382,453	1.00	7,175,242	1.01	3,951,996,712
1,840	0.90	1,073	101,793	41,441,247	1.00	7,116,448	1.01	3,957,734,960
2,048	1.00	1,280	120,068	41,484,294	1.00	7,073,401	1.00	3,963,315,581
2,256	1.10	1,487	137,509	41,568,747	1.00	6,988,948	0.99	3,970,672,501
2,464	1.20	1,694	156,359	41,712,245	1.01	6,845,450	0.97	3,979,113,668
2,672	1.30	1,901	174,635	41,808,425	1.01	6,749,270	0.95	3,986,155,767
2,880	1.41	2,108	193,140	41,933,919	1.01	6,623,776	0.94	3,993,016,605
3,088	1.51	2,315	212,945	42,004,805	1.01	6,552,890	0.93	3,998,671,018
3,296	1.61	2,522	229,752	42,069,510	1.01	6,488,185	0.92	4,004,361,681
3,504	1.71	2,727	249,659	42,147,487	1.02	6,410,208	0.91	4,011,443,254
3,712	1.81	2,932	268,594	42,210,203	1.02	6,347,492	0.90	4,018,473,394
3,920	1.91	3,139	287,582	42,281,503	1.02	6,276,192	0.89	4,027,039,418
4,128	2.02	3,346	307,149	42,338,098	1.02	6,219,597	0.88	4,036,030,208

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
undo header	692	4	6
1st level bmb	233	2	10
undo block	47	2	33
2nd level bmb	1	0	0
data block	6,861,614	-42,326,692	-6,169

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	11,012	11,013	8,999	7,608	845.43
UL-User-defined	14,757	14,757	1,117	445	398.03
RO-Multiple Object Reuse (fast object reuse)	324	324	35	11	307.54
SQ-Sequence Cache	2,932	2,932	89	3	29.04
JS-Job Scheduler (queue lock)	10,755	10,755	1	1	1,078.00
HW-Segment High Water Mark	5,519	5,519	6	0	36.17
KO-Multiple Object Checkpoint (fast object checkpoint)	36	36	4	0	30.25
FB-Format Block	1,234	1,234	1	0	2.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
5	98.15	182,635	8,702	354		0/0	0/0/0/75/53920/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
19-4月 08:57	15,897	24,096	3,928	321	1,225	0/0	0/0/0/9/6792/0
19-4月 08:47	13,774	22,674	3,321	316	1,221	0/0	0/0/0/15/10904/0
19-4月 08:37	26,305	42,054	8,702	326	1,219	0/0	0/0/0/40/22600/0
19-4月 08:27	13,590	52,522	8,095	336	1,222	0/0	0/0/0/1/2176/0
19-4月 08:17	13,926	23,504	7,488	342	1,219	0/0	0/0/0/7/8368/0
19-4月 08:07	14,658	17,785	6,881	354	1,215	0/0	0/0/0/3/3080/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
AWR Alerted Metric Element list	42,244	0.00		0	0
Consistent RBA	162,799	0.00	0.14	0	0
FIB s.o chain latch	180	0.00		0	0
FOB s.o list latch	52,659	0.00		0	0
In memory undo latch	10,704,505	0.02	0.02	2	165,360	0.00
JS mem alloc latch	6	0.00		0	0
JS queue access latch	6	0.00		0	0
JS queue state obj latch	21,510	0.00		0	0
JS slv state obj latch	197	0.00		0	0
KMG MMAN ready and startup request latch	1,202	0.00		0	0
KTF sga latch	10	0.00		0	1,215	0.00
KWQMN job cache list latch	1	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	0			0	1,202	0.00
OS process	14,751	0.00		0	0
OS process allocation	10,994	0.00		0	0
OS process: request allocation	9,474	0.00		0	0
PL/SQL warning settings	424,021	0.00		0	0
SQL memory manager latch	1	0.00		0	1,199	0.00
SQL memory manager workarea list latch	424,550	0.00	0.00	0	0
Shared B-Tree	129	0.00		0	0
Undo Hint Latch	0			0	71	0.00
active checkpoint queue latch	470,030	0.16	0.00	0	0
active service list	34,947	0.01	0.00	0	1,981	0.00
archive control	14	0.00		0	0
begin backup scn array	282	0.00		0	0
cache buffer handles	131,244	0.04	0.02	0	0
cache buffers chains	1,498,994,139	2.68	0.03	90006	25,637,702	0.25
cache buffers lru chain	3,743,528	0.24	0.01	0	39,692,553	0.35
cache table scan latch	0			0	724,560	0.26
channel handle pool latch	9,621	0.00		0	0
channel operations parent latch	34,651	0.00		0	0
checkpoint queue latch	3,016,890	0.01	0.01	0	1,199,723	0.01
client/application info	24,780	0.00		0	0
commit callback allocation	8	0.00		0	0
compile environment latch	683,209	0.00		0	0
dictionary lookup	44	0.00		0	0
dml lock allocation	716,830	0.08	0.04	1	0
dummy allocation	9,631	0.01	0.00	0	0
enqueue hash chains	1,717,835	0.02	0.09	2	17,845	0.02
enqueues	1,285,378	0.12	0.09	6	0
event group latch	4,721	0.00		0	0
file cache latch	1,691	0.00		0	0
global KZLD latch for mem in SGA	4,570	0.00		0	0
hash table column usage latch	974	0.00		0	5,066,332	0.00
hash table modification latch	144	0.00		0	0
job workq parent latch	0			0	201	0.50
job_queue_processes parameter latch	132	0.00		0	0
kks stats	775,258	2.08	0.91	699	0
ksuosstats global area	243	0.00		0	0
ktm global data	177	0.00		0	0
kwqbsn:qsga	129	0.00		0	0
lgwr LWN SCN	163,558	0.01	0.04	0	0
library cache	26,300,039	2.48	0.77	20248	906,328	10.07
library cache load lock	4,550	0.00		0	32	0.00
library cache lock	6,439,861	0.06	0.06	9	116	0.00
library cache lock allocation	88,494	0.00		0	0
library cache pin	15,800,676	0.05	0.07	13	3,627	0.03
library cache pin allocation	51,930	0.00		0	0
list of block allocation	83,182	0.00	0.50	0	0
loader state object freelist	91,933	0.00	1.00	0	0
longop free list parent	2,660	0.00		0	157	0.00
message pool operations parent latch	212	0.00		0	0
messages	1,471,673	0.27	0.00	0	0
mostly latch-free SCN	294,662	16.05	0.00	0	0
multiblock read objects	1,747,977	0.07	0.08	5	0
ncodef allocation latch	108	0.00		0	0
object queue header heap	32,130	0.00		0	31,841	0.00
object queue header operation	25,458,519	0.01	0.01	0	0
object stats modification	93	0.00		0	0
parallel query alloc buffer	480	0.00		0	0
parameter list	31,651	0.00		0	0
parameter table allocation management	4,838	0.93	0.91	7	0
post/wait queue	258,950	0.01	0.00	0	162,754	0.02
process allocation	9,474	0.04	0.25	0	4,720	0.02
process group creation	9,474	0.01	0.00	0	0
qmn task queue latch	516	0.00		0	0
redo allocation	825,206	0.19	0.01	0	6,843,734	0.40
redo copy	0			0	6,851,349	0.05
redo writing	1,003,142	0.05	0.01	0	0
resmgr group change latch	5,010	0.00		0	0
resmgr:actses active list	9,599	0.00		0	0
resmgr:actses change group	4,716	0.00		0	0
resmgr:free threads list	9,598	0.01	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	26,029,674	0.31	0.01	26	3,604	0.33
sequence cache	196,006	0.03	0.00	0	0
session allocation	1,769,878	0.11	0.03	0	0
session idle bit	13,622,983	0.01	0.17	1	0
session state list latch	3,938	0.00		0	0
session switching	108	0.00		0	0
session timer	1,980	0.00		0	0
shared pool	6,401,688	2.86	0.82	3184	0
simulator hash latch	230,778,891	0.01	0.01	0	0
simulator lru latch	227,128,300	6.83	0.03	26244	672,655	0.17
slave class	16	0.00		0	0
slave class create	64	1.56	1.00	0	0
sort extent pool	243	0.00		0	0
state object free list	12	0.00		0	0
statistics aggregation	112	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
temporary table state object allocation	8	0.00		0	0
threshold alerts latch	288	0.00		0	0
transaction allocation	2,808	0.00		0	0
transaction branch allocation	108	0.00		0	0
undo global data	51,739,301	70.34	0.11	253291	0
user lock	18,560	1.06	0.97	27	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	1,498,994,139	40,175,102	1,333,825	38,827,742
undo global data	51,739,301	36,392,557	4,109,862	32,305,929
simulator lru latch	227,128,300	15,520,844	464,807	15,060,320
library cache	26,300,039	652,793	501,273	179,979
shared pool	6,401,688	183,085	149,546	39,710
row cache objects	26,029,674	81,976	688	81,293
mostly latch-free SCN	294,662	47,295	41	47,254
simulator hash latch	230,778,891	31,461	162	31,302
kks stats	775,258	16,141	14,695	1,864
cache buffers lru chain	3,743,528	9,124	72	9,052
library cache pin	15,800,676	8,290	591	7,701
messages	1,471,673	4,036	17	4,019
library cache lock	6,439,861	3,583	229	3,354
object queue header operation	25,458,519	1,934	10	1,925
session allocation	1,769,878	1,880	49	1,831
In memory undo latch	10,704,505	1,705	30	1,676
redo allocation	825,206	1,563	16	1,547
enqueues	1,285,378	1,556	136	1,420
multiblock read objects	1,747,977	1,245	102	1,149
session idle bit	13,622,983	759	127	633
active checkpoint queue latch	470,030	733	2	731
dml lock allocation	716,830	578	23	555
redo writing	1,003,142	516	3	513
enqueue hash chains	1,717,835	400	37	363
checkpoint queue latch	3,016,890	214	2	212
user lock	18,560	196	190	9
cache buffer handles	131,244	51	1	50
parameter table allocation management	4,838	45	41	4
lgwr LWN SCN	163,558	23	1	22
Consistent RBA	162,799	7	1	6
process allocation	9,474	4	1	3
loader state object freelist	91,933	3	3	0
list of block allocation	83,182	2	1	1
slave class create	64	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	kturbk	12	22
In memory undo latch	kticmt: child	7	1
In memory undo latch	ktiFlush: child	6	2
In memory undo latch	ktichg: child	4	5
In memory undo latch	ktiTxnPoolFree	1	0
active checkpoint queue latch	kcbbacq: scan active checkpoints	2	2
cache buffer handles	kcbzgs	1	1
cache buffers chains	kcbgtcr: fast path	1,189,409	1,183,496
cache buffers chains	kcbgcur: kslbegin	81,526	176,074
cache buffers chains	kcbrls: kslbegin	49,881	54,886
cache buffers chains	kcbgtcr: kslbegin excl	40,385	35,087
cache buffers chains	kcbzib: multi-block read: nowait	33,282	0
cache buffers chains	kcbchg: kslbegin: bufs not pinned	30,108	6,273
cache buffers chains	kcbzwb	12,550	2,837
cache buffers chains	kcbzgb: scan from tail. nowait	11,292	0
cache buffers chains	kcbget: pin buffer	7,351	1,964
cache buffers chains	kcbbic1	5,307	412
cache buffers chains	kcbgtcr: kslbegin shared	1,492	31
cache buffers chains	kcbnew: new latch again	1,244	41
cache buffers chains	kcbbxsv	973	662
cache buffers chains	kcbchg: kslbegin: call CR func	720	2,615
cache buffers chains	kcbzib: finish free bufs	562	1,678
cache buffers chains	kcbnlc	337	225
cache buffers chains	kcbget: exchange rls	180	133
cache buffers chains	kcbbic2	170	132
cache buffers chains	kcbgtcr	169	0
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	119	0
cache buffers chains	kcbget: exchange	76	272
cache buffers chains	kcb_post_apply: kcbhq62	12	81
cache buffers chains	kcbzib: exchange rls	12	33
cache buffers chains	kcb_pre_apply: kcbhq61	10	84
cache buffers chains	kcbcge	7	126
cache buffers chains	kcb_is_private	6	471
cache buffers chains	kcbnew_1	5	10
cache buffers chains	kcbkzs	2	28
cache buffers chains	kcb_post_apply: kcbhq63	1	4
cache buffers lru chain	kcbzgws	52	0
cache buffers lru chain	kcbzar: KSLNBEGIN	9	0
cache buffers lru chain	kcbbxsv: move to being written	4	29
cache buffers lru chain	kcbkubc	3	40
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	2	0
cache buffers lru chain	kcbbic2	1	2
cache buffers lru chain	kcbzgm	1	0
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	2	0
cost function	kzulgt: find user res	107	115
cost function	kzulrl	83	75
dml lock allocation	ktaidm	15	10
dml lock allocation	ktaiam	8	13
enqueue hash chains	ksqgtl3	22	26
enqueue hash chains	ksqrcl	9	9
enqueue hash chains	ksqcmi: kslgpl	5	1
enqueue hash chains	ksqcmi: get hash chain latch after wait	1	1
enqueues	ksqies	59	69
enqueues	ksqgel: create enqueue	44	34
enqueues	ksqdel	33	33
kks stats	kks stats alloc/free	14,696	14,696
lgwr LWN SCN	kcs023	1	0
library cache	kglpndl: child: before processing	103,707	96,123
library cache	kglobpn: child:	34,542	54,176
library cache	kglukp: child	29,870	36,488
library cache	kglhdgn: child:	21,143	57,407
library cache	kglpin: child: heap processing	20,398	40,958
library cache	kglpnc: child	17,495	50,202
library cache	kglpndl: child: after processing	15,535	857
library cache	kgldti: 2child	15,266	11,711
library cache	kglic	12,011	28,888
library cache	kglpnp: child	10,669	20,073
library cache	kglpin	9,352	6,297
library cache	kglobld	5,223	7,190
library cache	kgldte: child 0	5,150	5,642
library cache	kglrtl	3,722	324
library cache	kglhdgc: child:	2,924	12,422
library cache	kglati	551	9
library cache	kgldtld: 2child	46	42
library cache	kglhdiv: child	21	2
library cache	kglini: child	14	7
library cache	kglivl: child	12	0
library cache	kglhdiv0: parent: invalidate	8	6
library cache	kglalt: child	1	2
library cache lock	kgllkdl: child: no lock handle	39,582	15,226
library cache lock	kgllkdl: child: cleanup	121	111
library cache lock	kgllkal: child: multiinstance	86	115
library cache lock	kglget: un-set reserved lock	19	0
library cache lock	kglpsl: child	3	3
library cache pin	kglpndl	277	152
library cache pin	kglpnal: child: alloc space	204	255
library cache pin	kglpnc: child	66	123
library cache pin	kglpnp: child	26	44
library cache pin	kgldnp: child	9	9
library cache pin	kglpnck	9	8
list of block allocation	ktlbbl	1	0
loader state object freelist	kcblfs	2	3
loader state object freelist	kcblgs	1	0
messages	ksarcv	7	3
messages	ksaamb: after wakeup	5	10
messages	ksarcv: after wait	5	4
mostly latch-free SCN	kcslcu3	40	42
mostly latch-free SCN	kcs024	1	0
mostly latch-free SCN	kcsnew_scn_rba	1	0
multiblock read objects	kcbzib: mbr get	54	45
multiblock read objects	kcbzib: normal mbr free	48	57
object queue header operation	kcbo_switch_cq	5	5
object queue header operation	kcbw_link_q	3	0
object queue header operation	kcbo_switch_q_bg	1	0
object queue header operation	kcbw_unlink_q	1	5
parameter table allocation management	ksp_param_table_free	41	41
process allocation	ksucrp	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	16	0
redo writing	kcrfwcr	2	2
redo writing	kcrfw_post: rba scn pair	1	0
row cache objects	kqreqd: reget	543	3
row cache objects	kqrpre: find obj	104	651
row cache objects	kqrso	19	13
row cache objects	kqreqd	18	17
session allocation	ksuxds: not user session	21	12
session allocation	ksucri	20	30
session allocation	ksuxds: KSUSFCLC not set	6	1
session allocation	ksudlc	1	3
session allocation	ksuprc	1	2
session idle bit	ksupuc: set busy	87	34
session idle bit	ksupuc: clear busy	33	82
session idle bit	ksuxds	9	13
shared pool	kghfrunp: clatch: nowait	119,613	0
shared pool	kghalo	76,376	60,842
shared pool	kghupr1	35,470	65,184
shared pool	kghfrunp: clatch: wait	34,463	57,260
shared pool	kghfrunp: alloc: wait	24,736	9,647
shared pool	kghfre	11,737	12,552
shared pool	kghalp	1,201	1,309
shared pool	kghasp	39	30
shared pool	kghfen: not perm alloc class	4	0
shared pool	kghfrh	1	0
simulator hash latch	kcbsacc: lookup dba	151	149
simulator hash latch	kcbs_lookup_setid: lookup dba	4	0
simulator hash latch	kcbsacc: insert dba	4	0
simulator hash latch	kcbsacc: remove dba	2	7
simulator hash latch	kcbs_get_or_extract_simbufseq	1	6
simulator lru latch	kcbs_simulate: simulate set	463,534	463,577
simulator lru latch	kcbs_simbufseq	1,096	1,104
simulator lru latch	kcbs_lookup_setid	51	0
slave class create	ksvcreate	1	0
undo global data	ktudba: KSLBEGIN	4,094,419	4,102,580
undo global data	kturimugur: child	10,114	743
undo global data	ktubnd:child	411	17
undo global data	ktudnx:child	410	468
undo global data	ktusmasp: ktugd_tuux	284	64
undo global data	ktusmupst: KSLBEGIN	102	15
undo global data	ktufrbs: child	45	655
undo global data	ktumof: KSLBEGIN	41	2
undo global data	ktusm_stealext: KSLBEGIN	31	3
undo global data	ktucof: at start	28	2
undo global data	ktugnb: KSLBEGIN	23	7
undo global data	kturar: KSLBEGIN	4	1

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: 5,097,482,882
Captured Segments account for 14.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
FJSLVIEW	DATACFG	VLANPORT		TABLE	341,626,384	6.70
FJSLVIEW	DATACFG	VLAN		TABLE	119,543,744	2.35
FJSLVIEW	INDEXCFG	PK_RES		INDEX	57,455,040	1.13
FJSLVIEW	DATAFLUX	FLUXD	P_20120430	TABLE PARTITION	28,096,160	0.55
FJSLVIEW	DATACFG	RES		TABLE	26,916,672	0.53

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 11,079,220
Captured Segments account for 89.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
FJSLVIEW	DATAFLUX	FLUXH	P_20120430	TABLE PARTITION	3,654,902	32.99
FJSLVIEW	DATALIST	PK_RESMONIHOURLYINFO	P_20120421	INDEX PARTITION	1,526,767	13.78
FJSLVIEW	DATALIST	ALARMSUMMARY		TABLE	1,343,551	12.13
FJSLVIEW	DATAFLUX	FLUX	P_20120421	TABLE PARTITION	1,047,928	9.46
FJSLVIEW	INDEXFLUX	PK_FLUX	P_20120421	INDEX PARTITION	641,009	5.79

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_ALERT_INFO		TABLE	16,012	78.85
FJSLVIEW	DATALIST	RESMONICURINFO		TABLE	1,942	9.56
FJSLVIEW	DATACFG	NCO_STATUS		TABLE	1,872	9.22
FJSLVIEW	INDEXFLUX	PK_FLUX	P_20120421	INDEX PARTITION	138	0.68
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	9050_42776	INDEX PARTITION	74	0.36

Back to Segment Statistics
Back to Top

Segments by ITL Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
FJSLVIEW	DATALIST	PK_RESMONIRAWINFO	P_20120419	INDEX PARTITION	5	100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
FJSLVIEW	DATACFG	VLANPORT	TABLE	4,091,048	61.87
FJSLVIEW	DATACFG	VLAN	TABLE	2,507,333	37.92
FJSLVIEW	DATACFG	PPINFO	TABLE	4,164	0.06
FJSLVIEW	DATACFG	PPEXTINFO	TABLE	3,536	0.05
FJSLVIEW	DATACFG	PORTINFO	TABLE	2,670	0.04

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	93	0.00	2	1
dc_files	3,410	0.00	0	155
dc_global_oids	15,363	0.07	0	30
dc_histogram_data	3,104,656	0.05	0	2,558
dc_histogram_defs	1,267,423	0.24	0	2,941
dc_object_grants	1,028	0.39	0	21
dc_object_ids	2,678,180	0.03	0	960
dc_objects	335,057	0.10	74	891
dc_profiles	4,673	0.00	0	1
dc_rollback_segments	61,942	0.00	0	565
dc_segments	297,266	0.85	314	2,121
dc_sequences	12,698	0.03	12,698	5
dc_tablespace_quotas	274	0.36	274	4
dc_tablespaces	909,593	0.00	0	16
dc_usernames	10,569	0.03	0	8
dc_users	2,059,939	0.00	0	19
outstanding_alerts	106	25.47	0	15

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	849	0.82	751,271	-0.00	9	0
CLUSTER	76	2.63	161	1.24	0	0
INDEX	38,417	0.11	331,831	0.02	11	0
PIPE	281,917	0.00	344,000	0.00	0	0
SQL AREA	191,191	99.55	4,392,544	8.71	2,597	135
TABLE/PROCEDURE	39,713	1.12	1,958,908	0.11	885	0
TRIGGER	224	2.68	233,365	0.01	22	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	365.92		0.77	1.07	22	37	475	475
	Freeable	346.69	0.00	0.85	0.53	8		407	407
	SQL	86.60	76.04	0.19	2.88	61	64	454	435
	PL/SQL	16.61	9.96	0.04	0.05	1	1	469	469
E	Other	340.01		0.78	1.20	22	37	435	435
	Freeable	308.69	0.00	0.86	0.65	8		359	359
	SQL	122.30	111.98	0.30	2.94	39	64	412	391
	PL/SQL	15.37	8.88	0.04	0.05	1	1	429	429

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	2,147,483,648
Fixed Size	2,086,600
Redo Buffers	4,325,376
Variable Size	4,288,555,320

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	128.00	128.00	0.00
large	free memory	1,024.00	1,024.00	0.00
shared	ASH buffers	29.00	29.00	0.00
shared	CCursor	285.16	275.41	-3.42
shared	CURSOR STATS	27.23	27.23	0.00
shared	Checkpoint queue	19.54	19.54	0.00
shared	PCursor	171.65	167.76	-2.26
shared	free memory	185.93	205.34	10.44
shared	kglsim heap	30.70	30.70	0.00
shared	kglsim object batch	73.81	73.81	0.00
shared	library cache	157.46	155.47	-1.26
shared	sql area	779.00	775.19	-0.49
	buffer_cache	2,048.00	2,048.00	0.00
	fixed_sga	1.99	1.99	0.00
	log_buffer	4.13	4.13	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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams 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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/admin/dbnms/adump
background_dump_dest	/oracle/admin/dbnms/bdump
compatible	10.2.0.1.0
control_files	/oradata1/dbnms/control01.ctl, /oradata1/dbnms/control02.ctl, /oradata1/dbnms/control03.ctl
core_dump_dest	/oracle/admin/dbnms/cdump
db_block_size	8192
db_cache_size	2147483648
db_domain
db_file_multiblock_read_count	16
db_files	2000
db_name	dbnms
db_recovery_file_dest	/oracle/flash_recovery_area
db_recovery_file_dest_size	2147483648
db_writer_processes	10
dispatchers	(PROTOCOL=TCP)(DISPATCHERS=5)
fast_start_mttr_target	3600
java_pool_size	134217728
job_queue_processes	10
large_pool_size	1073741824
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=218.85.155.2)(PORT=1529))
lock_sga	FALSE
log_archive_dest_1	location=/oradata1/arch
max_dispatchers	5
max_dump_file_size	6000m
max_shared_servers	500
open_cursors	300
optimizer_features_enable	8.1.7
optimizer_mode	CHOOSE
pga_aggregate_target	2147483648
processes	2000
remote_login_passwordfile	EXCLUSIVE
session_cached_cursors	200
sessions	2205
sga_max_size	6442450944
shared_pool_size	2147483648
shared_servers	0
sort_area_size	1024000
undo_management	AUTO
undo_tablespace	UNDOTBS2
user_dump_dest	/oracle/admin/dbnms/udump

End of Report

% Blocks changed per Read:	0.25	Recursive Call %:	28.69
Rollback per transaction %:	1.47	Rows per Sort:	4.14

Buffer Nowait %:	99.87	Redo NoWait %:	100.00
Buffer Hit %:	99.80	In-memory Sort %:	100.00
Library Hit %:	95.20	Soft Parse %:	88.91
Execute to Parse %:	51.80	Latch Hit %:	95.69
Parse CPU to Parse Elapsd %:	10.11	% Non-Parse CPU:	95.16