WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

ORCL 1312587260 orclstby 1 09-May-13 09:05 11.2.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ORCL	1312587260	orclstby	1	09-May-13 09:05	11.2.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

posp.bak Linux IA (32-bit) 2 9.91

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
posp.bak	Linux IA (32-bit)	2			9.91

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 10787 25-Aug-13 00:00:56 93 4.8

End Snap: 10943 31-Aug-13 12:00:06 93 4.4

Elapsed: 9,359.16 (mins)

DB Time: 5,151.94 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	10787	25-Aug-13 00:00:56	93	4.8
End Snap:	10943	31-Aug-13 12:00:06	93	4.4
Elapsed:		9,359.16 (mins)
DB Time:		5,151.94 (mins)

Report Summary

Cache Sizes

Begin End

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

Shared Pool Size: 1,168M 1,168M Log Buffer: 10,604K

	Begin	End
Buffer Cache:	736M	736M	Std Block Size:	8K
Shared Pool Size:	1,168M	1,168M	Log Buffer:	10,604K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.6 0.5 0.04 0.03

DB CPU(s): 0.2 0.2 0.01 0.01

Redo size: 4,923.7 4,009.8

Logical reads: 11,664.8 9,499.6

Block changes: 26.9 21.9

Physical reads: 5,462.9 4,448.9

Physical writes: 2.8 2.3

User calls: 17.6 14.3

Parses: 9.2 7.5

Hard parses: 0.1 0.1

W/A MB processed: -0.4 -0.3

Logons: 0.0 0.0

Executes: 13.5 11.0

Rollbacks: 0.0 0.0

Transactions: 1.2

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.6	0.5	0.04	0.03
DB CPU(s):	0.2	0.2	0.01	0.01
Redo size:	4,923.7	4,009.8
Logical reads:	11,664.8	9,499.6
Block changes:	26.9	21.9
Physical reads:	5,462.9	4,448.9
Physical writes:	2.8	2.3
User calls:	17.6	14.3
Parses:	9.2	7.5
Hard parses:	0.1	0.1
W/A MB processed:	-0.4	-0.3
Logons:	0.0	0.0
Executes:	13.5	11.0
Rollbacks:	0.0	0.0
Transactions:	1.2

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 99.98

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

Library Hit %: 98.65 Soft Parse %: 99.15

Execute to Parse %: 31.98 Latch Hit %: 99.94

Parse CPU to Parse Elapsd %: 0.25 % Non-Parse CPU: 99.65

Shared Pool Statistics

Begin End

Memory Usage %: 87.09 87.49

% SQL with executions>1: 97.60 96.70

% Memory for SQL w/exec>1: 89.89 88.04

	Begin	End
Memory Usage %:	87.09	87.49
% SQL with executions>1:	97.60	96.70
% Memory for SQL w/exec>1:	89.89	88.04

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
cursor: pin S wait on X	692	152,401	220233	49.30	Concurrency
DB CPU		107,367		34.73
direct path read	22,390,641	11,953	1	3.87	User I/O
log file sync	743,936	7,254	10	2.35	Commit
latch: cache buffers chains	32,624	4,168	128	1.35	Concurrency

Host CPU (CPUs: 2 Cores: Sockets: )

Load Average Begin Load Average End %User %System %WIO %Idle

0.17 0.16 7.1 1.5 1.9 91.3

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.17	0.16	7.1	1.5	1.9	91.3

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)

9.9 113.8 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
9.9	113.8	0.0

Begin End

Host Mem (MB): 10,146.8 10,146.8

SGA use (MB): 1,952.0 1,952.0

PGA use (MB): 256.7 225.5

% Host Mem used for SGA+PGA: 21.77 21.46

	Begin	End
Host Mem (MB):	10,146.8	10,146.8
SGA use (MB):	1,952.0	1,952.0
PGA use (MB):	256.7	225.5
% Host Mem used for SGA+PGA:	21.77	21.46

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
Shared Server Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 309116.6s
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
parse time elapsed	207,570.59	67.15
sql execute elapsed time	145,897.96	47.20
DB CPU	107,367.18	34.73
hard parse elapsed time	54,920.00	17.77
failed parse elapsed time	44,475.53	14.39
hard parse (sharing criteria) elapsed time	4,157.54	1.34
PL/SQL execution elapsed time	1,528.72	0.49
sequence load elapsed time	80.30	0.03
connection management call elapsed time	19.14	0.01
PL/SQL compilation elapsed time	13.76	0.00
inbound PL/SQL rpc elapsed time	4.24	0.00
repeated bind elapsed time	4.17	0.00
RMAN cpu time (backup/restore)	1.05	0.00
hard parse (bind mismatch) elapsed time	0.50	0.00
DB time	309,116.63
background elapsed time	43,218.22
background cpu time	3,393.71

Back to Wait Events Statistics
Back to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different
ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic	Value	End Value
BUSY_TIME	9,729,221
IDLE_TIME	102,305,574
IOWAIT_TIME	2,125,335
NICE_TIME	7,225
SYS_TIME	1,684,272
USER_TIME	7,913,458
LOAD	0	0
RSRC_MGR_CPU_WAIT_TIME	6,288
PHYSICAL_MEMORY_BYTES	10,639,704,064
NUM_CPUS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
25-Aug 00:00:56	0.17
25-Aug 01:00:00	0.04	0.71	0.52	0.12	99.29	1.59
25-Aug 02:00:05	0.14	0.72	0.51	0.14	99.28	1.63
25-Aug 03:00:09	0.13	0.64	0.47	0.12	99.36	1.49
25-Aug 04:00:14	0.16	0.63	0.47	0.11	99.37	1.43
25-Aug 05:00:21	0.52	3.56	1.79	1.70	96.44	1.79
25-Aug 06:00:52	1.58	19.53	10.45	8.99	80.47	1.80
25-Aug 07:00:04	0.19	0.82	0.57	0.19	99.18	1.55
25-Aug 08:00:10	0.15	0.74	0.53	0.13	99.26	1.49
25-Aug 09:00:23	0.15	1.55	1.25	0.20	98.45	1.92
25-Aug 10:00:30	0.05	0.81	0.56	0.16	99.19	1.73
25-Aug 11:00:44	0.05	1.90	1.54	0.24	98.10	2.09
25-Aug 12:00:56	0.33	0.94	0.64	0.18	99.06	1.99
25-Aug 13:00:03	0.17	0.98	0.67	0.17	99.02	2.11
25-Aug 14:00:08	0.02	1.12	0.76	0.20	98.88	2.27
25-Aug 15:00:18	0.12	1.40	1.00	0.24	98.60	2.31
25-Aug 16:00:26	0.11	1.08	0.76	0.19	98.92	2.10
25-Aug 17:00:37	0.31	1.01	0.69	0.20	98.99	2.08
25-Aug 18:00:42	0.19	1.04	0.70	0.19	98.96	2.22
25-Aug 19:00:49	0.33	1.30	0.95	0.20	98.70	2.29
25-Aug 20:00:55	0.29	1.10	0.76	0.19	98.90	2.35
25-Aug 21:00:05	0.07	1.13	0.75	0.21	98.87	2.30
25-Aug 22:00:12	0.15	0.98	0.67	0.18	99.02	2.01
25-Aug 23:00:17	0.03	1.12	0.84	0.18	98.88	1.87
26-Aug 00:00:23	0.05	0.74	0.53	0.13	99.26	1.64
26-Aug 01:00:34	0.13	0.74	0.53	0.15	99.26	1.56
26-Aug 02:00:39	0.01	0.82	0.58	0.16	99.18	1.55
26-Aug 03:00:44	0.27	0.70	0.51	0.13	99.30	1.44
26-Aug 04:00:50	0.12	0.67	0.50	0.12	99.33	1.42
26-Aug 05:00:55	0.59	1.40	0.91	0.43	98.60	1.41
26-Aug 06:00:33	0.19	19.85	10.34	9.42	80.15	2.47
26-Aug 07:00:42	0.30	0.96	0.67	0.22	99.04	1.55
26-Aug 08:00:16	0.16	37.21	24.47	12.47	62.79	6.28
26-Aug 09:00:28	0.43	2.29	1.58	0.63	97.71	1.57
26-Aug 10:00:39	0.07	4.31	3.20	0.97	95.69	1.65
26-Aug 11:00:31	0.25	16.04	11.90	3.93	83.96	2.23
26-Aug 12:00:43	0.55	23.68	16.50	6.94	76.32	2.61
26-Aug 13:00:54	0.20	2.58	1.91	0.53	97.42	2.02
26-Aug 14:00:56	1.39	23.50	21.89	1.47	76.50	1.99
26-Aug 15:00:12	0.24	10.35	9.58	0.63	89.65	1.96
26-Aug 16:00:20	0.23	4.66	3.33	1.15	95.34	2.00
26-Aug 17:00:33	0.03	7.93	6.98	0.79	92.07	1.96
26-Aug 18:00:43	0.24	3.77	3.09	0.53	96.23	2.05
26-Aug 19:00:53	0.03	3.35	2.65	0.53	96.65	2.05
26-Aug 20:01:00	0.14	1.42	1.10	0.19	98.58	2.08
26-Aug 21:00:07	0.21	26.12	25.43	0.56	73.88	2.00
26-Aug 22:00:16	0.96	1.54	1.08	0.26	98.46	2.02
26-Aug 23:00:19	1.08	51.33	49.45	1.75	48.67	1.66
27-Aug 00:00:28	0.15	0.79	0.57	0.15	99.21	1.71
27-Aug 01:00:34	0.00	0.73	0.53	0.13	99.27	1.59
27-Aug 02:00:40	0.00	0.68	0.50	0.12	99.32	1.53
27-Aug 03:00:45	0.05	0.79	0.58	0.16	99.21	1.44
27-Aug 04:00:51	0.00	0.64	0.47	0.12	99.36	1.40
27-Aug 05:01:01	0.62	1.46	0.93	0.47	98.54	1.47
27-Aug 06:00:19	0.32	18.91	9.98	8.85	81.09	1.75
27-Aug 07:00:29	0.34	0.86	0.58	0.20	99.14	1.48
27-Aug 08:00:45	0.01	35.64	23.47	11.98	64.36	3.69
27-Aug 09:00:53	0.06	1.72	1.25	0.38	98.28	1.59
27-Aug 10:00:07	0.54	10.23	8.02	2.09	89.77	1.60
27-Aug 11:00:15	0.01	5.09	3.75	1.21	94.91	1.94
27-Aug 12:00:49	0.30	20.11	17.10	2.85	79.89	1.95
27-Aug 13:00:56	0.04	1.13	0.81	0.20	98.87	2.02
27-Aug 14:00:01	0.42	2.19	1.69	0.34	97.81	2.08
27-Aug 15:00:07	0.31	1.95	1.52	0.31	98.05	1.94
27-Aug 16:00:16	0.06	3.82	3.20	0.47	96.18	2.06
27-Aug 17:00:21	0.08	2.53	1.79	0.56	97.47	1.98
27-Aug 18:00:27	0.07	2.60	1.79	0.66	97.40	2.00
27-Aug 19:00:36	0.02	1.35	0.95	0.26	98.65	2.00
27-Aug 20:00:42	0.08	1.42	1.09	0.18	98.58	2.13
27-Aug 21:00:48	0.29	1.27	0.89	0.22	98.73	2.26
27-Aug 22:01:00	1.95	2.41	1.93	0.34	97.59	1.98
27-Aug 23:00:16	0.09	46.18	43.78	2.23	53.82	2.00
28-Aug 00:00:32	0.17	0.81	0.58	0.14	99.19	1.69
28-Aug 01:00:39	0.02	0.77	0.55	0.14	99.23	1.58
28-Aug 02:00:43	0.16	0.68	0.47	0.13	99.32	1.55
28-Aug 03:00:48	0.00	0.64	0.46	0.12	99.36	1.48
28-Aug 04:00:52	0.11	0.68	0.50	0.12	99.32	1.43
28-Aug 05:00:58	0.58	1.54	0.99	0.48	98.46	1.50
28-Aug 06:00:19	0.30	19.02	10.06	8.88	80.98	1.73
28-Aug 07:00:25	0.27	0.82	0.57	0.17	99.18	1.47
28-Aug 08:00:39	0.09	35.51	23.37	11.95	64.49	3.55
28-Aug 09:00:49	0.08	2.24	1.73	0.42	97.76	1.55
28-Aug 10:00:04	0.23	15.48	12.74	2.61	84.52	1.77
28-Aug 11:00:13	0.14	6.48	5.05	1.29	93.52	1.76
28-Aug 12:00:20	0.12	5.30	4.10	1.06	94.70	1.94
28-Aug 13:00:27	0.04	4.91	4.07	0.70	95.09	1.92
28-Aug 14:00:34	0.15	3.81	3.15	0.51	96.19	2.10
28-Aug 15:00:40	0.11	4.64	3.99	0.52	95.36	1.92
28-Aug 16:00:48	0.19	1.54	1.10	0.31	98.46	1.98
28-Aug 17:00:54	0.23	3.49	2.79	0.55	96.51	2.00
28-Aug 18:00:01	0.08	2.69	1.90	0.63	97.31	2.04
28-Aug 19:00:08	0.22	0.98	0.67	0.17	99.02	2.07
28-Aug 20:00:13	0.08	1.67	1.32	0.19	98.33	2.24
28-Aug 21:00:20	0.10	3.28	2.83	0.29	96.72	2.24
28-Aug 22:00:28	0.96	1.99	1.53	0.30	98.01	2.06
28-Aug 23:00:15	0.05	30.83	29.03	1.67	69.17	1.81
29-Aug 00:00:23	0.03	0.75	0.53	0.13	99.25	1.64
29-Aug 01:00:30	0.25	0.70	0.50	0.12	99.30	1.57
29-Aug 02:00:36	0.02	0.76	0.53	0.16	99.24	1.51
29-Aug 03:00:42	0.10	0.69	0.50	0.12	99.31	1.46
29-Aug 04:00:47	0.01	0.62	0.44	0.11	99.38	1.41
29-Aug 05:00:58	0.71	1.69	1.10	0.52	98.31	1.44
29-Aug 06:00:08	0.06	19.11	10.12	8.90	80.89	1.75
29-Aug 07:00:17	0.01	0.82	0.55	0.19	99.18	1.42
29-Aug 08:00:23	1.00	47.34	35.57	11.62	52.66	2.50
29-Aug 09:00:32	1.10	43.12	33.13	9.87	56.88	1.80
29-Aug 10:00:15	6.02	51.52	44.90	6.46	48.48	1.11
29-Aug 11:00:53	1.90	71.99	69.23	2.64	28.01	0.92
29-Aug 12:00:05	0.18	32.56	30.69	1.72	67.44	1.66
29-Aug 13:00:11	0.63	3.25	2.69	0.43	96.75	1.97
29-Aug 14:00:19	0.12	11.64	9.34	2.16	88.36	1.96
29-Aug 15:00:28	0.12	2.00	1.41	0.45	98.00	2.00
29-Aug 16:00:34	0.09	1.52	1.07	0.30	98.48	1.99
29-Aug 17:00:42	0.12	2.25	1.69	0.39	97.75	1.99
29-Aug 18:00:46	0.04	2.72	2.07	0.51	97.28	2.00
29-Aug 19:00:52	0.13	1.68	1.27	0.26	98.32	2.09
29-Aug 20:00:58	0.12	2.35	1.84	0.35	97.65	2.22
29-Aug 21:00:04	0.19	1.03	0.70	0.17	98.97	2.28
29-Aug 22:00:11	0.32	1.17	0.84	0.19	98.83	2.09
29-Aug 23:00:22	1.02	51.98	51.39	0.48	48.02	1.41
30-Aug 00:00:30	0.10	4.09	3.87	0.13	95.91	1.65
30-Aug 01:00:37	0.05	0.82	0.60	0.15	99.18	1.57
30-Aug 02:00:41	0.04	0.73	0.53	0.13	99.27	1.52
30-Aug 03:00:46	0.09	0.67	0.47	0.14	99.33	1.48
30-Aug 04:00:51	0.04	0.60	0.43	0.11	99.40	1.42
30-Aug 05:00:58	0.99	1.50	0.97	0.46	98.50	1.43
30-Aug 06:00:05	0.06	19.86	10.51	9.25	80.14	1.79
30-Aug 07:00:12	0.19	0.78	0.53	0.18	99.22	1.47
30-Aug 08:00:19	1.15	46.98	35.25	11.58	53.02	2.49
30-Aug 09:00:29	2.10	44.27	34.24	9.91	55.73	1.73
30-Aug 10:00:37	0.15	29.29	23.11	6.04	70.71	1.64
30-Aug 11:00:45	0.45	4.12	3.21	0.78	95.88	1.76
30-Aug 12:00:51	0.33	14.60	12.37	2.10	85.40	1.85
30-Aug 13:00:56	0.10	4.81	4.08	0.60	95.19	1.99
30-Aug 14:00:01	0.03	3.09	2.35	0.58	96.91	2.04
30-Aug 15:00:07	0.27	2.68	2.10	0.45	97.32	1.97
30-Aug 16:00:12	0.17	2.15	1.70	0.33	97.85	1.95
30-Aug 17:00:20	1.37	19.06	17.76	1.16	80.94	1.95
30-Aug 18:01:00	41.52	39.49	38.90	0.43	60.51	1.71
30-Aug 19:00:19	0.10	52.92	52.33	0.48	47.08	0.98
30-Aug 20:00:24	0.06	1.47	1.04	0.28	98.53	2.18
30-Aug 21:00:30	0.14	1.23	0.81	0.26	98.77	2.36
30-Aug 22:00:35	2.18	2.19	1.67	0.39	97.81	2.00
30-Aug 23:00:51	1.02	51.60	50.30	1.20	48.40	1.42
31-Aug 00:00:04	0.07	3.34	3.02	0.23	96.66	1.75
31-Aug 01:00:08	0.28	0.92	0.62	0.22	99.08	1.65
31-Aug 02:00:15	0.03	0.86	0.58	0.21	99.14	1.59
31-Aug 03:00:19	0.02	0.83	0.54	0.22	99.17	1.52
31-Aug 04:00:25	0.45	1.30	1.02	0.22	98.70	1.39
31-Aug 05:00:35	0.54	2.73	2.16	0.48	97.27	2.07
31-Aug 06:01:29	1.79	20.61	11.32	9.18	79.39	1.94
31-Aug 07:00:23	0.25	14.53	13.42	0.96	85.47	6.25
31-Aug 08:00:30	0.02	0.94	0.65	0.23	99.06	1.52
31-Aug 09:00:35	0.00	1.31	0.91	0.33	98.69	1.55
31-Aug 10:00:46	0.33	1.21	0.83	0.27	98.79	1.78
31-Aug 11:00:56	0.07	2.42	1.71	0.58	97.58	1.98
31-Aug 12:00:06	0.16	1.79	1.25	0.41	98.21	2.01

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 93.5% of Total DB time 309,116.63 (s)
Total FG Wait Time: 181,597.40 (s) DB CPU time: 107,367.18 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Concurrency	33,860	0	157,374	4648	50.91
DB CPU			107,367		34.73
User I/O	189,316,195	0	15,497	0	5.01
Commit	743,936	0	7,254	10	2.35
Application	10,793	0	986	91	0.32
Configuration	86	16	166	1935	0.05
Other	684,670	98	136	0	0.04
Network	9,581,186	0	114	0	0.04
Scheduler	658	0	63	95	0.02
System I/O	108,149	0	6	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

