WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

HOTEL 4285105488 hotel 1 10.2.0.4.0 NO hotel

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
HOTEL	4285105488	hotel	1	10.2.0.4.0	NO	hotel

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 31215 21-Nov-13 09:00:12 35 1.8

End Snap: 31216 21-Nov-13 10:00:37 28 1.8

Elapsed: 60.42 (mins)

DB Time: 361.12 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	31215	21-Nov-13 09:00:12	35	1.8
End Snap:	31216	21-Nov-13 10:00:37	28	1.8
Elapsed:		60.42 (mins)
DB Time:		361.12 (mins)

Report Summary

Cache Sizes

Begin End

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

Shared Pool Size: 512M 512M Log Buffer: 14,308K

	Begin	End
Buffer Cache:	19,920M	19,920M	Std Block Size:	8K
Shared Pool Size:	512M	512M	Log Buffer:	14,308K

Load Profile

Per Second Per Transaction

Redo size: 3,421.67 23,314.54

Logical reads: 14,434.34 98,352.51

Block changes: 14.93 101.73

Physical reads: 330.34 2,250.85

Physical writes: 3.32 22.62

User calls: 19.12 130.27

Parses: 13.33 90.80

Hard parses: 0.39 2.64

Sorts: 13.55 92.30

Logons: 1.13 7.73

Executes: 13.85 94.36

Transactions: 0.15

	Per Second	Per Transaction
Redo size:	3,421.67	23,314.54
Logical reads:	14,434.34	98,352.51
Block changes:	14.93	101.73
Physical reads:	330.34	2,250.85
Physical writes:	3.32	22.62
User calls:	19.12	130.27
Parses:	13.33	90.80
Hard parses:	0.39	2.64
Sorts:	13.55	92.30
Logons:	1.13	7.73
Executes:	13.85	94.36
Transactions:	0.15

% Blocks changed per Read: 0.10 Recursive Call %: 87.27

Rollback per transaction %: 0.00 Rows per Sort: 24.63

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.87 Redo NoWait %: 100.00

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

Library Hit %: 95.17 Soft Parse %: 97.09

Execute to Parse %: 3.77 Latch Hit %: 99.98

Parse CPU to Parse Elapsd %: 9.95 % Non-Parse CPU: 98.52

Shared Pool Statistics

Begin End

Memory Usage %: 74.09 71.53

% SQL with executions>1: 51.01 61.65

% Memory for SQL w/exec>1: 50.68 54.14

	Begin	End
Memory Usage %:	74.09	71.53
% SQL with executions>1:	51.01	61.65
% Memory for SQL w/exec>1:	50.68	54.14

Top 5 Timed Events

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

db file sequential read 1,077,673 17,117 16 79.0 User I/O

read by other session 67,303 3,327 49 15.4 User I/O

db file parallel read 4,117 734 178 3.4 User I/O

control file parallel write 1,230 394 320 1.8 System I/O

CPU time 272 1.3

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	1,077,673	17,117	16	79.0	User I/O
read by other session	67,303	3,327	49	15.4	User I/O
db file parallel read	4,117	734	178	3.4	User I/O
control file parallel write	1,230	394	320	1.8	System I/O
CPU time		272		1.3

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): 21667.3s
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	21,577.33	99.58
DB CPU	272.02	1.26
parse time elapsed	62.37	0.29
hard parse elapsed time	51.79	0.24
connection management call elapsed time	29.85	0.14
PL/SQL compilation elapsed time	2.58	0.01
PL/SQL execution elapsed time	2.38	0.01
sequence load elapsed time	0.03	0.00
hard parse (sharing criteria) elapsed time	0.03	0.00
repeated bind elapsed time	0.01	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
DB time	21,667.30
background elapsed time	1,747.88
background cpu time	4.27

Back to Wait Events Statistics
Back to Top

Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
User I/O	1,149,144	0.00	21,183	18	2,160.05
System I/O	6,408	0.00	644	100	12.05
Commit	313	1.60	78	248	0.59
Other	160	2.50	2	14	0.30
Network	102,156	0.00	2	0	192.02
Concurrency	2,615	1.41	1	0	4.92
Configuration	1	0.00	0	12	0.00