s - second, ms - millisecond - 1000th of a second
Only events with Total Wait Time (s) >= .001 are shown
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
cursor: pin S wait on X	692	0	152,401	220233	0.00	49.30
direct path read	22,390,641	0	11,953	1	32.47	3.87
log file sync	743,936	0	7,254	10	1.08	2.35
latch: cache buffers chains	32,624	0	4,168	128	0.05	1.35
db file scattered read	65,189,486	0	1,631	0	94.54	0.53
db file sequential read	100,899,783	0	1,321	0	146.33	0.43
enq: KO - fast object checkpoint	10,283	0	982	96	0.01	0.32
library cache lock	65	0	773	11896	0.00	0.25
direct path write temp	33,346	0	373	11	0.05	0.12
read by other session	747,267	0	132	0	1.08	0.04
latch free	1,875	0	114	61	0.00	0.04
log file switch completion	52	0	78	1506	0.00	0.03
log file switch (private strand flush incomplete)	14	0	70	4995	0.00	0.02
db file parallel read	28,371	0	64	2	0.04	0.02
resmgr:cpu quantum	658	0	63	95	0.00	0.02
SQL*Net more data from client	208,608	0	59	0	0.30	0.02
SQL*Net message to client	9,066,659	0	28	0	13.15	0.01
SQL*Net more data to client	305,919	0	27	0	0.44	0.01
direct path write	2,957	0	15	5	0.00	0.00
log file switch (checkpoint incomplete)	3	0	13	4348	0.00	0.00
latch: shared pool	372	0	12	32	0.00	0.00
row cache lock	5	0	10	1969	0.00	0.00
latch: cache buffers lru chain	139	0	9	62	0.00	0.00
reliable message	10,357	0	7	1	0.02	0.00
write complete waits	2	0	4	2070	0.00	0.00
latch: row cache objects	51	0	4	80	0.00	0.00
SQL*Net break/reset to client	451	0	4	8	0.00	0.00
control file parallel write	273	0	4	13	0.00	0.00
library cache: mutex X	25	0	3	130	0.00	0.00
control file sequential read	107,778	0	2	0	0.16	0.00
direct path read temp	20,953	0	2	0	0.03	0.00
buffer busy waits	20	0	2	116	0.00	0.00
latch: enqueue hash chains	43	0	2	49	0.00	0.00
asynch descriptor resize	672,067	100	2	0	0.97	0.00
direct path sync	27	0	2	60	0.00	0.00
local write wait	77	0	1	14	0.00	0.00
log buffer space	1	0	1	888	0.00	0.00
ADR block file read	52	0	1	16	0.00	0.00
recovery area: computing obsolete files	7	0	1	104	0.00	0.00
enq: RO - fast object reuse	26	0	1	22	0.00	0.00
Disk file operations I/O	3,252	0	1	0	0.00	0.00
latch: object queue header operation	30	0	0	15	0.00	0.00
cursor: pin S	3	0	0	122	0.00	0.00
control file single write	98	0	0	3	0.00	0.00
recovery area: computing backed up files	7	0	0	32	0.00	0.00
ADR block file write	24	0	0	8	0.00	0.00
recovery area: computing dropped files	7	0	0	17	0.00	0.00
resmgr:internal state change	1	100	0	111	0.00	0.00
undo segment extension	14	100	0	4	0.00	0.00
kksfbc child completion	1	100	0	52	0.00	0.00
latch: messages	3	0	0	12	0.00	0.00
enq: CR - block range reuse ckpt	1	0	0	34	0.00	0.00
recovery area: computing applied logs	7	0	0	4	0.00	0.00
utl_file I/O	35	0	0	1	0.00	0.00
enq: TX - row lock contention	33	0	0	1	0.00	0.00
ADR file lock	48	0	0	0	0.00	0.00
SQL*Net message from client	9,066,647	0	33,850,146	3733	13.15
jobq slave wait	140,940	100	70,911	503	0.20
auto-sqltune: wait graph update	12	58	40	3358	0.00
PL/SQL lock timer	16	75	13	840	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)
Only events with Total Wait Time (s) >= .001 are shown
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
control file parallel write	579,884	0	9,620	17	0.84	22.26
log file parallel write	2,297,182	0	8,827	4	3.33	20.42
latch free	15,482	0	6,043	390	0.02	13.98
db file async I/O submit	104,417	0	4,898	47	0.15	11.33
process diagnostic dump	4,815	0	3,028	629	0.01	7.01
Data Guard: process clean up	1,060	94	1,015	957	0.00	2.35
ARCH wait for process start 3	995	94	963	968	0.00	2.23
Data Guard: process exit	847	86	757	893	0.00	1.75
db file sequential read	111,935	0	727	6	0.16	1.68
os thread startup	6,633	0	679	102	0.01	1.57
LNS wait on SENDREQ	1,137,654	0	516	0	1.65	1.19
enq: CF - contention	1,241	0	244	197	0.00	0.56
ARCH wait on SENDREQ	957	0	145	151	0.00	0.34
Data Guard Broker Wait	76	99	123	1624	0.00	0.29
LGWR-LNS wait on channel	9,445	100	110	12	0.01	0.26
control file sequential read	2,743,722	0	95	0	3.98	0.22
Disk file operations I/O	242,166	0	76	0	0.35	0.18
enq: PR - contention	10	0	60	6044	0.00	0.14
ADR block file read	3,905	0	54	14	0.01	0.12
ADR block file write	2,202	0	51	23	0.00	0.12
ARCH wait on ATTACH	957	0	36	38	0.00	0.08
SGA: allocation forcing component growth	262	97	28	106	0.00	0.06
Log archive I/O	3,208	0	24	7	0.00	0.06
Parameter File I/O	224,082	0	20	0	0.32	0.05
log file sync	351	0	15	44	0.00	0.04
log file switch (checkpoint incomplete)	1	0	13	13336	0.00	0.03
log file switch completion	16	0	11	674	0.00	0.02
direct path sync	180	0	10	57	0.00	0.02
latch: call allocation	87	0	9	102	0.00	0.02
db file scattered read	7,102	0	7	1	0.01	0.02
enq: PV - syncstart	1	0	7	6743	0.00	0.02
log file sequential read	1,946	0	6	3	0.00	0.01
enq: CR - block range reuse ckpt	272	0	5	19	0.00	0.01
db file single write	499	0	5	10	0.00	0.01
Streams AQ: qmn coordinator waiting for slave to start	2	50	5	2583	0.00	0.01
log buffer space	4	0	4	927	0.00	0.01
db file parallel read	406	0	2	6	0.00	0.01
latch: cache buffers lru chain	207	0	2	10	0.00	0.00
resmgr:cpu quantum	32	0	2	51	0.00	0.00
log file single write	166	0	1	7	0.00	0.00
direct path write	7,606	0	1	0	0.01	0.00
rdbms ipc reply	626	0	1	1	0.00	0.00
LGWR wait for redo copy	966	0	1	1	0.00	0.00
latch: shared pool	54	0	1	11	0.00	0.00
Data file init write	12	0	1	43	0.00	0.00
reliable message	1,038	0	0	0	0.00	0.00
asynch descriptor resize	20,657	100	0	0	0.03	0.00
latch: messages	14	0	0	16	0.00	0.00
log file switch (private strand flush incomplete)	1	0	0	211	0.00	0.00
latch: object queue header operation	41	0	0	4	0.00	0.00
resmgr:internal state change	1	100	0	121	0.00	0.00
SQL*Net more data from client	419	0	0	0	0.00	0.00
undo segment extension	14	86	0	4	0.00	0.00
ADR file lock	2,080	10	0	0	0.00	0.00
RMAN backup & recovery I/O	858	0	0	0	0.00	0.00
enq: RO - fast object reuse	107	0	0	0	0.00	0.00
SQL*Net more data to client	419	0	0	0	0.00	0.00
latch: redo allocation	43	0	0	0	0.00	0.00
buffer busy waits	63	0	0	0	0.00	0.00
ARCH wait on DETACH	974	0	0	0	0.00	0.00
SQL*Net message to client	6,466	0	0	0	0.01	0.00
enq: JS - queue lock	7	0	0	1	0.00	0.00
latch: enqueue hash chains	31	0	0	0	0.00	0.00
direct path write temp	15	0	0	0	0.00	0.00
LNS wait on LGWR	35	0	0	0	0.00	0.00
ARCH wait for archivelog lock	98	0	0	0	0.00	0.00
rdbms ipc message	4,704,696	65	11,462,154	2436	6.82
DIAG idle wait	1,113,913	100	1,122,690	1008	1.62
Streams AQ: qmn slave idle wait	20,475	0	561,581	27428	0.03
dispatcher timer	9,357	100	561,579	60017	0.01
shared server idle wait	18,702	100	561,545	30026	0.03
Streams AQ: qmn coordinator idle wait	28,956	69	561,515	19392	0.04
pmon timer	190,477	98	561,458	2948	0.28
smon timer	2,008	90	561,391	279577	0.00
Space Manager: slave idle wait	112,435	99	561,350	4993	0.16
LNS ASYNC end of log	1,557,182	27	560,833	360	2.26
VKRM Idle	7	0	216,000	30857076	0.00
class slave wait	3,074	0	439	143	0.00
SQL*Net message from client	8,099	0	58	7	0.01
LNS ASYNC archive log	35	100	35	1004	0.00
SGA: MMAN sleep for component shrink	393	96	4	11	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
% of Waits: value of .0 indicates value was <.05%; value of null is truly 0
% of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
Ordered by Event (idle events last)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	3957	41.8	5.2	13.5	33.0	4.4	.5	1.4	.1
ADR block file write	2226	.0	.7	8.8	70.9	8.4	1.2	9.8	.1
ADR file lock	2128	100.0					.0
ARCH wait for archivelog lock	98	100.0
ARCH wait for process start 3	995	.2			.3	.2	.3	98.1	.9
ARCH wait on ATTACH	957						76.2	23.7	.1
ARCH wait on DETACH	974	100.0
ARCH wait on SENDREQ	957							99.5	.5
Data Guard Broker Wait	76	1.3						89.5	9.2
Data Guard: process clean up	1060	1.2		.1	.6	1.2	.2	96.0	.7
Data Guard: process exit	847	7.1				.1	.2	92.0	.6
Data file init write	12	8.3					8.3	83.3
Disk file operations I/O	245.4K	99.9	.0	.0	.0	.0	.0	.1	.0
LGWR wait for redo copy	966	96.7	.1	.8	.7	.2	1.0	.4
LGWR-LNS wait on channel	9445	.0	.0	.1	.1	97.6	.9	1.4
LNS wait on DETACH	35	100.0
LNS wait on LGWR	35	100.0
LNS wait on SENDREQ	1137.6K	99.8	.1	.0	.0	.0	.0	.0	.0
Log archive I/O	3208	4.4	.5	86.7	3.2	1.5	.9	2.8
Parameter File I/O	224.1K	99.9	.0	.0	.1	.0	.0	.0	.0
RMAN backup & recovery I/O	858	99.5			.2	.2
SGA: allocation forcing component growth	262	.4					1.1	98.5
SQL*Net break/reset to client	453	92.7	.4	.7	1.8	1.3	1.5	1.3	.2
SQL*Net message to client	9073.1K	100.0	.0	.0	.0	.0
SQL*Net more data from client	209K	99.5	.3	.1	.0	.0	.0	.0
SQL*Net more data to client	306.3K	100.0	.0	.0	.0	.0	.0	.0
Streams AQ: qmn coordinator waiting for slave to start	2	50.0							50.0
asynch descriptor resize	692.7K	100.0	.0	.0			.0
buffer busy waits	83	91.6	1.2	3.6	2.4				1.2
control file parallel write	580.2K				.5	71.4	25.8	2.2	.0
control file sequential read	2851.5K	100.0	.0	.0	.0	.0	.0	.0	.0
control file single write	98	20.4	4.1	48.0	23.5	4.1
cursor: pin S	3	33.3		33.3				33.3
cursor: pin S wait on X	692					.1	.1	2.3	97.4
db file async I/O submit	104.4K	.0	.1	1.7	14.2	21.5	29.2	33.3	.2
db file parallel read	28.8K	43.6	21.9	18.6	13.4	1.4	.6	.4
db file scattered read	65.2M	100.0	.0	.0	.0	.0	.0	.0	.0
db file sequential read	101M	100.0	.0	.0	.0	.0	.0	.0	.0
db file single write	499			10.4	57.1	27.9	2.8	1.8
direct path read	22.4M	99.6	.3	.1	.0	.0	.0	.0	.0
direct path read temp	21K	100.0	.0	.0	.0	.0
direct path sync	207					1.0	45.4	52.7	1.0
direct path write	10.6K	79.0	.4	2.3	14.8	2.1	1.1	.2
direct path write temp	33.4K	1.3	.0	1.2	48.0	32.4	14.4	2.8
enq: CF - contention	1240	7.3	1.0	2.6	.8	.7	1.8	85.3	.6
enq: CR - block range reuse ckpt	273				.7	40.3	53.8	5.1
enq: JS - queue lock	7	71.4	14.3	14.3
enq: KO - fast object checkpoint	10.3K			.0	.4	4.5	24.6	70.0	.5
enq: PR - contention	10				10.0	10.0	20.0	10.0	50.0
enq: PV - syncstart	1								100.0
enq: RF - synch: DG Broker metadata	14	100.0
enq: RO - fast object reuse	133	81.2	1.5			2.3	13.5	1.5
enq: TX - row lock contention	33	72.7	18.2	9.1
kksfbc child completion	1							100.0
latch free	17.4K	76.4	.1	.1	.1	.1	2.4	7.7	13.2
latch: In memory undo latch	4	100.0
latch: cache buffers chains	32.6K	13.7	.1	.2	.4	1.3	6.3	77.5	.6
latch: cache buffers lru chain	346	74.6	.6	.9	1.7	4.3	4.0	13.6	.3
latch: call allocation	89	31.5	1.1	1.1	2.2	6.7	11.2	46.1
latch: enqueue hash chains	74	63.5					1.4	35.1
latch: messages	17	76.5					5.9	17.6
latch: object queue header operation	71	83.1	2.8	2.8	2.8	1.4	2.8	4.2
latch: redo allocation	43	97.7					2.3
latch: redo writing	2	100.0
latch: row cache objects	55	58.2		3.6	9.1	1.8	1.8	25.5
latch: shared pool	426	47.2	3.8	4.9	9.2	10.1	7.7	17.1
library cache lock	65	9.2		3.1	1.5	6.2		60.0	20.0
library cache: mutex X	25	16.0				4.0	12.0	68.0
local write wait	77				3.9	68.8	26.0	1.3
log buffer space	5				20.0			40.0	40.0
log file parallel write	2297.2K	50.0	.6	7.4	31.6	9.1	.8	.5	.0
log file sequential read	1946	53.4	3.2	32.3	3.5	4.8	1.5	1.2
log file single write	166		.6	21.7	58.4	16.3	2.4	.6
log file switch (checkpoint incomplete)	4							25.0	75.0
log file switch (private strand flush incomplete)	15							26.7	73.3
log file switch completion	68					1.5	1.5	51.5	45.6
log file sync	744.3K	.0	1.0	15.1	68.1	13.1	1.3	1.2	.0
os thread startup	6633	.0					91.7	7.8	.5
process diagnostic dump	4815	12.4	4.6	11.7	13.3	.5	23.3	1.3	32.9
rdbms ipc reply	626	96.6	.3	.2	.5	1.0	.2	1.3
read by other session	747.3K	99.7	.0	.0	.0	.0	.1	.1	.0
recovery area: computing applied logs	7			71.4	14.3	14.3
recovery area: computing backed up files	7						85.7	14.3
recovery area: computing dropped files	7				71.4	14.3		14.3
recovery area: computing obsolete files	7						57.1	42.9
reliable message	11.4K	94.2	1.3	2.5	.8	.7	.3	.1
resmgr:cpu quantum	690	14.9	3.2	2.8	4.8	13.9	8.6	50.9	1.0
resmgr:internal state change	2							100.0
row cache lock	5	80.0							20.0
undo segment extension	28	64.3	3.6	3.6		21.4	7.1
utl_file I/O	35	94.3			2.9		2.9
write complete waits	2								100.0
DIAG idle wait	1113.9K	.0						99.2	.8
LNS ASYNC archive log	35							97.1	2.9
LNS ASYNC end of log	1557.2K	.1	.1	.3	20.5	19.6	12.3	47.0	.1
PL/SQL lock timer	16	12.5						62.5	25.0
SGA: MMAN sleep for component shrink	393	.3	1.0		1.5	95.4	1.8
SQL*Net message from client	9074.7K	75.9	3.3	3.9	.3	1.6	1.0	1.7	12.3
Space Manager: slave idle wait	112.4K	.3	.0			.0		.0	99.7
Streams AQ: qmn coordinator idle wait	29K	30.6	.1	.0	.0	.0	.0	.0	69.2
Streams AQ: qmn slave idle wait	20.5K	2.2					.0		97.8
VKRM Idle	7								100.0
auto-sqltune: wait graph update	12	41.7							58.3
class slave wait	3074	98.5	.9	.2	.0	.0		.2	.1
dispatcher timer	9357								100.0
jobq slave wait	140.9K	.1	.0	.0	.0	.0	.0	99.7	.2
pmon timer	190.5K	1.4	.0	.0	.0	.0	.0	.4	98.1
rdbms ipc message	4704.7K	3.4	4.0	1.8	4.5	3.2	1.4	41.5	40.0
shared server idle wait	18.7K								100.0
smon timer	2008	1.5			.0			.6	97.9

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ADR block file read	56	98.5	.3	.8	.2	.1	.0	.0	.1
ADR block file write	219	90.1	4.1	3.7	.5	1.2	.3		.1
ARCH wait for process start 3	985	1.0	.3	.2	.8	1.3	95.5	.9
ARCH wait on ATTACH	227	76.2	20.6	2.0	.8	.1	.2		.1
ARCH wait on SENDREQ	955		1.7	71.2	17.0	6.8	2.8	.3	.2
Data Guard Broker Wait	73	1.3					89.5	6.6	2.6
Data Guard: process clean up	1024	3.3	.3	.1	.4	1.0	94.2	.6	.1
Data Guard: process exit	784	7.4	.1	.5	1.2	2.2	88.0	.6
Data file init write	10	16.7	75.0	8.3
Disk file operations I/O	169	99.9	.1	.0	.0				.0
LGWR wait for redo copy	4	99.6	.3	.1
LGWR-LNS wait on channel	130	98.6	1.4	.0
LNS wait on SENDREQ	243	100.0	.0	.0	.0	.0	.0	.0	.0
Log archive I/O	90	97.2	.2	.7	1.5	.3	.0
Parameter File I/O	1	100.0			.0				.0
SGA: allocation forcing component growth	258	1.5	.8	92.0	5.0	.8
SQL*Net break/reset to client	6	98.5	.7	.4			.2		.2
SQL*Net more data from client	24	100.0	.0	.0		.0
SQL*Net more data to client	14	100.0	.0	.0	.0	.0
control file parallel write	12.8K	97.8	1.3	.6	.1	.1	.0	.0	.0
control file sequential read	41	100.0	.0	.0	.0	.0		.0	.0
cursor: pin S	1	66.7				33.3
cursor: pin S wait on X	33	.3	.1	.1	.6	.6	.9	2.5	94.9
db file async I/O submit	34.9K	66.6	20.6	7.3	4.2	1.0	.2	.1	.0
db file parallel read	116	99.6	.3	.1	.0		.0
db file scattered read	1224	100.0	.0	.0	.0	.0	.0	.0	.0
db file sequential read	364	100.0	.0	.0	.0	.0	.0	.0	.0
db file single write	9	98.2	.6	.6	.2	.4
direct path read	1530	100.0	.0	.0	.0	.0	.0	.0	.0
direct path sync	111	46.4	44.9	5.3	1.9	.5		1.0
direct path write	21	99.8	.2	.0	.0
direct path write temp	925	97.2	2.5	.2	.0	.0
enq: CF - contention	1058	14.1	65.6	17.1	2.2	.3	.1		.6
enq: CR - block range reuse ckpt	14	94.9	4.4	.4	.4
enq: KO - fast object checkpoint	7248	29.5	32.2	21.4	10.2	4.5	1.7	.4	.0
enq: PR - contention	1	40.0	10.0						50.0
enq: RO - fast object reuse	2	98.5	.8		.8
kksfbc child completion	1		100.0
latch free	2701	79.2	1.1	1.4	1.2	.5	3.5	7.9	5.3
latch: cache buffers chains	25.4K	21.9	15.9	29.5	24.9	6.5	.7	.3	.3
latch: cache buffers lru chain	48	86.1	4.0	4.0	1.7	3.5	.3	.3
latch: call allocation	41	53.9	1.1	9.0	23.6	12.4
latch: enqueue hash chains	26	64.9	18.9	10.8	5.4
latch: messages	3	82.4	5.9	5.9	5.9
latch: object queue header operation	3	95.8	1.4	1.4		1.4
latch: row cache objects	14	74.5	7.3	5.5		7.3	5.5
latch: shared pool	73	82.9	5.2	6.8	3.1	1.4	.7
library cache lock	45	20.0	43.1	9.2	3.1	3.1	1.5	9.2	10.8
library cache: mutex X	17	32.0	16.0	12.0	20.0	20.0
local write wait	1	98.7	1.3
log buffer space	3	20.0	20.0				20.0	20.0	20.0
log file parallel write	11.9K	99.5	.3	.1	.1	.0	.0	.0	.0
log file sequential read	23	98.8	.7	.3	.2		.1
log file single write	1	99.4	.6
log file switch (checkpoint incomplete)	1			25.0					75.0
log file switch (private strand flush incomplete)	5		6.7	6.7	13.3			6.7	66.7
log file switch completion	41	2.9	4.4	30.9	4.4	1.5	10.3	8.8	36.8
log file sync	8823	98.8	.6	.3	.2	.1	.0	.0	.0
os thread startup	524	91.7	6.2	.6	.5	.3	.2	.1	.4
process diagnostic dump	1575	65.8	.9	.2	.2	.0	.0	31.4	1.5
rdbms ipc reply	8	98.7	1.0	.2	.2
read by other session	437	99.9	.0	.0	.0	.0	.0	.0	.0
recovery area: computing backed up files	1	85.7		14.3
recovery area: computing dropped files	1	85.7		14.3
recovery area: computing obsolete files	3	57.1	28.6			14.3
reliable message	16	99.9	.1	.1
resmgr:cpu quantum	355	48.1	11.2	22.6	12.2	4.1	.9	.6	.4
resmgr:internal state change	2			100.0
write complete waits	1							50.0	50.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
		% of Total Waits