Back to Wait Events Statistics
Back to Top

Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file sequential read	1,077,673	0.00	17,117	16	2,025.70
read by other session	67,303	0.00	3,327	49	126.51
db file parallel read	4,117	0.00	734	178	7.74
control file parallel write	1,230	0.00	394	320	2.31
log file parallel write	1,185	0.00	246	208	2.23
log file sync	313	1.60	78	248	0.59
db file scattered read	31	0.00	5	151	0.06
control file sequential read	3,993	0.00	3	1	7.51
enq: CF - contention	2	0.00	1	583	0.00
latch free	110	0.00	1	9	0.21
SQL*Net more data from client	12,407	0.00	1	0	23.32
latch: shared pool	55	0.00	1	10	0.10
SQL*Net more data to client	22,408	0.00	1	0	42.12
cursor: pin S wait on X	43	86.05	0	8	0.08
latch: cache buffers chains	2,467	0.00	0	0	4.64
SQL*Net message to client	67,341	0.00	0	0	126.58
SGA: allocation forcing component growth	7	57.14	0	11	0.01
os thread startup	2	0.00	0	33	0.00
enq: SQ - contention	1	0.00	0	12	0.00
latch: row cache objects	17	0.00	0	0	0.03
cursor: pin S	34	0.00	0	0	0.06
latch: library cache	28	0.00	0	0	0.05
latch: cache buffers lru chain	3	0.00	0	0	0.01
direct path write	17	0.00	0	0	0.03
latch: session allocation	1	0.00	0	0	0.00
buffer busy waits	1	0.00	0	0	0.00
latch: library cache lock	1	0.00	0	0	0.00
latch: object queue header operation	2	0.00	0	0	0.00
LGWR wait for redo copy	1	0.00	0	0	0.00
cursor: mutex X	1	0.00	0	0	0.00
direct path read	3	0.00	0	0	0.01
SQL*Net message from client	67,341	0.00	15,425	229	126.58
Streams AQ: waiting for time management or cleanup tasks	3	66.67	3,639	1212842	0.01
Streams AQ: qmn slave idle wait	128	0.00	3,512	27441	0.24
Streams AQ: qmn coordinator idle wait	272	52.94	3,512	12913	0.51
virtual circuit status	120	100.00	3,491	29088	0.23
jobq slave wait	1,163	94.67	3,369	2897	2.19
class slave wait	2	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
control file parallel write	1,230	0.00	394	320	2.31
log file parallel write	1,185	0.00	246	208	2.23
control file sequential read	2,482	0.00	3	1	4.67
db file sequential read	93	0.00	3	28	0.17
events in waitclass Other	7	0.00	1	167	0.01
db file scattered read	1	0.00	0	122	0.00
os thread startup	2	0.00	0	33	0.00
latch: shared pool	1	0.00	0	0	0.00
direct path write	1	0.00	-0	-0	0.00
rdbms ipc message	12,876	96.56	39,511	3069	24.20
Streams AQ: waiting for time management or cleanup tasks	3	66.67	3,639	1212842	0.01
pmon timer	1,618	100.00	3,532	2183	3.04
Streams AQ: qmn slave idle wait	128	0.00	3,512	27441	0.24
Streams AQ: qmn coordinator idle wait	272	52.94	3,512	12913	0.51
smon timer	12	91.67	3,118	259793	0.02

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	51,434
IDLE_TIME	5,729,676
IOWAIT_TIME	1,593,968
NICE_TIME	48
SYS_TIME	21,266
USER_TIME	29,763
LOAD	0
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,756,807,168
NUM_CPUS	16
NUM_CPU_SOCKETS	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
hotel	20,230.90	240.20	1,192,422	51,967,905
SYS$USERS	1,479.30	31.90	7,259	322,692
SYS$BACKGROUND	0.00	0.00	515	40,463
hotelXDB	0.00	0.00	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
hotel	1141950	1992221	1865	46	61531	142
SYS$USERS	7257	122908	743	55	24411	7
SYS$BACKGROUND	660	4615	3	7	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
6,332	0	0		29.22	b47pf01mbzz28	w3wp.exe	Select count(*) From T_PERSON ...
1,894	1	1	1893.51	8.74	3sbwvxg10smmb	w3wp.exe	Select count(*) From T_PERSON ...
1,347	1	1	1346.52	6.21	ahjxy7q4j91sx	w3wp.exe	Select * From ( Select tmp.*,...
1,285	0	1	1285.33	5.93	1br9z2p12pnk3	w3wp.exe	Select count(*) From T_PERSON ...
1,264	0	1	1263.82	5.83	79k5kbgp7nvc8	w3wp.exe	Select count(*) From T_PERSON ...
1,133	0	1	1132.89	5.23	ftzvdr06xr0zr	w3wp.exe	Select count(*) From T_PERSON ...
1,090	1	448	2.43	5.03	fr8u9audf7j2u		INSERT INTO SCOPER_HOTEL.T_PER...
815	0	1	814.86	3.76	4kswq7cmr4v66	w3wp.exe	Select count(*) From T_PERSON_...
723	0	1	722.80	3.34	9wamwn1vmzsk0	w3wp.exe	Select count(*) From T_PERSON ...
462	0	1	461.73	2.13	92uuqhkracav5	w3wp.exe	Select count(*) From T_PERSON ...
343	0	1	343.39	1.58	0mrhrs5qux378	w3wp.exe	Select * From ( Select tmp.*,...
300	0	2	149.76	1.38	cv95x4q9tdxqg	w3wp.exe	Select count(*) From T_PERSON ...
291	0	1	291.00	1.34	d5czpk12vawwc	w3wp.exe	Select count(*) From T_PERSON ...

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
6	6	4,077	0.00	0.03	0k8522rmdzg4k		select privilege# from sysauth...
5	5	16,242	0.00	0.02	0h6b2sajwb74n		select privilege#, level from ...
3	3	4	0.75	0.01	3qtfppqz6pag0	w3wp.exe	Select Count(*) From T_PERSON ...
2	4	1	2.44	0.02	ck8kwa8f5yqbk	w3wp.exe	Select count(*) From T_PERSON ...
2	2	5	0.46	0.01	g3tzv66s52azr	w3wp.exe	Select Count(*) From T_PERSON ...
2	2	2	1.08	0.01	5kzff83x974x4	w3wp.exe	Select count(*) From t_person ...
2	2	4,014	0.00	0.01	459f3z9u4fb3u		select value$ from props$ wher...
2	2	4,014	0.00	0.01	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
2	2	3	0.58	0.01	c5g9gb1pj8x1h	w3wp.exe	Select Count(*) From T_PERSON ...
2	2	3	0.57	0.01	g72yr3kzcksas	w3wp.exe	Select Count(*) From T_PERSON ...
1	1,894	1	0.81	8.74	3sbwvxg10smmb	w3wp.exe	Select count(*) From T_PERSON ...
1	1,090	448	0.00	5.03	fr8u9audf7j2u		INSERT INTO SCOPER_HOTEL.T_PER...
1	1,347	1	0.57	6.21	ahjxy7q4j91sx	w3wp.exe	Select * From ( Select tmp.*,...
0	1,285	1	0.32	5.93	1br9z2p12pnk3	w3wp.exe	Select count(*) From T_PERSON ...
0	815	1	0.32	3.76	4kswq7cmr4v66	w3wp.exe	Select count(*) From T_PERSON_...
0	6,332	0		29.22	b47pf01mbzz28	w3wp.exe	Select count(*) From T_PERSON ...
0	300	2	0.10	1.38	cv95x4q9tdxqg	w3wp.exe	Select count(*) From T_PERSON ...
0	343	1	0.05	1.58	0mrhrs5qux378	w3wp.exe	Select * From ( Select tmp.*,...
0	1,133	1	0.04	5.23	ftzvdr06xr0zr	w3wp.exe	Select count(*) From T_PERSON ...
0	291	1	0.02	1.34	d5czpk12vawwc	w3wp.exe	Select count(*) From T_PERSON ...
0	723	1	0.02	3.34	9wamwn1vmzsk0	w3wp.exe	Select count(*) From T_PERSON ...
0	1,264	1	0.02	5.83	79k5kbgp7nvc8	w3wp.exe	Select count(*) From T_PERSON ...
0	462	1	0.01	2.13	92uuqhkracav5	w3wp.exe	Select count(*) From T_PERSON ...

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: 52,323,535
Captured SQL account for 15.7% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
522,259	0		1.00	0.26	6331.57	b47pf01mbzz28	w3wp.exe	Select count(*) From T_PERSON ...
486,247	4	121,561.75	0.93	2.98	2.99	3qtfppqz6pag0	w3wp.exe	Select Count(*) From T_PERSON ...
416,286	5	83,257.20	0.80	2.32	2.32	g3tzv66s52azr	w3wp.exe	Select Count(*) From T_PERSON ...
413,469	1	413,469.00	0.79	2.44	3.77	ck8kwa8f5yqbk	w3wp.exe	Select count(*) From T_PERSON ...
359,106	1	359,106.00	0.69	0.81	1893.51	3sbwvxg10smmb	w3wp.exe	Select count(*) From T_PERSON ...
294,011	1	294,011.00	0.56	0.57	1346.52	ahjxy7q4j91sx	w3wp.exe	Select * From ( Select tmp.*,...
253,236	2	126,618.00	0.48	1.10	1.15	2w5cbm30mqmd7	w3wp.exe	Select count(*) From t_person ...
253,235	2	126,617.50	0.48	1.10	1.12	bsxknqz9x5j1b	w3wp.exe	Select count(*) From t_person ...
253,220	2	126,610.00	0.48	1.09	1.09	6xz17w31bf8p2	w3wp.exe	Select count(*) From t_person ...
253,220	2	126,610.00	0.48	1.09	1.09	740qw6ydthxp1	w3wp.exe	Select count(*) From t_person ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 1,197,450
Captured SQL account for 64.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
291,291	1	291,291.00	24.33	0.81	1893.51	3sbwvxg10smmb	w3wp.exe	Select count(*) From T_PERSON ...
131,984	1	131,984.00	11.02	0.57	1346.52	ahjxy7q4j91sx	w3wp.exe	Select * From ( Select tmp.*,...
130,009	1	130,009.00	10.86	0.32	814.86	4kswq7cmr4v66	w3wp.exe	Select count(*) From T_PERSON_...
49,060	0		4.10	0.26	6331.57	b47pf01mbzz28	w3wp.exe	Select count(*) From T_PERSON ...
33,575	1	33,575.00	2.80	0.05	343.39	0mrhrs5qux378	w3wp.exe	Select * From ( Select tmp.*,...
21,981	1	21,981.00	1.84	0.05	64.85	cm5w9jj1f0wws	w3wp.exe	Select count(*) From t_person ...
19,521	1	19,521.00	1.63	0.05	92.67	3ppv13zqs22zd	w3wp.exe	Select count(*) From t_person ...
16,997	1	16,997.00	1.42	0.04	138.18	bgz2bmwbbrsjg	w3wp.exe	Select count(*) From T_PERSON ...
14,834	1	14,834.00	1.24	0.03	85.59	1crrry115k0ws	w3wp.exe	Select count(*) From t_person ...
13,730	1	13,730.00	1.15	0.04	137.85	akr02cq8v8q0b	w3wp.exe	Select * From ( Select tmp.*,...
13,660	1	13,660.00	1.14	0.09	64.19	g1haqzub5wgqm	w3wp.exe	Select count(*) From T_PERSON ...
13,540	1	13,540.00	1.13	0.32	1285.33	1br9z2p12pnk3	w3wp.exe	Select count(*) From T_PERSON ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 50,198
Captured SQL account for 77.6% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
16,242	97,774	6.02	0.00	0h6b2sajwb74n		select privilege#, level from ...
4,077	16,242	3.98	0.00	0k8522rmdzg4k		select privilege# from sysauth...
4,014	4,011	1.00	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
4,014	4,014	1.00	0.00	459f3z9u4fb3u		select value$ from props$ wher...
4,014	4,014	1.00	0.00	5ur69atw3vfhj		select decode(failover_method,...
1,938	1,938	1.00	0.00	fqfnds38yj4v7		SELECT MAX(KEY) AS LAST_RZSJ F...
448	1,039	2.32	2.43	fr8u9audf7j2u		INSERT INTO SCOPER_HOTEL.T_PER...
426	426	1.00	0.00	3c1kubcdjnppq		update sys.col_usage$ set eq...
422	422	1.00	0.00	2ym6hhaq30r73		select type#, blocks, extents,...
238	90,440	380.00	0.00	3nz260v5dwqnv	PL/SQL Developer	select value from v$sesstat wh...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 48,308
Captured SQL account for 79.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
16,242	16,242	33.62	0h6b2sajwb74n		select privilege#, level from ...
4,077	4,077	8.44	0k8522rmdzg4k		select privilege# from sysauth...
4,014	4,014	8.31	459f3z9u4fb3u		select value$ from props$ wher...
4,014	4,014	8.31	5ur69atw3vfhj		select decode(failover_method,...
4,013	4,014	8.31	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
1,938	1,938	4.01	fqfnds38yj4v7		SELECT MAX(KEY) AS LAST_RZSJ F...
448	448	0.93	fr8u9audf7j2u		INSERT INTO SCOPER_HOTEL.T_PER...
422	422	0.87	2ym6hhaq30r73		select type#, blocks, extents,...
238	238	0.49	3nz260v5dwqnv	PL/SQL Developer	select value from v$sesstat wh...
238	238	0.49	9m7787camwh4m	PL/SQL Developer	begin :id := sys.dbms_transact...

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

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

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

0mrhrs5qux378 Select * From ( Select tmp.*, RowNum rnum From ( Select t.LKBM, t.XM, t.CSRQ, t.MZ, t.XB, t.ZJLX, t.ZJHM, t.RZFH, t.MC, t.RZSJ From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '621122%' Order By t.RZSJ DESC )tmp Where RowNum <= 15 ) outer_wrapper Where rnum >= 1

0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

1br9z2p12pnk3 Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '6210%' And t.RZFH = '6404' And t.RZSJ Between '201208170124' And '201208172324' And t.MC LIKE '%金源酒店%'

1crrry115k0ws Select count(*) From t_person Where LGBM = '6211240007' And CSSJ Between '201311010000' And '201311212400'

2w5cbm30mqmd7 Select count(*) From t_person Where LGBM = '6211210013' And CSSJ Between '201311180000' And '201311212400'

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

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

3nz260v5dwqnv select value from v$sesstat where sid = :sid order by statistic#

3ppv13zqs22zd Select count(*) From t_person Where LGBM = '6211240006' And CSSJ Between '201311010000' And '201311212400'

3qtfppqz6pag0 Select Count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620723%' And t.RZSJ Between '201311180907' And '201311210907' And t.LGBM = '6207230005'

3sbwvxg10smmb Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '6209%' And t.MC = '电力宾馆'

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

4kswq7cmr4v66 Select count(*) From T_PERSON_HIS t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '6209%' And t.RZFH = '108' And t.MC = '天骄宾馆一分店'

5kzff83x974x4 Select count(*) From t_person Where LGBM = '6211210082' And CSSJ Between '201311180000' And '201311212400'

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

6xz17w31bf8p2 Select count(*) From t_person Where LGBM = '6211210077' And CSSJ Between '201311180000' And '201311212400'

740qw6ydthxp1 Select count(*) From t_person Where LGBM = '6211210073' And CSSJ Between '201311180000' And '201311212400'

79k5kbgp7nvc8 Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '6210%' And t.RZFH = '8403' And t.RZSJ Between '201209150155' And '201209152355' And t.MC LIKE '%嘉嘉宾馆%'

92uuqhkracav5 Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620623%'

9m7787camwh4m begin :id := sys.dbms_transaction.local_transaction_id; end;

9wamwn1vmzsk0 Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '621122%'

ahjxy7q4j91sx Select * From ( Select tmp.*, RowNum rnum From ( Select t.LKBM, t.XM, t.CSRQ, t.MZ, t.XB, t.ZJLX, t.ZJHM, t.RZFH, t.MC, t.RZSJ From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620623%' Order By t.RZSJ DESC )tmp Where RowNum <= 15 ) outer_wrapper Where rnum >= 1

akr02cq8v8q0b Select * From ( Select tmp.*, RowNum rnum From ( Select t.LKBM, t.XM, t.CSRQ, t.MZ, t.XB, t.ZJLX, t.ZJHM, t.RZFH, t.MC, t.RZSJ From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '621122%' And t.LGBM = '6211220105' Order By t.RZSJ DESC )tmp Where RowNum <= 15 ) outer_wrapper Where rnum >= 1

b47pf01mbzz28 Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620802%' And t.SSXQ = '620802'

bgz2bmwbbrsjg Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '62%' And t.RZFH = '9315' And t.RZSJ Between '201309112244' And '201310112244' And t.MC = '西部宾馆'

bsxknqz9x5j1b Select count(*) From t_person Where LGBM = '6211210014' And CSSJ Between '201311180000' And '201311212400'

c5g9gb1pj8x1h Select Count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620723%' And t.RZSJ Between '201311190907' And '201311210907' And t.LGBM = '6207230003'

ck8kwa8f5yqbk Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620602%' And t.XB = '1' And t.CSRQ Between '19500101' And '19681130' And t.RZSJ Between '201311151012' And '201311211012'

cm5w9jj1f0wws Select count(*) From t_person Where LGBM = '6211240012' And CSSJ Between '201311010000' And '201311212400'

cv95x4q9tdxqg Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '6202%' And t.RZSJ Between '201311110917' And '201311120917' And t.LGBM = '6202000139'

d5czpk12vawwc Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '6202%' And t.RZSJ Between '201311120912' And '201311130912' And t.LGBM = '6202000139'

fqfnds38yj4v7 SELECT MAX(KEY) AS LAST_RZSJ FROM T_PERSON

fr8u9audf7j2u INSERT INTO SCOPER_HOTEL.T_PERSON (LKBM, XM, XB, MZ, CSRQ, ZJLX, ZJHM, SSXQ, XZ, RZSJ, RZFH, TFSJ, CSSJ, XYKLX, XYKHM, SCBZ, SLSJ, SLR, PYM, WBM, GNSJZT, LGBM, MC, GAJG, ZPWJCD, SFTD, TDLB, RS, TDLXR, LXRDH, DWMC, TDRZSY, ZPST, BDZT, RKSJ1, RKSJ2, KEY) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37)

ftzvdr06xr0zr Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '62%' And t.RZFH = '101' And t.RZSJ Between '201303171832' And '201303181832'

g1haqzub5wgqm Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '62%' And t.RZFH = '101' And t.RZSJ Between '201303171832' And '201303181832' And t.MC = '铜都宾馆'

g3tzv66s52azr Select Count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620602%' And t.XB = '1' And t.RZSJ Between '201311180958' And '201311200958' And t.LGBM = '6206020021'

g72yr3kzcksas Select Count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '622922%' And t.RZSJ Between '201311200000' And '201311210928' And t.LGBM = '6229220016'

SQL Id	SQL Text
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0mrhrs5qux378	Select * From ( Select tmp.*, RowNum rnum From ( Select t.LKBM, t.XM, t.CSRQ, t.MZ, t.XB, t.ZJLX, t.ZJHM, t.RZFH, t.MC, t.RZSJ From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '621122%' Order By t.RZSJ DESC )tmp Where RowNum <= 15 ) outer_wrapper Where rnum >= 1
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1br9z2p12pnk3	Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '6210%' And t.RZFH = '6404' And t.RZSJ Between '201208170124' And '201208172324' And t.MC LIKE '%金源酒店%'
1crrry115k0ws	Select count(*) From t_person Where LGBM = '6211240007' And CSSJ Between '201311010000' And '201311212400'
2w5cbm30mqmd7	Select count(*) From t_person Where LGBM = '6211210013' And CSSJ Between '201311180000' And '201311212400'
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
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3nz260v5dwqnv	select value from v$sesstat where sid = :sid order by statistic#
3ppv13zqs22zd	Select count(*) From t_person Where LGBM = '6211240006' And CSSJ Between '201311010000' And '201311212400'
3qtfppqz6pag0	Select Count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620723%' And t.RZSJ Between '201311180907' And '201311210907' And t.LGBM = '6207230005'
3sbwvxg10smmb	Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '6209%' And t.MC = '电力宾馆'
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4kswq7cmr4v66	Select count(*) From T_PERSON_HIS t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '6209%' And t.RZFH = '108' And t.MC = '天骄宾馆一分店'
5kzff83x974x4	Select count(*) From t_person Where LGBM = '6211210082' And CSSJ Between '201311180000' And '201311212400'
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6xz17w31bf8p2	Select count(*) From t_person Where LGBM = '6211210077' And CSSJ Between '201311180000' And '201311212400'
740qw6ydthxp1	Select count(*) From t_person Where LGBM = '6211210073' And CSSJ Between '201311180000' And '201311212400'
79k5kbgp7nvc8	Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '6210%' And t.RZFH = '8403' And t.RZSJ Between '201209150155' And '201209152355' And t.MC LIKE '%嘉嘉宾馆%'
92uuqhkracav5	Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620623%'
9m7787camwh4m	begin :id := sys.dbms_transaction.local_transaction_id; end;
9wamwn1vmzsk0	Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '621122%'
ahjxy7q4j91sx	Select * From ( Select tmp.*, RowNum rnum From ( Select t.LKBM, t.XM, t.CSRQ, t.MZ, t.XB, t.ZJLX, t.ZJHM, t.RZFH, t.MC, t.RZSJ From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620623%' Order By t.RZSJ DESC )tmp Where RowNum <= 15 ) outer_wrapper Where rnum >= 1
akr02cq8v8q0b	Select * From ( Select tmp.*, RowNum rnum From ( Select t.LKBM, t.XM, t.CSRQ, t.MZ, t.XB, t.ZJLX, t.ZJHM, t.RZFH, t.MC, t.RZSJ From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '621122%' And t.LGBM = '6211220105' Order By t.RZSJ DESC )tmp Where RowNum <= 15 ) outer_wrapper Where rnum >= 1
b47pf01mbzz28	Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620802%' And t.SSXQ = '620802'
bgz2bmwbbrsjg	Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '62%' And t.RZFH = '9315' And t.RZSJ Between '201309112244' And '201310112244' And t.MC = '西部宾馆'
bsxknqz9x5j1b	Select count(*) From t_person Where LGBM = '6211210014' And CSSJ Between '201311180000' And '201311212400'
c5g9gb1pj8x1h	Select Count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620723%' And t.RZSJ Between '201311190907' And '201311210907' And t.LGBM = '6207230003'
ck8kwa8f5yqbk	Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620602%' And t.XB = '1' And t.CSRQ Between '19500101' And '19681130' And t.RZSJ Between '201311151012' And '201311211012'
cm5w9jj1f0wws	Select count(*) From t_person Where LGBM = '6211240012' And CSSJ Between '201311010000' And '201311212400'
cv95x4q9tdxqg	Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '6202%' And t.RZSJ Between '201311110917' And '201311120917' And t.LGBM = '6202000139'
d5czpk12vawwc	Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '6202%' And t.RZSJ Between '201311120912' And '201311130912' And t.LGBM = '6202000139'
fqfnds38yj4v7	SELECT MAX(KEY) AS LAST_RZSJ FROM T_PERSON
fr8u9audf7j2u	INSERT INTO SCOPER_HOTEL.T_PERSON (LKBM, XM, XB, MZ, CSRQ, ZJLX, ZJHM, SSXQ, XZ, RZSJ, RZFH, TFSJ, CSSJ, XYKLX, XYKHM, SCBZ, SLSJ, SLR, PYM, WBM, GNSJZT, LGBM, MC, GAJG, ZPWJCD, SFTD, TDLB, RS, TDLXR, LXRDH, DWMC, TDRZSY, ZPST, BDZT, RKSJ1, RKSJ2, KEY) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37)
ftzvdr06xr0zr	Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '62%' And t.RZFH = '101' And t.RZSJ Between '201303171832' And '201303181832'
g1haqzub5wgqm	Select count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '62%' And t.RZFH = '101' And t.RZSJ Between '201303171832' And '201303181832' And t.MC = '铜都宾馆'
g3tzv66s52azr	Select Count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '620602%' And t.XB = '1' And t.RZSJ Between '201311180958' And '201311200958' And t.LGBM = '6206020021'
g72yr3kzcksas	Select Count(*) From T_PERSON t, t_hotel b Where t.lgbm=b.lgbm And b.ssgajg LIKE '622922%' And t.RZSJ Between '201311200000' And '201311210928' And t.LGBM = '6229220016'

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	26,709	7.37	50.20
CPU used when call started	26,600	7.34	50.00
CR blocks created	1,136	0.31	2.14
Cached Commit SCN referenced	940	0.26	1.77
Commit SCN cached	1	0.00	0.00
DB time	2,899,758	799.95	5,450.67
DBWR checkpoint buffers written	10,508	2.90	19.75
DBWR checkpoints	0	0.00	0.00
DBWR transaction table writes	86	0.02	0.16
DBWR undo block writes	606	0.17	1.14
IMU CR rollbacks	31	0.01	0.06
IMU Flushes	112	0.03	0.21
IMU Redo allocation size	1,263,424	348.54	2,374.86
IMU commits	421	0.12	0.79
IMU contention	0	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	2	0.00	0.00
IMU undo allocation size	3,385,360	933.91	6,363.46
IMU- failed to get a private strand	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	51,096	14.10	96.05
active txn count during cleanout	1,471	0.41	2.77
application wait time	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	12,538	3.46	23.57
branch node splits	1	0.00	0.00
buffer is not pinned count	50,532,742	13,940.32	94,986.36
buffer is pinned count	162,687,010	44,879.99	305,802.65
bytes received via SQL*Net from client	38,633,106	10,657.60	72,618.62
bytes sent via SQL*Net to client	80,606,889	22,236.79	151,516.71
calls to get snapshot scn: kcmgss	107,433	29.64	201.94
calls to kcmgas	2,934	0.81	5.52
calls to kcmgcs	356	0.10	0.67
change write time	53	0.01	0.10
cleanout - number of ktugct calls	1,892	0.52	3.56
cleanouts and rollbacks - consistent read gets	1,030	0.28	1.94
cleanouts only - consistent read gets	173	0.05	0.33
cluster key scan block gets	8,788	2.42	16.52
cluster key scans	3,108	0.86	5.84
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	696	0.19	1.31
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	14,686	4.05	27.61
commit cleanouts successfully completed	13,990	3.86	26.30
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	2,479	0.68	4.66
concurrency wait time	108	0.03	0.20
consistent changes	2,996	0.83	5.63
consistent gets	52,238,875	14,410.99	98,193.37
consistent gets - examination	1,345,681	371.23	2,529.48
consistent gets direct	21	0.01	0.04
consistent gets from cache	52,238,854	14,410.98	98,193.33
current blocks converted for CR	1	0.00	0.00
cursor authentications	426	0.12	0.80
data blocks consistent reads - undo records applied	2,853	0.79	5.36
db block changes	54,123	14.93	101.73
db block gets	84,660	23.35	159.14
db block gets direct	70	0.02	0.13
db block gets from cache	84,590	23.34	159.00
deferred (CURRENT) block cleanout applications	8,927	2.46	16.78
dirty buffers inspected	1,442	0.40	2.71
enqueue conversions	743	0.20	1.40
enqueue releases	45,018	12.42	84.62
enqueue requests	45,019	12.42	84.62
enqueue timeouts	1	0.00	0.00
enqueue waits	3	0.00	0.01
execute count	50,198	13.85	94.36
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	1,208,278	333.32	2,271.20
free buffer requested	1,199,331	330.86	2,254.38
heap block compress	81	0.02	0.15
hot buffers moved to head of LRU	977,857	269.76	1,838.08
immediate (CR) block cleanout applications	1,203	0.33	2.26
immediate (CURRENT) block cleanout applications	492	0.14	0.92
index crx upgrade (positioned)	2,509	0.69	4.72
index fast full scans (full)	54	0.01	0.10
index fetch by key	850,288	234.57	1,598.29
index scans kdiixs1	117,465	32.40	220.80
leaf node 90-10 splits	28	0.01	0.05
leaf node splits	124	0.03	0.23
lob reads	178	0.05	0.33
lob writes	674	0.19	1.27
lob writes unaligned	229	0.06	0.43
logons cumulative	4,112	1.13	7.73
messages received	6,275	1.73	11.80
messages sent	6,275	1.73	11.80
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	50,866,537	14,032.40	95,613.79
opened cursors cumulative	50,691	13.98	95.28
parse count (failures)	0	0.00	0.00
parse count (hard)	1,406	0.39	2.64
parse count (total)	48,308	13.33	90.80
parse time cpu	402	0.11	0.76
parse time elapsed	4,039	1.11	7.59
physical read IO requests	1,197,071	330.23	2,250.13
physical read bytes	9,809,510,400	2,706,121.10	18,438,929.32
physical read total IO requests	1,201,221	331.38	2,257.93
physical read total bytes	9,876,012,544	2,724,466.86	18,563,933.35
physical read total multi block requests	49	0.01	0.09
physical reads	1,197,450	330.34	2,250.85
physical reads cache	1,197,432	330.33	2,250.81
physical reads cache prefetch	117,794	32.50	221.42
physical reads direct	18	0.00	0.03
physical reads direct (lob)	3	0.00	0.01
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	10,858	3.00	20.41
physical write bytes	98,582,528	27,195.68	185,305.50
physical write total IO requests	15,787	4.36	29.67
physical write total bytes	172,035,584	47,458.96	323,375.16
physical write total multi block requests	1,307	0.36	2.46
physical writes	12,034	3.32	22.62
physical writes direct	70	0.02	0.13
physical writes direct (lob)	15	0.00	0.03
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	11,964	3.30	22.49
physical writes non checkpoint	6,726	1.86	12.64
pinned buffers inspected	1	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	3,598	0.99	6.76
recursive calls	474,913	131.01	892.69
recursive cpu usage	1,555	0.43	2.92
redo blocks written	25,449	7.02	47.84
redo buffer allocation retries	0	0.00	0.00
redo entries	31,013	8.56	58.30
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	537	0.15	1.01
redo size	12,403,336	3,421.67	23,314.54
redo subscn max counts	1,407	0.39	2.64
redo synch time	7,955	2.19	14.95
redo synch writes	272	0.08	0.51
redo wastage	315,708	87.09	593.44
redo write time	24,955	6.88	46.91
redo writer latching time	0	0.00	0.00
redo writes	1,184	0.33	2.23
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	89	0.02	0.17
rows fetched via callback	458,666	126.53	862.15
session connect time	0	0.00	0.00
session cursor cache hits	19,480	5.37	36.62
session logical reads	52,323,535	14,434.34	98,352.51
session pga memory	97,293,544	26,840.09	182,882.60
session pga memory max	317,428,968	87,568.21	596,670.99
session uga memory	###############	73,490,171.67	500,746,281.88
session uga memory max	1,175,735,064	324,346.61	2,210,028.32
shared hash latch upgrades - no wait	2,941	0.81	5.53
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	49,102	13.55	92.30
sorts (rows)	1,209,520	333.67	2,273.53
sql area evicted	2,334	0.64	4.39
sql area purged	0	0.00	0.00
summed dirty queue length	2,111	0.58	3.97
switch current to new buffer	12	0.00	0.02
table fetch by rowid	106,127,518	29,277.09	199,487.82
table fetch continued row	190	0.05	0.36
table scan blocks gotten	102,221	28.20	192.14
table scan rows gotten	4,182,352	1,153.77	7,861.56
table scans (long tables)	0	0.00	0.00
table scans (short tables)	10,168	2.81	19.11
total number of times SMON posted	1	0.00	0.00
transaction rollbacks	0	0.00	0.00
transaction tables consistent read rollbacks	2	0.00	0.00
transaction tables consistent reads - undo records applied	12	0.00	0.02
undo change vector size	3,604,016	994.23	6,774.47
user I/O wait time	2,114,777	583.40	3,975.14
user calls	69,303	19.12	130.27
user commits	532	0.15	1.00
workarea executions - optimal	19,711	5.44	37.05
write clones created in foreground	10	0.00	0.02

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	324,250	352,221
opened cursors current	64	51
logons current	35	28

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
HOTEL_DATA_DX	443,252	122	6.34	1.00	43	0	5	104.00
HOTEL_DATA_JQ	313,308	86	8.82	1.00	79	0	118	73.31
HOTEL_DATA_WW	134,268	37	11.62	1.00	71	0	0	0.00
HOTEL_DATA_JQ_2010	128,912	36	6.38	1.00	0	0	0	0.00
HOTEL_DATA_PL	48,308	13	63.69	1.00	29	0	62,517	49.41
HOTEL_IND	23,812	7	99.44	1.00	3,326	1	3,380	67.58
HOTEL_DATA_ZY	26,805	7	25.53	1.00	30	0	82	72.56
HOTEL_DATA_BY	23,874	7	20.27	1.00	49	0	107	57.20
HOTEL_DATA_QY	23,233	6	24.35	1.00	70	0	1	100.00
HOTEL_DATA	4,359	1	152.25	1.00	6,099	2	10	77.00
HOTEL_DATA_LXZ	9,583	3	57.51	1.00	28	0	400	67.70
HOTEL_DATA_TS	7,148	2	73.92	1.00	52	0	67	67.91
HOTEL_DATA_LN	4,836	1	21.09	1.00	31	0	32	82.19
HOTEL_DATA_JYG	4,101	1	103.16	1.00	36	0	419	67.33
HOTEL_DATA_JC	1,497	0	105.82	1.00	32	0	2	45.00
HOTEL_DATA_GN	1,441	0	116.72	1.00	7	0	173	61.16
SYSAUX	331	0	87.04	1.01	584	0	0	0.00
SYSTEM	468	0	120.92	1.02	97	0	0	0.00
HOTEL_DATA_LZ	239	0	96.49	1.00	0	0	0	0.00
UNDOTBS02	5	0	118.00	1.00	195	0	0	0.00
YZ_DATA	22	0	56.82	1.00	9	0	0	0.00
HOTEL_DICTIONARY	8	0	370.00	2.88	0	0	0	0.00
YZ_DATA_YZJBXX	8	0	102.50	1.00	0	0	0	0.00
YZ_DATA_DWXX	7	0	82.86	1.00	0	0	0	0.00
YZ_DATA_KKYZBL	6	0	71.67	1.00	0	0	0	0.00
HOTEL_DATA_DX_2010	5	0	226.00	1.00	0	0	0	0.00
HOTEL_DATA_FOREIGN	3	0	250.00	1.00	2	0	0	0.00
HOTEL_DATA_US	4	0	282.50	7.25	0	0	0	0.00
HOTEL_DATA_WW_2010	4	0	247.50	1.00	0	0	0	0.00
YZ_DATA_CJZTYMXX	4	0	225.00	1.00	0	0	0	0.00
YZ_DATA_PBYMXX	4	0	212.50	1.00	0	0	0	0.00
YZ_DATA_ZTYMXX	4	0	225.00	1.00	0	0	0	0.00
HOTEL_DATA_QY_2010	3	0	196.67	1.00	0	0	0	0.00
HOTEL_DATA_TS_2010	3	0	133.33	1.00	0	0	0	0.00
HOTEL_DATA_ZY_2010	3	0	210.00	1.00	0	0	0	0.00
YZ_DATA_CARD	3	0	166.67	1.00	0	0	0	0.00
YZ_DATA_CJYZXX	3	0	250.00	1.00	0	0	0	0.00
YZ_DATA_FJTP	3	0	236.67	1.00	0	0	0	0.00
YZ_DATA_FRWDWXX	3	0	266.67	1.00	0	0	0	0.00
YZ_DATA_FRWYZJBXX	3	0	283.33	1.00	0	0	0	0.00
YZ_DATA_RWKXX	3	0	286.67	1.00	0	0	0	0.00
YZ_DATA_YZBGSL	3	0	216.67	1.00	0	0	0	0.00
HOTEL_DATA_BYK	2	0	245.00	1.00	0	0	0	0.00
HOTEL_DATA_BY_2008	2	0	310.00	1.00	0	0	0	0.00
HOTEL_DATA_BY_2009	2	0	180.00	1.00	0	0	0	0.00
HOTEL_DATA_BY_2010	2	0	305.00	1.00	0	0	0	0.00
HOTEL_DATA_BY_2011	2	0	280.00	1.00	0	0	0	0.00
HOTEL_DATA_BY_2012	2	0	185.00	1.00	0	0	0	0.00
HOTEL_DATA_CALL	2	0	230.00	1.00	0	0	0	0.00
HOTEL_DATA_DX_2008	2	0	180.00	1.00	0	0	0	0.00
HOTEL_DATA_DX_2009	2	0	220.00	1.00	0	0	0	0.00
HOTEL_DATA_DX_2011	2	0	175.00	1.00	0	0	0	0.00
HOTEL_DATA_DX_2012	2	0	245.00	1.00	0	0	0	0.00
HOTEL_DATA_GNZ_2008	2	0	265.00	1.00	0	0	0	0.00
HOTEL_DATA_GNZ_2009	2	0	205.00	1.00	0	0	0	0.00
HOTEL_DATA_GNZ_2010	2	0	130.00	1.00	0	0	0	0.00
HOTEL_DATA_GNZ_2011	2	0	175.00	1.00	0	0	0	0.00
HOTEL_DATA_GNZ_2012	2	0	200.00	1.00	0	0	0	0.00
HOTEL_DATA_INFORMATION	2	0	280.00	1.00	0	0	0	0.00
HOTEL_DATA_JC_2008	2	0	145.00	1.00	0	0	0	0.00
HOTEL_DATA_JC_2009	2	0	255.00	1.00	0	0	0	0.00
HOTEL_DATA_JC_2010	2	0	255.00	1.00	0	0	0	0.00
HOTEL_DATA_JC_2011	2	0	245.00	1.00	0	0	0	0.00
HOTEL_DATA_JC_2012	2	0	195.00	1.00	0	0	0	0.00
HOTEL_DATA_JQ_2008	2	0	160.00	1.00	0	0	0	0.00
HOTEL_DATA_JQ_2009	2	0	255.00	1.00	0	0	0	0.00
HOTEL_DATA_JQ_2011	2	0	255.00	1.00	0	0	0	0.00
HOTEL_DATA_JQ_2012	2	0	130.00	1.00	0	0	0	0.00
HOTEL_DATA_LN_2008	2	0	145.00	1.00	0	0	0	0.00
HOTEL_DATA_LN_2009	2	0	210.00	1.00	0	0	0	0.00
HOTEL_DATA_LN_2010	2	0	250.00	1.00	0	0	0	0.00
HOTEL_DATA_LN_2011	2	0	230.00	1.00	0	0	0	0.00
HOTEL_DATA_LN_2012	2	0	140.00	1.00	0	0	0	0.00
HOTEL_DATA_LXZ_2008	2	0	160.00	1.00	0	0	0	0.00
HOTEL_DATA_LXZ_2009	2	0	235.00	1.00	0	0	0	0.00
HOTEL_DATA_LXZ_2010	2	0	290.00	1.00	0	0	0	0.00
HOTEL_DATA_LXZ_2011	2	0	290.00	1.00	0	0	0	0.00
HOTEL_DATA_LXZ_2012	2	0	235.00	1.00	0	0	0	0.00
HOTEL_DATA_LZ_2008	2	0	235.00	1.00	0	0	0	0.00
HOTEL_DATA_LZ_2009	2	0	250.00	1.00	0	0	0	0.00
HOTEL_DATA_LZ_2010	2	0	215.00	1.00	0	0	0	0.00
HOTEL_DATA_LZ_2011	2	0	240.00	1.00	0	0	0	0.00
HOTEL_DATA_LZ_2012	2	0	270.00	1.00	0	0	0	0.00
HOTEL_DATA_PL_2008	2	0	135.00	1.00	0	0	0	0.00
HOTEL_DATA_PL_2009	2	0	165.00	1.00	0	0	0	0.00
HOTEL_DATA_PL_2010	2	0	205.00	1.00	0	0	0	0.00
HOTEL_DATA_PL_2011	2	0	225.00	1.00	0	0	0	0.00
HOTEL_DATA_PL_2012	2	0	160.00	1.00	0	0	0	0.00
HOTEL_DATA_QY_2008	2	0	135.00	1.00	0	0	0	0.00
HOTEL_DATA_QY_2009	2	0	215.00	1.00	0	0	0	0.00
HOTEL_DATA_QY_2011	2	0	220.00	1.00	0	0	0	0.00
HOTEL_DATA_QY_2012	2	0	205.00	1.00	0	0	0	0.00
HOTEL_DATA_TS_2008	2	0	245.00	1.00	0	0	0	0.00
HOTEL_DATA_TS_2009	2	0	180.00	1.00	0	0	0	0.00
HOTEL_DATA_TS_2011	2	0	205.00	1.00	0	0	0	0.00
HOTEL_DATA_TS_2012	2	0	165.00	1.00	0	0	0	0.00
HOTEL_DATA_WW_2008	2	0	170.00	1.00	0	0	0	0.00
HOTEL_DATA_WW_2009	2	0	195.00	1.00	0	0	0	0.00
HOTEL_DATA_WW_2011	2	0	100.00	1.00	0	0	0	0.00
HOTEL_DATA_WW_2012	2	0	245.00	1.00	0	0	0	0.00
HOTEL_DATA_ZY_2008	2	0	150.00	1.00	0	0	0	0.00
HOTEL_DATA_ZY_2009	2	0	120.00	1.00	0	0	0	0.00
HOTEL_DATA_ZY_2011	2	0	235.00	1.00	0	0	0	0.00
HOTEL_DATA_ZY_2012	2	0	215.00	1.00	0	0	0	0.00
USERS	2	0	180.00	1.00	0	0	0	0.00
YZ_DATA_BMFP	2	0	265.00	1.00	0	0	0	0.00
YZ_DATA_CYRY	2	0	185.00	1.00	0	0	0	0.00
YZ_DATA_DJWDXX	2	0	205.00	1.00	0	0	0	0.00
YZ_DATA_GNMKXX	2	0	205.00	1.00	0	0	0	0.00
YZ_DATA_GWGLXX	2	0	185.00	1.00	0	0	0	0.00
YZ_DATA_SPDWXX	2	0	215.00	1.00	0	0	0	0.00
YZ_DATA_YH	2	0	220.00	1.00	0	0	0	0.00
YZ_DATA_YZWMFP	2	0	255.00	1.00	0	0	0	0.00
YZ_DATA_ZZDWXX	2	0	200.00	1.00	0	0	0	0.00
YZ_DICTIONARY	2	0	235.00	1.00	0	0	0	0.00
YZ_IND	2	0	310.00	1.00	0	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
HOTEL_DATA	/u02/oradata8/hotel/datafile/hotel_data.dbf	1,438	0	166.48	1.00	1,200	0	0	0.00
HOTEL_DATA	/u02/oradata8/hotel/datafile/hotel_data0.dbf	2,030	1	149.80	1.00	2,788	1	10	77.00
HOTEL_DATA	/u02/oradata8/hotel/datafile/hotel_data1.dbf	891	0	134.85	1.00	2,111	1	0	0.00
HOTEL_DATA_BY	/u02/oradata4/hotel/datafile/hotel_data_by0.dbf	11,559	3	33.55	1.00	11	0	0	0.00
HOTEL_DATA_BY	/u02/oradata4/hotel/datafile/hotel_data_by1.dbf	12,315	3	7.80	1.00	38	0	107	57.20
HOTEL_DATA_BYK	/u02/oradata5/hotel/datafile/hotel_data_byk.dbf	2	0	245.00	1.00	0	0	0	0.00
HOTEL_DATA_BY_2008	/u02/oradata2/hotel/datafile/hotel_data_by2008.dbf	2	0	310.00	1.00	0	0	0	0.00
HOTEL_DATA_BY_2009	/u02/oradata2/hotel/datafile/hotel_data_by2009.dbf	2	0	180.00	1.00	0	0	0	0.00
HOTEL_DATA_BY_2010	/u02/oradata2/hotel/datafile/hotel_data_by2010.dbf	2	0	305.00	1.00	0	0	0	0.00
HOTEL_DATA_BY_2011	/u02/oradata2/hotel/datafile/hotel_data_by2011.dbf	2	0	280.00	1.00	0	0	0	0.00
HOTEL_DATA_BY_2012	/u02/oradata2/hotel/datafile/hotel_data_by2012.dbf	2	0	185.00	1.00	0	0	0	0.00
HOTEL_DATA_CALL	/u02/oradata5/hotel/datafile/hotel_data_call.dbf	2	0	230.00	1.00	0	0	0	0.00
HOTEL_DATA_DX	/u02/oradata4/hotel/datafile/hotel_data_dx0.dbf	260,085	72	6.18	1.00	1	0	0	0.00
HOTEL_DATA_DX	/u02/oradata4/hotel/datafile/hotel_data_dx1.dbf	183,167	51	6.58	1.00	42	0	5	104.00
HOTEL_DATA_DX_2008	/u02/oradata2/hotel/datafile/hotel_data_dx2008.dbf	2	0	180.00	1.00	0	0	0	0.00
HOTEL_DATA_DX_2009	/u02/oradata2/hotel/datafile/hotel_data_dx2009.dbf	2	0	220.00	1.00	0	0	0	0.00
HOTEL_DATA_DX_2010	/u02/oradata2/hotel/datafile/hotel_data_dx2010.dbf	5	0	226.00	1.00	0	0	0	0.00
HOTEL_DATA_DX_2011	/u02/oradata2/hotel/datafile/hotel_data_dx2011.dbf	2	0	175.00	1.00	0	0	0	0.00
HOTEL_DATA_DX_2012	/u02/oradata2/hotel/datafile/hotel_data_dx2012.dbf	2	0	245.00	1.00	0	0	0	0.00
HOTEL_DATA_FOREIGN	/u02/oradata6/hotel/datafile/hotel_data_foreign0.dbf	3	0	250.00	1.00	2	0	0	0.00
HOTEL_DATA_GN	/u02/oradata1/hotel/datafile/hotel_data_gn0.dbf	1,441	0	116.72	1.00	7	0	173	61.16
HOTEL_DATA_GNZ_2008	/u02/oradata2/hotel/datafile/hotel_data_gnz2008.dbf	2	0	265.00	1.00	0	0	0	0.00
HOTEL_DATA_GNZ_2009	/u02/oradata2/hotel/datafile/hotel_data_gnz2009.dbf	2	0	205.00	1.00	0	0	0	0.00
HOTEL_DATA_GNZ_2010	/u02/oradata2/hotel/datafile/hotel_data_gnz2010.dbf	2	0	130.00	1.00	0	0	0	0.00
HOTEL_DATA_GNZ_2011	/u02/oradata2/hotel/datafile/hotel_data_gnz2011.dbf	2	0	175.00	1.00	0	0	0	0.00
HOTEL_DATA_GNZ_2012	/u02/oradata2/hotel/datafile/hotel_data_gnz2012.dbf	2	0	200.00	1.00	0	0	0	0.00
HOTEL_DATA_INFORMATION	/u02/oradata5/hotel/datafile/hotel_data_information0	2	0	280.00	1.00	0	0	0	0.00
HOTEL_DATA_JC	/u02/oradata1/hotel/datafile/hotel_data_jc0.dbf	1,497	0	105.82	1.00	32	0	2	45.00
HOTEL_DATA_JC_2008	/u02/oradata2/hotel/datafile/hotel_data_jc2008.dbf	2	0	145.00	1.00	0	0	0	0.00
HOTEL_DATA_JC_2009	/u02/oradata2/hotel/datafile/hotel_data_jc2009.dbf	2	0	255.00	1.00	0	0	0	0.00
HOTEL_DATA_JC_2010	/u02/oradata2/hotel/datafile/hotel_data_jc.2010.dbf	2	0	255.00	1.00	0	0	0	0.00
HOTEL_DATA_JC_2011	/u02/oradata2/hotel/datafile/hotel_data_jc2011.dbf	2	0	245.00	1.00	0	0	0	0.00
HOTEL_DATA_JC_2012	/u02/oradata2/hotel/datafile/hotel_data_jc2012.dbf	2	0	195.00	1.00	0	0	0	0.00
HOTEL_DATA_JQ	/u02/oradata1/hotel/datafile/hotel_data_jq0.dbf	159,752	44	8.25	1.00	0	0	0	0.00
HOTEL_DATA_JQ	/u02/oradata1/hotel/datafile/hotel_data_jq1.dbf	131,992	36	9.75	1.00	0	0	109	72.75
HOTEL_DATA_JQ	/u02/oradata1/hotel/datafile/hotel_data_jq2.dbf	21,564	6	7.29	1.00	79	0	9	80.00
HOTEL_DATA_JQ_2008	/u02/oradata2/hotel/datafile/hotel_data_jq2008.dbf	2	0	160.00	1.00	0	0	0	0.00
HOTEL_DATA_JQ_2009	/u02/oradata2/hotel/datafile/hotel_data_jq2009.dbf	2	0	255.00	1.00	0	0	0	0.00
HOTEL_DATA_JQ_2010	/u02/oradata2/hotel/datafile/hotel_data_jq2010.dbf	128,912	36	6.38	1.00	0	0	0	0.00
HOTEL_DATA_JQ_2011	/u02/oradata2/hotel/datafile/hotel_data_jq2011.dbf	2	0	255.00	1.00	0	0	0	0.00
HOTEL_DATA_JQ_2012	/u02/oradata2/hotel/datafile/hotel_data_jq2012.dbf	2	0	130.00	1.00	0	0	0	0.00
HOTEL_DATA_JYG	/u02/oradata2/hotel/datafile/hotel_data_jyg0.dbf	4,089	1	103.30	1.00	36	0	419	67.33
HOTEL_DATA_JYG	/u02/oradata2/hotel/datafile/hotel_data_jyg1.dbf	12	0	55.00	1.00	0	0	0	0.00
HOTEL_DATA_LN	/u02/oradata4/hotel/datafile/hotel_data_ln0.dbf	4,836	1	21.09	1.00	31	0	32	82.19
HOTEL_DATA_LN_2008	/u02/oradata2/hotel/datafile/hotel_data_ln2008.dbf	2	0	145.00	1.00	0	0	0	0.00
HOTEL_DATA_LN_2009	/u02/oradata2/hotel/datafile/hotel_data_ln2009.dbf	2	0	210.00	1.00	0	0	0	0.00
HOTEL_DATA_LN_2010	/u02/oradata2/hotel/datafile/hotel_data_ln2010.dbf	2	0	250.00	1.00	0	0	0	0.00
HOTEL_DATA_LN_2011	/u02/oradata2/hotel/datafile/hotel_data_ln2011.dbf	2	0	230.00	1.00	0	0	0	0.00
HOTEL_DATA_LN_2012	/u02/oradata2/hotel/datafile/hotel_data_ln2012.dbf	2	0	140.00	1.00	0	0	0	0.00
HOTEL_DATA_LXZ	/u02/oradata2/hotel/datafile/hotel_data_lxz0.dbf	8,943	2	55.00	1.00	27	0	400	67.70
HOTEL_DATA_LXZ	/u02/oradata2/hotel/datafile/hotel_data_lxz1.dbf	640	0	92.58	1.00	1	0	0	0.00
HOTEL_DATA_LXZ_2008	/u02/oradata2/hotel/datafile/hotel_data_lxz2008.dbf	2	0	160.00	1.00	0	0	0	0.00
HOTEL_DATA_LXZ_2009	/u02/oradata2/hotel/datafile/hotel_data_lxz2009.dbf	2	0	235.00	1.00	0	0	0	0.00
HOTEL_DATA_LXZ_2010	/u02/oradata2/hotel/datafile/hotel_data_lxz2010.dbf	2	0	290.00	1.00	0	0	0	0.00
HOTEL_DATA_LXZ_2011	/u02/oradata2/hotel/datafile/hotel_data_lxz2011.dbf	2	0	290.00	1.00	0	0	0	0.00
HOTEL_DATA_LXZ_2012	/u02/oradata2/hotel/datafile/hotel_data_lxz2012.dbf	2	0	235.00	1.00	0	0	0	0.00
HOTEL_DATA_LZ	/u02/oradata2/hotel/datafile/hotel_data_lz0.dbf	239	0	96.49	1.00	0	0	0	0.00
HOTEL_DATA_LZ_2008	/u02/oradata2/hotel/datafile/hotel_data_lz2008.dbf	2	0	235.00	1.00	0	0	0	0.00
HOTEL_DATA_LZ_2009	/u02/oradata2/hotel/datafile/hotel_data_lz2009.dbf	2	0	250.00	1.00	0	0	0	0.00
HOTEL_DATA_LZ_2010	/u02/oradata2/hotel/datafile/hotel_data_lz2010.dbf	2	0	215.00	1.00	0	0	0	0.00
HOTEL_DATA_LZ_2011	/u02/oradata2/hotel/datafile/hotel_data_lz2011.dbf	2	0	240.00	1.00	0	0	0	0.00
HOTEL_DATA_LZ_2012	/u02/oradata2/hotel/datafile/hotel_data_lz2012.dbf	2	0	270.00	1.00	0	0	0	0.00
HOTEL_DATA_PL	/u02/oradata3/hotel/datafile/hotel_data_pl0.dbf	43,788	12	64.17	1.00	0	0	56,742	49.76
HOTEL_DATA_PL	/u02/oradata3/hotel/datafile/hotel_data_pl1.dbf	4,520	1	59.07	1.00	29	0	5,775	45.94
HOTEL_DATA_PL_2008	/u02/oradata2/hotel/datafile/hotel_data_pl2008.dbf	2	0	135.00	1.00	0	0	0	0.00
HOTEL_DATA_PL_2009	/u02/oradata2/hotel/datafile/hotel_data_pl2009.dbf	2	0	165.00	1.00	0	0	0	0.00
HOTEL_DATA_PL_2010	/u02/oradata2/hotel/datafile/hotel_data_pl2010.dbf	2	0	205.00	1.00	0	0	0	0.00
HOTEL_DATA_PL_2011	/u02/oradata2/hotel/datafile/hotel_data_pl2011.dbf	2	0	225.00	1.00	0	0	0	0.00
HOTEL_DATA_PL_2012	/u02/oradata2/hotel/datafile/hotel_data_pl2012.dbf	2	0	160.00	1.00	0	0	0	0.00
HOTEL_DATA_QY	/u02/oradata3/hotel/datafile/hotel_data_qy0.dbf	11,061	3	20.85	1.00	0	0	0	0.00
HOTEL_DATA_QY	/u02/oradata3/hotel/datafile/hotel_data_qy1.dbf	11,190	3	27.83	1.00	62	0	0	0.00
HOTEL_DATA_QY	/u02/oradata3/hotel/datafile/hotel_data_qy2.dbf	982	0	24.10	1.00	8	0	1	100.00
HOTEL_DATA_QY_2008	/u02/oradata2/hotel/datafile/hotel_data_qy2008.dbf	2	0	135.00	1.00	0	0	0	0.00
HOTEL_DATA_QY_2009	/u02/oradata2/hotel/datafile/hotel_data_qy2009.dbf	2	0	215.00	1.00	0	0	0	0.00
HOTEL_DATA_QY_2010	/u02/oradata2/hotel/datafile/hotel_data_qy2010.dbf	3	0	196.67	1.00	0	0	0	0.00
HOTEL_DATA_QY_2011	/u02/oradata2/hotel/datafile/hotel_data_qy2011.dbf	2	0	220.00	1.00	0	0	0	0.00
HOTEL_DATA_QY_2012	/u02/oradata2/hotel/datafile/hotel_data_qy2012.dbf	2	0	205.00	1.00	0	0	0	0.00
HOTEL_DATA_TS	/u02/oradata3/hotel/datafile/hotel_data_ts0.dbf	1,546	0	31.78	1.00	0	0	0	0.00
HOTEL_DATA_TS	/u02/oradata3/hotel/datafile/hotel_data_ts1.dbf	5,257	1	87.94	1.00	9	0	38	56.05
HOTEL_DATA_TS	/u02/oradata3/hotel/datafile/hotel_data_ts2.dbf	345	0	49.22	1.00	43	0	29	83.45
HOTEL_DATA_TS_2008	/u02/oradata2/hotel/datafile/hotel_data_ts2008.dbf	2	0	245.00	1.00	0	0	0	0.00
HOTEL_DATA_TS_2009	/u02/oradata2/hotel/datafile/hotel_data_ts2009.dbf	2	0	180.00	1.00	0	0	0	0.00
HOTEL_DATA_TS_2010	/u02/oradata2/hotel/datafile/hotel_data_ts2010.dbf	3	0	133.33	1.00	0	0	0	0.00
HOTEL_DATA_TS_2011	/u02/oradata2/hotel/datafile/hotel_data_ts2011.dbf	2	0	205.00	1.00	0	0	0	0.00
HOTEL_DATA_TS_2012	/u02/oradata2/hotel/datafile/hotel_data_ts2012.dbf	2	0	165.00	1.00	0	0	0	0.00
HOTEL_DATA_US	/u02/oradata5/hotel/datafile/hotel_data_us.dbf	4	0	282.50	7.25	0	0	0	0.00
HOTEL_DATA_WW	/u02/oradata1/hotel/datafile/hotel_data_ww0.dbf	75,279	21	11.46	1.00	1	0	0	0.00
HOTEL_DATA_WW	/u02/oradata1/hotel/datafile/hotel_data_ww1.dbf	58,985	16	11.82	1.00	53	0	0	0.00
HOTEL_DATA_WW	/u02/oradata1/hotel/datafile/hotel_data_ww2.dbf	4	0	5.00	1.00	17	0	0	0.00
HOTEL_DATA_WW_2008	/u02/oradata2/hotel/datafile/hotel_data_ww2008.dbf	2	0	170.00	1.00	0	0	0	0.00
HOTEL_DATA_WW_2009	/u02/oradata2/hotel/datafile/hotel_data_ww2009.dbf	2	0	195.00	1.00	0	0	0	0.00
HOTEL_DATA_WW_2010	/u02/oradata2/hotel/datafile/hotel_data_ww2010.dbf	4	0	247.50	1.00	0	0	0	0.00
HOTEL_DATA_WW_2011	/u02/oradata2/hotel/datafile/hotel_data_ww2011.dbf	2	0	100.00	1.00	0	0	0	0.00
HOTEL_DATA_WW_2012	/u02/oradata2/hotel/datafile/hotel_data_ww2012.dbf	2	0	245.00	1.00	0	0	0	0.00
HOTEL_DATA_ZY	/u02/oradata2/hotel/datafile/hotel_data_zy0.dbf	16,029	4	35.67	1.00	0	0	0	0.00
HOTEL_DATA_ZY	/u02/oradata2/hotel/datafile/hotel_data_zy1.dbf	10,776	3	10.44	1.00	30	0	82	72.56
HOTEL_DATA_ZY_2008	/u02/oradata2/hotel/datafile/hotel_data_zy2008.dbf	2	0	150.00	1.00	0	0	0	0.00
HOTEL_DATA_ZY_2009	/u02/oradata2/hotel/datafile/hotel_data_zy2009.dbf	2	0	120.00	1.00	0	0	0	0.00
HOTEL_DATA_ZY_2010	/u02/oradata2/hotel/datafile/hotel_data_zy2010.dbf	3	0	210.00	1.00	0	0	0	0.00
HOTEL_DATA_ZY_2011	/u02/oradata2/hotel/datafile/hotel_data_zy2011.dbf	2	0	235.00	1.00	0	0	0	0.00
HOTEL_DATA_ZY_2012	/u02/oradata2/hotel/datafile/hotel_data_zy2012.dbf	2	0	215.00	1.00	0	0	0	0.00
HOTEL_DICTIONARY	/u02/oradata5/hotel/datafile/hotel_dictionary.dbf	8	0	370.00	2.88	0	0	0	0.00
HOTEL_IND	/u02/oradata5/hotel/datafile/hotel_ind0.dbf	7,260	2	106.25	1.00	841	0	1,167	54.87
HOTEL_IND	/u02/oradata5/hotel/datafile/hotel_ind1.dbf	3,514	1	93.18	1.00	402	0	446	64.62
HOTEL_IND	/u02/oradata5/hotel/datafile/hotel_ind2.dbf	3,499	1	109.18	1.00	221	0	480	84.17
HOTEL_IND	/u02/oradata5/hotel/datafile/hotel_ind3.dbf	9,539	3	92.98	1.00	1,862	1	1,287	73.95
SYSAUX	/u02/oradata7/sysaux01.dbf	331	0	87.04	1.01	584	0	0	0.00
SYSTEM	/u02/oradata7/system01.dbf	460	0	120.43	1.01	97	0	0	0.00
SYSTEM	/u02/oradata7/system02.dbf	8	0	148.75	1.38	0	0	0	0.00
UNDOTBS02	/u02/oradata4/undotbs02.dbf	3	0	110.00	1.00	158	0	0	0.00
UNDOTBS02	/u02/oradata4/undotbs03.dbf	2	0	130.00	1.00	37	0	0	0.00
USERS	/u02/oradata7/users01.dbf	2	0	180.00	1.00	0	0	0	0.00
YZ_DATA	/u02/oradata8/yz/yz_data.dbf	22	0	56.82	1.00	9	0	0	0.00
YZ_DATA_BMFP	/u02/oradata8/yz/yz_data_bmfp.dbf	2	0	265.00	1.00	0	0	0	0.00
YZ_DATA_CARD	/u02/yz/yz_data_card.dbf	3	0	166.67	1.00	0	0	0	0.00
YZ_DATA_CJYZXX	/u02/oradata8/yz/yz_data_cjyzxx.dbf	3	0	250.00	1.00	0	0	0	0.00
YZ_DATA_CJZTYMXX	/u02/oradata8/yz/yz_data_cjztymxx.dbf	4	0	225.00	1.00	0	0	0	0.00
YZ_DATA_CYRY	/u02/oradata8/yz/yz_data_cyry.dbf	2	0	185.00	1.00	0	0	0	0.00
YZ_DATA_DJWDXX	/u02/yz/yz_data_djwdxxb.dbf	2	0	205.00	1.00	0	0	0	0.00
YZ_DATA_DWXX	/u02/oradata8/yz/yz_data_dwxx.dbf	7	0	82.86	1.00	0	0	0	0.00
YZ_DATA_FJTP	/u02/oradata8/yz/yz_data_fjtp.dbf	3	0	236.67	1.00	0	0	0	0.00
YZ_DATA_FRWDWXX	/u02/oradata8/yz/yz_data_frwdwxx.dbf	3	0	266.67	1.00	0	0	0	0.00
YZ_DATA_FRWYZJBXX	/u02/oradata8/yz/yz_data_frwyzjbxx.dbf	3	0	283.33	1.00	0	0	0	0.00
YZ_DATA_GNMKXX	/u02/oradata8/yz/yz_data_gnmkxx.dbf	2	0	205.00	1.00	0	0	0	0.00
YZ_DATA_GWGLXX	/u02/oradata8/yz/yz_data_gwglxx.dbf	2	0	185.00	1.00	0	0	0	0.00
YZ_DATA_KKYZBL	/u02/oradata8/yz/yz_data_kkyzbl.dbf	6	0	71.67	1.00	0	0	0	0.00
YZ_DATA_PBYMXX	/u02/oradata8/yz/yz_data_pbymxx.dbf	4	0	212.50	1.00	0	0	0	0.00
YZ_DATA_RWKXX	/u02/oradata8/yz/yz_data_rwkxx.dbf	3	0	286.67	1.00	0	0	0	0.00
YZ_DATA_SPDWXX	/u02/yz/yz_data_spdwxx.dbf	2	0	215.00	1.00	0	0	0	0.00
YZ_DATA_YH	/u02/yz/yz_data_yh.dbf	2	0	220.00	1.00	0	0	0	0.00
YZ_DATA_YZBGSL	/u02/oradata8/yz/yz_data_yzbgsl.dbf	3	0	216.67	1.00	0	0	0	0.00
YZ_DATA_YZJBXX	/u02/oradata8/yz/yz_data_yzjbxx.dbf	8	0	102.50	1.00	0	0	0	0.00
YZ_DATA_YZWMFP	/u02/yz/yz_data_yzwmfp.dbf	2	0	255.00	1.00	0	0	0	0.00
YZ_DATA_ZTYMXX	/u02/oradata8/yz/yz_data_ztymxx.dbf	4	0	225.00	1.00	0	0	0	0.00
YZ_DATA_ZZDWXX	/u02/yz/yz_data_zzdwxx.dbf	2	0	200.00	1.00	0	0	0	0.00
YZ_DICTIONARY	/u02/oradata8/yz/yz_dictionary.dbf	2	0	235.00	1.00	0	0	0	0.00
YZ_IND	/u02/oradata8/yz/yz_ind.dbf	2	0	310.00	1.00	0	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	2,463,770	98	52,322,950	1,197,794	11,964	0	0	67,281

Advisory Statistics

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

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	16	819	2671	10294	943650	10294
E	0	20	1084	3994	14487	943650	14487

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	1,984	0.10	245,396	2.71	51,531,104
D	3,968	0.20	490,792	2.17	41,352,721
D	5,952	0.30	736,188	1.85	35,210,378
D	7,936	0.40	981,584	1.64	31,197,444
D	9,920	0.50	1,226,980	1.49	28,424,163
D	11,904	0.60	1,472,376	1.36	25,917,809
D	13,888	0.70	1,717,772	1.26	23,921,799
D	15,872	0.80	1,963,168	1.17	22,266,619
D	17,856	0.90	2,208,564	1.08	20,590,545
D	19,840	1.00	2,453,960	1.00	19,107,218
D	19,936	1.00	2,465,834	1.00	19,047,354
D	21,824	1.09	2,699,356	0.94	17,862,332
D	23,808	1.19	2,944,752	0.88	16,839,176
D	25,792	1.29	3,190,148	0.84	16,072,077
D	27,776	1.39	3,435,544	0.81	15,424,004
D	29,760	1.49	3,680,940	0.78	14,869,219
D	31,744	1.59	3,926,336	0.75	14,314,931
D	33,728	1.69	4,171,732	0.73	13,946,205
D	35,712	1.79	4,417,128	0.72	13,667,375
D	37,696	1.89	4,662,524	0.70	13,395,141
D	39,680	1.99	4,907,920	0.69	13,164,789

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	425	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,800	141.72	4.06	2.86	100.00	0.00	209,710
E	2,048	1,803	130.90	0.00	0.00	0.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	19,250	19,250
64K	128K	71	71
128K	256K	28	28
256K	512K	62	62
512K	1024K	94	94
1M	2M	196	196
8M	16M	1	1
32M	64M	1	1

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 %
256	0.13	43,947.19	754.01	98.00
512	0.25	43,947.19	754.01	98.00
1,024	0.50	43,947.19	0.00	100.00
1,536	0.75	43,947.19	0.00	100.00
2,048	1.00	43,947.19	0.00	100.00
2,458	1.20	43,947.19	0.00	100.00
2,867	1.40	43,947.19	0.00	100.00
3,277	1.60	43,947.19	0.00	100.00
3,686	1.80	43,947.19	0.00	100.00
4,096	2.00	43,947.19	0.00	100.00
6,144	3.00	43,947.19	0.00	100.00
8,192	4.00	43,947.19	0.00	100.00
12,288	6.00	43,947.19	0.00	100.00
16,384	8.00	43,947.19	0.00	100.00

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
320	0.63	68	4,739	92,817	0.90	10,847	12.72	660,112
384	0.75	132	7,989	96,670	0.94	6,994	8.20	660,685
448	0.88	195	11,660	100,264	0.98	3,400	3.99	661,229
512	1.00	258	14,814	102,811	1.00	853	1.00	661,636
576	1.13	321	17,509	104,430	1.02	1	0.00	661,968
640	1.25	384	20,216	105,764	1.03	1	0.00	662,261
704	1.38	447	23,350	107,078	1.04	1	0.00	662,522
768	1.50	510	26,464	108,118	1.05	1	0.00	662,749
832	1.63	569	29,316	108,830	1.06	1	0.00	662,935
896	1.75	600	30,943	109,368	1.06	1	0.00	663,082
960	1.88	615	31,630	109,806	1.07	1	0.00	663,193
1,024	2.00	616	31,739	110,166	1.07	1	0.00	663,272

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
5,120	0.25	1,415,439	41,249,341
10,240	0.50	960,004	28,377,611
15,360	0.75	800,822	23,876,887
20,480	1.00	629,924	19,046,655
25,600	1.25	524,664	16,071,567
30,720	1.50	465,892	14,313,561
35,840	1.75	439,561	13,665,975
40,960	2.00	421,797	13,165,048

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	67,301	3,409	51

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
CF-Controlfile Transaction	1,577	1,577	0	2	1	600.00
SQ-Sequence Cache	16	16	0	1	0	10.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
126	0.73	1,233	5,276	4	5760/5760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
21-Nov 10:05	210	210	0	3	5,760	0/0	0/0/0/0/0/0
21-Nov 09:55	97	197	5,276	2	5,760	0/0	0/0/0/0/0/0
21-Nov 09:45	61	80	4,671	2	5,760	0/0	0/0/0/0/0/0
21-Nov 09:35	76	171	4,064	2	5,760	0/0	0/0/0/0/0/0
21-Nov 09:25	79	120	3,459	2	5,760	0/0	0/0/0/0/0/0
21-Nov 09:15	66	265	2,853	2	5,760	0/0	0/0/0/0/0/0
21-Nov 09:05	141	190	2,246	4	5,760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,138	0.00		0	0
AWR Alerted Metric Element list	18,259	0.00		0	0
Consistent RBA	1,185	0.00		0	0
FAL request queue	72	0.00		0	0
FAL subheap alocation	72	0.00		0	0
FIB s.o chain latch	18	0.00		0	0
FOB s.o list latch	3,000	0.00		0	0
In memory undo latch	10,313	0.00		0	2,766	0.00
JS mem alloc latch	8	0.00		0	0
JS queue access latch	8	0.00		0	0
JS queue state obj latch	26,186	0.00		0	0
JS slv state obj latch	15	0.00		0	0
KMG MMAN ready and startup request latch	1,287	0.00		0	0
KMG resize request state object freelist	12	0.00		0	0
KTF sga latch	6	0.00		0	977	0.00
KWQMN job cache list latch	6	0.00		0	0
MQL Tracking Latch	0			0	71	0.00
Memory Management Latch	180	0.00		0	1,284	0.00
OS process	12,192	0.00		0	0
OS process allocation	9,328	0.00		0	0
OS process: request allocation	8,115	0.00		0	0
PL/SQL warning settings	4,740	0.00		0	0
SGA IO buffer pool latch	12	0.00		0	12	0.00
SQL memory manager latch	1	0.00		0	1,069	0.00
SQL memory manager workarea list latch	74,515	0.00		0	0
Shared B-Tree	128	0.00		0	0
active checkpoint queue latch	8,017	0.02	0.00	0	0
active service list	28,155	0.00		0	1,616	0.00
archive control	68	0.00		0	0
archive process latch	1,213	0.00		0	0
begin backup scn array	18	0.00		0	0
buffer pool	148	0.00		0	0
cache buffer handles	220	0.00		0	0
cache buffers chains	104,785,174	0.01	0.17	0	1,362,604	0.00
cache buffers lru chain	35,742	0.03	0.27	0	1,219,599	0.01
cache table scan latch	0			0	31	0.00
channel handle pool latch	8,117	0.00		0	0
channel operations parent latch	27,977	0.00		0	0
checkpoint queue latch	262,264	0.00		0	14,751	0.00
client/application info	21,942	0.00		0	0
compile environment latch	4,117	0.00		0	0
dml lock allocation	4,109	0.00		0	0
dummy allocation	8,239	0.02	0.00	0	0
enqueue hash chains	90,822	0.00		0	2	0.00
enqueues	92,202	0.01	0.33	0	0
event group latch	4,055	0.00		0	0
file cache latch	892	0.00		0	0
global KZLD latch for mem in SGA	4,053	0.00		0	0
global tx hash mapping	36	0.00		0	0
hash table column usage latch	254	0.00		0	48,329	0.00
hash table modification latch	80	0.00		0	0
job workq parent latch	0			0	124	0.00
job_queue_processes parameter latch	122	0.00		0	0
kks stats	9,808	0.00		0	0
kokc descriptor allocation latch	42	0.00		0	0
ksuosstats global area	243	0.00		0	0
ktm global data	12	0.00		0	0
kwqbsn:qsga	128	0.00		0	0
lgwr LWN SCN	1,280	0.00		0	0
library cache	221,948	0.19	0.07	0	4,454	0.00
library cache load lock	1,094	0.00		0	0
library cache lock	158,743	0.04	0.01	0	0
library cache lock allocation	10,092	0.00		0	0
library cache pin	58,705	0.01	0.00	0	0
library cache pin allocation	404	0.00		0	0
list of block allocation	1,741	0.00		0	0
loader state object freelist	86	0.00		0	0
message pool operations parent latch	2	0.00		0	0
messages	42,021	0.02	0.00	0	0
mostly latch-free SCN	1,281	0.00		0	0
multiblock read objects	8,358	0.00		0	0
ncodef allocation latch	77	0.00		0	0
object queue header heap	32,689	0.00		0	205	0.00
object queue header operation	2,461,370	0.00	0.50	0	4,015	0.00
object stats modification	2	0.00		0	0
parallel query alloc buffer	460	0.00		0	0
parameter list	939	0.00		0	0
parameter table allocation management	4,140	0.00		0	0
post/wait queue	577	0.00		0	313	0.00
process allocation	8,115	1.27	0.97	1	4,054	0.02
process group creation	8,115	0.00		0	0
qmn task queue latch	512	0.00		0	0
redo allocation	9,283	0.00		0	31,021	0.01
redo copy	0			0	31,022	0.01
redo writing	13,824	0.01	0.00	0	0
resmgr group change latch	4,362	0.00		0	0
resmgr:active threads	8,236	0.00		0	0
resmgr:actses change group	4,115	0.00		0	0
resmgr:free threads list	8,235	0.07	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	1,009,271	0.32	0.01	0	371	0.00
sequence cache	12,931	0.09	0.00	0	0
session allocation	180,221	0.02	0.03	0	0
session idle bit	151,077	0.00	0.00	0	0
session state list latch	8,222	0.07	0.00	0	0
session switching	77	0.00		0	0
session timer	1,616	0.00		0	0
shared pool	185,969	0.08	0.36	1	0
shared pool sim alloc	73	0.00		0	0
shared pool simulator	102,187	0.00		0	0
simulator hash latch	3,507,787	0.00	0.08	0	0
simulator lru latch	12,601	0.01	1.00	0	3,371,443	0.05
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	125	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	2,968	0.00		0	0
transaction allocation	700	0.00		0	0
transaction branch allocation	1,649	0.00		0	0
undo global data	10,259	0.01	0.00	0	0
user lock	16,352	0.12	0.26	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	104,785,174	14,772	2,467	12,685
row cache objects	1,009,271	3,226	17	3,209
library cache	221,948	415	28	387
shared pool	185,969	154	55	104
process allocation	8,115	103	100	3
library cache lock	158,743	71	1	70
session allocation	180,221	33	1	32
user lock	16,352	19	5	14
simulator hash latch	3,507,787	13	1	12
cache buffers lru chain	35,742	11	3	8
enqueues	92,202	6	2	4
object queue header operation	2,461,370	4	2	2
simulator lru latch	12,601	1	1	0
slave class create	8	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
cache buffers chains	kcbgtcr: kslbegin excl	3,613	3,354
cache buffers chains	kcbgtcr: fast path	109	3
cache buffers chains	kcbrls: kslbegin	36	402
cache buffers chains	kcbchg: kslbegin: bufs not pinned	7	4
cache buffers chains	kcbzwb	3	1
cache buffers chains	kcbget: pin buffer	1	2
cache buffers chains	kcbzib: finish free bufs	1	3
cache buffers lru chain	kcbzgws	3	0
cost function	kzulgt: find user res	5	5
enqueues	ksqdel	1	0
enqueues	ksqgel: create enqueue	1	1
library cache	kglhdgn: child:	11	11
library cache	kglpndl: child: after processing	8	9
library cache	kglpndl: child: before processing	7	0
library cache	kgldte: child 0	1	1
library cache	kglobpn: child:	1	7
library cache lock	kgllkal: child: multiinstance	1	1
object queue header operation	kcbo_switch_cq	2	0
object queue header operation	kcbw_unlink_q	1	2
process allocation	ksucrp	101	0
row cache objects	kqrpre: find obj	15	14
row cache objects	kqreqd	1	3
row cache objects	kqreqd: reget	1	0
session allocation	ksuxds: KSUSFCLC not set	1	0
shared pool	kghalo	55	42
simulator hash latch	kcbsacc: lookup dba	1	1
simulator lru latch	kcbs_shrink_pool	1	0
slave class create	ksvcreate	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 52,323,535
Captured Segments account for 99.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
SCOPER_HOTEL	HOTEL_DATA_QY	T_PERSON	RTITION_QY	TABLE PARTITION	6,267,360	11.98
SCOPER_HOTEL	HOTEL_DATA_DX	T_PERSON	RTITION_DX	TABLE PARTITION	5,864,192	11.21
SCOPER_HOTEL	HOTEL_DATA_JQ	T_PERSON	RTITION_JQ	TABLE PARTITION	5,447,344	10.41
SCOPER_HOTEL	HOTEL_DATA_WW	T_PERSON	RTITION_WW	TABLE PARTITION	5,117,168	9.78
SCOPER_HOTEL	HOTEL_DATA_BY	T_PERSON	RTITION_BY	TABLE PARTITION	4,638,896	8.87

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 1,197,450
Captured Segments account for 89.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SCOPER_HOTEL	HOTEL_DATA_DX	T_PERSON	RTITION_DX	TABLE PARTITION	443,288	37.02
SCOPER_HOTEL	HOTEL_DATA_JQ	T_PERSON	RTITION_JQ	TABLE PARTITION	313,298	26.16
SCOPER_HOTEL	HOTEL_DATA_WW	T_PERSON	RTITION_WW	TABLE PARTITION	134,256	11.21
SCOPER_HOTEL	HOTEL_DATA_PL	T_PERSON	RTITION_PL	TABLE PARTITION	48,300	4.03
SCOPER_HOTEL	HOTEL_DATA_ZY	T_PERSON	RTITION_ZY	TABLE PARTITION	26,794	2.24

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
SCOPER_HOTEL	HOTEL_IND	T_PERSON_CSSJ	INDEX	8	17.78
SCOPER_HOTEL	HOTEL_IND	T_PERSON_IND	INDEX	8	17.78
SCOPER_HOTEL	HOTEL_DATA	T_PERSON_KEY	INDEX	6	13.33
SCOPER_HOTEL	HOTEL_DATA	T_PERSON_TFSJ	INDEX	6	13.33
SCOPER_HOTEL	HOTEL_DATA	T_PERSON_MZ	INDEX	5	11.11

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
SCOPER_HOTEL	HOTEL_DATA	T_PERSON_RZFH		INDEX	1	100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
SCOPER_HOTEL	HOTEL_IND	T_PERSON_IND		INDEX	1	100.00

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	64	0.00	2	1
dc_database_links	8,102	0.00	0	1
dc_files	137	100.00	0	137
dc_global_oids	320	3.75	0	19
dc_histogram_data	55,453	0.89	0	1,544
dc_histogram_defs	13,374	7.81	0	1,435
dc_object_grants	120	16.67	0	22
dc_object_ids	117,006	0.15	0	457
dc_objects	7,069	2.76	6	399
dc_profiles	4,115	0.00	0	1
dc_rollback_segments	823	0.00	0	48
dc_segments	17,706	1.27	6	370
dc_sequences	15	6.67	15	3
dc_tablespace_quotas	2	100.00	1	3
dc_tablespaces	8,578	0.00	0	119
dc_usernames	24,777	0.13	0	42
dc_users	145,726	0.00	0	68
outstanding_alerts	1,440	0.00	0	236

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	713	0.00	1,426	0.70	10	0
CLUSTER	33	6.06	69	2.90	0	0
INDEX	20	20.00	914	0.98	5	0
SQL AREA	32,839	6.27	83,035	5.41	437	153
TABLE/PROCEDURE	767	0.65	18,200	2.76	288	0
TRIGGER	36	0.00	200	0.50	1	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	90.98		2.46	5.88	22	31	37	37
	Freeable	45.94	0.00	2.30	3.16	10		20	20
	SQL	4.98	4.55	0.19	0.44	1	18	26	24
	PL/SQL	0.32	0.21	0.01	0.01	0	0	35	35
E	Other	86.75		2.89	6.48	22	31	30	30
	Freeable	43.00	0.00	2.69	3.43	10		16	16
	SQL	0.85	0.43	0.04	0.04	0	7	19	18
	PL/SQL	0.31	0.21	0.01	0.02	0	0	28	28

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	20,887,633,920
Fixed Size	2,122,368
Redo Buffers	14,651,392
Variable Size	570,428,800

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	ASH buffers	29.00	29.00	0.00
shared	CCursor	13.92	13.46	-3.29
shared	KGH: NO ACCESS	127.44	127.44	0.00
shared	PCursor	11.34	10.67	-5.89
shared	db_block_hash_buckets	180.00	180.00	0.00
shared	free memory	132.66	145.78	9.88
shared	library cache	13.20	13.43	1.79
shared	row cache	7.16	7.16	0.00
shared	simulator hash buckets	8.02	8.02	0.00
shared	sql area	58.13	43.80	-24.66
	buffer_cache	19,920.00	19,920.00	0.00
	fixed_sga	2.02	2.02	0.00
	log_buffer	13.97	13.97	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

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	/u01/oracle/admin/hotel/adump
background_dump_dest	/u01/oracle/admin/hotel/bdump
compatible	10.2.0.3.0
control_files	/u02/oradata7/control01.ctl, /u02/oradata7/control02.ctl, /u02/oradata7/control03.ctl
core_dump_dest	/u01/oracle/admin/hotel/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	hotel
db_recovery_file_dest	/u02/oradata6/flash_recovery_area
db_recovery_file_dest_size	85899345920
dispatchers	(PROTOCOL=TCP) (SERVICE=hotelXDB)
job_queue_processes	10
log_archive_format	%t_%s_%r.dbf
nls_language	SIMPLIFIED CHINESE
nls_territory	CHINA
open_cursors	300
pga_aggregate_target	2147483648
processes	150
remote_login_passwordfile	EXCLUSIVE
sga_max_size	21474836480
sga_target	21474836480
undo_management	AUTO
undo_tablespace	UNDOTBS02
user_dump_dest	/u01/oracle/admin/hotel/udump

End of Report

% Blocks changed per Read:	0.10	Recursive Call %:	87.27
Rollback per transaction %:	0.00	Rows per Sort:	24.63

Buffer Nowait %:	99.87	Redo NoWait %:	100.00
Buffer Hit %:	97.71	In-memory Sort %:	100.00
Library Hit %:	95.17	Soft Parse %:	97.09
Execute to Parse %:	3.77	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	9.95	% Non-Parse CPU:	98.52