ADR block file read	4	99.9	.0	.1		.0
ADR block file write	2	99.9		.1
ARCH wait on ATTACH	1	99.9	.1
ARCH wait on SENDREQ	2	99.8	.1	.1
Data Guard Broker Wait	2	97.4				2.6
Data Guard: process clean up	1	99.9	.1
Disk file operations I/O	2	100.0				.0
LNS wait on SENDREQ	37	100.0	.0	.0	.0
Parameter File I/O	1	100.0			.0
SQL*Net break/reset to client	1	99.8	.2
Streams AQ: qmn coordinator waiting for slave to start	1	50.0		50.0
buffer busy waits	1	98.8	1.2
control file parallel write	21	100.0	.0	.0	.0	.0	.0
control file sequential read	5	100.0	.0	.0	.0
cursor: pin S wait on X	174	5.1	3.2	5.6	4.0	4.2	3.5	4.6	69.8
db file async I/O submit	47	100.0	.0	.0	.0	.0			.0
db file scattered read	2	100.0	.0
db file sequential read	39	100.0	.0	.0	.0	.0	.0
direct path read	3	100.0	.0	.0
enq: CF - contention	7	99.4	.2	.1	.2			.1
enq: KO - fast object checkpoint	5	100.0	.0
enq: PR - contention	5	50.0	10.0	20.0		20.0
enq: PV - syncstart	1			100.0
latch free	917	94.7	4.8	.3	.1	.0	.0	.0
latch: cache buffers chains	91	99.7	.2	.1	.0	.0
library cache lock	6	89.2					1.5	7.7	1.5
log buffer space	1	80.0	20.0
log file parallel write	18	100.0	.0	.0	.0	.0	.0
log file switch (checkpoint incomplete)	3	25.0	25.0		50.0
log file switch (private strand flush incomplete)	10	33.3	40.0	13.3	6.7	6.7
log file switch completion	25	63.2	36.8
log file sync	115	100.0	.0	.0	.0	.0	.0
os thread startup	24	99.6	.1	.0	.1	.2	.0
process diagnostic dump	72	98.5	.8	.4	.2	.1	.0
read by other session	3	100.0	.0
resmgr:cpu quantum	3	99.6	.4
row cache lock	1	80.0			20.0
write complete waits	1	50.0	50.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes) h is 4096*1024 milliseconds (approximately 70 minutes or 1.17 hours)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 4m to 1h	<2m	<4m	<8m
		% of Total Waits
cursor: pin S wait on X	483	30.2	14.2	55.6
db file async I/O submit	2	100.0	.0
library cache lock	1	98.5		1.5

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
SYS$USERS	291,455	96,169	2,020,122	5,414,091
orclstby	17,660	11,196	1,047,216	1,106,138
SYS$BACKGROUND	0	0	335	30,126
orclstbyXDB	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	180214576	10856	33750	157356	4384642	96
orclstby	9103442	4645	105	18	5188769	17
SYS$BACKGROUND	592176	845	6740	680	1140613	697

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 56.1% of Total DB Time (s): 309,117
Captured PL/SQL account for 6.5% of Total DB Time (s): 309,117

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
28,882.53	18	1,604.58	9.34	0.03	0.00	50ytwwtkwc9yx	JDBC Thin Client	select * from (select a.*, row...
28,007.40	15	1,867.16	9.06	1.19	0.24	8svmgbjgq1rhj	JDBC Thin Client	select * from (select a.*, row...
18,070.78	9	2,007.86	5.85	13.66	0.00	8gnqvbwpu0x4s	JDBC Thin Client	select count(*) as cnt_total, ...
18,014.49	7	2,573.50	5.83	96.02	4.56	59v4zh1ac3v2a	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
17,872.02	20	893.60	5.78	7.19	0.17	8x77wds414f3v	JDBC Thin Client	select * from (select a.*, row...
15,909.59	9,871	1.61	5.15	93.30	32.82	gpb77nw9jsa19	JDBC Thin Client	SELECT TID TID, SUM(FEE_AMT) I...
12,325.58	12	1,027.13	3.99	14.57	0.00	5tdxj1yuaatm9	JDBC Thin Client	select count(*) as cnt_total, ...
9,973.41	9,014	1.11	3.23	96.80	19.33	cksqs9djg3npj	JDBC Thin Client	SELECT S.TRANS_ID, S.ORG_ID, S...
5,773.84	6	962.31	1.87	15.36	0.00	dpyujwynmqqnr	JDBC Thin Client	select count(*) from ((((((his...
2,552.45	14,322	0.18	0.83	99.74	47.98	fqwdpgf3fj8uc	rscan@POS2 (TNS V1-V3)	select max(end_date) , max(txn...

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 - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 55.8% of Total CPU Time (s): 107,367
Captured PL/SQL account for 17.1% of Total CPU Time (s): 107,367

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
17,297.82	7	2,471.12	16.11	18,014.49	96.02	4.56	59v4zh1ac3v2a	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
14,844.13	9,871	1.50	13.83	15,909.59	93.30	32.82	gpb77nw9jsa19	JDBC Thin Client	SELECT TID TID, SUM(FEE_AMT) I...
9,654.48	9,014	1.07	8.99	9,973.41	96.80	19.33	cksqs9djg3npj	JDBC Thin Client	SELECT S.TRANS_ID, S.ORG_ID, S...
2,545.89	14,322	0.18	2.37	2,552.45	99.74	47.98	fqwdpgf3fj8uc	rscan@POS2 (TNS V1-V3)	select max(end_date) , max(txn...
2,528.81	14,207	0.18	2.36	2,535.73	99.73	47.85	cucgzf9rrrtrh	rscan@POS2 (TNS V1-V3)	select max(txn_amt) into :b0 f...
2,467.69	9	274.19	2.30	18,070.78	13.66	0.00	8gnqvbwpu0x4s	JDBC Thin Client	select count(*) as cnt_total, ...
2,157.21	12,833	0.17	2.01	2,163.31	99.72	50.51	1qzp3x4unnb8y	rscan@POS2 (TNS V1-V3)	select max(end_date) , max(txn...
2,146.79	12,725	0.17	2.00	2,152.80	99.72	50.29	bnjnpxuj8h28a	rscan@POS2 (TNS V1-V3)	select max(txn_amt) into :b0 f...
1,796.28	12	149.69	1.67	12,325.58	14.57	0.00	5tdxj1yuaatm9	JDBC Thin Client	select count(*) as cnt_total, ...
1,284.70	20	64.23	1.20	17,872.02	7.19	0.17	8x77wds414f3v	JDBC Thin Client	select * from (select a.*, row...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 91.3% of Total User I/O Wait Time (s): 16,347
Captured PL/SQL account for 6.7% of Total User I/O Wait Time (s): 16,347

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
5,221.72	9,871	0.53	31.94	15,909.59	93.30	32.82	gpb77nw9jsa19	JDBC Thin Client	SELECT TID TID, SUM(FEE_AMT) I...
1,928.30	9,014	0.21	11.80	9,973.41	96.80	19.33	cksqs9djg3npj	JDBC Thin Client	SELECT S.TRANS_ID, S.ORG_ID, S...
1,224.63	14,322	0.09	7.49	2,552.45	99.74	47.98	fqwdpgf3fj8uc	rscan@POS2 (TNS V1-V3)	select max(end_date) , max(txn...
1,213.44	14,207	0.09	7.42	2,535.73	99.73	47.85	cucgzf9rrrtrh	rscan@POS2 (TNS V1-V3)	select max(txn_amt) into :b0 f...
1,092.73	12,833	0.09	6.68	2,163.31	99.72	50.51	1qzp3x4unnb8y	rscan@POS2 (TNS V1-V3)	select max(end_date) , max(txn...
1,082.64	12,725	0.09	6.62	2,152.80	99.72	50.29	bnjnpxuj8h28a	rscan@POS2 (TNS V1-V3)	select max(txn_amt) into :b0 f...
822.31	7	117.47	5.03	18,014.49	96.02	4.56	59v4zh1ac3v2a	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
349.44	11	31.77	2.14	451.40	25.22	77.41	a5tu6fyby63za	DBMS_SCHEDULER	/* SQL Analyze(183, 1) */ sele...
170.20	296	0.57	1.04	1,110.40	86.48	15.33	7gnwmzqs1gw9k	JDBC Thin Client	select * from (select a.*, row...
155.01	287	0.54	0.95	530.74	95.12	29.21	354nafr89dv0k	JDBC Thin Client	select count(*) from ((((((his...

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 as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 6,550,355,091
Captured SQL account for 95.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,298,255,906	9	144,250,656.22	19.82	18,070.78	13.66	0.00	8gnqvbwpu0x4s	JDBC Thin Client	select count(*) as cnt_total, ...
1,233,689,766	9,871	124,981.23	18.83	15,909.59	93.30	32.82	gpb77nw9jsa19	JDBC Thin Client	SELECT TID TID, SUM(FEE_AMT) I...
953,646,131	12	79,470,510.92	14.56	12,325.58	14.57	0.00	5tdxj1yuaatm9	JDBC Thin Client	select count(*) as cnt_total, ...
476,945,682	6	79,490,947.00	7.28	5,773.84	15.36	0.00	dpyujwynmqqnr	JDBC Thin Client	select count(*) from ((((((his...
474,321,510	9,014	52,620.54	7.24	9,973.41	96.80	19.33	cksqs9djg3npj	JDBC Thin Client	SELECT S.TRANS_ID, S.ORG_ID, S...
283,046,856	14,322	19,763.08	4.32	2,552.45	99.74	47.98	fqwdpgf3fj8uc	rscan@POS2 (TNS V1-V3)	select max(end_date) , max(txn...
280,769,856	14,207	19,762.78	4.29	2,535.73	99.73	47.85	cucgzf9rrrtrh	rscan@POS2 (TNS V1-V3)	select max(txn_amt) into :b0 f...
252,732,459	12,833	19,693.95	3.86	2,163.31	99.72	50.51	1qzp3x4unnb8y	rscan@POS2 (TNS V1-V3)	select max(end_date) , max(txn...
250,622,980	12,725	19,695.32	3.83	2,152.80	99.72	50.29	bnjnpxuj8h28a	rscan@POS2 (TNS V1-V3)	select max(txn_amt) into :b0 f...
144,018,480	7	20,574,068.57	2.20	18,014.49	96.02	4.56	59v4zh1ac3v2a	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
79,598,183	1	79,598,183.00	1.22	162.08	99.66	0.00	aadkaf3qqx1da	JDBC Thin Client	select * from (select a.*, row...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 3,067,673,638
Captured SQL account for 96.6% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,233,604,540	9,871	124,972.60	40.21	15,909.59	93.30	32.82	gpb77nw9jsa19	JDBC Thin Client	SELECT TID TID, SUM(FEE_AMT) I...
277,610,482	14,322	19,383.50	9.05	2,552.45	99.74	47.98	fqwdpgf3fj8uc	rscan@POS2 (TNS V1-V3)	select max(end_date) , max(txn...
275,377,167	14,207	19,383.20	8.98	2,535.73	99.73	47.85	cucgzf9rrrtrh	rscan@POS2 (TNS V1-V3)	select max(txn_amt) into :b0 f...
247,870,797	12,833	19,315.11	8.08	2,163.31	99.72	50.51	1qzp3x4unnb8y	rscan@POS2 (TNS V1-V3)	select max(end_date) , max(txn...
245,801,902	12,725	19,316.46	8.01	2,152.80	99.72	50.29	bnjnpxuj8h28a	rscan@POS2 (TNS V1-V3)	select max(txn_amt) into :b0 f...
245,364,865	9,014	27,220.42	8.00	9,973.41	96.80	19.33	cksqs9djg3npj	JDBC Thin Client	SELECT S.TRANS_ID, S.ORG_ID, S...
70,862,195	7	10,123,170.71	2.31	18,014.49	96.02	4.56	59v4zh1ac3v2a	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
35,913,767	287	125,135.08	1.17	530.74	95.12	29.21	354nafr89dv0k	JDBC Thin Client	select count(*) from ((((((his...
35,789,431	286	125,137.87	1.17	527.38	95.24	29.24	fu8ama8sk13xq	JDBC Thin Client	select count(*) as cnt_total, ...
30,359,408	296	102,565.57	0.99	1,110.40	86.48	15.33	7gnwmzqs1gw9k	JDBC Thin Client	select * from (select a.*, row...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 190,708,647
Captured SQL account for 53.2% of Total
Total UnOptimized Read Requests: 190,708,647
Captured SQL account for 53.2% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
66,030,903	66,030,903	9,014	7,325.37	34.62	cksqs9djg3npj	JDBC Thin Client	SELECT S.TRANS_ID, S.ORG_ID, S...
13,925,334	13,925,334	7	1,989,333.43	7.30	59v4zh1ac3v2a	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
5,952,691	5,952,691	9,871	603.05	3.12	gpb77nw9jsa19	JDBC Thin Client	SELECT TID TID, SUM(FEE_AMT) I...
2,381,592	2,381,592	14,322	166.29	1.25	fqwdpgf3fj8uc	rscan@POS2 (TNS V1-V3)	select max(end_date) , max(txn...
2,362,432	2,362,432	14,207	166.29	1.24	cucgzf9rrrtrh	rscan@POS2 (TNS V1-V3)	select max(txn_amt) into :b0 f...
2,122,839	2,122,839	12,833	165.42	1.11	1qzp3x4unnb8y	rscan@POS2 (TNS V1-V3)	select max(end_date) , max(txn...
2,105,115	2,105,115	12,725	165.43	1.10	bnjnpxuj8h28a	rscan@POS2 (TNS V1-V3)	select max(txn_amt) into :b0 f...
1,719,743	1,719,743	69	24,923.81	0.90	gmmm86n7yuhds	JDBC Thin Client	select * from (select a.*, row...
741,692	741,692	35	21,191.20	0.39	5ytxuv41w99um	JDBC Thin Client	select * from (select a.*, row...
592,333	592,333	56	10,577.38	0.31	4utsscm4jx72g	JDBC Thin Client	select hist_trans.acc_type as ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 7,601,423
Captured SQL account for 72.9% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
427,166	427,198	1.00	24.64	93.62	0.00	388ag3suq32fk	boc_logon@POS2 (TNS V1-V3)	select null into :b0 from DUAL...
417,016	417,016	1.00	41.93	95.75	0.00	7h35uxf5uhmm1	JDBC Thin Client	select sysdate from dual
256,240	256,240	1.00	12.92	99.76	0.00	4h2q8uyah4ds7	POSP_MSG@POS2 (TNS V1-V3)	select SYSDATE into :b0 from D...
204,393	204,393	1.00	20.05	38.03	0.06	7sx5p1ug5ag12	DBMS_SCHEDULER	SELECT SPARE4 FROM SYS.OPTSTAT...
166,124	0	0.00	5.19	78.05	0.00	cn39cg7kr98v6	DBMS_SCHEDULER	SELECT P.VALCHAR FROM SYS.OPTS...
164,985	100,480	0.61	9.94	100.09	0.00	97mnf9k0s7hkb	POSP_MSG@POS2 (TNS V1-V3)	select parent_code into :b0 fr...
164,715	164,680	1.00	24.64	98.68	0.14	8fg7pd57sg8qj	POSP_MSG@POS2 (TNS V1-V3)	select appl_id , mid , tid , e...
161,741	126,516	0.78	28.96	97.63	0.00	9x5hqb6m9tcqd	POSP_MSG@POS2 (TNS V1-V3)	insert into tmp_rt_cfg (rule_i...
141,461	0	0.00	18.48	92.51	0.00	c61pagq2dc9tf	abc_logon@POS2 (TNS V1-V3)	select t.rowid , t.sp_id , t.s...
133,716	133,716	1.00	174.95	88.44	0.00	2t5j4fktu8r8j	POSP_MSG@POS2 (TNS V1-V3)	select max(card_bin) into :b0 ...
133,579	133,120	1.00	10.03	99.64	0.06	1fd0uth6vkb9h	POSP_MSG@POS2 (TNS V1-V3)	select card_bin , trk_id , bin...
131,903	0	0.00	45.00	96.01	0.00	f15fwh05y4gap	boc_logon@POS2 (TNS V1-V3)	select tid_cnv.rowid , tid_cnv...
131,546	131,546	1.00	10.58	102.16	0.00	bfthth6tpy5z6	POSP_MSG@POS2 (TNS V1-V3)	select count(*) into :b0 from ...
104,322	104,303	1.00	14.26	94.76	0.02	53wfrpab6f8pq	JDBC Thin Client	select mchinfo0_.MID as MID16_...
103,919	103,919	1.00	45.76	49.68	0.02	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
101,882	101,881	1.00	766.14	94.53	0.00	0bkjwu3swz0wy		SELECT value, type FROM v$para...
101,719	101,717	1.00	10.62	90.78	0.37	4p2y8pfy5mnhk	POSP_MSG@POS2 (TNS V1-V3)	select mid , cname , br_cname ...
100,078	226	0.00	5.85	105.36	0.00	g7t6jxn5u76s7	cncb_logon@POS2 (TNS V1-V3)	select distinct rc_text into :...
83,378	83,378	1.00	594.15	91.39	0.00	bmquxnvdftw7t		SELECT value FROM v$parameter ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 5,170,413
Captured SQL account for 73.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
417,016	417,016	8.07	7h35uxf5uhmm1	JDBC Thin Client	select sysdate from dual
133,716	133,716	2.59	2t5j4fktu8r8j	POSP_MSG@POS2 (TNS V1-V3)	select max(card_bin) into :b0 ...
133,579	133,579	2.58	1fd0uth6vkb9h	POSP_MSG@POS2 (TNS V1-V3)	select card_bin , trk_id , bin...
131,546	131,546	2.54	bfthth6tpy5z6	POSP_MSG@POS2 (TNS V1-V3)	select count(*) into :b0 from ...
104,322	104,322	2.02	53wfrpab6f8pq	JDBC Thin Client	select mchinfo0_.MID as MID16_...
103,919	103,919	2.01	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
101,882	101,882	1.97	0bkjwu3swz0wy		SELECT value, type FROM v$para...
89,752	256,240	1.74	4h2q8uyah4ds7	POSP_MSG@POS2 (TNS V1-V3)	select SYSDATE into :b0 from D...
88,677	164,715	1.72	8fg7pd57sg8qj	POSP_MSG@POS2 (TNS V1-V3)	select appl_id , mid , tid , e...
83,378	83,378	1.61	bmquxnvdftw7t		SELECT value FROM v$parameter ...
72,647	427,166	1.41	388ag3suq32fk	boc_logon@POS2 (TNS V1-V3)	select null into :b0 from DUAL...
72,367	101,719	1.40	4p2y8pfy5mnhk	POSP_MSG@POS2 (TNS V1-V3)	select mid , cname , br_cname ...
71,986	100,078	1.39	g7t6jxn5u76s7	cncb_logon@POS2 (TNS V1-V3)	select distinct rc_text into :...
70,659	70,659	1.37	542xwh588kwc9	JDBC Thin Client	select * from posp_trans_con w...
67,775	67,775	1.31	fg2kb5jf0rb0q	POSP_MSG@POS2 (TNS V1-V3)	update tid_cnv set trace1=:b0,...
67,601	67,601	1.31	fs32yyv34zcxd	POSP_MSG@POS2 (TNS V1-V3)	update tid_rot set use_status=...
67,048	67,048	1.30	c03f8gtt8kfa5	POSP_MSG@POS2 (TNS V1-V3)	select mid , sp_id , tid , sp_...
67,024	67,456	1.30	9b7k0cq7uwr4x	POSP_MSG@POS2 (TNS V1-V3)	select appl_id , txn_id , msg_...
66,157	66,157	1.28	bz6g38c3yk2gp	cncb_logon@POS2 (TNS V1-V3)	select sp_id , txn_id , txn_na...
65,726	65,726	1.27	5vmgdn89nwy11	cncb_logon@POS2 (TNS V1-V3)	select sp_name , appl_id , set...
64,506	164,985	1.25	97mnf9k0s7hkb	POSP_MSG@POS2 (TNS V1-V3)	select parent_code into :b0 fr...
64,411	64,410	1.25	2j2bh9ckfmqz6	POSP_MSG@POS2 (TNS V1-V3)	delete from tmp_rt_cfg
64,168	64,168	1.24	7mq1q8gyxh5ju	POSP_MSG@POS2 (TNS V1-V3)	select rule_id , rt_cond , sp_...
63,544	63,544	1.23	6n7su0tc4yt91	POSP_MSG@POS2 (TNS V1-V3)	delete from tmp_rt
63,258	161,741	1.22	9x5hqb6m9tcqd	POSP_MSG@POS2 (TNS V1-V3)	insert into tmp_rt_cfg (rule_i...
63,081	63,081	1.22	frh3pbp41p8tq	JDBC Thin Client	update hist_trans set bank_rat...
62,797	62,857	1.21	9cb7wppwqrujs	POSP_MSG@POS2 (TNS V1-V3)	update tid_rot set use_status=...
62,709	62,709	1.21	cat301jv56yss	POSP_MSG@POS2 (TNS V1-V3)	update tid_rot set use_status=...
62,357	62,357	1.21	51m2pcmryyxw0	POSP_MSG@POS2 (TNS V1-V3)	SELECT COUNT(*) FROM tmp_rt WH...
62,043	62,043	1.20	a7dr5gsqqp901	JDBC Thin Client	SELECT TRANS_ID, PAN, DECODE(T...
61,841	61,841	1.20	gwqza2qp909sd	POSP_MSG@POS2 (TNS V1-V3)	select mid , sp_id , tid , sp_...
60,443	60,443	1.17	1vkysvvhcu8qu	POSP_MSG@POS2 (TNS V1-V3)	select sp_id into :b0 from tid...
58,063	58,063	1.12	6fp8fvthq7h5s	POSP_MSG@POS2 (TNS V1-V3)	select count(*) into :b0 from ...
57,851	57,851	1.12	7gkgdf65zz9v7	POSP_MSG@POS2 (TNS V1-V3)	select count(*) into :b0 from ...
55,143	55,143	1.07	css530d1fpqzf	POSP_MSG@POS2 (TNS V1-V3)	SELECT COUNT(*) FROM tmp_rt WH...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
7,333,448	2,035	0.60	bn4b3vjw2mj3u		SELECT OBJOID, CLSOID, DECODE(...
4,240,387	312	0.35	69k5bhm12sz98		SELECT dbin.instance_number, d...
3,679,478	350	0.30	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
3,354,873	156	0.27	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
3,350,786	63	0.27	6wm3n4d7bnddg		SELECT source, (case when tim...
3,210,794	134	0.26	a5mmhrrnpwjsc		SELECT OBJOID, CLSOID, (2*PRI ...
2,615,190	204	0.21	g9rkc277bsu74	JDBC Thin Client	select * from (select a.*, row...
2,359,913	610	0.19	1tgukkrqj3zhw		SELECT OBJOID, CLSOID, (2*PRI ...
2,352,433	137	0.19	9n8xc314xdm0t		insert into wrh$_shared_server...
2,216,977	28	0.18	2zd224kurqsr9		SELECT XMLTYPE(I.DATA) AS DATA...
2,174,678	125	0.18	45bv8pz1znkhr		UPDATE WRI$_ADV_RECOMMENDATION...
2,077,591	974	0.17	cumjq42201t37		select u1.user#, u2.user#, u3....
2,070,654	168	0.17	5s34t44u10q4g		SELECT a.name task_name, nvl(e...
1,930,652	168	0.16	akh9zqqkx3wj7		select 1, max(id) from sys.wri...
1,915,016	82	0.16	5bfb0gqkhhnmb	POSP_MSG@POS2 (TNS V1-V3)	select TRANS.* from TRANS wher...
1,836,048	45	0.15	dkjtq5u817q9y	POSP_MSG@POS2 (TNS V1-V3)	select trans.* from trans wher...
1,770,215	90	0.14	8n9b0k4n9g3bb	JDBC Thin Client	select * from (select a.*, row...
1,656,539	80	0.14	f0wj261bm8snd		update wrm$_wr_control set sna...
1,532,729	313	0.13	730vdzhng6m6g	DBMS_SCHEDULER	update sys.scheduler$_job set ...
1,479,157	18	0.12	18u5bnb9bzvha	DBMS_SCHEDULER	SELECT STATUS# FROM SYS.DBA_AD...
1,460,244	168	0.12	gdn3ysuyssf82		SELECT advisor_id FROM sys.wri...
1,360,511	168	0.11	c8gnrhxma4tas		SELECT owner#, property FROM s...
1,321,485	79	0.11	aktbxfjwnzgmu		update WRM$_DATABASE_INSTANCE ...
1,321,193	388	0.11	g4gp07gt2z920		update sys.scheduler$_job set ...
1,304,978	974	0.11	47a50dvdgnxc2		update sys.job$ set failures=0...
1,218,066	9	0.10	d2g2xjjz4d2rp		SELECT MAX(E.EXECUTION_NAME) F...
1,209,942	70	0.10	fstp7x8vrq235	DBMS_SCHEDULER	UPDATE SYS.WRI$_ADV_TASKS SET ...
1,192,797	1,388	0.10	crwtm662ycm4w		select count(*) from sys.job$ ...
1,142,979	928	0.09	19x1189chq3xd		SELECT LOCKID FROM DBMS_LOCK_A...
1,067,673	46,165	0.09	bqdxkn8qx7mkj	POSP_MSG@POS2 (TNS V1-V3)	insert into trans values (:s1 ...
1,060,272	40	0.09	84ygtc6ucuafk	DBMS_SCHEDULER	update sys.scheduler$_job set ...

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
141	312	69k5bhm12sz98		SELECT dbin.instance_number, d...
117	168	gdn3ysuyssf82		SELECT advisor_id FROM sys.wri...
112	168	5s34t44u10q4g		SELECT a.name task_name, nvl(e...
109	168	c8gnrhxma4tas		SELECT owner#, property FROM s...
83	61,841	gwqza2qp909sd	POSP_MSG@POS2 (TNS V1-V3)	select mid , sp_id , tid , sp_...
82	67,048	c03f8gtt8kfa5	POSP_MSG@POS2 (TNS V1-V3)	select mid , sp_id , tid , sp_...
82	67,601	fs32yyv34zcxd	POSP_MSG@POS2 (TNS V1-V3)	update tid_rot set use_status=...
81	20,750	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
81	974	47a50dvdgnxc2		update sys.job$ set failures=0...
81	67,775	fg2kb5jf0rb0q	POSP_MSG@POS2 (TNS V1-V3)	update tid_cnv set trace1=:b0,...
80	60,443	1vkysvvhcu8qu	POSP_MSG@POS2 (TNS V1-V3)	select sp_id into :b0 from tid...
80	168	akh9zqqkx3wj7		select 1, max(id) from sys.wri...
80	62,709	cat301jv56yss	POSP_MSG@POS2 (TNS V1-V3)	update tid_rot set use_status=...
79	33,683	7wv6hr9pbkmaz	POSP_MSG@POS2 (TNS V1-V3)	select count(*) into :b0 from ...
77	974	cumjq42201t37		select u1.user#, u2.user#, u3....
76	928	19x1189chq3xd		SELECT LOCKID FROM DBMS_LOCK_A...
76	15,283	g00cj285jmgsw		update sys.mon_mods$ set inser...
75	79	aktbxfjwnzgmu		update WRM$_DATABASE_INSTANCE ...
75	388	g4gp07gt2z920		update sys.scheduler$_job set ...
73	313	730vdzhng6m6g	DBMS_SCHEDULER	update sys.scheduler$_job set ...
72	56	0ut2yw7mxf0aq		insert into WRM$_SNAPSHOT (sna...
72	1,388	crwtm662ycm4w		select count(*) from sys.job$ ...
70	40	84ygtc6ucuafk	DBMS_SCHEDULER	update sys.scheduler$_job set ...
70	2,035	bn4b3vjw2mj3u		SELECT OBJOID, CLSOID, DECODE(...
67	80	f0wj261bm8snd		update wrm$_wr_control set sna...
67	194	gzp4qmgv72b1d	POSP_MSG@POS2 (TNS V1-V3)	SELECT sp_mid, sp_tid, trace1,...
65	131,903	f15fwh05y4gap	boc_logon@POS2 (TNS V1-V3)	select tid_cnv.rowid , tid_cnv...
65	131,903	f15fwh05y4gap	boc_logon@POS2 (TNS V1-V3)	select tid_cnv.rowid , tid_cnv...
61	610	1tgukkrqj3zhw		SELECT OBJOID, CLSOID, (2*PRI ...
61	46,165	bqdxkn8qx7mkj	POSP_MSG@POS2 (TNS V1-V3)	insert into trans values (:s1 ...
60	18	18u5bnb9bzvha	DBMS_SCHEDULER	SELECT STATUS# FROM SYS.DBA_AD...
60	28	2zd224kurqsr9		SELECT XMLTYPE(I.DATA) AS DATA...
60	82	5bfb0gqkhhnmb	POSP_MSG@POS2 (TNS V1-V3)	select TRANS.* from TRANS wher...
60	31	7gzxf61vj6wq4	DBMS_SCHEDULER	SELECT ID FROM SYS.WRI$_ADV_TA...
59	9	d2g2xjjz4d2rp		SELECT MAX(E.EXECUTION_NAME) F...
59	70	fstp7x8vrq235	DBMS_SCHEDULER	UPDATE SYS.WRI$_ADV_TASKS SET ...
55	125	45bv8pz1znkhr		UPDATE WRI$_ADV_RECOMMENDATION...
55	63	6wm3n4d7bnddg		SELECT source, (case when tim...
55	45	dkjtq5u817q9y	POSP_MSG@POS2 (TNS V1-V3)	select trans.* from trans wher...
55	45	dkjtq5u817q9y	POSP_MSG@POS2 (TNS V1-V3)	select trans.* from trans wher...
54	134	a5mmhrrnpwjsc		SELECT OBJOID, CLSOID, (2*PRI ...
48	101,719	4p2y8pfy5mnhk	POSP_MSG@POS2 (TNS V1-V3)	select mid , cname , br_cname ...
43	137	9n8xc314xdm0t		insert into wrh$_shared_server...
43	95	bunssq950snhf		insert into wrh$_sga_target_ad...
42	156	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
42	96	dayq182sk41ks		insert into wrh$_memory_target...
39	350	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
36	164,715	8fg7pd57sg8qj	POSP_MSG@POS2 (TNS V1-V3)	select appl_id , mid , tid , e...
34	204	g9rkc277bsu74	JDBC Thin Client	select * from (select a.*, row...
34	204	g9rkc277bsu74	JDBC Thin Client	select * from (select a.*, row...
34	204	g9rkc277bsu74	JDBC Thin Client	select * from (select a.*, row...
34	204	g9rkc277bsu74	JDBC Thin Client	select * from (select a.*, row...
29	90	8n9b0k4n9g3bb	JDBC Thin Client	select * from (select a.*, row...
29	90	8n9b0k4n9g3bb	JDBC Thin Client	select * from (select a.*, row...
29	90	8n9b0k4n9g3bb	JDBC Thin Client	select * from (select a.*, row...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

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

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	1,099	0.00	0.00
Batched IO (full) vector count	13,675	0.02	0.02
Batched IO (space) vector count	725	0.00	0.00
Batched IO block miss count	2,264,221	4.03	3.28
Batched IO buffer defrag count	2,461	0.00	0.00
Batched IO double miss count	18,913	0.03	0.03
Batched IO same unit count	274,998	0.49	0.40
Batched IO single block count	639	0.00	0.00
Batched IO slow jump count	16,290	0.03	0.02
Batched IO vector block count	2,006,590	3.57	2.91
Batched IO vector read count	20,676	0.04	0.03
Block Cleanout Optim referenced	7,347	0.01	0.01
CCursor + sql area evicted	2,224	0.00	0.00
CPU used by this session	9,068,189	16.15	13.15
CPU used when call started	7,053,325	12.56	10.23
CR blocks created	61,377	0.11	0.09
Cached Commit SCN referenced	66,742	0.12	0.10
Commit SCN cached	141,486	0.25	0.21
DB time	35,261,615	62.79	51.14
DBWR checkpoint buffers written	831,344	1.48	1.21
DBWR checkpoints	10,671	0.02	0.02
DBWR object drop buffers written	84	0.00	0.00
DBWR revisited being-written buffer	27,154	0.05	0.04
DBWR tablespace checkpoint buffers written	131,931	0.23	0.19
DBWR thread checkpoint buffers written	6,019	0.01	0.01
DBWR transaction table writes	16,717	0.03	0.02
DBWR undo block writes	158,385	0.28	0.23
HSC Heap Segment Block Changes	3,365,782	5.99	4.88
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	109,913	0.20	0.16
Heap Segment Array Updates	27,039	0.05	0.04
IMU CR rollbacks	1,540	0.00	0.00
IMU Flushes	298,452	0.53	0.43
IMU Redo allocation size	378,046,168	673.22	548.26
IMU commits	378,060	0.67	0.55
IMU contention	3,987	0.01	0.01
IMU ktichg flush	275	0.00	0.00
IMU pool not allocated	355	0.00	0.00
IMU recursive-transaction flush	70	0.00	0.00
IMU undo allocation size	835,348,304	1,487.58	1,211.46
IMU- failed to get a private strand	355	0.00	0.00
LOB table id lookup cache misses	3	0.00	0.00
Number of read IOs issued	22,390,643	39.87	32.47
RowCR - row contention	41	0.00	0.00
RowCR attempts	1,468	0.00	0.00
RowCR hits	1,423	0.00	0.00
SMON posted for undo segment shrink	148	0.00	0.00
SQL*Net roundtrips to/from client	9,068,195	16.15	13.15
TBS Extension: bytes extended	10,485,760	18.67	15.21
TBS Extension: files extended	1	0.00	0.00
TBS Extension: tasks created	25	0.00	0.00
TBS Extension: tasks executed	25	0.00	0.00
active txn count during cleanout	105,240	0.19	0.15
application wait time	98,631	0.18	0.14
background checkpoints completed	83	0.00	0.00
background checkpoints started	83	0.00	0.00
background timeouts	3,002,000	5.35	4.35
branch node splits	22	0.00	0.00
buffer is not pinned count	3,001,440,331	5,344.92	4,352.83
buffer is pinned count	2,946,069,750	5,246.32	4,272.53
bytes received via SQL*Net from client	2,731,161,936	4,863.62	3,960.86
bytes sent via SQL*Net to client	3,159,990,298	5,627.27	4,582.77
bytes via SQL*Net vector from client	0	0.00	0.00
calls to get snapshot scn: kcmgss	8,627,385	15.36	12.51
calls to kcmgas	1,483,910	2.64	2.15
calls to kcmgcs	5,299,994	9.44	7.69
cell physical IO interconnect bytes	25,221,801,618,432	44,914,646.62	36,577,879.97
change write time	17,062	0.03	0.02
cleanout - number of ktugct calls	395,455	0.70	0.57
cleanouts and rollbacks - consistent read gets	59,640	0.11	0.09
cleanouts only - consistent read gets	153,017	0.27	0.22
cluster key scan block gets	704,389	1.25	1.02
cluster key scans	525,077	0.94	0.76
commit batch/immediate performed	117	0.00	0.00
commit batch/immediate requested	117	0.00	0.00
commit cleanout failures: block lost	408,678	0.73	0.59
commit cleanout failures: buffer being written	2,783	0.00	0.00
commit cleanout failures: callback failure	2,489	0.00	0.00
commit cleanout failures: cannot pin	17	0.00	0.00
commit cleanouts	1,924,007	3.43	2.79
commit cleanouts successfully completed	1,510,040	2.69	2.19
commit immediate performed	117	0.00	0.00
commit immediate requested	117	0.00	0.00
commit txn count during cleanout	454,423	0.81	0.66
concurrency wait time	15,805,406	28.15	22.92
consistent changes	1,404,336	2.50	2.04
consistent gets	6,535,834,448	11,638.93	9,478.58
consistent gets - examination	77,491,053	138.00	112.38
consistent gets direct	2,733,750,993	4,868.23	3,964.62
consistent gets from cache	3,802,083,455	6,770.70	5,513.97
consistent gets from cache (fastpath)	3,556,175,217	6,332.79	5,157.34
cursor authentications	14,637	0.03	0.02
data blocks consistent reads - undo records applied	490,744	0.87	0.71
db block changes	15,099,781	26.89	21.90
db block gets	14,520,643	25.86	21.06
db block gets direct	28,546	0.05	0.04
db block gets from cache	14,492,097	25.81	21.02
db block gets from cache (fastpath)	3,141,268	5.59	4.56
deferred (CURRENT) block cleanout applications	919,367	1.64	1.33
dirty buffers inspected	84,136	0.15	0.12
enqueue conversions	391,170	0.70	0.57
enqueue releases	13,791,020	24.56	20.00
enqueue requests	13,791,132	24.56	20.00
enqueue timeouts	114	0.00	0.00
enqueue waits	11,994	0.02	0.02
execute count	7,601,423	13.54	11.02
failed probes on index block reclamation	67	0.00	0.00
file io service time	78	0.00	0.00
file io wait time	8,582,190,463	15,283.05	12,446.31
free buffer inspected	335,945,282	598.25	487.20
free buffer requested	333,953,481	594.70	484.32
heap block compress	589,719	1.05	0.86
hot buffers moved to head of LRU	6,359,275	11.32	9.22
immediate (CR) block cleanout applications	212,657	0.38	0.31
immediate (CURRENT) block cleanout applications	250,871	0.45	0.36
index crx upgrade (positioned)	10,379	0.02	0.02
index crx upgrade (prefetch)	2	0.00	0.00
index fast full scans (full)	7,901	0.01	0.01
index fetch by key	102,326,327	182.22	148.40
index scans kdiixs1	7,199,975	12.82	10.44
leaf node 90-10 splits	4,868	0.01	0.01
leaf node splits	13,544	0.02	0.02
lob reads	54,544	0.10	0.08
lob writes	26,055	0.05	0.04
lob writes unaligned	26,055	0.05	0.04
logons cumulative	9,635	0.02	0.01
max cf enq hold time	164,180	0.29	0.24
messages received	3,325,179	5.92	4.82
messages sent	3,325,179	5.92	4.82
min active SCN optimization applied on CR	184,343	0.33	0.27
no buffer to keep pinned count	952	0.00	0.00
no work - consistent read gets	6,451,947,680	11,489.54	9,356.93
non-idle wait count	222,880,347	396.90	323.23
non-idle wait time	21,983,460	39.15	31.88
opened cursors cumulative	3,243,629	5.78	4.70
parse count (describe)	356	0.00	0.00
parse count (failures)	4,708	0.01	0.01
parse count (hard)	43,786	0.08	0.06
parse count (total)	5,170,413	9.21	7.50
parse time cpu	37,199	0.07	0.05
parse time elapsed	14,995,482	26.70	21.75
physical read IO requests	190,708,647	339.61	276.57
physical read bytes	25,130,382,442,496	44,751,848.57	36,445,299.44
physical read total IO requests	193,791,838	345.10	281.05
physical read total bytes	25,183,310,365,184	44,846,101.91	36,522,058.08
physical read total multi block requests	22,296,621	39.71	32.34
physical reads	3,067,673,638	5,462.87	4,448.89
physical reads cache	333,491,632	593.88	483.65
physical reads cache prefetch	167,258,573	297.85	242.57
physical reads direct	2,734,182,006	4,868.99	3,965.24
physical reads direct (lob)	6,307	0.01	0.01
physical reads direct temporary tablespace	432,922	0.77	0.63
physical write IO requests	652,169	1.16	0.95
physical write bytes	12,919,611,392	23,007.07	18,736.65
physical write total IO requests	2,966,088	5.28	4.30
physical write total bytes	38,491,253,248	68,544.71	55,821.88
physical write total multi block requests	26,639	0.05	0.04
physical writes	1,577,101	2.81	2.29
physical writes direct	635,345	1.13	0.92
physical writes direct (lob)	8,339	0.01	0.01
physical writes direct temporary tablespace	616,975	1.10	0.89
physical writes from cache	941,756	1.68	1.37
physical writes non checkpoint	1,142,891	2.04	1.66
pinned buffers inspected	10,248	0.02	0.01
pinned cursors current	0	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetched blocks aged out before use	78,061	0.14	0.11
process last non-idle time	566,040	1.01	0.82
recovery array read time	0	0.00	0.00
recovery array reads	0	0.00	0.00
recovery block gets from cache	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	16,713,070	29.76	24.24
recursive cpu usage	3,852,083	6.86	5.59
redo blocks checksummed by FG (exclusive)	1,698,227	3.02	2.46
redo blocks read for recovery	0	0.00	0.00
redo blocks written	6,339,351	11.29	9.19
redo buffer allocation retries	235	0.00	0.00
redo entries	7,137,405	12.71	10.35
redo k-bytes read (memory)	2,351,380	4.19	3.41
redo k-bytes read (memory) by LNS	2,351,380	4.19	3.41
redo k-bytes read for recovery	0	0.00	0.00
redo k-bytes read total	5,964,860	10.62	8.65
redo k-bytes read total by LNS	2,817,314	5.02	4.09
redo log space requests	1,729	0.00	0.00
redo log space wait time	16,736	0.03	0.02
redo ordering marks	129,807	0.23	0.19
redo size	2,764,901,388	4,923.70	4,009.79
redo size for direct writes	151,155,268	269.18	219.21
redo subscn max counts	255,500	0.45	0.37
redo synch time	726,769	1.29	1.05
redo synch writes	744,299	1.33	1.08
redo wastage	372,852,408	663.97	540.73
redo write time	884,676	1.58	1.28
redo writes	1,148,592	2.05	1.67
rollback changes - undo records applied	5,734	0.01	0.01
rollbacks only - consistent read gets	3,191	0.01	0.00
rows fetched via callback	6,945,385	12.37	10.07
scheduler wait time	6,443	0.01	0.01
session connect time	0	0.00	0.00
session cursor cache hits	2,768,700	4.93	4.02
session logical reads	6,550,355,091	11,664.78	9,499.64
shared hash latch upgrades - no wait	1,065,326	1.90	1.54
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	2	0.00	0.00
sorts (memory)	1,397,228	2.49	2.03
sorts (rows)	94,838,941	168.89	137.54
sql area evicted	33,288	0.06	0.05
sql area purged	6,027	0.01	0.01
summed dirty queue length	127,549	0.23	0.18
switch current to new buffer	242,187	0.43	0.35
table fetch by rowid	2,785,296,289	4,960.02	4,039.37
table fetch continued row	243,020,634	432.77	352.44
table scan blocks gotten	3,438,911,730	6,123.97	4,987.28
table scan rows gotten	111,216,623,587	198,053.07	161,291.74
table scans (direct read)	67,657	0.12	0.10
table scans (long tables)	73,991	0.13	0.11
table scans (short tables)	1,734,402	3.09	2.52
temp space allocated (bytes)	75,497,472	134.44	109.49
total cf enq hold time	719,350	1.28	1.04
total number of cf enq holders	66,290	0.12	0.10
total number of times SMON posted	203	0.00	0.00
transaction rollbacks	117	0.00	0.00
transaction tables consistent read rollbacks	1	0.00	0.00
transaction tables consistent reads - undo records applied	14	0.00	0.00
undo change vector size	1,010,992,424	1,800.36	1,466.19
user I/O wait time	1,634,689	2.91	2.37
user calls	9,878,012	17.59	14.33
user commits	677,208	1.21	0.98
user rollbacks	12,329	0.02	0.02
workarea executions - multipass	16	0.00	0.00
workarea executions - onepass	54	0.00	0.00
workarea executions - optimal	639,924	1.14	0.93
write clones created for recovery	0	0.00	0.00
write clones created in background	79	0.00	0.00
write clones created in foreground	2,284	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session uga memory max	85,797,871,016	97,218,784,016
session pga memory	16,024,542,368	18,866,733,752
session pga memory max	38,808,078,788	45,163,259,340
session cursor cache count	500,188	580,337
session uga memory	32,503,761,788,672	38,388,366,530,104
opened cursors current	443	410
logons current	93	93

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)	83	0.53

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
ordered by (Data Read + Write) desc

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	20.4T	39.91	38.0388	29M	0.00	.000051	22.4M	0.02
Buffer Cache Reads	2.5T	299.69	4.63963	0M	0.00	0M	166.3M	0.00
Others	49.1G	5.47	.089623	20.7G	2.07	.037836	4232.7K	4.57
DBWR	0M	0.00	0M	7.2G	1.08	.013103	104.4K	46.39
Direct Writes	10M	0.00	.000017	4.8G	0.08	.008784	43.9K	8.46
LGWR	78M	0.01	.000138	3G	2.05	.005557	1155.5K	7.15
RMAN	89M	0.01	.000158	20M	0.00	.000035	7835	2.14
Streams AQ	8M	0.00	.000014	0M	0.00	0M	265	22.58
TOTAL:	22.9T	345.10	42.7684	35.8G	5.28	.065369	194.2M	0.17

Back to IO Stats
Back to Top

IOStat by Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Small Read and Large Read are average service times, in milliseconds
Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	22.9T	339.57	42.6723	7.3G	1.10	.013322	0.01	0.02
Control File	45.5G	5.08	.082961	17.8G	2.07	.032417	0.02	0.02
Temp File	3.4G	0.05	.006227	4.7G	0.06	.008619	0.01	0.01
Log File	3.5G	0.01	.006318	3G	2.05	.005511	0.00	1.13
Archive Log	0M	0.00	0M	3G	0.01	.005474	0.03
Other	328M	0.40	.000584	0M	0.00	0M	0.08
TOTAL:	22.9T	345.10	42.7684	35.8G	5.28	.065344	0.01	0.02

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Ordered by (Data Read + Write) desc for each function

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	20.4T	39.91	38.0388	29M	0.00	.000051	0
Direct Reads (Data File)	20.4T	39.91	38.0388	29M	0.00	.000051	0
Buffer Cache Reads	2.5T	299.69	4.63963	0M	0.00	0M	166.2M	0.00
Buffer Cache Reads (Data File)	2.5T	299.69	4.63963	0M	0.00	0M	166.2M	0.00
Others	48.8G	5.07	.089039	20.7G	2.07	.037836	2846.1K	0.24
Others (Control File)	45.3G	5.06	.082665	17.7G	2.06	.032337	2840.9K	0.02
Others (Log File)	3.5G	0.01	.006316	0M	0.00	0M	631	0.00
Others (Archive Log)	0M	0.00	0M	3G	0.01	.005474	0
Others (Data File)	32M	0.01	.000056	14M	0.00	.000024	4533	142.18
DBWR	0M	0.00	0M	7.2G	1.08	.013103	5	0.00
DBWR (Data File)	0M	0.00	0M	7.2G	1.08	.013103	0
DBWR (Control File)	0M	0.00	0M	0M	0.00	0M	5	0.00
Direct Writes	10M	0.00	.000017	4.8G	0.08	.008784	0
Direct Writes (Data File)	10M	0.00	.000017	4.8G	0.08	.008784	0
LGWR	78M	0.01	.000138	3G	2.05	.005557	5244	0.20
LGWR (Log File)	1M	0.00	.000001	3G	2.05	.005511	332	3.09
LGWR (Control File)	77M	0.01	.000137	26M	0.00	.000046	4912	0.00
RMAN	89M	0.01	.000158	20M	0.00	.000035	6559	0.00
RMAN (Control File)	89M	0.01	.000158	20M	0.00	.000035	5701	0.00
RMAN (Archive Log)	0M	0.00	0M	0M	0.00	0M	858	0.03
Streams AQ	8M	0.00	.000014	0M	0.00	0M	265	22.58
Streams AQ (Data File)	8M	0.00	.000014	0M	0.00	0M	265	22.58
TOTAL:	22.9T	344.70	42.7679	35.8G	5.28	.065369	169.1M	0.01

Back to IO Stats
Back to Top

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)
QBPOSP	190,389,501	339	0.02	16.11	453,660	1	857,316	0.15
SYSAUX	213,339	0	3.75	2.65	102,210	0	0	0.00
SYSTEM	78,865	0	0.33	2.34	16,992	0	1	0.00
TEMP	25,738	0	0.02	17.39	35,767	0	0	0.00
UNDOTBS1	558	0	0.11	1.00	43,540	0	81	0.25
EXAMPLE	2	0	5.00	1.00	0	0	0	0.00
USERS	2	0	0.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)
EXAMPLE	/u01/app/oracle/oradata/orclstby/example01.dbf	2	0	5.00	1.00	0	0	0	0.00
QBPOSP	/u01/app/oracle/oradata/orclstby/qbposp.dbf	190,389,501	339	0.02	16.11	453,660	1	857,316	0.15
SYSAUX	/u01/app/oracle/oradata/orclstby/sysaux01.dbf	213,339	0	3.75	2.65	102,210	0	0	0.00
SYSTEM	/u01/app/oracle/oradata/orclstby/system01.dbf	78,865	0	0.33	2.34	16,992	0	1	0.00
TEMP	/u01/app/oracle/oradata/orclstby/temp01.dbf	25,738	0	0.02	17.39	35,767	0	0
UNDOTBS1	/u01/app/oracle/oradata/orclstby/undotbs01.dbf	558	0	0.11	1.00	43,540	0	81	0.25
USERS	/u01/app/oracle/oradata/orclstby/users01.dbf	2	0	0.00	1.00	0	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

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	91,678	107	-4,790,450,235	333,490,227	941,756	0	3	857,399

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 1,577,101

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	6,011	0	0	693,394	8

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
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 RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	11	397	1666	4438	165888	4438
E	0	11	535	2931	10764	165888	10764

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

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 (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	64	0.09	8	4.33	4,578,105	1	78739.00
D	128	0.17	16	3.24	3,424,406	1	56738.00
D	192	0.26	24	1.90	2,009,537	1	29757.00
D	256	0.35	32	1.73	1,831,593	1	26363.00
D	320	0.43	40	1.65	1,741,767	1	24650.00
D	384	0.52	48	1.59	1,685,189	1	23571.00
D	448	0.61	56	1.53	1,617,516	1	22281.00
D	512	0.70	64	1.42	1,498,902	1	20019.00
D	576	0.78	72	1.20	1,271,937	1	15691.00
D	640	0.87	80	1.13	1,196,568	1	14253.00
D	704	0.96	88	1.05	1,108,520	1	12574.00
D	736	1.00	92	1.00	1,057,206	1	11596.00
D	768	1.04	96	0.95	1,005,796	1	10615.00
D	832	1.13	104	0.84	892,461	1	8454.00
D	896	1.22	112	0.75	794,700	1	6590.00
D	960	1.30	120	0.69	726,929	1	6226.00
D	1,024	1.39	128	0.63	666,253	1	6195.00
D	1,088	1.48	136	0.56	590,971	1	6157.00
D	1,152	1.57	143	0.50	528,402	1	6125.00
D	1,216	1.65	151	0.44	469,020	1	6095.00
D	1,280	1.74	159	0.39	410,224	1	6065.00

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
79.55	51,537	13,250

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs	M-Pass Execs
2K	4K	587,306	587,306	0	0
64K	128K	6,150	6,150	0	0
128K	256K	2,531	2,531	0	0
256K	512K	2,017	2,017	0	0
512K	1024K	37,790	37,786	4	0
1M	2M	1,382	1,382	0	0
2M	4M	1,663	1,647	16	0
4M	8M	831	831	0	0
8M	16M	195	195	0	0
16M	32M	81	63	18	0
32M	64M	19	13	6	0
64M	128M	3	3	0	0
128M	256M	26	0	10	16

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	Estd Time
170	0.13	14,460.20	28,243.74	34.00	847	56,620,526
340	0.25	14,460.20	13,399.39	52.00	192	36,938,618
680	0.50	14,460.20	12,673.63	53.00	72	35,976,346
1,020	0.75	14,460.20	12,532.14	54.00	0	35,788,754
1,360	1.00	14,460.20	12,532.14	54.00	0	35,788,754
1,632	1.20	14,460.20	4,485.63	76.00	0	25,119,994
1,904	1.40	14,460.20	4,485.63	76.00	0	25,119,994
2,176	1.60	14,460.20	4,485.63	76.00	0	25,119,994
2,448	1.80	14,460.20	4,485.63	76.00	0	25,119,994
2,720	2.00	14,460.20	4,485.63	76.00	0	25,119,994
4,080	3.00	14,460.20	4,485.63	76.00	0	25,119,994
5,440	4.00	14,460.20	4,485.63	76.00	0	25,119,994
8,160	6.00	14,460.20	4,485.63	76.00	0	25,119,994
10,880	8.00	14,460.20	4,485.63	76.00	0	25,119,994

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
400	0.34	57	3,961	779,588	0.98	548,789	1.02	15,674
528	0.45	185	11,692	781,805	0.99	546,572	1.02	35,002
656	0.56	313	18,089	785,491	0.99	542,886	1.01	35,178
784	0.67	441	23,141	787,491	0.99	540,886	1.01	35,276
912	0.78	569	25,700	789,539	1.00	538,838	1.01	35,377
1,040	0.89	697	28,032	791,520	1.00	536,857	1.00	35,483
1,168	1.00	825	32,063	792,734	1.00	535,643	1.00	35,545
1,296	1.11	953	35,980	793,329	1.00	535,048	1.00	35,571
1,424	1.22	1,081	39,508	793,576	1.00	534,801	1.00	35,582
1,552	1.33	1,208	43,972	793,678	1.00	534,699	1.00	35,586
1,680	1.44	1,336	47,723	793,738	1.00	534,639	1.00	35,589
1,808	1.55	1,464	51,215	793,792	1.00	534,585	1.00	35,592
1,936	1.66	1,591	56,120	793,840	1.00	534,537	1.00	35,595
2,064	1.77	1,719	61,007	793,864	1.00	534,513	1.00	35,597
2,192	1.88	1,847	65,828	793,885	1.00	534,492	1.00	35,598
2,320	1.99	1,975	71,159	793,908	1.00	534,469	1.00	35,599
2,448	2.10	2,103	75,524	793,926	1.00	534,451	1.00	35,600

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
976	0.50	1,050,049	1,993,996,874
1,464	0.75	1,035,172	1,057,206,338
1,952	1.00	1,025,939	1,057,206,338
2,440	1.25	1,023,682	967,026,637
2,928	1.50	1,023,374	623,963,181
3,416	1.75	1,023,169	545,729,912
3,904	2.00	1,023,169	545,729,912

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	857,318	132	0
undo header	80	0	0
file header block	1	0	10

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)
KO-Multiple Object Checkpoint (fast object checkpoint)	92,574	92,574	0	10,283	978	95.11
CF-Controlfile Transaction	683,434	683,338	95	1,240	193	155.85
PR-Process Startup	6,637	6,637	0	10	60	6,041.00
PV-KSV slave startup (syncstart)	3,075	3,075	0	1	7	6,730.00
CR-Reuse Block Range (block range reuse ckpt)	6,101	6,101	0	273	5	19.41
RO-Multiple Object Reuse (fast object reuse)	2,718	2,718	0	133	1	4.36
TX-Transaction (row lock contention)	33	33	0	33	0	0.91
RF-Data Guard Broker (synch: DG Broker metadata)	1,894,436	1,894,436	0	14	0	0.00
JS-Job Scheduler (queue lock)	2,035,179	2,035,179	0	7	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	141.37	864,603	3,139	8	15/66.3	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
31-Aug 11:52	59	1,410	617	3	24	0/0	0/0/0/0/0/0
31-Aug 11:42	58	1,309	1,221	3	34	0/0	0/0/0/0/0/0
31-Aug 11:32	51	1,298	619	1	24	0/0	0/0/0/0/0/0
31-Aug 11:22	42	1,039	1,223	1	34	0/0	0/0/0/0/0/0
31-Aug 11:12	51	1,262	621	3	24	0/0	0/0/0/0/0/0
31-Aug 11:02	145	1,223	1,225	3	34	0/0	0/0/0/0/0/0
31-Aug 10:52	52	1,377	623	3	24	0/0	0/0/0/0/0/0
31-Aug 10:42	52	1,085	1,225	3	34	0/0	0/0/0/0/0/0
31-Aug 10:32	41	1,071	625	3	24	0/0	0/0/0/0/0/0
31-Aug 10:22	43	992	1,228	3	34	0/0	0/0/0/0/0/0
31-Aug 10:12	630	1,534	627	3	24	0/0	0/0/0/0/0/0
31-Aug 10:02	139	942	1,225	3	34	0/0	0/0/0/0/0/0
31-Aug 09:52	43	1,036	620	3	24	0/0	0/0/0/0/0/0
31-Aug 09:42	38	859	1,223	3	34	0/0	0/0/0/0/0/0
31-Aug 09:32	30	736	621	3	24	0/0	0/0/0/0/0/0
31-Aug 09:22	21	525	1,224	1	34	0/0	0/0/0/0/0/0
31-Aug 09:12	26	698	624	1	24	0/0	0/0/0/0/0/0
31-Aug 09:02	125	617	1,225	3	34	0/0	0/0/0/0/0/0
31-Aug 08:52	21	561	624	1	24	0/0	0/0/0/0/0/0
31-Aug 08:42	14	398	1,228	1	34	0/0	0/0/0/0/0/0
31-Aug 08:32	16	311	626	3	24	0/0	0/0/0/0/0/0
31-Aug 08:22	12	255	1,229	1	35	0/0	0/0/0/0/0/0
31-Aug 08:12	6	298	628	1	24	0/0	0/0/0/0/0/0
31-Aug 08:02	96	221	1,230	3	35	0/0	0/0/0/0/0/0
31-Aug 07:52	7	177	629	1	24	0/0	0/0/0/0/0/0
31-Aug 07:42	2	98	1,233	1	35	0/0	0/0/0/0/0/0
31-Aug 07:32	5	142	1,972	1	47	0/0	0/0/0/0/0/0
31-Aug 07:22	1	46	3,139	1	66	0/0	0/0/0/0/0/0
31-Aug 07:12	2	146	2,538	1	56	0/0	0/0/0/0/0/0
31-Aug 07:02	313	152	1,936	3	46	0/0	0/0/0/0/0/0
31-Aug 06:52	2	53	632	1	25	0/0	0/0/0/0/0/0
31-Aug 06:42	3	55	1,236	1	35	0/0	0/0/0/0/0/0
31-Aug 06:32	11	201	634	2	25	0/0	0/0/0/0/0/0
31-Aug 06:22	11	136	1,250	2	35	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
Mutex Sleep Summary
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
AQ deq hash table latch	156	0.00		0	0
ASM db client latch	1,124,103	0.00		0	0
ASM map operation hash table	156	0.00		0	0
ASM network state latch	9,403	0.00		0	0
AWR Alerted Metric Element list	4,549,707	0.00		0	0
Change Notification Hash table latch	186,763	0.00		0	0
Consistent RBA	1,148,679	0.00	0.50	0	0
DML lock allocation	2,276,508	0.00		0	0
DMON Work Queues Latch	37,304	0.00		0	0
Event Group Locks	8,421	0.00		0	0
FAL Queue	17,576	0.00		0	0
FIB s.o chain latch	228,724	0.00		0	0
FOB s.o list latch	259,785	0.00	0.00	0	0
File State Object Pool Parent Latch	156	0.00		0	0
IPC stats buffer allocation latch	156	0.00		0	0
In memory undo latch	5,788,364	0.00	0.45	0	991,941	0.00
JS Sh mem access	1,201	0.83	1.00	0	0
JS broadcast autostart latch	16	0.00		0	0
JS mem alloc latch	1,470	0.00		0	0
JS queue access latch	1,626	0.00		0	0
JS queue state obj latch	4,070,358	0.00		0	0
JS slv state obj latch	12,442	0.00		0	0
KFC FX Hash Latch	156	0.00		0	0
KFC Hash Latch	156	0.00		0	0
KFCL LE Freelist	156	0.00		0	0
KGNFS-NFS:SHM structure	156	0.00		0	0
KGNFS-NFS:SVR LIST	156	0.00		0	0
KJC message pool free list	156	0.00		0	0
KJCT flow control latch	156	0.00		0	0
KMG MMAN ready and startup request latch	186,485	0.00		0	0
KMG resize request state object freelist	24	0.00		0	0
KTF sga latch	2,925	0.00		0	180,821	0.00
LGWR NS Write	2,288,597	0.00	0.96	26	0
Locator state objects pool parent latch	156	0.00		0	0
Lsod array latch	156	0.00		0	0
MQL Tracking Latch	0			0	11,183	0.00
Managed Standby Recovery State	9,331	0.00		0	0
Memory Management Latch	967	0.00		0	186,485	0.00
Memory Queue	156	0.00		0	0
Memory Queue Message Subscriber #1	156	0.00		0	0
Memory Queue Message Subscriber #2	156	0.00		0	0
Memory Queue Message Subscriber #3	156	0.00		0	0
Memory Queue Message Subscriber #4	156	0.00		0	0
Memory Queue Subscriber	156	0.00		0	0
MinActiveScn Latch	3,066	0.00		0	0
Mutex	156	0.00		0	0
Mutex Stats	156	0.00		0	0
NSV command ID generation latch	9,329	0.00		0	0
NSV creation/termination latch	9,329	0.00		0	0
OS process	65,723	0.00		0	0
OS process allocation	229,670	0.00	1.00	0	0
OS process: request allocation	16,530	0.00		0	0
PL/SQL warning settings	75,788	0.00		0	0
PX hash array latch	156	0.00		0	0
QMT	156	0.00		0	0
RSM process latch	55,989	0.00		0	0
Real-time plan statistics latch	270,884	0.00	0.50	0	1	0.00
Request id generation latch	9,326	0.00		0	0
Reserved Space Latch	332	0.00		0	0
SGA IO buffer pool latch	2,208	0.00		0	2,399	0.00
SGA blob parent	156	0.00		0	0
SGA bucket locks	156	0.00		0	0
SGA heap locks	156	0.00		0	0
SGA pool locks	156	0.00		0	0
SQL memory manager latch	18,814	0.01	1.00	0	550,495	0.00
SQL memory manager workarea list latch	37,731,589	0.00	0.33	0	0
Shared B-Tree	20,181	0.00		0	0
Streams Generic	156	0.00		0	0
Testing	156	0.00		0	0
Token Manager	156	0.00		0	0
WCR: sync	156	0.00		0	0
Write State Object Pool Parent Latch	156	0.00		0	0
X$KSFQP	768	0.00		0	0
XDB NFS Security Latch	156	0.00		0	0
XDB unused session pool	156	0.00		0	0
XDB used session pool	156	0.00		0	0
active checkpoint queue latch	2,343,068	0.00	0.00	0	0
active service list	1,174,314	0.00	0.67	2	805,415	0.00
alert log latch	8,423	0.06	0.40	0	0
archive control	4,401,852	0.00	0.52	0	0
archive process latch	41,188	1.53	0.85	0	0
begin backup scn array	10,563	0.00		0	0
buffer pool	188	0.00		0	0
business card	156	0.00		0	0
cache buffer handles	261,568	0.00		0	0
cache buffers chains	7,933,484,737	0.08	0.01	4168	20,901,940,759	0.00
cache buffers lru chain	1,511,031	0.15	0.16	11	3,875,522,900	0.47
cache table scan latch	65,194,294	0.00	0.01	0	65,194,294	0.00
call allocation	63,782	0.16	0.88	9	0
cas latch	156	0.00		0	0
change notification client cache latch	156	0.00		0	0
channel handle pool latch	19,275	0.00		0	0
channel operations parent latch	6,539,766	0.00	0.02	0	0
checkpoint queue latch	37,236,287	0.00	0.00	0	871,378	0.00
client/application info	36,377	0.00		0	0
compile environment latch	9,681	0.00		0	0
corrupted undo seg latch	17,319	0.00		0	0
cp cmon/server latch	156	0.00		0	0
cp pool latch	156	0.00		0	0
cp server hash latch	156	0.00		0	0
cp sga latch	9,403	0.00		0	0
cvmap freelist lock	156	0.00		0	0
database property service latch	138	0.00		0	0
deferred cleanup latch	9,403	0.00		0	0
dml lock allocation	9,877	0.00		0	0
done queue latch	156	0.00		0	0
dummy allocation	19,426	0.01	0.00	0	0
enqueue hash chains	28,007,245	0.01	0.03	2	404	0.00
enqueues	23,550,732	0.01	0.01	0	0
fifth spare latch	156	0.00		0	0
file cache latch	27,356	0.00		0	0
flashback copy	156	0.00		0	0
gc element	156	0.00		0	0
gcs commit scn state	156	0.00		0	0
gcs partitioned table hash	156	0.00		0	0
gcs pcm hashed value bucket hash	156	0.00		0	0
gcs resource freelist	156	0.00		0	0
gcs resource hash	156	0.00		0	0
gcs resource scan list	156	0.00		0	0
gcs shadows freelist	156	0.00		0	0
ges domain table	156	0.00		0	0
ges enqueue table freelist	156	0.00		0	0
ges group table	156	0.00		0	0
ges process hash list	156	0.00		0	0
ges process parent latch	156	0.00		0	0
ges resource hash list	156	0.00		0	0
ges resource scan list	156	0.00		0	0
ges resource table freelist	156	0.00		0	0
ges value block free list	156	0.00		0	0
global KZLD latch for mem in SGA	1,552	0.00		0	0
global tx hash mapping	156	0.00		0	0
granule operation	156	0.00		0	0
hash table column usage latch	17,739	0.05	0.11	0	1,013,436,672	0.01
hash table modification latch	13,310	0.00		0	0
heartbeat check	156	0.00		0	0
internal temp table object number allocation latch	352	0.00		0	0
intra txn parallel recovery	156	0.00		0	0
io pool granule metadata list	156	0.00		0	0
job workq parent latch	1,526	0.00		0	1,370	0.95
job_queue_processes free list latch	3,548	0.00		0	0
job_queue_processes parameter latch	123,204	0.00		0	0
k2q lock allocation	156	0.00		0	0
kcbtsemkid latch	83	0.00		0	0
kdlx hb parent latch	156	0.00		0	0
kgb parent	156	0.00		0	0
kks stats	184,942	0.00	0.00	0	0
kmcptab latch	42	0.00		0	0
kmcpvec latch	0			0	14	0.00
kokc descriptor allocation latch	5,360	0.00		0	0
krbmrosl	2,203	0.00		0	0
ksfv messages	156	0.00		0	0
kss move lock	6,306	0.00		0	0
ksuosstats global area	37,729	0.00		0	0
ksv allocation latch	21,707	0.00		0	0
ksv class latch	12,453	0.02	0.00	0	0
ksv msg queue latch	156	0.00		0	0
ksz_so allocation latch	16,530	0.01	1.00	0	0
ktm global data	3,263	0.00		0	0
kwqbsn:qsga	20,025	0.00		0	0
lgwr LWN SCN	1,155,253	0.00		0	0
list of block allocation	32,150	0.00		0	0
loader state object freelist	152,656	0.00	0.00	0	0
lob segment dispenser latch	156	0.00		0	0
lob segment hash table latch	2,024	0.00		0	0
lob segment query latch	156	0.00		0	0
lock DBA buffer during media recovery	156	0.00		0	0
logical standby cache	156	0.00		0	0
logminer context allocation	156	0.00		0	0
logminer work area	156	0.00		0	0
longop free list parent	6,912	0.00		0	1,316	0.00
managed standby latch	17,704	18.71	1.16	5976	0
mapped buffers lru chain	156	0.00		0	0
message pool operations parent latch	175,126	0.01	0.09	0	0
messages	14,865,878	0.02	0.01	0	0
mostly latch-free SCN	1,155,227	0.00		0	0
msg queue latch	156	0.00		0	0
multiblock read objects	324,769,660	0.01	0.06	10	0
name-service namespace bucket	156	0.00		0	0
ncodef allocation latch	9,403	0.00		0	0
object queue header heap	43,202	0.00		0	39,152	0.00
object queue header operation	676,889,291	0.00	0.01	1	19,822	0.20
object stats modification	107,990	0.00		0	14	0.00
parallel query alloc buffer	73,640	0.00		0	0
parallel query stats	156	0.00		0	0
parameter list	7,294	0.00		0	0
parameter table management	19,913	0.00		0	0
peshm	156	0.00		0	0
pesom_free_list	156	0.00		0	0
pesom_hash_node	156	0.00		0	0
post/wait queue	1,150,980	0.00	0.00	0	772,785	0.00
process allocation	23,179	0.03	0.88	0	8,264	0.01
process group creation	16,530	0.01	0.50	0	0
process queue	156	0.00		0	0
process queue reference	156	0.00		0	0
qmn state object latch	2	0.00		0	0
qmn task queue latch	81,953	13.87	1.00	0	0
query server freelists	156	0.00		0	0
queued dump request	1,865	0.00		0	0
queuing load statistics	156	0.00		0	0
readredo stats and histogram	1,137,150	0.00		0	0
recovery domain hash list	156	0.00		0	0
redo allocation	5,454,904	0.00	0.41	0	7,137,636	0.00
redo copy	156	0.00		0	7,137,702	0.02
redo writing	6,522,578	0.00	0.02	0	0
reservation so alloc latch	166	0.00		0	0
resmgr group change latch	10,254	0.00		0	0
resmgr:active threads	57,490	0.00		0	28,804	0.00
resmgr:actses change group	9,543	0.00		0	0
resmgr:actses change state	1,331	0.00		0	0
resmgr:free threads list	20,724	0.01	0.00	0	0
resmgr:method mem alloc latch	140	0.00		0	0
resmgr:plan CPU method	1,948	0.00		0	0
resmgr:resource group CPU method	32,484	0.00		0	0
resmgr:schema config	49,058	0.00		0	2,871	0.00
resmgr:session queuing	1,836	0.00		0	0
rm cas latch	156	0.00		0	0
row cache objects	142,570,735	0.01	0.01	4	7,534	0.01
second spare latch	156	0.00		0	0
sequence cache	281,055	0.00		0	0
session allocation	4,688,379	0.00		0	1,562,636	0.00
session idle bit	21,343,006	0.00	0.29	0	0
session queue latch	156	0.00		0	0
session state list latch	28,370	0.01	0.00	0	0
session switching	50,884	0.00	1.00	0	0
session timer	190,466	0.00		0	0
shared pool	5,956,340	0.03	0.25	13	0
shared pool sim alloc	233	0.00		0	0
shared pool simulator	452,887	0.00		0	0
sim partition latch	156	0.00		0	0
simulator hash latch	289,590,563	0.00	0.10	105	0
simulator lru latch	326,050	0.04	0.30	4	265,035,575	5.70
sort extent pool	23,446	0.00		0	0
space background state object latch	1,236	0.00		0	0
space background task latch	414,366	0.04	0.43	0	372,565	0.00
state object free list	314	0.00		0	0
statistics aggregation	87,360	0.00		0	0
tablespace key chain	2,805	0.00		0	0
temp lob duration state obj allocation	376	0.00		0	0
temporary table state object allocation	228	0.00		0	0
test excl. parent l0	156	0.00		0	0
test excl. parent2 l0	156	0.00		0	0
third spare latch	156	0.00		0	0
threshold alerts latch	22,241	0.00		0	0
transaction allocation	15,505	0.00		0	0
undo global data	4,761,002	0.00	0.00	0	0
virtual circuit buffers	156	0.00		0	0
virtual circuit holder	156	0.00		0	0
virtual circuit queues	156	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	7,933,484,737	6,023,869	33,020	5,991,240
multiblock read objects	324,769,660	23,184	1,277	21,947
qmn task queue latch	81,953	11,364	11,364	0
row cache objects	142,570,735	10,307	55	10,252
simulator hash latch	289,590,563	6,000	622	5,388
object queue header operation	676,889,291	5,667	71	5,596
managed standby latch	17,704	3,312	3,845	1
cache table scan latch	65,194,294	3,145	17	3,129
enqueues	23,550,732	2,587	30	2,563
messages	14,865,878	2,405	17	2,388
enqueue hash chains	28,007,245	2,259	75	2,185
cache buffers lru chain	1,511,031	2,241	365	1,895
shared pool	5,956,340	1,840	469	1,421
archive process latch	41,188	632	536	99
channel operations parent latch	6,539,766	182	4	178
space background task latch	414,366	174	74	100
redo writing	6,522,578	132	2	130
simulator lru latch	326,050	115	35	81
redo allocation	5,454,904	106	43	63
call allocation	63,782	104	91	15
archive control	4,401,852	75	39	36
LGWR NS Write	2,288,597	52	50	2
session idle bit	21,343,006	24	7	17
active service list	1,174,314	18	12	6
In memory undo latch	5,788,364	11	5	7
message pool operations parent latch	175,126	11	1	10
JS Sh mem access	1,201	10	10	0
hash table column usage latch	17,739	9	1	8
Real-time plan statistics latch	270,884	8	4	5
process allocation	23,179	8	7	1
alert log latch	8,423	5	2	3
SQL memory manager workarea list latch	37,731,589	3	1	2
Consistent RBA	1,148,679	2	1	1
process group creation	16,530	2	1	1
OS process allocation	229,670	1	1	0
SQL memory manager latch	18,814	1	1	0
ksz_so allocation latch	16,530	1	1	0
session switching	50,884	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	4	2
In memory undo latch	ktichg: child	3	4
In memory undo latch	kturbk	1	1
JS Sh mem access	jsksGetShMemLatch	10	10
LGWR NS Write	kcrrnsltwa	45	17
LGWR NS Write	kcrrnsltwl	4	2
LGWR NS Write	kcrrnsltwk	1	62
OS process allocation	kso_delete_process:1	1	1
PC and Classifier lists for WLM	No latch	43	0
Real-time plan statistics latch	keswxAddNewPlanEntry	4	4
SQL memory manager latch	qesmmIDeamonCb	1	0
SQL memory manager workarea list latch	qesmmIUnRegisterWorkArea	1	0
active service list	kswslogon: session logout	13	12
active service list	kswsite: service iterator	1	0
archive control	krsv_hung_arch(check	1,454	2,785
archive control	kcrrpgadinit	37	33
archive control	kcrrpng	2	0
archive process latch	kcrrasgn	353	3
archive process latch	kcrrgpll	149	193
archive process latch	kcrrsarc	23	0
archive process latch	krss_find_work.gl.1	8	340
archive process latch	kcrrsmx - after startup	3	0
archive process latch	krshfmw	2	2
cache buffers chains	kcbgtcr: fast path (cr pin)	24,801	20,436
cache buffers chains	kcbrls_1	6,448	12,141
cache buffers chains	kcbgtcr_2	1,683	394
cache buffers chains	kcbrls_2	439	408
cache buffers chains	kcbzibmlt: multi-block read: nowait	350	0
cache buffers chains	kcbzhngcbk2_1	71	0
cache buffers chains	kcbzibmlt: finish free bufs	46	49
cache buffers chains	kcbzwb	31	401
cache buffers chains	kcbbic1	17	0
cache buffers chains	kcbzgb: scan from tail. nowait	9	0
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	2	1
cache buffers chains	kcbbic2	1	0
cache buffers chains	kcbchg1: kslbegin: call CR func	1	11
cache buffers chains	kcbgcur_2	1	4
cache buffers lru chain	kcbzgm	164	0
cache buffers lru chain	kcbzgws	146	114
cache buffers lru chain	kcbzar: KSLNBEGIN	47	0
cache buffers lru chain	kcbo_ivd_proc	8	11
cache table scan latch	kcbz_find_table_scan_read_buffer	9	0
cache table scan latch	kcbz_free_table_scan_read_buffer	8	17
call allocation	ksudlp: top call	53	34
call allocation	ksuxds	37	51
call allocation	ksucrp: top call	1	4
channel operations parent latch	ksrchdelete_sub()	3	3
channel operations parent latch	ksrwait()	1	0
enqueue hash chains	ksqrcl	41	43
enqueue hash chains	ksqgtl3	27	32
enqueue hash chains	ksqcnl	7	0
enqueues	ksqdel	16	2
enqueues	ksqgel: create enqueue	13	28
enqueues	ksqgtl2	1	0
hash table column usage latch	KSXMMON_GETCELEM	1	0
ksz_so allocation latch	ksz_parent_so_del1	1	1
managed standby latch	krsv_proc_kill.1	2,389	1,058
managed standby latch	krss_init_proc	1	0
managed standby latch	krsv_proc_kill.2	1	6
message pool operations parent latch	ksrmalloc()	1	2
messages	ksarcv	10	4
messages	ksarcv: after wait	4	6
messages	ksaamb: after wakeup	3	7
mostly latch-free SCN	kcsnew_scn_rba	1	0
multiblock read objects	kcbzibmlt: normal mbr free	673	658
multiblock read objects	kcbzibmlt	604	619
object queue header operation	kcbo_unlink_q	41	12
object queue header operation	kcbo_link_q	15	1
object queue header operation	kcbo_switch_cq	7	20
object queue header operation	kcbo_service_ockpt	5	0
object queue header operation	kcbo_sw_buf	2	0
object queue header operation	kcbo_ivbo	1	1
object queue header operation	kcbo_link_q:reget	1	0
object queue header operation	kcbo_switch_mq_bg	1	20
object queue header operation	kcbo_write_q	1	3
process allocation	ksucrp:1	6	0
process allocation	ksudlp	1	1
process group creation	ksupgprem	1	1
qmn task queue latch	kwqmnmvtsks: delay to ready list	11,105	0
qmn task queue latch	kwqmnaddtsk: add task	259	0
redo allocation	kcrfw_redo_gen: redo allocation 1	43	0
redo writing	kcrfw_post: rba scn pair	1	0
redo writing	kcrfwcr	1	0
row cache objects	kqreqd: reget	43	0
row cache objects	kqrpre: find obj	10	53
row cache objects	kqrso	2	0
session idle bit	ksupuc: set busy	4	3
session idle bit	ksupuc: clear busy	3	4
session switching	kskexeall	1	1
shared pool	kghalo	288	131
shared pool	kghalp	63	72
shared pool	kghupr1	62	210
shared pool	kghfre	55	49
shared pool	kghfrh	1	1
simulator hash latch	kcbsacc: lookup dba	615	612
simulator hash latch	kcbs_lookup_setid: lookup dba	7	8
simulator lru latch	kcbs_simulate: simulate set	34	0
simulator lru latch	kcbs_lookup_setid	1	0
space background task latch	ktsjCreateTask	30	0
space background task latch	ktsj_grab_task	1	608

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Cursor Pin	kkslce [KKSCHLPIN2]	13,169,813	-571
Library Cache	kglhdgn2 106	8,600	-191
Library Cache	kglrfcl1 79	4,538	-10
Library Cache	kgllkdl1 85	42	39
Library Cache	kgldtin1 42	16	0
Cursor Pin	kksfbc [KKSCHLFSP2]	3	0
Library Cache	kglhdgn1 62	2	120
Library Cache	kgllkc1 57	1	86
Library Cache	kglpndl1 95	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 Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 6,550,355,091
Captured Segments account for 99.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
QBPOSP	QBPOSP	HIST_TRANS	TABLE	5,270,000,960	80.45
QBPOSP	QBPOSP	R_JNR	TABLE	1,047,379,136	15.99
QBPOSP	QBPOSP	PK_TID_INFO	INDEX	47,334,640	0.72
SYS	SYSAUX	WRI$_ADV_SQLT_PLAN_HASH_01	INDEX	22,036,272	0.34
QBPOSP	QBPOSP	R_EVENT	TABLE	20,257,904	0.31

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 3,067,673,638
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
QBPOSP	QBPOSP	HIST_TRANS	TABLE	2,017,541,933	65.77
QBPOSP	QBPOSP	R_JNR	TABLE	1,047,091,825	34.13
QBPOSP	QBPOSP	POSP_ACCOUNT	TABLE	720,661	0.02
QBPOSP	QBPOSP	POSP_ACCOUNT_RECORD	TABLE	246,941	0.01
QBPOSP	QBPOSP	TRANS4	INDEX	173,142	0.01

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 190,708,647
Captured Segments account for 99.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
QBPOSP	QBPOSP	HIST_TRANS	TABLE	180,853,465	94.83
QBPOSP	QBPOSP	R_JNR	TABLE	8,981,192	4.71
QBPOSP	QBPOSP	TRANS4	INDEX	165,345	0.09
QBPOSP	QBPOSP	TRANS8	INDEX	73,771	0.04
QBPOSP	QBPOSP	PKTRANS2	INDEX	61,962	0.03

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 190,708,647
Captured Segments account for 99.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
QBPOSP	QBPOSP	HIST_TRANS	TABLE	180,853,465	94.83
QBPOSP	QBPOSP	R_JNR	TABLE	8,981,192	4.71
QBPOSP	QBPOSP	TRANS4	INDEX	165,345	0.09
QBPOSP	QBPOSP	TRANS8	INDEX	73,771	0.04
QBPOSP	QBPOSP	PKTRANS2	INDEX	61,962	0.03

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 2,734,182,006
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Direct Reads	%Total
QBPOSP	QBPOSP	HIST_TRANS	TABLE	1,686,071,296	61.67
QBPOSP	QBPOSP	R_JNR	TABLE	1,047,086,258	38.30
QBPOSP	QBPOSP	POSP_ACCOUNT	TABLE	382,779	0.01
QBPOSP	QBPOSP	POSP_ACCOUNT_RECORD	TABLE	119,610	0.00
QBPOSP	QBPOSP	POSP_ACCOUNT_DETAIL	TABLE	63,539	0.00

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 1,577,101
Captured Segments account for 40.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
QBPOSP	QBPOSP	HIST_TRANS	TABLE	142,603	9.04
QBPOSP	QBPOSP	TRANS	TABLE	73,329	4.65
QBPOSP	QBPOSP	TRANS8	INDEX	46,063	2.92
QBPOSP	QBPOSP	TRANS13	INDEX	38,848	2.46
QBPOSP	QBPOSP	TRANS2	INDEX	34,905	2.21

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 652,169
Captured Segments account for 71.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
QBPOSP	QBPOSP	HIST_TRANS	TABLE	125,935	19.31
QBPOSP	QBPOSP	TRANS	TABLE	55,826	8.56
QBPOSP	QBPOSP	TRANS13	INDEX	28,365	4.35
QBPOSP	QBPOSP	TRANS2	INDEX	28,115	4.31
QBPOSP	QBPOSP	TRANS8	INDEX	26,460	4.06

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 635,345
Captured Segments account for 2.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
QBPOSP	QBPOSP	TRANS10		INDEX	8,223	1.29
SYS	SYSAUX	SYS_LOB0000006213C00038$$		LOB	6,072	0.96
SYS	SYSAUX	SYS_LOB0000006207C00004$$		LOB	1,197	0.19
SYS	SYSAUX	SYS_LOB0000005778C00040$$		LOB	762	0.12
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1312587260_10798	TABLE PARTITION	442	0.07

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 81,892
Captured Segments account for 93.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
QBPOSP	QBPOSP	R_JNR	TABLE	54,110	66.07
QBPOSP	QBPOSP	HIST_TRANS	TABLE	19,672	24.02
SYS	SYSTEM	I_OBJ2	INDEX	1,335	1.63
QBPOSP	QBPOSP	PK_TID_INFO	INDEX	453	0.55
QBPOSP	QBPOSP	PK_MCH_INFO	INDEX	243	0.30

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
QBPOSP	QBPOSP	HIST_TRANS	TABLE	863,280	16.68
SYS	SYSTEM	HISTGRM$	TABLE	470,368	9.09
SYS	SYSTEM	I_H_OBJ#_COL#	INDEX	463,152	8.95
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST	INDEX	267,616	5.17
SYS	SYSAUX	I_WRI$_OPTSTAT_H_ST	INDEX	240,208	4.64

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
QBPOSP	QBPOSP	TRANS6	INDEX	44	14.57
QBPOSP	QBPOSP	PKTRANS2	INDEX	36	11.92
QBPOSP	QBPOSP	TID_ROT	TABLE	32	10.60
QBPOSP	QBPOSP	TRANS7	INDEX	32	10.60
QBPOSP	QBPOSP	TRANS4	INDEX	28	9.27

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
QBPOSP	QBPOSP	TID_ROT	TABLE	6	54.55
QBPOSP	QBPOSP	HIST_TRANS	TABLE	4	36.36
SYS	SYSTEM	SCHEDULER$_JOB	TABLE	1	9.09

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	13,729	0.00	324	1
dc_constraints	758	50.00	758	105
dc_files	36	16.67	0	6
dc_global_oids	4,684	0.56	0	46
dc_histogram_data	1,725,207	1.23	26,943	9,522
dc_histogram_defs	1,258,346	3.27	19,179	6,056
dc_object_grants	1,122	17.47	0	175
dc_objects	1,141,538	0.40	3,331	2,391
dc_profiles	3,320	0.00	0	1
dc_rollback_segments	136,422	0.00	0	22
dc_segments	657,436	0.14	2,905	1,215
dc_sequences	109,930	0.02	109,930	33
dc_tablespaces	21,370,898	0.00	0	8
dc_users	21,669,384	0.00	2	208
global database name	378,601	0.00	0	1
outstanding_alerts	4,665	0.00	0	5
sch_lj_objs	186	16.67	0	12
sch_lj_oids	845	4.62	0	22

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	25,839	0.13	68,091	0.06	8	0
CLUSTER	7,103	0.07	2,360	0.21	0	0
DBLINK	3,208	0.06	0		0	0
DIRECTORY	7	14.29	14	14.29	0	0
EDITION	5,453	0.00	8,312	0.00	0	0
INDEX	16,451	2.19	14,060	15.91	965	0
JAVA DATA	3	100.00	3	100.00	0	0
JAVA RESOURCE	3	100.00	3	100.00	0	0
JAVA SOURCE	3	100.00	3	100.00	0	0
OBJECT ID	548	100.00	0		0	0
SCHEMA	14,420	0.04	0		0	0
SQL AREA	729,868	8.78	8,475,533	1.28	16,187	12,739
TABLE/PROCEDURE	410,666	0.20	792,699	1.52	5,336	0
TEMPORARY INDEX	1,202	20.63	1,202	100.00	954	0
TEMPORARY TABLE	3,294	5.80	3,294	100.00	3,103	0
TRIGGER	68,541	0.04	68,541	0.04	0	0

Memory Statistics

Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Memory Dynamic Components

Min/Max sizes since instance startup
Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
ordered by Component

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	736.00	736.00	576.00	1,472.00	10	GRO/MAN
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	1,360.00	1,360.00	1,312.00	1,520.00	12	SHR/MAN
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	1,952.00	1,952.00	1,792.00	1,952.00	12	GRO/DEF
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	16.00	16.00	16.00	16.00	0	STA/
large pool	16.00	16.00	0.00	16.00	0	GRO/IMM
shared pool	1,168.00	1,168.00	416.00	1,168.00	0	GRO/IMM
streams pool	0.00	0.00	0.00	0.00	0	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

Resizes, Grows, Shrinks - Operations captured by AWR if there are operations on the same component for the same operation_type, target_size, and with the same start_time only one operation is captured
ordered by Component

Component	Min Size (Mb)	Max Size (Mb)	Avg Size (Mb)	Re- Sizes	Grows	Shrinks
DEFAULT buffer cache	576.00	736.00	656.00	12	2	10
PGA Target	1,360.00	1,520.00	1,440.00	12	10	2
SGA Target	1,792.00	1,952.00	1,872.00	12	2	10

Back to Memory Statistics
Back to Top

Memory Resize Ops

Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred Delta : change in size of the component Target Delta: displayed only if final size <> target_size
Status: COMplete/CANcelled/INActive/PENding/ERRor
ordered by start_time desc,component

Start	Ela (s)	Component	Oper Typ/Mod	Init Size (M)	Delta	Final (M)	Sta
08/29 22:00:15	0	pga	SHR/MAN	1,440	-80	1,360	COM
08/29 22:00:14	1	sga	GRO/DEF	1,872	80	1,952	COM
08/29 16:35:12	0	pga	SHR/MAN	1,520	-80	1,440	COM
08/29 16:35:11	1	sga	GRO/DEF	1,792	80	1,872	COM
08/29 10:14:54	42321	bufcache	GRO/MAN	592	144	736	COM
08/29 10:14:54	22818	bufcache	GRO/MAN	592	64	656	COM
08/29 10:14:54	0	bufcache	SHR/DEF	592	-16	576	COM
08/29 10:14:54	0	pga	GRO/MAN	1,504	16	1,520	COM
08/29 10:14:51	3	sga	SHR/DEF	1,808	-16	1,792	COM
08/29 10:13:13	0	bufcache	SHR/DEF	608	-16	592	COM
08/29 10:13:13	0	pga	GRO/MAN	1,488	16	1,504	COM
08/29 10:13:11	2	sga	SHR/DEF	1,824	-16	1,808	COM
08/29 10:09:18	0	bufcache	SHR/DEF	624	-16	608	COM
08/29 10:09:18	0	pga	GRO/MAN	1,472	16	1,488	COM
08/29 10:09:15	3	sga	SHR/DEF	1,840	-16	1,824	COM
08/29 10:05:41	0	bufcache	SHR/DEF	640	-16	624	COM
08/29 10:05:41	0	pga	GRO/MAN	1,456	16	1,472	COM
08/29 10:05:39	2	sga	SHR/DEF	1,856	-16	1,840	COM
08/29 09:58:51	0	pga	GRO/MAN	1,440	16	1,456	COM
08/29 09:58:47	4	bufcache	SHR/DEF	656	-16	640	COM
08/29 09:58:44	7	sga	SHR/DEF	1,872	-16	1,856	COM
08/29 09:57:11	0	bufcache	SHR/DEF	672	-16	656	COM
08/29 09:57:11	0	pga	GRO/MAN	1,424	16	1,440	COM
08/29 09:57:10	1	sga	SHR/DEF	1,888	-16	1,872	COM
08/29 09:52:07	0	bufcache	SHR/DEF	688	-16	672	COM
08/29 09:52:07	0	pga	GRO/MAN	1,408	16	1,424	COM
08/29 09:52:05	2	sga	SHR/DEF	1,904	-16	1,888	COM
08/29 09:49:34	0	bufcache	SHR/DEF	704	-16	688	COM
08/29 09:49:34	0	pga	GRO/MAN	1,392	16	1,408	COM
08/29 09:49:30	4	sga	SHR/DEF	1,920	-16	1,904	COM
08/29 09:46:56	0	bufcache	SHR/DEF	720	-16	704	COM
08/29 09:46:56	0	pga	GRO/MAN	1,376	16	1,392	COM
08/29 09:46:53	3	sga	SHR/DEF	1,936	-16	1,920	COM
08/29 09:40:51	0	pga	GRO/MAN	1,360	16	1,376	COM
08/29 09:40:50	1	bufcache	SHR/DEF	736	-16	720	COM
08/29 09:40:50	1	sga	SHR/DEF	1,952	-16	1,936	COM

Back to Memory Statistics
Back to Top

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	224.54		2.36	4.86	28	37	95	95
	Freeable	30.38	0.00	0.69	0.63	3		44	44
	SQL	0.90	0.26	0.01	0.01	0	12	72	47
	PL/SQL	0.88	0.56	0.01	0.02	0	0	93	93
E	Other	202.68		2.13	4.55	28	36	95	95
	Freeable	21.56	0.00	1.03	0.97	4		21	21
	SQL	0.75	0.23	0.01	0.01	0	17	72	47
	PL/SQL	0.53	0.32	0.01	0.01	0	0	93	93

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	771,751,936
Fixed Size	1,337,548
Redo Buffers	10,858,496
Variable Size	1,258,293,044

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	0.47	0.47	0.00
large	free memory	15.53	15.53	0.00
shared	CCUR	127.36	128.47	0.87
shared	KGLHD	22.83	22.25	-2.54
shared	KGLS	12.45	13.95	11.99
shared	PCUR	64.20	63.94	-0.41
shared	SQLA	656.42	658.24	0.28
shared	free memory	150.82	146.09	-3.14
	buffer_cache	736.00	736.00	0.00
	fixed_sga	1.28	1.28	0.00
	log_buffer	10.36	10.36	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

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 Capture Rate

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

Streams Apply Rate

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 Queue 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

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

only rows with Current or Maximum Utilization > 80% of Limit are shown
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
processes	96	150	150	150

Shared Server Statistics

Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections	Avg Active Connections	Avg Total Shared Srvrs	Avg Active Shared Srvrs	Avg Total Dispatchers	Avg Active Dispatchers
0	0	1	0	1	0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec	Disp Queue Per Sec	Server Msgs/Sec	Server KB/Sec	Common Queue Total	Disp Queue Total	Server Total Msgs	Server Total(KB)
0	0	0	0.00	0	0	0	0

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Statistics are combined for all servers
Incoming and Outgoing Net % are included in %Busy

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
560,167	0.00	100.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

Ordered by %Busy, descending
Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Name	Avg Conns	Total Disp Time (s)	%Busy	%Idle	Total Queued	Total Queue Wait (s)	Avg Queue Wait (ms)
D000	0.00	560,167	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

if IP/Public/Source at End snap is different a '*' is displayed

Parameter Name	Begin value	End value (if different)
archive_lag_target	0
audit_file_dest	/u01/app/oracle/admin/orclstby/adump
audit_trail	OS
compatible	11.2.0.0.0
control_files	/u01/app/oracle/oradata/orclstby/control01.ctl, /u01/app/oracle/flash_recovery_area/control02.ctl
db_block_size	8192
db_domain
db_file_name_convert	orcl, orclstby
db_name	orcl
db_recovery_file_dest	/u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size	21474836480
db_unique_name	orclstby
dg_broker_start	TRUE
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=orclstbyXDB)
fal_client	orclstby
fal_server	orcl
job_queue_processes	10
log_archive_config	dg_config=(orcl, orclstby)
log_archive_dest_1	location=use_db_recovery_file_dest valid_for=(all_logfiles, all_roles) db_unique_name=orclstby
log_archive_dest_2	service=orclstbystby async valid_for=(online_logfiles, primary_role) db_unique_name=orclstby
log_archive_dest_3	service="orcl", LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="orcl" net_timeout=30, valid_for=(all_logfiles, primary_role)
log_archive_dest_state_1	ENABLE
log_archive_dest_state_2	ENABLE
log_archive_dest_state_3	ENABLE
log_archive_format	orclstby_%t_%s_%r.arc
log_archive_max_processes	5
log_archive_min_succeed_dest	1
log_archive_trace	0
log_file_name_convert	orcl, orclstby
memory_target	3405774848
open_cursors	300
processes	150
remote_login_passwordfile	EXCLUSIVE
standby_file_management	AUTO
undo_tablespace	UNDOTBS1

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	99.98	Redo NoWait %:	99.98
Buffer Hit %:	91.26	In-memory Sort %:	100.00
Library Hit %:	98.65	Soft Parse %:	99.15
Execute to Parse %:	31.98	Latch Hit %:	99.94
Parse CPU to Parse Elapsd %:	0.25	% Non-Parse CPU:	99.65